CN110347992B - Data analysis method and system based on electronic report - Google Patents
Data analysis method and system based on electronic report Download PDFInfo
- Publication number
- CN110347992B CN110347992B CN201910619533.0A CN201910619533A CN110347992B CN 110347992 B CN110347992 B CN 110347992B CN 201910619533 A CN201910619533 A CN 201910619533A CN 110347992 B CN110347992 B CN 110347992B
- Authority
- CN
- China
- Prior art keywords
- report
- cloud server
- processed
- electronic report
- calculation
- 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.)
- Active
Links
- 238000000034 method Methods 0.000 title claims abstract description 70
- 238000007405 data analysis Methods 0.000 title claims abstract description 27
- 238000004364 calculation method Methods 0.000 claims abstract description 54
- 238000004891 communication Methods 0.000 claims abstract description 13
- 230000008569 process Effects 0.000 claims abstract description 12
- 238000012545 processing Methods 0.000 claims description 15
- 238000004590 computer program Methods 0.000 claims description 8
- 238000004140 cleaning Methods 0.000 claims description 6
- 238000007670 refining Methods 0.000 claims description 5
- 238000006243 chemical reaction Methods 0.000 claims description 3
- 230000001360 synchronised effect Effects 0.000 claims 2
- 238000010586 diagram Methods 0.000 description 5
- 238000004458 analytical method Methods 0.000 description 4
- 230000005540 biological transmission Effects 0.000 description 4
- 230000006870 function Effects 0.000 description 4
- 230000008878 coupling Effects 0.000 description 3
- 238000010168 coupling process Methods 0.000 description 3
- 238000005859 coupling reaction Methods 0.000 description 3
- 230000006978 adaptation Effects 0.000 description 2
- 238000003491 array Methods 0.000 description 1
- 238000012550 audit Methods 0.000 description 1
- 238000004422 calculation algorithm Methods 0.000 description 1
- 238000013479 data entry Methods 0.000 description 1
- 238000013461 design Methods 0.000 description 1
- 238000011161 development Methods 0.000 description 1
- 235000019800 disodium phosphate Nutrition 0.000 description 1
- 230000006872 improvement Effects 0.000 description 1
- 238000007726 management method Methods 0.000 description 1
- 238000012544 monitoring process Methods 0.000 description 1
- 238000006467 substitution reaction Methods 0.000 description 1
- 230000007306 turnover Effects 0.000 description 1
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/10—File systems; File servers
- G06F16/16—File or folder operations, e.g. details of user interfaces specifically adapted to file systems
- G06F16/168—Details of user interfaces specifically adapted to file systems, e.g. browsing and visualisation, 2d or 3d GUIs
-
- 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
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Physics & Mathematics (AREA)
- Artificial Intelligence (AREA)
- Health & Medical Sciences (AREA)
- Audiology, Speech & Language Pathology (AREA)
- Computational Linguistics (AREA)
- General Health & Medical Sciences (AREA)
- Databases & Information Systems (AREA)
- Data Mining & Analysis (AREA)
- Human Computer Interaction (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The embodiment of the invention discloses a data analysis method and a system based on an electronic report, wherein the method comprises the following steps: the client establishes communication connection with the cloud server; the client receives user operation to obtain a to-be-processed electronic report, and sends the to-be-processed report to the cloud server; the cloud server processes the electronic report to be processed based on a pre-stored calculation logic, a key field database, a calculation index formula and an output formula to obtain a table file; the cloud server sends the form file to an external user. By implementing the embodiment of the invention, the time for data input or formula establishment of an external report user is greatly saved, and the legal report of more than 95% of continental areas can be identified and calculated, so that the method has strong universality. In addition, the method is characterized by moving and working for 24 hours in the whole day because the method is carried out by the Internet, thereby greatly improving the calculation requirement of the original report user on the data, and being particularly high-efficiency, accurate and low-cost.
Description
Technical Field
The invention relates to the technical field of electronic report processing, in particular to a data analysis method, a client, a cloud server and a system based on an electronic report.
Background
In the economic field, decision makers often make a "good or bad" judgment by a most direct and intuitive method, namely, calculate financial data results, for various purposes such as investment, audit, analysis, economic pre-warning, and economic monitoring.
The method for calculating and using the financial data results is the most commonly adopted method for global external decision makers (namely external data users who make economic judgment through external data sources), and the process is that the external decision makers calculate the data recorded by the financial report through a preset calculation formula, so that various desired results are obtained. After the popularization of computers, decision makers often calculate by various computer software such as Excel, SPSS, x finance software, etc. to obtain results.
However, in actual work, the calculation of the above-mentioned various software is to be realized, the first step is data input, and especially, the external decision maker firstly and must do work after obtaining various data provided by the external object, namely, firstly inputting the required external data into Excel and then starting the subsequent model formula establishment and calculation. Although the calculation process is completed by a computer, the speed is very high, the traditional recording work always has the following bottlenecks, which restrict the improvement of the whole work efficiency:
(1) When the acquired external data source is a paper certificate:
The process of logging into Excel is laborious and inefficient. When a decision maker wants to calculate a result by using external data, the data entry workload is huge and takes a long time.
(2) When the acquired external data source is electronic file data:
Problem one: the forms of enterprises that acquire external data sources are various, and thus the acquired report forms are also various.
And a second problem: the same type of enterprises, such as civil enterprises, have the problem that the financial software is used for compiling the report forms due to different requirements of financial management, but the report forms are saved through Excel after being compiled by traditional manual operation, so that the report forms are not uniform from different compiling modes to the final report forms.
Problem three: the report formats finally generated by different software companies are under the national unified standard, but are not completely the same to a greater or lesser extent, and the problem of non-uniform report formats can be caused. Such as: the subject of the year accounts payable can appear in different places of B24, D47, C23, D18, etc. in the electronic form according to the typesetting requirements of different companies.
Fourth problem: when an external decision maker faces various forms of electronic report forms, a calculation formula needs to be re-established for each different electronic report form. Such as:
accounts payable turnover number (including payable) =current accumulated number/business cost (payable of the present year + payable of the last year)/2.
Disclosure of Invention
The embodiment of the invention aims to provide a data analysis method, a client, a cloud server and a system based on an electronic report, so as to greatly improve the efficiency of reading and using report data of an external decision maker.
To achieve the above object, in a first aspect, an embodiment of the present invention provides a data analysis method based on an electronic report, including:
Establishing communication connection with a client;
receiving the electronic report to be processed uploaded by the client;
Processing the electronic report to be processed based on a pre-stored calculation logic, a key field database, a calculation index formula and an output formula to obtain a table file;
And sending the form file to an external user.
As a preferred embodiment of the present application, the electronic report to be processed is processed based on pre-stored calculation logic, a key field database, a calculation index formula and an output formula to obtain a table file, which specifically includes:
Identifying, storing and numbering characters and numbers contained in the electronic report to be processed through preset logic to obtain a processing result;
Comparing, cleaning and converting the processing result with a pre-stored key field database to obtain a comparison result;
Calculating the comparison result based on a preset calculation index formula to obtain a calculation result;
And filling the calculation result according to a preset output format to generate a table file.
In a second aspect, an embodiment of the present invention provides a data analysis method based on an electronic report, including:
Establishing communication connection with a cloud server;
receiving user operation to obtain a to-be-processed electronic report, and sending the to-be-processed report to the cloud server;
And receiving a table file sent by the cloud server, wherein the table file is obtained by processing the electronic report to be processed by the cloud server based on a pre-stored calculation logic, a key field database, a calculation index formula and an output formula.
As a preferred embodiment of the present application, receiving a user operation to obtain a pending electronic report, specifically includes:
receiving login operation of a user to enter an operation page;
Receiving a selection operation of a user on the operation page to determine the electronic report to be processed;
and receiving uploading operation of a user to acquire the prestored electronic report to be processed.
Further, the data analysis method further includes:
And sending the report to be processed to a mailbox reserved by an external user.
In a third aspect, an embodiment of the present invention provides a data analysis method based on an electronic report, including:
The client establishes communication connection with the cloud server;
the client receives user operation to obtain a to-be-processed electronic report, and sends the to-be-processed report to the cloud server;
the cloud server processes the electronic report to be processed based on a pre-stored calculation logic, a key field database, a calculation index formula and an output formula to obtain a table file;
and the cloud server sends the form file to an external user.
As a preferred embodiment of the present application, the client receives a user operation to obtain a pending electronic report, and specifically includes:
The client receives login operation of a user to enter an operation page;
Receiving a selection operation of a user at the operation page by the client to determine the report to be processed;
The client receives uploading operation of a user to acquire the prestored pending report
In a fourth aspect, an embodiment of the present invention further provides a cloud server, including a processor, an input device, an output device, and a memory, where the processor, the input device, the output device, and the memory are connected to each other, where the memory is configured to store a computer program, the computer program includes program instructions, and the processor is configured to call the program instructions and execute the method of the first aspect.
In a fifth aspect, an embodiment of the present invention further provides a client, including a processor, an input device, an output device, and a memory, where the processor, the input device, the output device, and the memory are connected to each other, and the memory is configured to store a computer program, where the computer program includes program instructions, and the processor is configured to invoke the program instructions to perform the method of the second aspect.
In a sixth aspect, the embodiment of the invention further provides a data analysis system based on the electronic report, which comprises a client and a cloud server. Wherein the cloud server is as described in the fourth aspect, and the client is as described in the fifth aspect.
By implementing the embodiment of the invention, the time for data input or formula establishment of an external report user is greatly saved, and the legal report of more than 95% of continental areas can be identified and calculated, so that the method has strong universality. In addition, the method is characterized by moving and working for 24 hours in the whole day because the method is carried out by the Internet, thereby greatly improving the calculation requirement of the original report user on the data, and being particularly high-efficiency, accurate and low-cost.
Drawings
In order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, the drawings used in the description of the embodiments or the prior art will be briefly described below. Like elements or portions are generally identified by like reference numerals throughout the several figures. In the drawings, elements or portions thereof are not necessarily drawn to scale.
FIG. 1 is a schematic flow chart of a method for analyzing electronic report-based data provided by a first embodiment of the invention;
FIG. 2 is a schematic flow chart of a method for electronic report based data analysis provided by a second embodiment of the present invention;
FIG. 3 is a schematic flow chart of a method for electronic report based data analysis provided by a third embodiment of the present invention;
FIG. 4 is a diagram of a particular operational page for WeChat public number Port development;
FIG. 5 is an output results interface diagram;
FIG. 6 is a schematic diagram of a data analysis system based on electronic report according to the first embodiment of the present invention;
fig. 7 is a schematic structural diagram of the cloud server shown in fig. 6;
Fig. 8 is a schematic diagram of the structure of the client shown in fig. 6.
Detailed Description
The following description of the embodiments of the present invention will be made clearly and fully with reference to the accompanying drawings, in which it is evident that the embodiments described are some, but not all embodiments of the invention. All other embodiments, which can be made by those skilled in the art based on the embodiments of the invention without making any inventive effort, are intended to be within the scope of the invention.
It should be understood that the terms "comprises" and "comprising," when used in this specification and the appended claims, specify the presence of stated features, integers, steps, operations, elements, and/or components, but do not preclude the presence or addition of one or more other features, integers, steps, operations, elements, components, and/or groups thereof. It is also to be understood that the terminology used in the description of the invention herein is for the purpose of describing particular embodiments only and is not intended to be limiting of the invention. As used in this specification and the appended claims, the singular forms "a," "an," and "the" are intended to include the plural forms as well, unless the context clearly indicates otherwise.
It should be further understood that the term "and/or" as used in the present specification and the appended claims refers to any and all possible combinations of one or more of the associated listed items, and includes such combinations.
Referring to fig. 1, a data analysis method based on an electronic report according to a first embodiment of the present invention is shown. It should be noted that, in this embodiment, the cloud server is used as an execution body for explanation. As shown, the method may include the steps of:
S101, establishing communication connection with the client.
Specifically, a mobile storage server is established at a cloud end and used as a carrier for storing various original data, related computing software and various interfaces.
S102, receiving the electronic report to be processed uploaded by the client.
Specifically, the user operates an application program installed on the client or through a WeChat public number to upload the electronic report to be processed to the cloud server. The specific process of the client obtaining and uploading the electronic report to be processed will be described in detail in the following embodiments.
S103, processing the electronic report to be processed based on a pre-stored calculation logic, a key field database, a calculation index formula and an output formula to obtain a table file.
Specifically, step S103 includes:
Identifying, storing and numbering characters and numbers contained in the electronic report to be processed through preset logic to obtain a processing result;
Comparing, cleaning and converting the processing result with a pre-stored key field database to obtain a comparison result;
Calculating the comparison result based on a preset calculation index formula to obtain a calculation result;
And filling the calculation result according to a preset output format to generate a table file.
The key field database is formed by the inventor after collecting, refining and summarizing the related information of all main flow legal enterprise reports in the current Chinese continental area for many times, so that the report adaptation rate is very high, and the working efficiency and accuracy can be greatly improved.
By implementing the data analysis method based on the electronic report, various external electronic reports are identified, matched, classified and calculated on the cloud server through implementation of the technical means and reconstruction of business logic, so that the time for data input or formula establishment of an external report user is greatly saved, legal reports in more than 95% of continental areas can be identified and calculated, and the method has strong universality. In addition, the method is characterized by moving and working for 24 hours in the whole day because the method is carried out by the Internet, thereby greatly improving the calculation requirement of the original report user on the data, and being particularly high-efficiency, accurate and low-cost.
Referring to fig. 2, a data analysis method based on an electronic report according to a second embodiment of the present invention is shown. In this embodiment, the client is used as an execution body. As shown, the method may include the steps of:
s201, establishing communication connection with a cloud server.
Specifically, a WeChat public number is established, and the WeChat public number is connected with a cloud server port so as to establish communication connection between a client and the cloud server. And transmitting the data to a cloud server for subsequent operation according to the preset format and character requirements through the specific data transmission page of the developed WeChat public account number. Wherein the client includes, but is not limited to, mobile handsets and the like.
S202, receiving user operation to acquire the electronic report to be processed.
The specific operation page developed at the WeChat public number Port is used for transmission of the external electronic form, based on which step S202 includes:
(1) The client receives login operation of a user to enter an operation page. On the operation page, according to the requirements of the national economy industry classification standard of 2017 edition published by the national statistical office, a drop-down menu of 97 class industry distribution is provided for an external user to select.
(2) And receiving a selection operation of a user in the operation page to determine a pending report.
After determining the industry to which report data belongs, a user selects a specific year of a report to be uploaded in a pull-down menu mode, for example: 2015. 2016, 2017, 2020, etc.
(3) And receiving uploading operation of a user to acquire a prestored report to be processed.
After determining the specific time for uploading the report, for example, in 2018, the external user selects an "Excel report uploading" icon to enter a file uploading state. At this time, the WeChat public number can automatically call the storage function of the mobile phone, and an external user can select the file to be uploaded by clicking the file after finding the Excel file stored in advance.
If the external user needs to submit other time file uploading, such as 2019, the above steps are repeated until all the required files are selected.
And S203, sending the electronic report to be processed to a cloud server, and simultaneously sending the report to be processed to a mailbox reserved by an external user.
After all files to be uploaded are selected, the system automatically uploads all Excel files selected by external users to the cloud server after clicking a ' submit ' button, and meanwhile, the mobile phone interface immediately prompts ' mail sending success-! The method is characterized in that the character is adopted, and in the same time, an external user can simultaneously receive a mail of 31 common calculation indexes displayed through an Excel electronic table in a pre-stored mailbox, and the analysis result of the 31 common indexes can be obtained within 1 minute after the original 141-minute input or 45-minute formula establishment is carried out.
S204, receiving the form file sent by the cloud server.
After receiving the electronic report to be processed uploaded by the client, the cloud server processes the electronic report to be processed based on a prestored calculation logic, a key field database, a calculation index formula and an output formula to obtain a form file, and sends the form file to the client.
By implementing the embodiment of the invention and reconstructing business logic, various external electronic reports are identified, matched, classified and calculated on the cloud server, so that the time for data input or formula establishment of external report users is greatly saved, and legal reports in more than 95% of continental areas can be identified and calculated, thereby having stronger universality. In addition, the method is characterized by moving and working for 24 hours in the whole day because the method is carried out by the Internet, thereby greatly improving the calculation requirement of the original report user on the data, and being particularly high-efficiency, accurate and low-cost.
By taking the case of three sets (9) of reports of an enterprise for three years as an example, the invention realizes 31 common index analysis results which can be obtained after the original 141 minutes of input or 45 minutes of formula establishment in 1 minute on the premise of 100% accuracy and is practical for more than 95% of legal enterprise reports in the current national continental area.
Referring to fig. 3, a third embodiment of the present invention provides a data analysis method based on electronic report. As shown, the method may include the steps of:
s301, a client establishes communication connection with a cloud server;
s302, a client receives user operation to obtain a to-be-processed electronic report, and the to-be-processed report is sent to a cloud server;
S303, the cloud server processes the electronic report to be processed based on a pre-stored calculation logic, a key field database, a calculation index formula and an output formula to obtain a table file;
S304, the cloud server form file is sent to an external user.
The process flow may be further described as follows:
1. And a mobile storage server is established at the cloud as a carrier for storing various original data, related computing software and various interfaces.
2. Setting up a micro-signal public number, connecting a micro-signal public number port with a cloud server port, and transmitting data to the cloud for subsequent operation according to a preset format and character requirements through a developed micro-signal public number specific data transmission page.
3. Developing a specific operation page (shown in fig. 4) at the WeChat public number port for transmission of an external electronic form, wherein the specific operation steps are as follows:
(1) After entering an operation page, according to the requirements of the national economy industry classification standard of 2017 edition published by the national statistics bureau, a drop-down menu of 97 class industry distribution is provided for an external user to select;
(2) After determining the industry to which report data belongs, a user selects a specific year of a report to be uploaded in a pull-down menu mode, for example: 2015. 2016, 2017, 2020, etc.;
(3) After determining the specific time for uploading the report, for example, in 2018, the external user selects an "Excel report uploading" icon to enter a file uploading state. At this time, the WeChat public number can automatically call the storage function of the mobile phone, and an external user can select the file to be uploaded by clicking the file after finding the Excel file stored in advance.
(4) If the external user needs to submit other time file uploading, such as 2019, repeating the step (3) until all the required files are selected;
(5) After all files to be uploaded are selected, the system automatically uploads all Excel files selected by external users to the cloud server after clicking a ' submit ' button, and meanwhile, the mobile phone interface immediately prompts ' mail sending success-! The method is characterized in that the character is adopted, and in the same time, an external user can simultaneously receive a mail of 31 common calculation indexes displayed through an Excel electronic table in a pre-stored mailbox, and the analysis result of the 31 common indexes can be obtained within 1 minute after the original 141-minute input or 45-minute formula establishment is carried out.
4. After receiving the electronic form uploaded by the WeChat public number, the cloud server carries out background operation on the preset logic through a series of instructions by Java language, and the cloud server not only identifies, stores and classifies the characters contained in the received electronic form, but also carries out comparison of a key field database by synchronization, thereby completing conversion and cleaning of numbers corresponding to the characters. For example, in the uploaded electronic form, 500 accounts receivable is presented at the position B23, but according to the requirements of the national accounting standards, the accounts should be accounts receivable, the accounts are different from accounts and the positions where the accounts appear are not on the position B23, but are accounts receivable due to the meaning of the accounts, so that at the moment, through the pre-determined computer language and the established program logic, the software automatically performs fuzzy query and comparison on the accounts receivable at the position B23 in the key field database, and determines that the accounts receivable are accounts according to the standard of the key field database, thereby the 500 accounts receivable are deposited into the accounts receivable accounts and used for subsequent calculation. The key field database is formed by the inventor after collecting, refining and summarizing the related information of all main flow legal enterprise reports in the current continental China for many times, so that the report adaptation rate is very high, and the working efficiency and accuracy can be greatly improved.
5. For the fields and data adapted by the key field database, the cloud server stores and establishes the most commonly used 31 calculation index formulas according to the related accounting system requirements of China to correspondingly calculate and output the result (as shown in fig. 5). For fields that do not fit through the "key fields" database, their data will be displayed with 0. Note that fig. 5 shows only a part of the output result by way of example, and the calculation of the output result is not limited to this in practice.
6. And finally, the cloud server fills the calculation result according to a preset output format, generates an Excel file, sends the Excel file to a mailbox reserved in the cloud by an external user, and ends the flow.
By implementing the embodiment and reconstructing business logic through the technical means, the legal electronic report is uploaded through the client, so that the time for data input or formula establishment of an external report user is greatly saved, various external electronic reports are identified, matched, classified and calculated on a cloud server, and the legal report in more than 95% of continental areas can be identified and calculated, so that the method has strong universality. In addition, the method is characterized by moving and working for 24 hours in the whole day because the method is carried out by the Internet, thereby greatly improving the calculation requirement of the original report user on the data, and being particularly high-efficiency, accurate and low-cost.
Based on the same inventive concept, the embodiment of the invention provides a data analysis system based on an electronic report. As shown in fig. 6, the data analysis system includes a cloud server 100 and a client 200.
Further, as shown in fig. 7, the cloud server 100 may include: one or more processors 101, one or more input devices 102, one or more output devices 103, and a memory 104, the processors 101, input devices 102, output devices 103, and memory 104 being interconnected by a bus 105. The memory 104 is used for storing a computer program comprising program instructions, the processor 101 being configured to invoke the program instructions for performing the method of the first method embodiment part described above.
Further, as shown in fig. 7, the client 200 may include: one or more processors 201, one or more input devices 202, one or more output devices 203, and a memory 204, the processors 201, input devices 202, output devices 203, and memory 204 being interconnected by a bus 205. The memory 204 is used for storing a computer program comprising program instructions, which the processor 201 is configured to invoke for performing the method of the second method embodiment part described above.
It should be appreciated that in embodiments of the present invention, the processors 101, 201 may be central processing units (Central Processing Unit, CPU), but may also be other general purpose processors, digital signal processors (DIGITAL SIGNAL processors, DSPs), application SPECIFIC INTEGRATED Circuits (ASICs), field-Programmable gate arrays (Field-Programmable GATE ARRAY, FPGA) or other Programmable logic devices, discrete gate or transistor logic devices, discrete hardware components, etc. A general purpose processor may be a microprocessor or the processor may be any conventional processor or the like.
The input devices 102, 202 may include a keyboard or the like and the output devices 103, 203 may include a display (LCD or the like), speakers or the like.
The memory 104, 204 may include read only memory and random access memory and provide instructions and data to the processor 101. A portion of the memory 104, 204 may also include non-volatile random access memory. For example, the memory 104, 204 may also store information of the device type.
In a specific implementation, the processor 101 (201), the input device 102 (202), and the output device 103 (203) described in the embodiments of the present invention may execute the implementation described in the embodiments of the electronic report based data analysis method provided in the embodiments of the present invention, which is not described herein again.
By implementing the data analysis device and the data analysis system provided by the embodiment of the invention, the time for data input or formula establishment of an external report user is greatly saved, and legal reports in more than 95% of continental areas can be identified and calculated, so that the data analysis device and the data analysis system have stronger universality. In addition, the method is characterized by moving and working for 24 hours in the whole day because the method is carried out by the Internet, thereby greatly improving the calculation requirement of the original report user on the data, and being particularly high-efficiency, accurate and low-cost.
It should be noted that, for the specific workflow of the data analysis system and the data analysis device according to the embodiments of the present invention, please refer to the foregoing method embodiment section, and no further description is given here.
Those of ordinary skill in the art will appreciate that the elements and algorithm steps described in connection with the embodiments disclosed herein may be embodied in electronic hardware, in computer software, or in a combination of the two, and that the elements and steps of the examples have been generally described in terms of function in the foregoing description to clearly illustrate the interchangeability of hardware and software. Whether such functionality is implemented as hardware or software depends upon the particular application and design constraints imposed on the solution. Skilled artisans may implement the described functionality in varying ways for each particular application, but such implementation decisions should not be interpreted as causing a departure from the scope of the present invention.
In the several embodiments provided by the present application, it should be understood that the disclosed systems and methods may be implemented in other ways. For example, the apparatus embodiments described above are merely illustrative, e.g., the division of the units is merely a logical function division, and there may be additional divisions when actually implemented, e.g., multiple units or components may be combined or integrated into another system, or some features may be omitted or not performed. In addition, the coupling or direct coupling or communication connection shown or discussed with each other may be an indirect coupling or communication connection via some interfaces, devices, or elements, or may be an electrical, mechanical, or other form of connection.
The units described as separate units may or may not be physically separate, and units shown as units may or may not be physical units, may be located in one place, or may be distributed on a plurality of network units. Some or all of the units may be selected according to actual needs to achieve the purpose of the embodiment of the present invention.
In addition, each functional unit in the embodiments of the present invention may be integrated in one processing unit, or each unit may exist alone physically, or two or more units may be integrated in one unit. The integrated units may be implemented in hardware or in software functional units.
The integrated units, if implemented in the form of software functional units and sold or used as stand-alone products, may be stored in a computer readable storage medium. Based on such understanding, the technical solution of the present invention is essentially or a part contributing to the prior art, or all or part of the technical solution may be embodied in the form of a software product stored in a storage medium, comprising several instructions for causing a computer device (which may be a personal computer, a server, or a network device, etc.) to perform all or part of the steps of the method according to the embodiments of the present invention.
While the invention has been described with reference to certain preferred embodiments, it will be understood by those skilled in the art that various changes and substitutions of equivalents may be made and equivalents will be apparent to those skilled in the art without departing from the scope of the invention. Therefore, the protection scope of the invention is subject to the protection scope of the claims.
Claims (6)
1. A method for analyzing data based on an electronic report, comprising:
Establishing communication connection with a client;
receiving the electronic report to be processed uploaded by the client;
Processing the electronic report to be processed based on a pre-stored calculation logic, a key field database, a calculation index formula and an output format to obtain a table file; the computing logic refers to various original data, related computing software and various interfaces stored in a cloud;
sending the form file to an external user;
The key field database is formed by collecting, refining and summarizing all main flow legal enterprise report related information in the current Chinese continental region for many times;
the forming process of the table file specifically comprises the following steps:
Recognizing, storing and numbering characters and numbers contained in the electronic report to be processed through preset calculation logic to obtain a processing result;
Comparing, cleaning and converting the processing result with a pre-stored key field database to obtain a comparison result;
Calculating the comparison result based on a preset calculation index formula to obtain a calculation result;
And filling the calculation result according to a preset output format to generate a table file.
2. A method for analyzing data based on an electronic report, comprising:
Establishing communication connection with a cloud server;
Receiving user operation to obtain an electronic report to be processed;
The report to be processed is sent to the cloud server, and meanwhile, the report to be processed is sent to a mailbox reserved by an external user;
Receiving a form file sent by the cloud server, wherein the form file is obtained by processing the electronic report to be processed by the cloud server based on a pre-stored calculation logic, a key field database, a calculation index formula and an output format; the computing logic refers to various original data, related computing software and various interfaces stored in a cloud;
The key field database is formed by collecting, refining and summarizing all main flow legal enterprise report related information in the current Chinese continental region for many times;
Receiving user operation to obtain an electronic report to be processed, wherein the method specifically comprises the following steps:
The client receives login operation of a user to enter an operation page, and on the operation page, a drop-down menu of 97 kinds of industry distribution is provided for an external user for selection according to related requirements published by the national statistical bureau;
after determining the industry to which report data belongs in an operation page, a user selects a specific year of a report to be uploaded in a drop-down menu mode;
after determining the specific time for uploading the report, the external user selects an Excel report uploading icon to enter a file uploading state;
The report to be processed is sent to the cloud server, and meanwhile, the report to be processed is sent to a mailbox reserved by an external user, specifically:
After all files to be uploaded are selected, after a ' submit ' button is clicked, the system automatically uploads all Excel files selected by external users to the cloud server, and the mobile phone interface immediately prompts ' mail sending success-! The method includes the steps that a word is formed, and in the same time, a mail of 31 common calculation indexes displayed through an Excel electronic form is received simultaneously in a mailbox reserved by an external user;
the forming process of the table file specifically comprises the following steps:
The cloud server receives the electronic report to be processed, identifies, stores and classifies the characters contained in the electronic report, and completes conversion and cleaning of numbers corresponding to the characters through synchronous comparison of a key field database;
The cloud server stores the fields and the data which are adapted through the key field database according to the related accounting system requirements of China, establishes 31 most commonly used calculation index formulas, carries out corresponding calculation and outputs the result; for fields that do not fit through the key field database, their data will be displayed at 0.
3. A method for analyzing data based on an electronic report, comprising:
The client establishes communication connection with the cloud server;
The client receives user operation to obtain an electronic report to be processed, and sends the electronic report to be processed to the cloud server;
The cloud server processes the electronic report to be processed based on a pre-stored calculation logic, a key field database, a calculation index formula and an output formula to obtain a table file; the key field database is formed by collecting, refining and summarizing all main flow legal enterprise report related information in the current Chinese continental region for many times; the computing logic refers to various original data, related computing software and various interfaces stored in a cloud;
the cloud server sends the form file to an external user;
the client receives user operation to obtain the electronic report to be processed, specifically:
The client receives login operation of a user to enter an operation page, and on the operation page, a drop-down menu of 97 kinds of industry distribution is provided for an external user for selection according to related requirements published by the national statistical bureau;
after determining the industry to which report data belongs in an operation page, a user selects a specific year of a report to be uploaded in a drop-down menu mode;
after determining the specific time for uploading the report, the external user selects an Excel report uploading icon to enter a file uploading state;
The table file is specifically obtained by:
The cloud server receives the electronic report to be processed, identifies, stores and classifies the characters contained in the electronic report, and completes conversion and cleaning of numbers corresponding to the characters through synchronous comparison of a key field database;
The cloud server stores the fields and the data which are adapted through the key field database according to the related accounting system requirements of China, establishes 31 most commonly used calculation index formulas, carries out corresponding calculation and outputs the result; for fields that do not fit through the key field database, their data will be displayed at 0.
4. A cloud server comprising a processor, an input device, an output device, and a memory, the processor, the input device, the output device, and the memory being interconnected, wherein the memory is configured to store a computer program comprising program instructions, the processor being configured to invoke the program instructions to perform the method of claim 1.
5. A client comprising a processor, an input device, an output device, and a memory, the processor, the input device, the output device, and the memory being interconnected, wherein the memory is configured to store a computer program comprising program instructions, the processor being configured to invoke the program instructions to perform the method of claim 2.
6. A data analysis system based on an electronic report, comprising a client and a cloud server, wherein the cloud server is as claimed in claim 4, and the client is as claimed in claim 5.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910619533.0A CN110347992B (en) | 2019-07-10 | 2019-07-10 | Data analysis method and system based on electronic report |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910619533.0A CN110347992B (en) | 2019-07-10 | 2019-07-10 | Data analysis method and system based on electronic report |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN110347992A CN110347992A (en) | 2019-10-18 |
| CN110347992B true CN110347992B (en) | 2024-05-14 |
Family
ID=68174788
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201910619533.0A Active CN110347992B (en) | 2019-07-10 | 2019-07-10 | Data analysis method and system based on electronic report |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN110347992B (en) |
Families Citing this family (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110929488B (en) * | 2019-11-06 | 2023-12-26 | 深圳市云智融科技有限公司 | Data processing method and related device |
Citations (20)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| EP1544756A1 (en) * | 2003-12-19 | 2005-06-22 | Thales | Method for updating data in a spreadsheet program |
| CN101075307A (en) * | 2006-05-18 | 2007-11-21 | 徐明达 | Method and system for indexing and assuming list |
| CN101650710A (en) * | 2009-08-03 | 2010-02-17 | 金蝶软件（中国）有限公司 | Online software service system as well as method and device for generating report |
| CN101944082A (en) * | 2010-09-10 | 2011-01-12 | 中国恩菲工程技术有限公司 | Excel-like report processing method |
| CN102096664A (en) * | 2009-12-09 | 2011-06-15 | 新奥特（北京）视频技术有限公司 | Report generating method |
| CN102323945A (en) * | 2011-09-02 | 2012-01-18 | 南京中兴力维软件有限公司 | SQL (Structured Query Language)-based database management method and device |
| CN102855229A (en) * | 2011-06-30 | 2013-01-02 | 镇江雅迅软件有限责任公司 | Self-defined statistical report form generating system based on EXCEL form |
| CN103257959A (en) * | 2012-02-15 | 2013-08-21 | 深圳市金蝶友商电子商务服务有限公司 | Method and device for generating spreadsheet report |
| CN104239366A (en) * | 2013-06-21 | 2014-12-24 | 苏州精易会信息技术有限公司 | Spreadsheet data management method based on C/S mode |
| CN105159997A (en) * | 2015-09-08 | 2015-12-16 | 深圳禧金信息技术有限公司 | Report form processing method and report form processing system |
| CN105405069A (en) * | 2015-12-02 | 2016-03-16 | 国家电网公司 | Electricity purchase operating decision analysis and data processing method |
| CN105761010A (en) * | 2016-02-24 | 2016-07-13 | 国网山东省电力公司 | Method and system for real-time monitoring of group enterprise audit based on real-time data acquisition |
| CN106991183A (en) * | 2017-03-27 | 2017-07-28 | 福建数林信息科技有限公司 | A kind of business intelligence ETL method for packing and system |
| CN107832279A (en) * | 2017-09-12 | 2018-03-23 | 北京中燕信息技术有限公司 | A kind of method, equipment and computer-readable recording medium for generating form |
| CN108572945A (en) * | 2018-03-09 | 2018-09-25 | 吉贝克信息技术（北京）有限公司 | Create method, system, storage medium and the electronic equipment of report |
| US10083016B1 (en) * | 2017-06-08 | 2018-09-25 | LockPath, Inc. | Procedurally specifying calculated database fields, and populating them |
| CN109471890A (en) * | 2018-10-16 | 2019-03-15 | 深圳壹账通智能科技有限公司 | Generation method, terminal device and the medium of report file |
| CN109669976A (en) * | 2018-11-22 | 2019-04-23 | 武汉达梦数据库有限公司 | Data service method and equipment based on ETL |
| CN109766529A (en) * | 2018-12-03 | 2019-05-17 | 中国联合网络通信集团有限公司 | A kind of generation method and equipment of report |
| CN109992757A (en) * | 2017-12-29 | 2019-07-09 | 广州宏扬信息技术有限公司 | One kind making a report on method system based on report data |
-
2019
- 2019-07-10 CN CN201910619533.0A patent/CN110347992B/en active Active
Patent Citations (20)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| EP1544756A1 (en) * | 2003-12-19 | 2005-06-22 | Thales | Method for updating data in a spreadsheet program |
| CN101075307A (en) * | 2006-05-18 | 2007-11-21 | 徐明达 | Method and system for indexing and assuming list |
| CN101650710A (en) * | 2009-08-03 | 2010-02-17 | 金蝶软件（中国）有限公司 | Online software service system as well as method and device for generating report |
| CN102096664A (en) * | 2009-12-09 | 2011-06-15 | 新奥特（北京）视频技术有限公司 | Report generating method |
| CN101944082A (en) * | 2010-09-10 | 2011-01-12 | 中国恩菲工程技术有限公司 | Excel-like report processing method |
| CN102855229A (en) * | 2011-06-30 | 2013-01-02 | 镇江雅迅软件有限责任公司 | Self-defined statistical report form generating system based on EXCEL form |
| CN102323945A (en) * | 2011-09-02 | 2012-01-18 | 南京中兴力维软件有限公司 | SQL (Structured Query Language)-based database management method and device |
| CN103257959A (en) * | 2012-02-15 | 2013-08-21 | 深圳市金蝶友商电子商务服务有限公司 | Method and device for generating spreadsheet report |
| CN104239366A (en) * | 2013-06-21 | 2014-12-24 | 苏州精易会信息技术有限公司 | Spreadsheet data management method based on C/S mode |
| CN105159997A (en) * | 2015-09-08 | 2015-12-16 | 深圳禧金信息技术有限公司 | Report form processing method and report form processing system |
| CN105405069A (en) * | 2015-12-02 | 2016-03-16 | 国家电网公司 | Electricity purchase operating decision analysis and data processing method |
| CN105761010A (en) * | 2016-02-24 | 2016-07-13 | 国网山东省电力公司 | Method and system for real-time monitoring of group enterprise audit based on real-time data acquisition |
| CN106991183A (en) * | 2017-03-27 | 2017-07-28 | 福建数林信息科技有限公司 | A kind of business intelligence ETL method for packing and system |
| US10083016B1 (en) * | 2017-06-08 | 2018-09-25 | LockPath, Inc. | Procedurally specifying calculated database fields, and populating them |
| CN107832279A (en) * | 2017-09-12 | 2018-03-23 | 北京中燕信息技术有限公司 | A kind of method, equipment and computer-readable recording medium for generating form |
| CN109992757A (en) * | 2017-12-29 | 2019-07-09 | 广州宏扬信息技术有限公司 | One kind making a report on method system based on report data |
| CN108572945A (en) * | 2018-03-09 | 2018-09-25 | 吉贝克信息技术（北京）有限公司 | Create method, system, storage medium and the electronic equipment of report |
| CN109471890A (en) * | 2018-10-16 | 2019-03-15 | 深圳壹账通智能科技有限公司 | Generation method, terminal device and the medium of report file |
| CN109669976A (en) * | 2018-11-22 | 2019-04-23 | 武汉达梦数据库有限公司 | Data service method and equipment based on ETL |
| CN109766529A (en) * | 2018-12-03 | 2019-05-17 | 中国联合网络通信集团有限公司 | A kind of generation method and equipment of report |
Non-Patent Citations (1)
| Title |
|---|
| Paul Turley.《Professional Microsoft SQL Server 2016 Reporting Services and Mobile Reports》.Wrox,2017,整本书籍. * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN110347992A (en) | 2019-10-18 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| WO2020088326A1 (en) | Interface operation and maintenance method and apparatus | |
| CN107657516B (en) | Method for generating certificate and financial server | |
| CN111198873B (en) | Data processing method and device | |
| CN108572963A (en) | Information acquisition method and device | |
| CA2927580C (en) | Method and system for document data extraction template management | |
| CN111078695B (en) | Method and device for calculating association relation of metadata in enterprise | |
| AU2014343044A1 (en) | Method and system for document data extraction template management | |
| CN111240688A (en) | excel file analysis method and device, computer equipment and storage medium | |
| WO2021212121A1 (en) | Systems and methods for unifying formats and adaptively automating processing of business records data | |
| CN110837496A (en) | Data quality management method and system based on dynamic sql | |
| CN113190562A (en) | Report generation method and device and electronic equipment | |
| CN110347992B (en) | Data analysis method and system based on electronic report | |
| CN116611411A (en) | Business system report generation method, device, equipment and storage medium | |
| CN113934733A (en) | Problem positioning method, device, system, storage medium and electronic equipment | |
| CN109947797B (en) | Data inspection device and method | |
| CN117591516A (en) | Supervision report data analysis system, supervision report data analysis method, supervision report data analysis equipment and storage medium | |
| CN114997977B (en) | Data processing method, device, electronic equipment and computer readable medium | |
| CN111045983A (en) | Nuclear power station electronic file management method and device, terminal equipment and medium | |
| CN106204207A (en) | A kind of bill generates method and apparatus | |
| CN110020166A (en) | A kind of data analysing method and relevant device | |
| WO2018200167A1 (en) | Managing asynchronous analytics operation based on communication exchange | |
| CN113362097A (en) | User determination method and device | |
| CN107180047B (en) | File generation method and device | |
| CN111882294B (en) | Method and device for flow approval | |
| CN109492010B (en) | Statistical method, device, equipment and storage medium for work records |
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 | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |