Automatic checking method for budget demand data, computer equipment and storage medium

Abstract

The invention relates to the technical field of data verification, and discloses a budget demand data automatic verification method, computer equipment and a storage medium, and the method comprises the steps: creating an Excel form comprising a data verification module, an articulation verification module and an automatic summarization calculation module; a data verification module is used for verifying budget demand data in the Excel form; an articulation checking module is used for checking the articulation between a general table and a detailed table in the Excel form; and automatically summarizing and calculating the budget demand data and the basic data of each unit in the Excel form by using an automatic summarizing and calculating module, and storing the data in a database. By introducing an advanced automatic verification tool, data can be more effectively integrated, processed and analyzed, so that the workload of manual operation is greatly reduced, the burden is reduced, the data processing and analysis time is shortened, the working efficiency is improved, and the resource allocation process is more efficient, accurate and reliable.

Description

Technical Field

[0001] The present invention relates to the technical field of data verification, and in particular to a method for automatically verifying budget demand data, a computer device and a storage medium. Background Art

[0002] In recent years, power grid companies have deeply realized the key role played by resource allocation centers and have focused on playing their core role in order to accelerate the construction of a refined investment management system that can strictly follow operating constraints and closely link with output benefits. In view of this, optimizing resource allocation models and achieving efficient allocation and utilization of resources has become an urgent and important task under the current situation.

[0003] However, in the complex process of resource allocation, an important link that cannot be ignored is the extensive collection of massive basic data and detailed budget demand information of subordinate units. These data are then subject to strict data verification, sophisticated data processing, and in-depth data analysis. At present, this process mainly relies on manual operations for data collection and maintenance, which not only leads to a large amount of repetitive work, but also significantly reduces the overall efficiency of resource allocation, thereby affecting the accuracy and timeliness of resource allocation.

[0004] Therefore, in order to fundamentally solve this problem and improve the efficiency and quality of the entire resource allocation process, it is particularly urgent to innovate and upgrade existing technical means.

[0005] The above information is presented as background information only to assist with understanding the present disclosure and no determination or admission is made as to whether any of the above may be used as prior art with respect to the present disclosure. Summary of the invention

[0006] The present invention provides a budget demand data automatic verification method, computer equipment and storage medium to solve the problems existing in the prior art.

[0007] To achieve the above object, the present invention provides the following technical solutions:

[0008] In a first aspect, the present invention provides a method for automatically verifying budget demand data, the method comprising:

[0009] Create an Excel form, which includes a data verification module, a cross-reference relationship verification module and an automatic summary calculation module;

[0010] Using the data verification module to verify the budget demand data in the Excel form;

[0011] Using the cross-reference verification module to verify the cross-reference relationship between the general table and the detailed table in the Excel form;

[0012] The automatic summary calculation module is used to automatically summarize and calculate the budget demand data and basic data of each unit in the Excel form, and save them to the database.

[0013] Furthermore, in the method for automatically verifying budget demand data, the step of creating an Excel form, wherein the Excel form includes a data verification module, a cross-reference relationship verification module, and an automatic summary calculation module, comprises:

[0014] Create an Excel spreadsheet;

[0015] In the Excel form, VBA code is used to establish a data verification module, a cross-reference relationship verification module and an automatic summary calculation module.

[0016] Furthermore, in the method for automatically verifying budget demand data, the Excel form includes budget item names, computer equipment and storage media, budget amounts and budget dates.

[0017] Furthermore, in the method for automatically verifying budget demand data, the step of verifying the budget demand data in the Excel form by using the data verification module includes:

[0018] The budget demand data in the Excel form is verified by using the data verification module as follows:

[0019] Check whether the budget amount is greater than 0;

[0020] Verify that the budget date is within a reasonable range.

[0021] Furthermore, in the method for automatically verifying budget demand data, the step of automatically summarizing and calculating the budget demand data and basic data of each unit in the Excel form by using the automatic summary calculation module and saving them to the database includes:

[0022] The automatic summary calculation module is used to automatically summarize the budget demand data and basic data of each unit in the Excel form;

[0023] The automatic summary calculation module is used to automatically calculate the total budget amount and the budget average value for the data summarized in the Excel form, and save them in the database.

[0024] Furthermore, in the method for automatically verifying budget demand data, the Excel form also includes an information sharing and review module;

