CN110347992A - Data analysing method and system based on electronic report forms - Google Patents
Data analysing method and system based on electronic report forms Download PDFInfo
- Publication number
- CN110347992A CN110347992A CN201910619533.0A CN201910619533A CN110347992A CN 110347992 A CN110347992 A CN 110347992A CN 201910619533 A CN201910619533 A CN 201910619533A CN 110347992 A CN110347992 A CN 110347992A
- Authority
- CN
- China
- Prior art keywords
- processed
- electronic report
- report forms
- cloud server
- client
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
- 238000000034 method Methods 0.000 title claims abstract description 51
- 238000004891 communication Methods 0.000 claims abstract description 13
- 238000012545 processing Methods 0.000 claims description 15
- 238000004590 computer program Methods 0.000 claims description 10
- 238000007405 data analysis Methods 0.000 claims description 8
- 238000004364 calculation method Methods 0.000 claims description 3
- 235000013399 edible fruits Nutrition 0.000 claims 1
- 238000003860 storage Methods 0.000 description 9
- 238000010586 diagram Methods 0.000 description 6
- 230000006870 function Effects 0.000 description 6
- 230000008569 process Effects 0.000 description 6
- 238000004458 analytical method Methods 0.000 description 4
- 230000005540 biological transmission Effects 0.000 description 3
- 238000010168 coupling process Methods 0.000 description 3
- 238000005859 coupling reaction Methods 0.000 description 3
- 230000008878 coupling Effects 0.000 description 2
- 238000009826 distribution Methods 0.000 description 2
- 238000005516 engineering process Methods 0.000 description 2
- 239000000203 mixture Substances 0.000 description 2
- 238000012986 modification Methods 0.000 description 2
- 230000004048 modification Effects 0.000 description 2
- 238000012546 transfer Methods 0.000 description 2
- 230000006978 adaptation Effects 0.000 description 1
- 238000012550 audit Methods 0.000 description 1
- 230000015572 biosynthetic process Effects 0.000 description 1
- 238000004422 calculation algorithm Methods 0.000 description 1
- 238000006243 chemical reaction Methods 0.000 description 1
- 238000004140 cleaning Methods 0.000 description 1
- 238000013461 design Methods 0.000 description 1
- 230000005611 electricity Effects 0.000 description 1
- 238000009472 formulation Methods 0.000 description 1
- 238000007726 management method Methods 0.000 description 1
- 230000006855 networking Effects 0.000 description 1
- 238000005192 partition Methods 0.000 description 1
- 238000002360 preparation method Methods 0.000 description 1
- 238000000926 separation method Methods 0.000 description 1
- 238000006467 substitution reaction Methods 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
Abstract
The embodiment of the invention discloses a kind of data analysing method and system based on electronic report forms, method include: that client and cloud server establish communication connection；Client receives user's operation to obtain electronic report forms to be processed, and report to be processed is sent to cloud server；Cloud server is based on pre-stored calculating logic, critical field database, parameter formula and output formula and handles electronic report forms to be processed, to obtain form document；Form document is sent to external users by cloud server.Implement the embodiment of the present invention, the time that the data inputting for being greatly saved external report user or formula are set up can be identified and be calculated to the legal report of 95% or more Continental Area, have stronger versatility.Further, since being carrier by internet, thus have the characteristics that whole day mobile office in 24 hours, greatly improves original report user to the calculating needs of data, specific efficient, accurate, low cost feature.
Description
Technical field
The present invention relates to electronic report forms processing technology fields, and in particular to a kind of data analysis side based on electronic report forms
Method, client, cloud server and system.
Background technique
In economic field, needed for the various purposes such as investment, audit, analysis, economic alarming, Economic Monitor, decision
Person carries out " quality " judgement often through a kind of most direct, intuitive method, that is, calculates financial data result.
It calculates and uses financial data the result is that the external policymaker in the whole world (makes economic judgement by external data sources
External data user) method that most generallys use, the number that process is recorded by external policymaker by financial statement,
It is calculated by pre-set calculation formula, to obtain desired various results.After computer is universal, policymaker
It carries out calculating to obtain result often through all kinds of computer softwares such as such as Excel, SPSS, ×× financial softwares.
But the calculating of above-mentioned all kinds of softwares is realized in real work, the first step most started is data inputting, especially
External policymaker is exactly first by needs obtaining provided by external object after Various types of data the work at first and having to do
External data, which is entered into after Excel, could start subsequent model formation and set up and calculate.Although the process of calculating is by computer
Complete, speed is very fast, but exist always in traditional typing work following a few place's 'bottleneck' restrictions whole work efficiency
Promotion:
(1) when the external data source of acquirement is papery voucher:
The process of typing to Excel is laborious and inefficiency.When policymaker wants using external data calculated result, data
Typing workload is huge, spends the time long.
(2) when the external data source of acquirement is electronics file data:
Problem one: obtaining the form of enterprise multiplicity of external data source, thus the report style obtained is also multiplicity.
Problem two: same class enterprise, such as private enterprise are had and are compiled using financial software since the requirement of financial management is different
Report processed, but also have worked out using traditional-handwork after saved by Excel, thus different form of presentation is to the end
The statement form showed is skimble-scamble.
Problem three: or more although the statement form that different software companys ultimately produces is all under unification of the motherland standard
Or be not less complete striking resemblances, can all there be the skimble-scamble problem of statement form.Such as: " this year accounts payable " this section
Mesh can be according to the B24 of different company's typesetting needed to appear in electrical form, D47, C23, the different places such as D18.
Problem four: when external policymaker faces the electronic report forms being in various forms, for each different electronic report forms
It needs to re-establish calculation formula.Such as:
Days Payable Outstanding (containing bill payable)=current characteristics/running cost * (this year accounts payable+sheet
Year bill payable+last year accounts payable+last year bill payable)/2.
Summary of the invention
The embodiment of the present invention is designed to provide a kind of data analysing method based on electronic report forms, client, cloud
Server and system are read and the efficiency using report data with greatly improving external policymaker.
To achieve the above object, in a first aspect, the embodiment of the invention provides a kind of, the data based on electronic report forms are analyzed
Method, comprising:
Establish the communication connection with client；
Receive the electronic report forms to be processed that the client uploads；
Based on pre-stored calculating logic, critical field database, parameter formula and output formula to it is described to
Processing electronic report forms are handled, to obtain form document；
The form document is sent to external users.
As a kind of preferred embodiment of the application, by pre-stored calculating logic, critical field database, based on
It calculates Index Formula and output formula handles the electronic report forms to be processed, to obtain form document, specifically include:
Text included in the electronic report forms to be processed is identified, stored and compiled with number by logic of propositions
Number processing, to obtain processing result；
The processing result is compared, cleaned and converted with pre-stored critical field database, to be compared
To result；
The comparison result is calculated based on preset parameter formula, to obtain calculated result；
The calculated result is filled according to preset output format, generates form document.
Second aspect, the embodiment of the invention provides a kind of data analysing methods based on electronic report forms, comprising:
Establish the communication connection with cloud server；
User's operation is received to obtain electronic report forms to be processed, and the report to be processed is sent to the cloud service
Device；
The form document that the cloud server is sent is received, the form document is based on preparatory by the cloud server
Calculating logic, critical field database, parameter formula and the output formula of storage carry out the electronic report forms to be processed
Processing gained.
As a kind of preferred embodiment of the application, user's operation is received to obtain electronic report forms to be processed, is specifically wrapped
It includes:
The register of user is received to enter operation pages；
In the operation pages, the selection operation of user is received with the determination electronic report forms to be processed；
The upload operation of user is received, to obtain the pre-stored electronic report forms to be processed.
Further, the data analysing method further include:
The report to be processed is sent in the mailbox that external users retains in advance.
The third aspect, the embodiment of the invention provides a kind of data analysing methods based on electronic report forms, comprising:
Client and cloud server establish communication connection；
The client receives user's operation to obtain electronic report forms to be processed, and the report to be processed is sent to institute
State cloud server；
The cloud server is based on pre-stored calculating logic, critical field database, parameter formula and defeated
Formula handles the electronic report forms to be processed out, to obtain form document；
The form document is sent to external users by the cloud server.
As a kind of preferred embodiment of the application, the client receives user's operation to obtain electronics report to be processed
Table specifically includes:
The client receives the register of user to enter operation pages；
In the operation pages, the client receives the selection operation of user with the determination report to be processed；
The client receives the upload operation of user, to obtain the pre-stored report to be processed
Fourth aspect, the embodiment of the invention also provides a kind of cloud servers, including processor, input equipment, output
Equipment and memory, the processor, input equipment, output equipment and memory are connected with each other, wherein the memory is used for
Computer program is stored, the computer program includes program instruction, and the processor is configured for that described program is called to refer to
It enables, the method for executing above-mentioned first aspect.
5th aspect, the embodiment of the invention also provides a kind of clients, including processor, input equipment, output equipment
And memory, the processor, input equipment, output equipment and memory are connected with each other, wherein the memory is for storing
Computer program, the computer program include program instruction, and the processor is configured for calling described program instruction, are held
The method of the above-mentioned second aspect of row.
6th aspect, the embodiment of the invention also provides a kind of data analysis systems based on electronic report forms, including client
End and cloud server.Wherein, cloud server is as described in above-mentioned fourth aspect, and client is as described in terms of the above-mentioned 5th.
The implementation embodiment of the present invention, the time that the data inputting for being greatly saved external report user or formula are set up,
The legal report of 95% or more Continental Area can be identified and be calculated, there is stronger versatility.Further, since by mutual
Networking is carrier, thus has the characteristics that whole day mobile office in 24 hours, greatly improves original report user to the meter of data
It calculates and needs, specific efficient, accurate, low cost feature.
Detailed description of the invention
It, below will be to specific in order to illustrate more clearly of the specific embodiment of the invention or technical solution in the prior art
Embodiment or attached drawing needed to be used in the description of the prior art are briefly described.In all the appended drawings, similar element
Or part is generally identified by similar appended drawing reference.In attached drawing, each element or part might not be drawn according to actual ratio.
Fig. 1 is the schematic flow diagram for the data analysing method based on electronic report forms that first embodiment of the invention provides；
Fig. 2 is the schematic flow diagram for the data analysing method based on electronic report forms that second embodiment of the invention provides；
Fig. 3 is the schematic flow diagram for the data analysing method based on electronic report forms that third embodiment of the invention provides；
Fig. 4 is that specific operation pages figure is developed in wechat public platform port；
Fig. 5 is output result interface figure；
Fig. 6 is the structural schematic diagram for the data analysis system based on electronic report forms that ground of the invention first embodiment provides；
Fig. 7 is the structural schematic diagram of cloud server shown in fig. 6；
Fig. 8 is the structural schematic diagram of client shown in fig. 6.
Specific embodiment
Following will be combined with the drawings in the embodiments of the present invention, and technical solution in the embodiment of the present invention carries out clear, complete
Site preparation description, it is clear that described embodiments are some of the embodiments of the present invention, instead of all the embodiments.Based on this hair
Embodiment in bright, every other implementation obtained by those of ordinary skill in the art without making creative efforts
Example, shall fall within the protection scope of the present invention.
It should be appreciated that ought use in this specification and in the appended claims, term " includes " and "comprising" instruction
Described feature, entirety, step, operation, the presence of element and/or component, but one or more of the other feature, whole is not precluded
Body, step, operation, the presence or addition of element, component and/or its set.It is also understood that the institute in this description of the invention
The term used is merely for the sake of being not intended to limit the present invention for the purpose of describing particular embodiments.Such as in description of the invention
With it is used in the attached claims like that, other situations unless the context is clearly specified, otherwise singular
" one ", "one" and "the" are intended to include plural form.
It will be further appreciated that the term "and/or" used in description of the invention and the appended claims is
Refer to any combination and all possible combinations of one or more of associated item listed, and including these combinations.
Referring to FIG. 1, being the data analysing method based on electronic report forms that first embodiment of the invention provides.It needs to illustrate
, the present embodiment is illustrated using cloud server as executing subject.As shown, this method may include following step
It is rapid:
S101 establishes the communication connection with client.
Specifically, first establish beyond the clouds mobile storage server as store all kinds of initial data, relevant calculation software with
The carrier of all kinds of interfaces.
S102 receives the electronic report forms to be processed that client uploads.
Specifically, user's operation is installed on the application program of client or by wechat public platform, by electronics to be processed
Report upload is to cloud server.The detailed process that client obtained and uploaded electronic report forms to be processed will be in subsequent embodiment
Detailed description.
S103, based on pre-stored calculating logic, critical field database, parameter formula and output formula to institute
It states electronic report forms to be processed to be handled, to obtain form document.
Specifically, step S103 includes:
Text included in the electronic report forms to be processed is identified, stored and compiled with number by logic of propositions
Number processing, to obtain processing result；
The processing result is compared, cleaned and converted with pre-stored critical field database, to be compared
To result；
The comparison result is calculated based on preset parameter formula, to obtain calculated result；
The calculated result is filled according to preset output format, generates form document.
Wherein, critical field database is the present inventor to all mainstream legitimate enterprise report phases in current CONTINENTAL AREA OF CHINA
Information is closed to be formed after multiple acquisition, refinement and summary, thus report fitting percentage is very high, can greatly improve working efficiency
With accuracy.
Implement the data analysing method based on electronic report forms in the present embodiment, passes through the implementation and service logic of technological means
Reconstruction, by all kinds of external electrical reports beyond the clouds server identified, match, sort out with calculate, outside will be greatly saved
The time that the data inputting or formula of report user is set up, the legal report of 95% or more Continental Area can be carried out identification with
It calculates, there is stronger versatility.Further, since be carrier by internet, thus with whole day mobile office in 24 hours
Feature greatly improves original report user to the calculating needs of data, specific feature efficiently, accurate, inexpensive.
Referring to FIG. 2, being the data analysing method based on electronic report forms that second embodiment of the invention provides.It needs to illustrate
, the present embodiment is illustrated using client as executing subject.As shown, this method may comprise steps of:
S201 establishes the communication connection with cloud server.
Specifically, set up wechat public platform, wechat public platform be connected with cloud server port, with establish client and
The communication connection of cloud server.It is subsequent to pass through the specific page data transmission face of wechat public affairs account developed for data according to preparatory
The format of setting, character requirement, are transmitted to cloud server for subsequent operation.Wherein, client includes but are not limited to
Cell phone etc..
S202 receives user's operation to obtain electronic report forms to be processed.
In wechat public platform port, the concrete operations page of exploitation is used for the transmission of external electrical table, is based on this, step
S202 includes:
(1) client receives the register of user to enter operation pages.In the operation pages, according to State Statistics Bureau
The requirement of " the 2017 editions industrial sectors of national economy classification standards " announced, provides the drop-down dish of 97 class industry distribution for external users
It is single to be selected for it.
(2) in operation pages, the selection operation of user is received with determination report to be processed.
After determining the affiliated industry of report data, user uploads the specific of report needed for choosing by way of drop-down menu
Time, such as: 2015,2016,2017,2020.
(3) upload operation of user is received, to obtain pre-stored report to be processed.
Such as 2018 after determining the specific time for uploading report, external users selects " Excel report upload " figure
Mark enters file and uploads state.At this point, wechat public platform can transfer the storage function of mobile phone automatically, external users is found in advance
Upper transmitting file needed for clicking file after the Excel file of deposit and can choosing seeds.
If repeating the above steps if external users need to submit other times file to upload such as 2019, until required
The file wanted all finishes for selected kind.
Electronic report forms to be processed are sent to cloud server, while report to be processed are sent to external use by S203
In the mailbox that person retains in advance.
Choose after the file of upload in need, system will upload all external users automatically after clicking " submission " button
The Excel file chosen to Cloud Server, meanwhile, mobile phone interface can prompt that " mail is sent successfully at once！" printed words, and same
One time, in the mailbox that external users retains in advance by and meanwhile receive a 31 shown by Excel electrical form
The mail of a common parameter can just obtain 31 common fingers after formula is set up in original typing in 141 minutes or 45 minutes
Target analysis result is realized in 1 minute.
S204 receives the form document that cloud server is sent.
After cloud server receives the electronic report forms to be processed that client uploads, it is based on pre-stored calculating logic, pass
Key field database, parameter formula and output formula handle the electronic report forms to be processed, to obtain table text
Part, and form document will be sent to client.
Implement the embodiment of the present invention, by the implementation of technological means and the reconstruction of service logic, by all kinds of external electrical reports
Server is identified, is matched, being sorted out and being calculated table beyond the clouds, will be greatly saved the data inputting or public affairs of external report user
The time that formula is set up can be identified and be calculated to the legal report of 95% or more Continental Area, have stronger versatility.This
Outside, due to being carrier by internet, thus have the characteristics that whole day mobile office in 24 hours, greatly improve original report and use
Person needs the calculating of data, specific feature efficiently, accurate, inexpensive.
With the case citing of 3 years three sets of (9) reports of certain enterprise, the present invention will be under the premise of 100% accuracy rate, will
Typing in originally 141 minutes sets up after formula that just getable 31 common counters analysis result was realized at 1 minute for 45 minutes
And it is practically applicable to current 95% or more legitimate enterprise report of CONTINENTAL AREA OF CHINA.
Again referring to FIG. 3, being the data analysing method based on electronic report forms that third embodiment of the invention provides.As schemed
Show, this method may comprise steps of:
S301, client and cloud server establish communication connection；
S302, client receive user's operation to obtain electronic report forms to be processed, and, report to be processed is sent to cloud clothes
Business device；
S303, cloud server are based on pre-stored calculating logic, critical field database, parameter formula and defeated
Formula handles the electronic report forms to be processed out, to obtain form document；
S304, cloud server form document are sent to external users.
This method process can be further discussed below:
1, mobile storage server is established beyond the clouds as all kinds of initial data of storage, relevant calculation software and all kinds of interfaces
Carrier.
2, wechat public platform is set up, wechat public platform port is connected with cloud server port, and passes through the micro- of exploitation
Believe that data according to preset format, character requirement, are transmitted to cloud for subsequent by the specific page data transmission face of public platform
Operation.
3, the specific operation pages biography (as shown in Figure 4) for external electrical table is developed in wechat public platform port
It is defeated, concrete operation step are as follows:
(1) after entering operation pages, " the 2017 editions industrial sectors of national economy classification standards " announced according to State Statistics Bureau
It is required that providing the drop-down menu of 97 class industry distribution for its selection for external users；
(2) after determining the affiliated industry of report data, user uploads report needed for choosing by way of drop-down menu
The specific time, such as: 2015,2016,2017,2020；
(3) such as 2018 after determining the specific time for uploading report, external users selects " Excel report upload "
Icon enters file and uploads state.At this point, wechat public platform can transfer the storage function of mobile phone automatically, external users finds thing
Upper transmitting file needed for clicking file after the Excel file of preceding deposit and can choosing seeds.
(4) if repeating above-mentioned (3) step, directly if external users need to submit other times file to upload such as 2019
It is all finished for selected kind to required file；
(5) choose after the file of upload in need, system makes all outsides are uploaded automatically after clicking " submission " button
The Excel file that user chooses to Cloud Server, meanwhile, mobile phone interface can prompt that " mail is sent successfully at once！" printed words, and
Portion will be received simultaneously in the same time, in the mailbox that external users retains in advance to show by Excel electrical form
31 common parameters mail, original typing in 141 minutes or 45 minutes, which are set up, can just obtain 31 after formula often
It is realized in 1 minute with the analysis result of index.
4, it after cloud server receives the electrical form that wechat public platform uploads, will will be set in advance by Java language
Logic by a series of instruction carry out consistency operation, both text included in received electrical form was identified,
It stores and numbers classification, and the comparison by synchronizing " the critical field database " that carries out, so that completion is right to this text
The number answered carries out conversion and cleaning.For example, in the electrical form of upload, " accounts receivable are presented in the position B23
500 yuan of money ", but according to the requirement of national accounting standard, the account should be " accounts receivable ", and " account " is different from " account " and occurs
Position also should not its meaning is exactly " accounts receivable " on B23, but after all, thus pass through pre-determined calculating at this time
The programmed logic of machine language and formulation, software can automatically by " account receivable " in the position B23 " critical field database " into
Row fuzzy query with compare and determine that it is exactly " accounts receivable " subject according to the standard of " critical field database ", thus general
500 yuan are included in " accounts receivable " subject and for subsequent calculating.Wherein, " critical field database " is the present inventor to current
All mainstream legitimate enterprise report relevant informations in CONTINENTAL AREA OF CHINA are formed after multiple acquisition, refinement and summary, thus
Report fitting percentage is very high, can greatly improve working efficiency and accuracy.
5, to the field and data being adapted to by " critical field database ", cloud server will be according to China national correlation
Accounting system requirement, is stored and sets up most common 31 parameter formula and accordingly calculated and export result
(as shown in Figure 5).To the field for not passing through " critical field " database adaptation, data will be display with 0.It needs to illustrate
It is that Fig. 5 only illustratively shows partial output results, actually calculates exported result and be not limited only to this.
6, finally, being generated after calculated result filled calculated result according to the output format set up in advance by cloud server
Excel file is simultaneously sent in the reserved mailbox beyond the clouds of external users, terminates process.
Implement the present embodiment, by the implementation of technological means and the reconstruction of service logic, it is legal to upload by client
Electronic report forms, the time that the data inputting for being greatly saved external report user or formula are set up, by all kinds of external electrical reports
Server is identified, is matched, being sorted out and being calculated table beyond the clouds, can be identified to the legal report of 95% or more Continental Area
With calculating, there is stronger versatility.Further, since being carrier by internet, thus there is whole day mobile office in 24 hours
The characteristics of, original report user is greatly improved to the calculating needs of data, specific feature efficiently, accurate, inexpensive.
Based on identical inventive concept, the embodiment of the invention provides a kind of data analysis systems based on electronic report forms.
As shown in fig. 6, the data analysis system includes cloud server 100 and client 200.
Further, as shown in fig. 7, cloud server 100 may include: one or more processors 101, one or more
A input equipment 102, one or more output equipments 103 and memory 104, above-mentioned processor 101, input equipment 102, output
Equipment 103 and memory 104 are connected with each other by bus 105.Memory 104 is for storing computer program, the computer
Program includes program instruction, and the processor 101 is configured for that the above-mentioned first method of described program instruction execution is called to implement
The method of example part.
Further, as shown in fig. 7, client 200 may include: one or more processors 201, it is one or more defeated
Enter equipment 202, one or more output equipments 203 and memory 204, above-mentioned processor 201, input equipment 202, output equipment
203 and memory 204 be connected with each other by bus 205.Memory 204 is for storing computer program, the computer program
Including program instruction, the processor 201 is configured for calling described program instruction execution above-mentioned second method embodiment portion
The method divided.
It should be appreciated that in embodiments of the present invention, alleged processor 101,201 can be central processing unit (Central
Processing Unit, CPU), which can also be other general processors, digital signal processor (Digital
Signal Processor, DSP), specific integrated circuit (Application Specific Integrated Circuit,
ASIC), field programmable gate array (Field-Programmable Gate Array, FPGA) or other programmable logic
Device, discrete gate or transistor logic, discrete hardware components etc..General processor can be microprocessor or this at
Reason device is also possible to any conventional processor etc..
Input equipment 102,202 may include keyboard etc., and output equipment 103,203 may include display (LCD etc.), raise
Sound device etc..
The memory 104,204 may include read-only memory and random access memory, and refer to the offer of processor 101
Order and data.The a part of of memory 104,204 can also include nonvolatile RAM.For example, memory
It 104,204 can be with the information of storage device type.
In the specific implementation, processor 101 (201) described in the embodiment of the present invention, input equipment 102 (202), output
Equipment 103 (203) can be performed is retouched in the embodiment of the data analysing method provided in an embodiment of the present invention based on electronic report forms
The implementation stated, details are not described herein.
Implement data analysis set-up and system provided by the embodiment of the present invention, will be greatly saved external report user's
The time that data inputting or formula are set up can be identified and be calculated to the legal report of 95% or more Continental Area, have compared with
Strong versatility.Further, since being carrier by internet, thus have the characteristics that whole day mobile office in 24 hours, mentions significantly
High original report user needs the calculating of data, specific efficient, accurate, low cost feature.
It should be noted that the data analysis system of the embodiment of the present invention and the specific workflow of device, before please referring to
Embodiment of the method part is stated, details are not described herein.
Those of ordinary skill in the art may be aware that list described in conjunction with the examples disclosed in the embodiments of the present disclosure
Member and algorithm steps, can be realized with electronic hardware, computer software, or a combination of the two, in order to clearly demonstrate hardware
With the interchangeability of software, each exemplary composition and step are generally described according to function in the above description.This
A little functions are implemented in hardware or software actually, the specific application and design constraint depending on technical solution.Specially
Industry technical staff can use different methods to achieve the described function each specific application, but this realization is not
It is considered as beyond the scope of this invention.
In several embodiments provided herein, it should be understood that disclosed system and method can pass through it
Its mode is realized.For example, the apparatus embodiments described above are merely exemplary, for example, the division of the unit, only
Only a kind of logical function partition, there may be another division manner in actual implementation, such as multiple units or components can be tied
Another system is closed or is desirably integrated into, or some features can be ignored or not executed.In addition, shown or discussed phase
Mutually between coupling, direct-coupling or communication connection can be through some interfaces, the INDIRECT COUPLING or communication of device or unit
Connection is also possible to electricity, mechanical or other form connections.
The unit as illustrated by the separation member may or may not be physically separated, aobvious as unit
The component shown may or may not be physical unit, it can and it is in one place, or may be distributed over multiple
In network unit.Some or all of unit therein can be selected to realize the embodiment of the present invention according to the actual needs
Purpose.
It, can also be in addition, the functional units in various embodiments of the present invention may be integrated into one processing unit
It is that each unit physically exists alone, is also possible to two or more units and is integrated in one unit.It is above-mentioned integrated
Unit both can take the form of hardware realization, can also realize in the form of software functional units.
If the integrated unit is realized in the form of SFU software functional unit and sells or use as independent product
When, it can store in a computer readable storage medium.Based on this understanding, technical solution of the present invention is substantially
The all or part of the part that contributes to existing technology or the technical solution can be in the form of software products in other words
It embodies, which is stored in a storage medium, including some instructions are used so that a computer
Equipment (can be personal computer, server or the network equipment etc.) executes the complete of each embodiment the method for the present invention
Portion or part steps.
The above description is merely a specific embodiment, but scope of protection of the present invention is not limited thereto, any
Those familiar with the art in the technical scope disclosed by the present invention, can readily occur in various equivalent modifications or replace
It changes, these modifications or substitutions should be covered by the protection scope of the present invention.Therefore, protection scope of the present invention should be with right
It is required that protection scope subject to.
Claims (10)
1. a kind of data analysing method based on electronic report forms characterized by comprising
Establish the communication connection with client；
Receive the electronic report forms to be processed that the client uploads；
Based on pre-stored calculating logic, critical field database, parameter formula and output formula to described to be processed
Electronic report forms are handled, to obtain form document；
The form document is sent to external users.
2. as described in claim 1 based on the data analysing method of electronic report forms, which is characterized in that based on pre-stored
Logic, critical field database, parameter formula and output formula is calculated to handle the electronic report forms to be processed, with
To form document, specifically include:
Text included in the electronic report forms to be processed and number are identified by logic of propositions, store and number at
Reason, to obtain processing result；
The processing result is compared, cleaned and converted with pre-stored critical field database, to obtain comparing knot
Fruit；
The comparison result is calculated based on preset parameter formula, to obtain calculated result；
The calculated result is filled according to preset output format, generates form document.
3. a kind of data analysing method based on electronic report forms characterized by comprising
Establish the communication connection with cloud server；
User's operation is received to obtain electronic report forms to be processed, and the report to be processed is sent to the cloud server；
The form document that the cloud server is sent is received, the form document is based on being stored in advance by the cloud server
Calculating logic, critical field database, parameter formula and output formula the electronic report forms to be processed are handled
Gained.
4. as claimed in claim 3 based on the data analysing method of electronic report forms, which is characterized in that receive user's operation to obtain
Electronic report forms to be processed are taken, are specifically included:
The register of user is received to enter operation pages；
In the operation pages, the selection operation of user is received with the determination electronic report forms to be processed；
The upload operation of user is received, to obtain the pre-stored electronic report forms to be processed.
5. as claimed in claim 4 based on the data analysing method of electronic report forms, which is characterized in that the data analysing method
Further include:
The report to be processed is sent in the mailbox that external users retains in advance.
6. a kind of data analysing method based on electronic report forms characterized by comprising
Client and cloud server establish communication connection；
The client receives user's operation to obtain electronic report forms to be processed, and the report to be processed is sent to the cloud
Hold server；
It is public that the cloud server is based on pre-stored calculating logic, critical field database, parameter formula and output
Formula handles the electronic report forms to be processed, to obtain form document；
The form document is sent to external users by the cloud server.
7. as claimed in claim 6 based on the data analysing method of electronic report forms, which is characterized in that the client, which receives, to be used
Family is operated to obtain electronic report forms to be processed, is specifically included:
The client receives the register of user to enter operation pages；
In the operation pages, the client receives the selection operation of user with the determination report to be processed；
The client receives the upload operation of user, to obtain the pre-stored report to be processed.
8. a kind of cloud server, which is characterized in that including processor, input equipment, output equipment and memory, the processing
Device, input equipment, output equipment and memory are connected with each other, wherein the memory is for storing computer program, the meter
Calculation machine program includes program instruction, and the processor is configured for calling described program instruction, executes such as claims 1 or 2
The method.
9. a kind of client, which is characterized in that including processor, input equipment, output equipment and memory, the processor,
Input equipment, output equipment and memory are connected with each other, wherein the memory is for storing computer program, the calculating
Machine program includes program instruction, and the processor is configured for calling described program instruction, is executed as claim 3-5 is any
Method described in.
10. a kind of data analysis system based on electronic report forms, including client and cloud server, which is characterized in that described
For cloud server as described in power requires 8, the client is as claimed in claim 9.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910619533.0A CN110347992A (en) | 2019-07-10 | 2019-07-10 | Data analysing method and system based on electronic report forms |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910619533.0A CN110347992A (en) | 2019-07-10 | 2019-07-10 | Data analysing method and system based on electronic report forms |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN110347992A true CN110347992A (en) | 2019-10-18 |
Family
ID=68174788
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201910619533.0A Pending CN110347992A (en) | 2019-07-10 | 2019-07-10 | Data analysing method and system based on electronic report forms |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN110347992A (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110929488A (en) * | 2019-11-06 | 2020-03-27 | 深圳市云智融科技有限公司 | 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 |
| US10083016B1 (en) * | 2017-06-08 | 2018-09-25 | LockPath, Inc. | Procedurally specifying calculated database fields, and populating them |
| 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 |
| 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/CN110347992A/en active Pending
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 * |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110929488A (en) * | 2019-11-06 | 2020-03-27 | 深圳市云智融科技有限公司 | Data processing method and related device |
| CN110929488B (en) * | 2019-11-06 | 2023-12-26 | 深圳市云智融科技有限公司 | Data processing method and related device |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN107102941B (en) | Test case generation method and device | |
| CN107833341A (en) | A kind of intelligent queuing method, equipment and computer-readable recording medium | |
| AU2007336337B2 (en) | System and method for optimizing changes of data sets | |
| CN109902901A (en) | Method for allocating tasks, device, storage medium and computer equipment | |
| CN108833458B (en) | Application recommendation method, device, medium and equipment | |
| WO2019019649A1 (en) | Method and apparatus for generating investment portfolio product, storage medium and computer device | |
| CN109933534B (en) | Method and device for determining financial test object | |
| CN110363621A (en) | A kind of order information supplying system based on artificial intelligence technology | |
| CN107516158A (en) | A kind of method for allocating tasks, device and terminal device | |
| CN105096023A (en) | System and method for pushing data relevant to working standard | |
| CN109582452A (en) | A kind of container dispatching method, dispatching device and electronic equipment | |
| CN107818168A (en) | Topic searching method, device and equipment | |
| CN101655803A (en) | Method and mobile terminal for implementing mathematical model simulation | |
| CN109981715A (en) | A kind of method and device of session management | |
| CN108268357A (en) | real-time data processing method and device | |
| CN109615410B (en) | Data processing method and device, computer equipment and computer readable storage medium | |
| CN110347992A (en) | Data analysing method and system based on electronic report forms | |
| CN111986030B (en) | Data processing method, device, storage medium and computer equipment | |
| CN109086289A (en) | A kind of media data processing method, client, medium and equipment | |
| CN109995767A (en) | Account single-point logging method, terminal device and storage medium | |
| CN109064180A (en) | Comment on method, apparatus and terminal device | |
| CN113205412B (en) | Method and related device for determining business types handled by intelligent counter | |
| CN115907043A (en) | Multi-party multi-model privacy transaction-based federal learning content push method and device | |
| CN106570699A (en) | Client contact information excavation method and server | |
| JP6840204B1 (en) | Business support system and method |
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 |