CN116738944A - Comprehensive budget planning system - Google Patents
Comprehensive budget planning system Download PDFInfo
- Publication number
- CN116738944A CN116738944A CN202310227091.1A CN202310227091A CN116738944A CN 116738944 A CN116738944 A CN 116738944A CN 202310227091 A CN202310227091 A CN 202310227091A CN 116738944 A CN116738944 A CN 116738944A
- Authority
- CN
- China
- Prior art keywords
- budget
- module
- setting
- budgeting
- cell
- 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.)
- Pending
Links
- 238000013439 planning Methods 0.000 title claims abstract description 44
- 238000004458 analytical method Methods 0.000 claims abstract description 13
- 238000013461 design Methods 0.000 claims abstract description 13
- 238000013475 authorization Methods 0.000 claims abstract description 7
- 230000010365 information processing Effects 0.000 claims abstract description 4
- 238000000034 method Methods 0.000 claims description 16
- 230000008569 process Effects 0.000 claims description 12
- 238000004364 calculation method Methods 0.000 claims description 11
- 238000012550 audit Methods 0.000 claims description 7
- 230000001934 delay Effects 0.000 claims description 3
- 238000009472 formulation Methods 0.000 description 4
- 230000003993 interaction Effects 0.000 description 4
- 239000000203 mixture Substances 0.000 description 4
- 230000001360 synchronised effect Effects 0.000 description 2
- 238000012546 transfer Methods 0.000 description 2
- 230000009286 beneficial effect Effects 0.000 description 1
- 230000015572 biosynthetic process Effects 0.000 description 1
- 238000005266 casting Methods 0.000 description 1
- 238000011161 development Methods 0.000 description 1
- 238000010586 diagram Methods 0.000 description 1
- 238000005516 engineering process Methods 0.000 description 1
- 230000008676 import Effects 0.000 description 1
- 238000007726 management method Methods 0.000 description 1
- 238000012545 processing Methods 0.000 description 1
- 230000002035 prolonged effect Effects 0.000 description 1
- 238000005096 rolling process Methods 0.000 description 1
- 238000004088 simulation Methods 0.000 description 1
- 238000003786 synthesis reaction Methods 0.000 description 1
- 230000008685 targeting Effects 0.000 description 1
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/174—Form filling; Merging
-
- 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
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q10/00—Administration; Management
- G06Q10/10—Office automation; Time management
- G06Q10/103—Workflow collaboration or project management
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Business, Economics & Management (AREA)
- General Physics & Mathematics (AREA)
- Strategic Management (AREA)
- Human Resources & Organizations (AREA)
- Physics & Mathematics (AREA)
- General Health & Medical Sciences (AREA)
- Entrepreneurship & Innovation (AREA)
- Health & Medical Sciences (AREA)
- Computational Linguistics (AREA)
- Audiology, Speech & Language Pathology (AREA)
- Artificial Intelligence (AREA)
- General Engineering & Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Economics (AREA)
- Marketing (AREA)
- Operations Research (AREA)
- Quality & Reliability (AREA)
- Tourism & Hospitality (AREA)
- General Business, Economics & Management (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The embodiment of the application discloses a comprehensive budget planning system. The application comprises a budget foundation module, a budget information processing module, a template design module, a compiling table generating module, a budget authorizing module, a compiling table compiling module, a report analysis module and a cost reimbursement module; the budget foundation module is used for setting a budget company and a budget planning responsible person; the budget special information module is used for storing information of an external system and preset reference variables; the template design module is used for setting a budget editing table and an embedded calculator; the programming table generation module is used for selecting a budget main body, a budget programming table and a budget scheme type; and the budget authorization module is used for setting the auditing flow and the query authority of the budget editing table. The application shortens the budget flow time, simplifies the auditing mode, can customize the form operation queue, cuts off the flow to reduce repeated requests, and reduces the pressure of the server.
Description
Technical Field
The application relates to the technical field of computers, in particular to a comprehensive budget planning system.
Background
With the continuous development of social science and technology, companies in different industries perform budgeting collection through an excel distribution collection mode. Some companies also use budget systems such as user friends/golden butterfly/year round, etc. These budgeting systems have focused on targeting and resolution, on the budgeting auditing process, and on budgeting execution control.
When the group budget is planned, if a plurality of companies are involved, internal relations exist among the companies, and the auditing of the company editing table is related to the auditing of the horizontal management layer of the present level company and the auditing of the vertical functional line, the whole planning process becomes complex, and the applicability of the conventional system on the market is reduced. Meanwhile, according to a general budget planning sequence, when the planning table relates to the subordinate relation, if the subordinate planning is equal to the subordinate planning and the superior planning table is compiled again, the whole budget flow time is prolonged, and the enterprise relation in the group is complex, so that the auditing mode of the budget planning table is complex. Meanwhile, when a large number of formulas are involved in the budget editing table, if the budget editing table is submitted to front-end computing, the front-end computing tool design is complicated, if the budget editing table is submitted to the rear-end, the interaction mode of the database needs to be considered, the server/browser performance is insufficient, the server/browser is easy to be blocked, and therefore the overall efficiency of operators is reduced.
Disclosure of Invention
In view of the above, the present specification has been presented to provide a comprehensive budgeting system that overcomes or at least partially solves the above-described problems.
Other features and advantages of the present disclosure will be apparent from the following detailed description, or may be learned in part by the practice of the disclosure.
The embodiment of the application provides a comprehensive budget planning system, which comprises the following steps: the comprehensive budget planning system is characterized by comprising a budget foundation module, a budget information processing module, a template design module, a planning table generation module, a budget authorization module, a planning table planning module, a report analysis module and a cost reimbursement module; the budget foundation module is used for setting a budget company and a budget planning responsible person; the budget special information module is used for storing information of an external system and preset reference variables; the template design module is used for setting a budget editing table and an embedded calculator; the programming table generation module is used for selecting a budget main body, a budget programming table and a budget scheme type; the budget authorization module is used for setting an auditing flow and inquiry authority of the budget editing table; the compiling table compiling module is used for conducting budget compiling according to the query authority and with a preset operation dimension, and the system automatically generates a compiling result according to the embedded calculator; the report analysis module is used for carrying out budget analysis; and the expense reimbursement module is used for transmitting the budget schedule with the completed audit to the expense control platform.
In some embodiments, the budgeting table includes a list information template support module, a cell template support module, and a form filling and function control module, the list information template support module being configured to set a list information template for the budgeting table; the cell template supporting module is used for setting a cell template for the budget planning table; the form filling and function control module is used for setting a form operation queue for the budget planning form, and the form operation queue is used for avoiding data updating errors or delays caused by too fast user operation.
In some embodiments, setting a form operation queue for a budget inventory includes: when detecting that a user operates the cells of the budget planning table, judging whether the cells in the form operation queue are updated, if yes, acquiring cell data operated by the user, putting the cell data operated by the user into the form operation queue, updating the cell data operated by the user, obtaining updated cell data, and notifying the cells operated by the user to update data according to the updated cell data; if not, acquiring the cell data in the form operation queue, updating the cell data in the form operation queue, notifying the cell in the form operation queue to update the data after the cell data in the form operation queue is updated, and placing the cell data operated by the user into the form operation queue.
In some embodiments, list information templates are set for budgeting tables, including custom generation of column coordinates, setting of column attributes, column positioning attributes, and column and row batch operation attributes; column attributes include column names and column widths; column positioning attributes include left fixed, right fixed, and normal display.
In some embodiments, setting a cell template for the budgeting table includes determining cell editable conditions, setting data types, and entering a manner; data types include text and numbers; the input mode comprises manual input, formula calculation and drop-down selection in a drop-down table.
In some embodiments, budget compilations tables are set, as well as embedded calculators, including custom budget periods, custom addition of rows to the budget compilations tables during the programming process, default column widths, and left and right fixed columns.
In some embodiments, budgeting is performed according to the query rights and in a preset operating dimension, including setting a default dockee and a dockee of an associated company according to a budget orchestration table, the dockee being capable of performing a budget orchestration table transfer or commit operation; setting operation authority of a budget editing table according to a company level or a function line level, wherein the operation authority comprises inquiry and audit; and setting auditing modes according to different compiling tables, wherein the auditing modes comprise automatic auditing and primary auditing.
The application has the beneficial effects that:
the comprehensive budget planning system disclosed by the application can carry out multidimensional compiling table authority design, and supports setting of default dockees and dockees of related companies according to compiling table; wherein, the dockee can perform operations such as editing, transferring, submitting and the like; but also support the operation authorities such as inquiry and audit of the setting and making table according to the company level or the function line level; in addition, the method supports the setting of auditing modes such as automatic auditing or primary auditing according to different compiling tables, shortens the duration of a budget process and simplifies the auditing modes.
In addition, the application can self-define the form operation queue, avoid the condition that the user operates too fast data update error or data update delay causes the loss of certain operation record through the queue operation, the input box is used for intercepting and reducing repeated requests, the pressure of the server is reduced, and the server supports the data update of a single cell to reduce the data volume after interaction.
It is to be understood that both the foregoing general description and the following detailed description are exemplary and explanatory only and are not restrictive of the disclosure.
Drawings
In order to more clearly illustrate the technical solutions of the embodiments of the present application, the drawings that are needed in the description of the embodiments will be briefly described below, it being obvious that the drawings in the following description are only some embodiments of the present application, and that other drawings may be obtained according to these drawings without inventive effort for a person skilled in the art.
FIG. 1 is a schematic diagram of a comprehensive budgeting system provided by an embodiment of the present application.
FIG. 2 is a flow chart illustrating a method for setting up a queue of form operations for a budget orchestration table according to an embodiment of the present application.
Detailed Description
The following description of the embodiments of the present application will be made clearly and completely with reference to the accompanying drawings, in which it is apparent that the embodiments described are only some embodiments of the present application, but not all embodiments. All other embodiments, which can be made by those skilled in the art based on the embodiments of the application without making any inventive effort, are intended to fall within the scope of the application.
An embodiment of the present application provides a comprehensive budgeting system involving computer processing, as shown in FIG. 1, the comprehensive budgeting system comprising: the system comprises a budget foundation module, a budget information processing module, a template design module, a compiling table generating module, a budget authorizing module, a compiling table compiling module, a report analysis module and a cost reimbursement module; the budget foundation module is used for setting a budget company and a budget planning responsible person; the budget special information module is used for storing information of an external system and preset reference variables; the template design module is used for setting a budget editing table and an embedded calculator; the programming table generation module is used for selecting a budget main body, a budget programming table and a budget scheme type; the budget authorization module is used for setting an auditing flow and inquiry authority of the budget editing table; the compiling table compiling module is used for conducting budget compiling according to the query authority and with a preset operation dimension, and the system automatically generates a compiling result according to the embedded calculator; the report analysis module is used for carrying out budget analysis; and the expense reimbursement module is used for transmitting the budget schedule with the completed audit to the expense control platform.
In particular, the comprehensive budgeting system may be integrated in an electronic device, which may be a terminal, a server, etc. The terminal can be a mobile phone, a tablet computer, an intelligent Bluetooth device, a notebook computer, a personal computer (Personal Computer, PC) or the like; the server may be a single server or a server cluster composed of a plurality of servers.
In the embodiment of the application, the budget foundation module can be used for maintaining the whole budget company and a default budget planning responsible person; the budget special information module can be used for intermediately storing information of an external system (namely other system data) or maintaining some special reference variables; the template design module can be used for designing the style of the budget editing table and a rule calculator needing to be embedded; the programming table generating module can be used for selecting the budget main body participated in at this time, the budget table needing programming and the type of the budget scheme; the budget authorization module can set the auditing flow of the compiling table and inquire the authority; the compiling table compiling module can carry out budget compiling according to the authority by using the dimension of a company or an operator, and the system automatically generates a compiling result according to the rule calculator; the report analysis module can be used for budget analysis such as actual and budget comparison and the like; the expense reimbursement system can push the compiled form data which is checked and finished to an expense control platform.
In some embodiments, the budgeting table includes a list information template support module, a cell template support module, and a form filling and function control module, the list information template support module being configured to set a list information template for the budgeting table; the cell template supporting module is used for setting a cell template for the budget planning table; the form filling and function control module is used for setting a form operation queue for the budget planning form, and the form operation queue is used for avoiding data updating errors or delays caused by too fast user operation.
In some embodiments, setting a form operation queue for a budget inventory includes: when detecting that a user operates the cells of the budget planning table, judging whether the cells in the form operation queue are updated, if yes, acquiring cell data operated by the user, putting the cell data operated by the user into the form operation queue, updating the cell data operated by the user, obtaining updated cell data, and notifying the cells operated by the user to update data according to the updated cell data; if not, acquiring the cell data in the form operation queue, updating the cell data in the form operation queue, notifying the cell in the form operation queue to update the data after the cell data in the form operation queue is updated, and placing the cell data operated by the user into the form operation queue.
As shown in FIG. 2, in an embodiment of the present application, the user operates the budgeting table operation cell AA 1: save data 2, operate on cell AA 2: and storing data 777, when detecting that the user operates the cell AA1 and the cell AA2 on the budget schedule, putting the record operation into a queue after the operation is completed, and waiting for the execution completion of the last operation task. Judging whether the cell in the form operation queue is updated, wherein the operation queue is also provided with cells AB1 and AB2 which are waiting for updating, in addition, in the process of updating the data of the cells BA1 and BA2, the data of the formula calculation cell BA1 is (AA 1) =44, the data of the formula calculation cell BA2 is (AA 1) =66, the follow-up queue is notified after the data of the cells BA1 and BA2 are updated, and meanwhile, the interaction completion notification is related to the cell updating.
In some embodiments, list information templates are set for budgeting tables, including custom generation of column coordinates, setting of column attributes, column positioning attributes, and column and row batch operation attributes; column attributes include column names and column widths; column positioning attributes include left fixed, right fixed, and normal display.
In some embodiments, setting a cell template for the budgeting table includes determining cell editable conditions, setting data types, and entering a manner; data types include text and numbers; the input mode comprises manual input, formula calculation and drop-down selection in a drop-down table.
In the embodiment of the application, the comprehensive budget planning system supports the input and output modes of each cell in the budget planning table, can rapidly carry out cell configuration, such as whole row batch setting, whole line batch setting, EXCEL import updating after cell specific setting or export, and the like, and can also set the planning conditions of each cell in the planning table, such as whether a constructor can edit, check a data format, input bit number control, and the like; in addition, the input means may include manual input, selection within a drop down box, or calculation by other lattices, etc.
In some embodiments, budget compilations tables are set, as well as embedded calculators, including custom budget periods, custom addition of rows to the budget compilations tables during the programming process, default column widths, and left and right fixed columns.
In the embodiment of the application, the template design module comprises a multifunctional custom template designer which can support setting of custom report rows and columns; supporting custom budget periods, such as cross-year budget, half-year budget and the like; the custom addition of lines in the compiling process is supported, for example, fixed resource purchasing does not need to limit the compiling table to fix a plurality of lines; setting a default column width and left and right fixed columns may also be supported.
In some embodiments, budgeting is performed according to the query rights and in a preset operating dimension, including setting a default dockee and a dockee of an associated company according to a budget orchestration table, the dockee being capable of performing a budget orchestration table transfer or commit operation; setting operation authority of a budget editing table according to a company level or a function line level, wherein the operation authority comprises inquiry and audit; and setting auditing modes according to different compiling tables, wherein the auditing modes comprise automatic auditing and primary auditing.
In the embodiment of the application, the comprehensive budget planning system can also be compatible with various calculation formulas, supports basic addition, subtraction, multiplication and division, supports special functions IF, average number, upper accumulated number, weighted multiplication and the like, supports data referencing other budget planning tables, supports data referencing other systems, supports template simulation trial calculation, supports budget of the present year or rolling budget and the like. In addition, the application is compatible with the synchronous compiling of the associated compiling table on the basis of cross-compiling table reference formulas.
In the process of generating the budget planning table, the front end and the back end can both calculate, and in addition, in the calculation implementation mode of the budget planning table, the back end can provide the whole implementation mode for cache calculation and the like.
In an embodiment of the present application, the description of the formulas in the budget formulation table is as follows:
the type of formula used in embodiments of the present application depends on the row and column nature of the cell to which the formula is to refer, e.g., [ a [ b [ c [ d ] is the type of referring cell. In the formula, the first parameter may be the coordinates of a line; the last parameter is a budget formulation table that can be referenced; the parameters in the middle of the formula are dynamic rows and columns, and are parameters which need to be transmitted, and the embodiment of the application can transmit ALL or date or Nth column or row. Such as: the formula [ a [ BC3, GB99] is a fixed row and fixed column, the formula [ b [ CA5, X2, GB99] ], the formula [ b [ CA4, ALL, GB99] are fixed row and dynamic column, the formula [ c [ BD2, ALL, GB99] ], the formula [ c [ BD2, Y2, GB99] are dynamic row and fixed column, the formula [ d [ CA2, XN, ALL, GB99] ], the formula [ d [ CA2, XN, Y1, GB99] ], the formula [ d [ CA2, ALL, Y1, GB99] are dynamic row and dynamic column, and the formula [ h [ CA30, N+ -X, GB99] is the sum of the addition and subtraction of the current period and the addition period of the current period.
Examples of formulas in the budget formulation table are as follows:
such as: second row = third row + fourth row = [ a [ BC3, GB99] ] + [ a [ BC4, GB99] ];
such as: total 2 rows of unit price = total 4 rows of total price/total 1 row area = [ a [ BB4, WY03] ]/[ a [ BB1, WY03] ]/365;
such as: total 4 lines total = total sum of each period of the fourth line = [ b [ CA4, ALL, WY03] ];
such as: total price per period of the fourth line = cost per period of the seventh line = [ b [ CA7, XN, WY03] ];
such as: average number of the third row = third row summary/total number of phases = [ b [ CA3, ALL, WY01] ]/$g,1$, where $g,1$ = total number of phases;
such as: g, [ b [ CA4, ALL, GB99] ] [ b [ CA5, ALL, GB99] ] represents a first period of the fourth row, a first period of the fifth row+a second period of the fourth row, a second period of the fifth row+an nth period of the … fourth row;
such as: [ b [ CA4, ALL, GB99] ] [ b [ CA5, ALL, GB99] represents (first phase of fourth row + … +N phase of fourth row) [ first phase of fifth row + … +N phase of fifth row ].
In the embodiment of the application, some common variables, such as V2, can be defined in advance as the total casting cost, and are referenced in the special information of the synchronous budget of other systems, such as [ e [ V2, X1] ] is a variable which is obtained by grabbing V2 in a variable table according to a budget scheme and has a period equal to the first period of the budget period.
For example, a special function IF formula=if { [ e [ V2,202201] ] >2 is defined; 10; [ e [ V2,202201] ] }.
In the embodiment of the application, IF synthesis examples: in the calculation process of the income tax in the current period, if the profit to be withheld in the last year+the accumulated profit in the current period of the current year is <0, the income tax in the current period of the current year=the accumulated income tax calculated in the current period of the current period; if the profit to be withheld in the last year+the profit accumulated at the expiration date of the present year > =0, the income tax of the present year= (the profit to be withheld in the last year+the profit accumulated at the expiration date of the present year) ×25% -the accumulated income tax that has been counted in the expiration date. The formulation may be: =if { [ a [ BB50, GB03] ] + [ h [ CA29, N, GB99] ] + [ h [ CA30, N, GB99] ] + [ h [ CA31, N, GB99] ] <0; [ h [ CA32, N minus 1, GB99] ] -1; ([ a [ BB50, GB03] ] + [ h [ CA29, N, GB99] ] + [ h [ CA30, N, GB99] ] + [ h [ CA31, N, GB99] ]) 0.25- [ h [ CA32, N minus 1, GB99] ] }.
The comprehensive budget planning system disclosed by the application can carry out multidimensional compiling table authority design, and supports setting of default dockees and dockees of related companies according to compiling table; wherein, the dockee can perform operations such as editing, transferring, submitting and the like; but also support the operation authorities such as inquiry and audit of the setting and making table according to the company level or the function line level; in addition, the method supports the setting of auditing modes such as automatic auditing or primary auditing according to different compiling tables, shortens the duration of a budget process and simplifies the auditing modes.
In addition, the application can self-define the form operation queue, avoid the condition that the user operates too fast data update error or data update delay causes the loss of certain operation record through the queue operation, the input box is used for intercepting and reducing repeated requests, the pressure of the server is reduced, and the server supports the data update of a single cell to reduce the data volume after interaction.
In addition, the application can support partial information brought into the existing business system in the process of programming the budget table, and support data brought into the financial system during budget analysis, namely, the data of the existing business system can be used as programming basis or decision basis, thereby realizing intelligent automatic programming of the budget programming table.
The comprehensive budget planning system can be integrated in electronic equipment, and the electronic equipment can be a terminal, a server and other equipment. The terminal can be a mobile phone, a tablet computer, an intelligent Bluetooth device, a notebook computer, a personal computer (Personal Computer, PC) or the like; the server may be a single server or a server cluster composed of a plurality of servers.
The foregoing has outlined some of the more detailed description of a comprehensive budget planning system and the like provided by the embodiments of the present application, wherein specific examples are provided herein to illustrate the principles and embodiments of the present application, and the above examples are provided to assist in understanding the methods and core concepts of the present application; meanwhile, as those skilled in the art will vary in the specific embodiments and application scope according to the ideas of the present application, the present description should not be construed as limiting the present application in summary.
Claims (7)
1. The comprehensive budget planning system is characterized by comprising a budget foundation module, a budget information processing module, a template design module, a planning table generation module, a budget authorization module, a planning table planning module, a report analysis module and a cost reimbursement module; the budget foundation module is used for setting a budget company and a budget planning responsible person; the budget special information module is used for storing information of an external system and preset reference variables; the template design module is used for setting a budget editing table and an embedded calculator; the programming table generation module is used for selecting a budget main body, a budget programming table and a budget scheme type; the budget authorization module is used for setting an auditing flow and a query authority of the budget editing table; the compiling table compiling module is used for conducting budget compiling according to the query authority and with a preset operation dimension, and the system automatically generates a compiling result according to the embedded calculator; the report analysis module is used for carrying out budget analysis; and the expense reimbursement module is used for transmitting the audited budget schedule to the expense control platform.
2. The comprehensive budgeting system of claim 1 wherein said budgeting table includes a list information template support module, a cell template support module, and a form filling and function control module, said list information template support module for setting a list information template for said budgeting table; the cell template supporting module is used for setting a cell template for the budget planning table; the form filling and function control module is used for setting a form operation queue for the budget editing form, and the form operation queue is used for avoiding data updating errors or delays caused by too fast user operation.
3. The comprehensive budgeting system of claim 2 wherein said setting up a form operation queue for said budgeting table comprises:
when detecting that a user updates the budget setting list operation cells, judging whether the cells in the list operation queue are updated, if yes, acquiring the cell data operated by the user, putting the cell data operated by the user into the list operation queue, updating the cell data operated by the user to obtain updated cell data, and notifying the cells operated by the user to update data according to the updated cell data;
if not, acquiring the cell data in the form operation queue, updating the cell data in the form operation queue, notifying the cell in the form operation queue to update the data after the cell data in the form operation queue is updated, and placing the cell data operated by the user into the form operation queue.
4. The comprehensive budgeting system of claim 2 wherein said setting list information templates for said budgeting table includes custom generating column coordinates, setting column attributes, column positioning attributes, and column and row batch operation attributes; the column attributes include a column name and a column width; the column positioning attributes include left fixed, right fixed, and normal display.
5. The comprehensive budgeting system of claim 3 or 4, wherein said setting up cell templates for said budgeting table includes determining cell editable conditions, setting up data types, and input means; the data types include text and numbers; the input mode comprises manual input, formula calculation and drop-down selection in a drop-down table.
6. The comprehensive budgeting system of claim 5 wherein said set budgeting table and embedded calculator includes custom budgeting period, custom adding rows to said budgeting table during the programming process, setting default column width and left and right fixed columns.
7. The comprehensive budgeting system of claim 1, wherein said budgeting in accordance with said query rights and with a preset operating dimension includes setting a default dockee and a dockee of an associated company in accordance with said budgeting table, said dockee being capable of budgeting table dispatch or submission operations; setting operation authority of a budget editing table according to a company level or a function line level, wherein the operation authority comprises inquiry and audit; and setting auditing modes according to different compiling tables.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202310227091.1A CN116738944A (en) | 2023-03-10 | 2023-03-10 | Comprehensive budget planning system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202310227091.1A CN116738944A (en) | 2023-03-10 | 2023-03-10 | Comprehensive budget planning system |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN116738944A true CN116738944A (en) | 2023-09-12 |
Family
ID=87906740
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202310227091.1A Pending CN116738944A (en) | 2023-03-10 | 2023-03-10 | Comprehensive budget planning system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN116738944A (en) |
-
2023
- 2023-03-10 CN CN202310227091.1A patent/CN116738944A/en active Pending
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN102117306B (en) | Method and system for monitoring ETL (extract-transform-load) data processing process | |
| CN100568237C (en) | Report form template in the multidimensional enterprise software system generates method and system | |
| US20050060500A1 (en) | General purpose memory compiler system and associated methods | |
| US20030110191A1 (en) | System and method for efficiently and flexibly utilizing spreadsheet information | |
| JP2008165835A (en) | Budget planning system by computer | |
| US7512451B2 (en) | System and method for interactive process management | |
| CN101976394B (en) | Data acquiring and counting system and method | |
| CN102208057A (en) | Method, platform and system for processing audit information | |
| CN113610595B (en) | Report and examination price informatization management method and system | |
| CN102112999A (en) | Systems and methods for transforming a business process into reusable services | |
| CN103116827A (en) | Rural power grid engineering control system | |
| JP7339628B2 (en) | Online report creation system using Excel tools | |
| US20150310390A1 (en) | Aggregation and workflow engines for managing project information | |
| US20100138807A1 (en) | Method and System for Benefits Calculator for Information Technology Projects | |
| CN114066176A (en) | Vehicle cost management method, system, equipment and storage medium based on vehicle structure template | |
| Ganichev et al. | Rethinking Russian digital economy development under sunctions | |
| CN116738944A (en) | Comprehensive budget planning system | |
| CN114004542B (en) | Enterprise task management method, system, computer equipment and storage medium | |
| CN101271550A (en) | Data distribution method and device in application system | |
| CN101490672A (en) | Query processing for smart services | |
| CN113592263A (en) | Resource return increment prediction method and device based on dynamic resource return increase ratio | |
| US20040073466A1 (en) | Systems and methods for evaluating telecommunications projects | |
| JP2002082995A (en) | Information processor and recording medium with program executed by the same stored therein | |
| US9412083B2 (en) | Aggregation and workflow engines for managing project information | |
| Zhang et al. | Engineering vehicle management system based on the internet of things |
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 |