[0025] The information sharing and review module is used to realize the sharing function of budget demand data between the financial department and the responsible department, so as to facilitate the inquiry and review by the financial department.

[0026] Furthermore, in the method for automatically verifying budget demand data, the Excel form also includes a revision execution module;

[0027] The revision execution module is used to implement the budget reserve outbound operation according to the reviewed reserve demand, and supports the function of rolling revision of the budget.

[0028] Furthermore, in the method for automatically verifying budget demand data, the Excel form also includes an error prompt module;

[0029] The error prompt module is used to implement an error prompt function.

[0030] In a second aspect, the present invention provides a computer device, including a memory and a processor, wherein the memory stores a computer program, and when the processor executes the computer program, the method for automatically verifying budget demand data as provided in the first aspect above is implemented.

[0031] In a third aspect, the present invention provides a storage medium comprising computer executable instructions, wherein the computer executable instructions are executed by a computer processor to implement the method for automatically verifying budget demand data as provided in the first aspect above.

[0032] Compared with the prior art, the present invention has the following beneficial effects:

[0033] The present invention provides a method for automatically verifying budget demand data, a computer device and a storage medium. By introducing an advanced automatic verification tool, namely an Excel form including a data verification module, a cross-reference verification module and an automatic summary calculation module, data can be more effectively integrated, processed and analyzed, thereby greatly reducing the workload of manual operations, alleviating the burden on staff, shortening the time for data processing and analysis, improving work efficiency, and ensuring that the resource allocation process is more efficient, accurate and reliable.

[0034] The present invention has other features and advantages, which will be apparent from or will be described in detail in the accompanying drawings and the following detailed description incorporated herein, which together serve to explain the specific principles of the invention. BRIEF DESCRIPTION OF THE DRAWINGS

[0035] In order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, the drawings required for use in the embodiments or the description of the prior art will be briefly introduced below. Obviously, the drawings described below are only some embodiments of the present invention. For ordinary technicians in this field, other drawings can be obtained based on these drawings without paying creative work.

[0036] Figure 1 It is a flowchart of a method for automatically verifying budget demand data provided by Embodiment 1 of the present invention;

[0037] Figure 2 It is a structural diagram of a computer device provided in Embodiment 2 of the present invention. DETAILED DESCRIPTION

[0038] In order to explain in detail the possible application scenarios, technical principles, specific schemes that can be implemented, and the purposes and effects that can be achieved, the following is a detailed description of the specific embodiments listed in conjunction with the accompanying drawings. The embodiments described herein are only used to more clearly illustrate the technical solutions of the present application, and are therefore only used as examples, and cannot be used to limit the scope of protection of the present application.

[0039] Reference to "embodiment" herein means that the specific features, structures or characteristics described in conjunction with the embodiment may be included in at least one embodiment of the present application. The term "embodiment" appearing in various places in the specification does not necessarily refer to the same embodiment, nor does it particularly limit its independence or association with other embodiments. In principle, in the present application, as long as there is no technical contradiction or conflict, the various technical features mentioned in the embodiments can be combined in any way to form a corresponding implementable technical solution.

[0040] Unless otherwise defined, the technical terms used in this document have the same meanings as those generally understood by those skilled in the art to which this application belongs; the use of relevant terms in this document is only for describing specific embodiments and is not intended to limit this application.

[0041] In the description of this application, the term "and / or" is an expression used to describe the logical relationship between objects, indicating that three relationships may exist, for example, A and / or B, which means: A exists, B exists, and A and B exist at the same time. In addition, the character " / " in this article generally indicates that the objects before and after are in a logical relationship of "or".

[0042] In the present application, terms such as “first” and “second” are merely used to distinguish one entity or operation from another entity or operation, and do not necessarily require or imply any actual relationship of quantity, priority or sequence between these entities or operations.

[0043] Without further limitations, in this application, the words "include", "comprises", "has" or other similar expressions used in the sentences are intended to cover non-exclusive inclusion. These expressions do not exclude the presence of additional elements in the process, method or product including the elements, so that the process, method or product including a series of elements may include not only those limited elements, but also other elements not explicitly listed, or also include elements inherent to such process, method or product.

[0044] In this application, expressions such as "greater than", "less than", "exceed" and the like are understood to exclude the number itself; expressions such as "above", "below", "within" and the like are understood to include the number itself. In addition, in the description of the embodiments of this application, "multiple" means more than two (including two), and similar expressions related to "multiple" are also understood in this way, such as "multiple groups", "multiple times", etc., unless otherwise clearly and specifically limited.

[0045] In the description of the embodiments of the present application, space-related expressions used, such as "center", "longitudinal", "lateral", "length", "width", "thickness", "up", "down", "front", "back", "left", "right", "vertical", "horizontal", "vertical", "top", "bottom", "inside", "outside", "clockwise", "counterclockwise", "axial", "radial", "circumferential", etc., indicate the orientation or position relationship based on the orientation or position relationship shown in the specific embodiments or drawings, and are only for the convenience of describing the specific embodiments of the present application or facilitating the reader's understanding, and do not indicate or imply that the referred device or component must have a specific position, a specific orientation, or be constructed or operated in a specific orientation, and therefore cannot be understood as a limitation on the embodiments of the present application.

[0046] Unless otherwise expressly specified or limited, in the description of the embodiments of the present application, the terms such as "install", "connect", "connect", "fix", "set", etc. used should be understood in a broad sense. For example, the "connection" can be a fixed connection, a detachable connection, or an integrated setting; it can be a mechanical connection, an electrical connection, or a communication connection; it can be a direct connection, or it can be indirectly connected through an intermediate medium; it can be the internal connection of two elements or the interaction relationship between two elements. For technicians in the technical field to which the present application belongs, the specific meanings of the above terms in the embodiments of the present application can be understood according to the specific circumstances.

[0047] Embodiment 1

[0048] In view of the above-mentioned defects in the existing technology, the applicant, based on many years of rich practical experience and professional knowledge in this field, and in conjunction with the application of theory, actively conducts research and innovation in the hope of creating a technology that can solve the defects in the existing technology. After continuous research and design, the present invention with real practical value was finally created.

[0049] Please refer to Figure 1 , is a flow chart of a method for automatically verifying budget demand data provided in Embodiment 1 of the present invention. The method specifically comprises the following steps:

[0050] S101, creating an Excel form, wherein the Excel form includes a data verification module, a cross-reference relationship verification module and an automatic summary calculation module.

[0051] It should be noted that the created Excel form serves as the basic platform for the entire data processing and verification process. This step ensures that all subsequent operations will be carried out in a unified and standardized environment, thereby improving the consistency and efficiency of the overall process.

[0052] The design of modules such as data verification module, cross-reference verification module and automatic summary calculation module is aimed at comprehensively improving the efficiency and accuracy of data processing.

[0053] In an implementation of this embodiment, the step S101 may be further refined to include the following contents:

[0054] Create an Excel spreadsheet;

[0055] In the Excel form, VBA code is used to establish a data verification module, a cross-reference relationship verification module and an automatic summary calculation module.

[0056] It should be noted that in the created Excel form, three core modules are carefully designed and constructed using the powerful programming tool VBA (Visual Basic for Applications): data verification module, cross-reference verification module and automatic summary calculation module.

[0057] The data verification module uses VBA code to fully verify the budget demand data in the Excel form. This module can automatically check the format, range and logical consistency of the data to ensure the accuracy of the data.

[0058] The cross-reference verification module also relies on VBA code to strictly verify the cross-reference relationship between the master table and the detail table in the Excel form. This step ensures the consistency and rationality of the data and effectively prevents data errors or omissions.

[0059] The automatic summary calculation module uses the automatic processing capabilities of VBA code to automatically summarize and calculate the budget demand data and basic data from different units in the Excel form. This module not only improves the efficiency of data processing, but also ensures the accuracy of the calculation results.

[0060] Through this series of carefully designed modules, Excel spreadsheets have been successfully transformed into a powerful and easy-to-use data processing and verification tool. This innovative approach not only significantly reduces the complexity and workload of manual operations, but also effectively improves the accuracy and efficiency of data processing and analysis, providing strong support for the organization's resource allocation decisions.

[0061] S102: Using the data verification module to verify the budget demand data in the Excel form.

[0062] It should be noted that this step relies on the data verification module to conduct a comprehensive and detailed verification of the budget demand data entered in the Excel table. This step ensures the integrity and accuracy of the data and provides a solid foundation for subsequent analysis.

[0063] In one implementation of this embodiment, the Excel form includes the budget item name, budget amount and budget date.

[0064] It should be noted that the Excel form not only serves as a basic platform for data processing and verification, but also contains multiple key fields to ensure the integrity and accuracy of the data. Specifically, the Excel form includes important information such as the budget item name, budget amount and budget date. These information together constitute the core components of the budget demand data and provide the necessary basis for subsequent data verification.

[0065] In an implementation of this embodiment, the step S102 may be further refined to include the following contents:

[0066] Check whether the budget amount is greater than 0;

[0067] Verify that the budget date is within a reasonable range.

[0068] It should be noted that the step of checking whether the budget amount is greater than 0 is the basis of data verification and is intended to ensure the validity of the budget amount. By checking whether the budget amount is greater than 0, invalid or illogical budget requests can be excluded, thereby ensuring the accuracy and rationality of the data.

[0069] Verify that the budget date is within a reasonable range: This step is to verify the rationality of the budget date. Specifically, it is necessary to check whether the budget date is within a predetermined time range (for example, the budget request for the current year should be between the start date and end date of the year). Through this verification, the timeliness of the budget request can be ensured and outdated or invalid budget data can be avoided.

[0070] In summary, by refining the operation process of step S102 and combining it with the rich data fields in the Excel form, an efficient and accurate automatic verification system for budget demand data is successfully built. This system not only significantly reduces the complexity and workload of manual operations, but also improves the efficiency and accuracy of data processing, providing strong support for the organization's resource allocation decisions.

[0071] S103: Use the cross-reference verification module to verify the cross-reference relationship between the master table and the detail table in the Excel form.

[0072] It should be noted that this step uses the cross-reference verification module to strictly verify the logical relationship between the master table and each detail table in the Excel table. This step effectively verifies the consistency and rationality of the data and further enhances the credibility of the data.

[0073] S104: Utilize the automatic summary calculation module to automatically summarize and calculate the budget demand data and basic data of each unit in the Excel form, and save them to a database.

[0074] It should be noted that this step uses the automatic summary calculation module to automatically summarize and calculate the budget demand data and basic data from different units in the Excel table, and safely stores the processing results in the database. This step not only greatly improves the speed of data processing, but also ensures the immediate availability and security of data.

[0075] In an implementation of this embodiment, the step S104 may be further refined to include the following contents:

[0076] The automatic summary calculation module is used to automatically summarize the budget demand data and basic data of each unit in the Excel form;

[0077] The automatic summary calculation module is used to automatically calculate the total budget amount and the budget average value for the data summarized in the Excel form, and save them in the database.

[0078] It should be noted that, first of all, the automatic summary calculation module is used to automatically summarize the budget demand data and basic data of each unit in the Excel form. This step is the core link of data processing, which ensures the accurate collection and integration of all relevant data. Specifically, the automatic summary calculation module will traverse each unit in the Excel form, extract its budget demand data and basic data (such as the number of personnel, the number of projects, etc.), and summarize these data according to the preset rules. In this process, the module will automatically identify and process various data formats to ensure the accuracy and completeness of the data.

[0079] Next, the automatic summary calculation module is used to automatically calculate the summarized data to obtain the total budget amount and the budget average, and these calculation results are saved in the database. This step is a deepening link in data processing. It obtains key financial indicators through further analysis of the summarized data. Specifically, the module will calculate the total budget amount based on the summarized budget demand data, that is, the sum of all unit budget demands; at the same time, it will also calculate the budget average based on the basic data and budget demand data to reflect the average level of budget demands of each unit. These calculation results are of great significance for subsequent budget analysis, decision making, etc.

[0080] By refining the operation process of step S104, an efficient and accurate automatic summary and calculation system for budget demand data is successfully constructed. This system not only significantly improves the efficiency and accuracy of data processing, but also ensures the timeliness and availability of calculation results, providing strong data support for the organization's resource allocation decisions. At the same time, saving the calculation results to the database also facilitates subsequent data query and analysis, further improving the convenience and efficiency of data management.

[0081] In one implementation of this embodiment, the Excel form also includes an information sharing and review module;

[0082] The information sharing and review module is used to realize the sharing function of budget demand data between the financial department and the responsible department, so as to facilitate the inquiry and review by the financial department.

[0083] It should be noted that this embodiment introduces an information sharing and review module to optimize the processing flow of budget demand data and improve the efficiency and transparency of data management.

[0084] Specifically, the newly added information sharing and review module in the Excel form is designed to achieve seamless sharing of budget demand data between the finance department and the responsible department. The design of this function fully considers the collaborative needs of different departments in the budget management process, ensuring the timely transmission and efficient use of data. Through the information sharing and review module, the finance department can easily query the budget demand data submitted by the responsible department, so as to conduct detailed review and analysis. Similarly, the responsible department can also obtain real-time feedback from the finance department on budget needs, so as to adjust and optimize the budget plan in a timely manner.

[0085] In actual operation, the information sharing and auditing module ensures the security and confidentiality of data during the sharing process through a series of technical means, such as data encryption and permission control. At the same time, the module also provides flexible data query and screening functions, allowing users to quickly locate the required budget demand data according to their needs, thereby improving the efficiency and accuracy of data processing.

[0086] In one implementation of this embodiment, the Excel form also includes a revision execution module;

[0087] The revision execution module is used to implement the budget reserve outbound operation according to the reviewed reserve demand, and supports the function of rolling revision of the budget.

[0088] It should be noted that this embodiment introduces a revision execution module to further enhance the processing capability and flexibility of budget demand data.

[0089] Specifically, the newly added revision execution module in the Excel form mainly undertakes two important tasks: first, to execute the budget reserve outbound operation according to the audited reserve demand; second, to support the rolling revision function of the budget. The realization of these two functions not only improves the precision and response speed of budget management, but also enhances the adaptability and flexibility of the budget plan.

[0090] In the budget reserve outbound operation, the revision execution module will automatically extract the corresponding budget resources from the budget reserve according to the reserve requirements reviewed by the finance department, and allocate them to the corresponding departments or projects. This process not only ensures the reasonable allocation and effective use of budget resources, but also greatly improves the efficiency and accuracy of budget execution.

[0091] At the same time, the revision execution module also supports the rolling revision function of the budget. This means that during the budget management process, when the external environment or internal conditions change, users can flexibly adjust and optimize the budget plan according to the actual situation. Through the revision execution module, users can easily modify budget data, adjust budget allocations, update budget plans, etc., to ensure that the budget plan is always consistent with the organization's goals.

[0092] In actual operation, the revision execution module provides a friendly user interface and convenient operation process, allowing users to easily complete the budget outbound operation and rolling revision work. At the same time, the module also has a strong data processing capability, which can quickly process a large amount of budget data to ensure the timeliness and accuracy of budget management.

[0093] In one implementation of this embodiment, the Excel form also includes an error prompt module;

[0094] The error prompt module is used to implement an error prompt function.

[0095] It should be noted that this embodiment introduces an error prompt module to further improve the user experience and efficiency during use.

[0096] Specifically, the newly added error prompt module in the Excel form mainly undertakes a key task: to implement the error prompt function. This function is designed to help users promptly discover and correct errors that may occur during the entry, processing or analysis of budget demand data.

[0097] In actual operation, when users are entering, modifying or analyzing budget demand data, if the system detects that the data is wrong or does not conform to the preset rules (such as data format errors, data outside the reasonable range, inconsistent cross-references, etc.), the error prompt module will immediately pop up the corresponding prompt information to inform the user of the specific location and cause of the error. In this way, users can quickly locate and correct the error based on the prompt information, thereby avoiding deviations in subsequent processing and analysis results caused by erroneous data.

[0098] In addition, the error prompt module also has intelligent learning and optimization functions. It will continuously optimize the rules and algorithms for error detection based on user feedback and error types during use, and improve the accuracy and efficiency of error identification. At the same time, the module can also record the user's error correction operation process, so as to provide users with more personalized error prompts and solutions in subsequent use.

[0099] Although the terms such as verification, cross-checking, and form are used more frequently in this application, the possibility of using other terms is not excluded. These terms are used only to more conveniently describe and explain the essence of the present invention; interpreting them as any additional restrictions is contrary to the spirit of the present invention.

[0100] The present invention provides an automatic verification method for budget demand data. By introducing an advanced automatic verification tool, namely an Excel form including a data verification module, a cross-reference verification module and an automatic summary calculation module, it is possible to more effectively integrate, process and analyze data, thereby greatly reducing the workload of manual operations, alleviating the burden on staff, shortening the time for data processing and analysis, improving work efficiency, and ensuring that the resource allocation process is more efficient, accurate and reliable.

[0101] Embodiment 2

[0102] Figure 2 A schematic diagram of the structure of a computer device provided in Embodiment 2 of the present invention. Figure 2 A block diagram of an exemplary computer device 12 suitable for use in implementing embodiments of the present invention is shown. Figure 2 The computer device 12 shown is only an example and should not bring any limitation to the functions and scope of use of the embodiments of the present invention.

[0103] like Figure 2 As shown, the computer device 12 is in the form of a general-purpose computing device. The components of the computer device 12 may include, but are not limited to: one or more processors or processing units 16, a system memory 28, and a bus 18 that connects various system components (including the system memory 28 and the processing unit 16).

[0104] Bus 18 represents one or more of several types of bus structures, including a memory bus or memory controller, a peripheral bus, an accelerated graphics port, a processor or a local bus using any of a variety of bus architectures. By way of example, these architectures include, but are not limited to, an Industry Standard Architecture (ISA) bus, a Micro Channel Architecture (MAC) bus, an Enhanced ISA bus, a Video Electronics Standards Association (VESA) local bus, and a Peripheral Component Interconnect (PCI) bus.

[0105] The computer device 12 typically includes a variety of computer system readable media. These media can be any available media that can be accessed by the computer device 12, including volatile and non-volatile media, removable and non-removable media.

[0106] The system memory 28 may include computer system readable media in the form of volatile memory, such as random access memory (RAM) 30 and / or cache memory 32. The computer device 12 may further include other removable / non-removable, volatile / non-volatile computer system storage media. By way of example only, the storage system 34 may be used to read and write non-removable, non-volatile magnetic media ( Figure 2 not shown, usually called a "hard drive"). Although Figure 2Not shown in the figure, a disk drive for reading and writing to a removable non-volatile disk (e.g., a "floppy disk"), and an optical disk drive for reading and writing to a removable non-volatile optical disk (e.g., a CD-ROM, a DVD-ROM, or other optical media) may be provided. In these cases, each drive may be connected to the bus 18 via one or more data medium interfaces. The memory 28 may include at least one program product having a set (e.g., at least one) of program modules that are configured to perform the functions of the various embodiments of the present invention.

[0107] A program / utility 40 having a set (at least one) of program modules 42 may be stored, for example, in the memory 28, such program modules 42 including but not limited to an operating system, one or more application programs, other program modules, and program data, each of which or some combination may include an implementation of a network environment. The program modules 42 generally perform the functions and / or methods of the embodiments described herein.

[0108] The computer device 12 may also communicate with one or more external devices 14 (e.g., keyboards, pointing devices, displays 24, etc.), one or more devices that enable a user to interact with the computer device 12, and / or any device that enables the computer device 12 to communicate with one or more other computing devices (e.g., a network card, a modem, etc.). Such communication may be performed via an input / output (I / O) interface 22. In addition, the computer device 12 may also communicate with one or more networks (e.g., a local area network (LAN), a wide area network (WAN), and / or a public network, such as the Internet) via a network adapter 20. As shown, the network adapter 20 communicates with the other modules of the computer device 12 via a bus 18. It should be understood that although Figure 2 Not shown, other hardware and / or software modules may be used in conjunction with computer device 12, including but not limited to microcode, device drivers, redundant processing units, external disk drive arrays, RAID systems, tape drives, and data backup storage systems.

[0109] The processing unit 16 executes various functional applications and data processing by running the programs stored in the system memory 28, such as implementing the automatic verification method of budget demand data provided in the embodiment of the present invention.

[0110] Embodiment 3

[0111] Embodiment 3 of the present invention provides a computer-readable storage medium on which computer-executable instructions are stored. When the instructions are executed by a processor, the method for automatically verifying budget demand data provided in all the embodiments of the present application is implemented.

[0112] Any combination of one or more computer-readable media may be used. A computer-readable medium may be a computer-readable signal medium or a computer-readable storage medium. A computer-readable storage medium may be, for example, but not limited to, an electrical, magnetic, optical, electromagnetic, infrared, or semiconductor system, device, or device, or any combination thereof. More specific examples (a non-exhaustive list) of computer-readable storage media include: an electrical connection with one or more wires, a portable computer disk, a hard disk, a random access memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), an optical fiber, a portable compact disk read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination thereof. In this document, a computer-readable storage medium may be any tangible medium containing or storing a program that may be used by or in conjunction with an instruction execution system, device, or device.

[0113] Computer-readable signal media may include data signals propagated in baseband or as part of a carrier wave, which carry computer-readable program code. Such propagated data signals may take a variety of forms, including but not limited to electromagnetic signals, optical signals, or any suitable combination of the above. Computer-readable signal media may also be any computer-readable medium other than a computer-readable storage medium, which may send, propagate, or transmit a program for use by or in conjunction with an instruction execution system, apparatus, or device.

[0114] Program code embodied on a computer readable medium may be transmitted using any appropriate medium, including but not limited to wireless, wireline, optical fiber cable, RF, etc., or any suitable combination of the foregoing.

[0115] Computer program code for performing the operations of the present invention may be written in one or more programming languages ​​or a combination thereof, including object-oriented programming languages ​​such as Java, Smalltalk, C++, and conventional procedural programming languages ​​such as "C" or similar programming languages. The program code may be executed entirely on the user's computer, partially on the user's computer, as a separate software package, partially on the user's computer and partially on a remote computer, or entirely on a remote computer or server. In the case of a remote computer, the remote computer may be connected to the user's computer through any type of network, including a local area network (LAN) or a wide area network (WAN), or may be connected to an external computer (e.g., through the Internet using an Internet service provider).

[0116] Finally, it should be noted that although the above embodiments have been described in the specification and drawings of this application, this does not limit the scope of patent protection of this application. All technical solutions generated by replacing or modifying equivalent structures or equivalent processes based on the essential concept of this application using the contents recorded in the specification and drawings of this application, as well as directly or indirectly implementing the technical solutions of the above embodiments in other related technical fields, are included in the scope of patent protection of this application.

Claims

1. A method for automatically verifying budget demand data, characterized in that: The method comprises: Create an Excel form, which includes a data verification module, a cross-reference relationship verification module and an automatic summary calculation module; Using the data verification module to verify the budget demand data in the Excel form; Using the cross-reference verification module to verify the cross-reference relationship between the general table and the detailed table in the Excel form; The automatic summary calculation module is used to automatically summarize and calculate the budget demand data and basic data of each unit in the Excel form, and save them to the database.

2. The method for automatically verifying budget demand data according to claim 1, characterized in that: The step of creating an Excel form, wherein the Excel form includes a data verification module, a cross-reference relationship verification module, and an automatic summary calculation module comprises: Create an Excel spreadsheet; In the Excel form, VBA code is used to establish a data verification module, a cross-reference relationship verification module and an automatic summary calculation module.

3. The method for automatically verifying budget demand data according to claim 1, characterized in that: The Excel form includes the budget item name, computer equipment and storage media, budget amount and budget date.

4. The method for automatically verifying budget demand data according to claim 3, characterized in that: The step of using the data verification module to verify the budget demand data in the Excel form includes: The budget demand data in the Excel form is verified by using the data verification module as follows: Check whether the budget amount is greater than 0; Verify that the budget date is within a reasonable range.

5. The method for automatically verifying budget demand data according to claim 1, characterized in that: The step of automatically aggregating and calculating the budget demand data and basic data of each unit in the Excel form by using the automatic aggregation calculation module and saving them to the database includes: The automatic summary calculation module is used to automatically summarize the budget demand data and basic data of each unit in the Excel form; The automatic summary calculation module is used to automatically calculate the total budget amount and the budget average value for the data summarized in the Excel form, and save them in the database.

6. The method for automatically verifying budget demand data according to claim 1, characterized in that: The Excel form also includes an information sharing and review module; The information sharing and review module is used to realize the sharing function of budget demand data between the financial department and the responsible department, so as to facilitate the inquiry and review by the financial department.

7. The method for automatically verifying budget demand data according to claim 1, characterized in that: The Excel form also includes a revision execution module; The revision execution module is used to implement the budget reserve outbound operation according to the reviewed reserve demand, and supports the function of rolling revision of the budget.

8. The method for automatically verifying budget demand data according to claim 1, characterized in that: The Excel form also includes an error prompt module; The error prompt module is used to implement an error prompt function.

9. A computer device comprising a memory and a processor, wherein the memory stores a computer program, wherein: When the processor executes the computer program, the method for automatically verifying budget demand data according to any one of claims 1 to 8 is implemented.

10. A storage medium containing computer executable instructions, characterized in that: The computer executable instructions are executed by a computer processor to implement the method for automatically verifying budget demand data according to any one of claims 1 to 8.

Images