CN201974846U - Data collecting and counting system - Google Patents

Data collecting and counting system Download PDF

Info

Publication number
CN201974846U
CN201974846U CN2010205850194U CN201020585019U CN201974846U CN 201974846 U CN201974846 U CN 201974846U CN 2010205850194 U CN2010205850194 U CN 2010205850194U CN 201020585019 U CN201020585019 U CN 201020585019U CN 201974846 U CN201974846 U CN 201974846U
Authority
CN
China
Prior art keywords
data
module
data acquisition
server
file
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.)
Expired - Lifetime
Application number
CN2010205850194U
Other languages
Chinese (zh)
Inventor
荣明军
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Evermore Software Ltd By Share Ltd
Original Assignee
Wuxi Evermore Software Inc
Priority date (The priority date 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 date listed.)
Filing date
Publication date
Application filed by Wuxi Evermore Software Inc filed Critical Wuxi Evermore Software Inc
Priority to CN2010205850194U priority Critical patent/CN201974846U/en
Application granted granted Critical
Publication of CN201974846U publication Critical patent/CN201974846U/en
Anticipated expiration legal-status Critical
Expired - Lifetime legal-status Critical Current

Links

Images

Landscapes

  • Management, Administration, Business Operations System, And Electronic Commerce (AREA)

Abstract

The utility model discloses a data collecting and counting system, which comprises a plurality of data collecting devices and servers. Each data collecting device comprises a data filling module for filling data into a spreadsheet module, a submission conforming module for conforming submission, a data packaging module for packaging the filled spreadsheet module as a data file, and a data transmitting module for transmitting the data file to the server. Each server comprises a data receiving module for receiving the data files transmitted by the data collecting devices, a data analyzing module for analyzing the data files to obtain collected data, and a data gathering module for gathering the collected data to form a database or a data sheet, thus gathering and counting the collected data in real time automatically, wherein the result is correct and the operation is time-saving and force-saving.

Description

Data acquisition and statistical system
[technical field]
The utility model relates to data acquisition and statistics application field, especially a kind of based on network data acquisition and statistical system.
[background technology]
In the social life at present various questionnaires are arranged, the form of questionnaire can be collected a lot of useful data by inquiry, and the help people passable by these data make more correct decision-making.Such as in order to understand the pressure condition of each city inhabitant, social investigation mechanism may print many parts of questionnaires and fill in by the citizen in each city, and content may relate to columns such as family income situation, family are propped up and had troubles, kinsfolk's composition, the number of times of going on a tour.Yet these questionnaires all are paper-based form generally, and providing and collect these questionnaires all is the thing that wastes time and energy very much, and the questionnaire that tabulate statistics is regained equally also is a uninteresting and loaded down with trivial details thing.
Except questionnaire, also have other a lot of application may need to carry out data aggregation and statistics, such as certain Products Co., Ltd need collect each dealer shipment, stock up, situation such as stock, this just needs each dealer that corresponding situation is write registration form, issues this Products Co., Ltd afterwards and adds up.In general, all may need to carry out the collection and the statistics of data in the various aspects of every field.
Along with rapid development of network, carry out data acquisition and add up also to become becoming more and more popular by the form of Email.Following mask body introduces that a kind of described scheme comprises: the investigator designs electronic form template based on the data acquisition of electrical form and the scheme of statistics, and in the annex mode electronic form template file is sent to the surveyee by Email; The surveyee fills in data after opening electronic form file, fill in finish after, described electronic form file is fed back to the investigator by mail in the annex mode; The investigator begins to carry out data statistics after waiting for that all surveyees feed back or reach the statistical condition of setting (such as reaching the cut-off date).Described data statistics process can comprise: each surveyee's electronic form file is opened, is duplicated in data to a statistic summary table in it, gather end after, carry out the artificial data analysis, such as the calculating ratio, make chart, write report etc.
Clearly, above-mentioned data acquisition and statistical project based on electrical form has following defective: 1, data gather and are loaded down with trivial details, need win data manually, and workload is big, also makes mistakes easily; 2, before no show Statistic Design condition, unless manual statistics, otherwise can't obtain the situation of real-time statistics.
Therefore, wish to propose a kind of improved data acquisition and statistical project.
[summary of the invention]
One of the technical problems to be solved in the utility model is to provide a kind of data acquisition and statistical system, and it can carry out full automatic data acquisition and statistics, and the result is accurate and time saving and energy saving.
In order to address the above problem, according to an aspect of the present utility model, the utility model proposes a kind of data acquisition and statistical system, it comprises a plurality of data acquisition equipments and server.Each data acquisition equipment comprises that the data of filling in data in electronic form template are filled in module, definite submission of submitting to is confirmed module, the electronic form template of filling in is encapsulated as the data encapsulation module of a data file and described data file is sent to data in server transmission module.Described server comprises the data reception module that receives the data file that each data acquisition equipment sends, described data file is resolved the data resolution module that obtains image data and image data is gathered to form the data summarizing module of database or tables of data.
Further, described server also comprises the report generation module according to database and tables of data generation statistical report.
Further, described data acquisition equipment also includes the report acquisition module that obtains report from server.
Further, described data acquisition equipment is implemented on the computer system, system storage, memory storage, input/output interface and network interface that described computer system comprises bus, central processing unit, is made up of random access memory and ROM (read-only memory).
Further, data are filled in module and are connected to each other with submit to confirming module, submit to confirm module and the data encapsulation module is connected to each other, data encapsulation module and data transfer module are connected to each other.
Further, data reception module and data resolution module are connected to each other, and data resolution module and data summarizing module are connected to each other.
Compared with prior art, data acquisition in the utility model and statistical system can reach image data automatic real-time gathered and add up, and the result is accurate and time saving and energy saving.
About other purposes of the present utility model, feature and advantage are described in detail in embodiment below in conjunction with accompanying drawing.
[description of drawings]
In conjunction with reaching ensuing detailed description with reference to the accompanying drawings, the utility model will be more readily understood, the structure member that wherein same Reference numeral is corresponding same, wherein:
Fig. 1 is data acquisition and the statistical system structured flowchart in one embodiment in the utility model;
Fig. 2 is the structured flowchart of example of the realization environment of the data acquisition equipment shown in Fig. 1;
Fig. 3 is the structured flowchart in one embodiment of the data acquisition equipment shown in Fig. 1;
Fig. 4 is the structured flowchart in one embodiment of the server shown in Fig. 1;
Fig. 5 A-5D is that data acquisition and statistical system one uses example in the utility model; With
Fig. 6 A-6D is the Another application example of data acquisition and statistical system in the utility model.
[embodiment]
For above-mentioned purpose of the present utility model, feature and advantage can be become apparent more, the utility model is described in further detail below in conjunction with the drawings and specific embodiments.
Detailed description of the present utility model mainly presents by program, step, logical block, process or other symbolistic descriptions, the running of the technical scheme in its direct or indirect simulation the utility model.Affiliated those of skill in the art use these descriptions herein and state that the others skilled in the art in affiliated field effectively introduce their work essence.
Alleged herein " embodiment " or " embodiment " are meant that special characteristic, structure or the characteristic relevant with described embodiment can be contained at least one implementation of the utility model at least.Different local in this manual " in one embodiment " that occur also nonessentially all refer to same embodiment, must not be yet with other embodiment mutually exclusive separately or select embodiment.In addition, represent the sequence of modules in method, process flow diagram or the functional block diagram of one or more embodiment and revocablely refer to any particular order, also do not constitute restriction of the present utility model.
Fig. 1 is data acquisition and statistical system 100 structured flowchart in one embodiment in the utility model.Described system 100 includes server 104, sets up several data acquisition equipments 102 of communication by network 103 and described server.Described network 103 can comprise Local Area Network, wide area network (WAN), mobile radio communication, PSTN (PSTN), the Internet or their combination.For easy, only show two data collecting devices and a server among Fig. 1, in practice, more data collecting device and a plurality of server can be arranged.
Described data acquisition equipment 102 can be implemented on the computer system, and described computer system comprises signal conditioning packages such as personal computer, notebook computer, panel computer, smart mobile phone or PDA(Personal Digital Assistant).Fig. 2 is the structured flowchart of an example of the running environment of the data acquisition equipment 102 shown in Fig. 1, system storage, memory storage 204, input/output interface 205 and network interface 207 that described computer system comprises bus 210, central processing unit (CPU) 201, is made up of random-access memory (ram) 202 and ROM (read-only memory) (ROM) 203.The communication that described bus 210 can be provided as between each module provides the path.Can link to each other with input-output device such as keyboard, mouse, display, printer, contactor control devices by described input/output interface 205.Memory storage 204 can be exterior storage mediums such as hard disk, CD, can storage operating system in it, the electrical form module.Described electrical form module can be the EXCEL of Microsoft, also can be other module with spreadsheet function.Described computer system can be connected on the computing machine of other types or the server and carries out data interaction with it by network interface 207.Certainly, the information handling system of other frameworks can be used as the data acquisition equipment in the utility model equally.Described data acquisition equipment includes the demonstration display that is connected to input/output interface, is used for carrying out electrical form and shows.
After electrical form module in the memory storage 204 ran on the computer system, the running environment shown in Fig. 2 just became a data collecting device 102, and it can carry out generation, visit or the modification of electrical form.Described data acquisition equipment 102 comprises that the data of filling in data in electronic form template are filled in module 301, module 302 is confirmed in submission that determine to submit to, the electronic form template of filling in is encapsulated as the data encapsulation module 303 of a data file and described data file is sent to the data transfer module 304 of server 104.Data are filled in module 301 and are connected to each other with submitting affirmation module 302 to, submit to and confirm that module 302 and data encapsulation module 303 are connected to each other, data encapsulation module 303 is connected to each other with data transfer module 304.
Described electronic form template is the template of predefined, and which cell in electronic form template can be filled in data in (position of cell), and filling in which kind of data (content of cell) all is to pass through predefined.Fig. 5 A is the exemplary plot of an electronic form template in the utility model, need to fill in a student " name " among the cell A2 wherein, need to fill in the achievement of this student " mathematics " among the cell B2, need to fill in the achievement of this student " chemistry " among the cell C2,, F2 need fill in the achievement of this student " physics ".Fig. 5 B is that a data acquisition equipment is filled in the exemplary plot of finishing after the electronic form template shown in Fig. 5 A, and Fig. 5 C fills in the exemplary plot of finishing after the electronic form template shown in Fig. 5 A for another data acquisition equipment.
After the user confirms that by submission module 302 confirms to carry out the data submission, electronic form template after data encapsulation module 303 will be filled in is encapsulated as data file, the position and the data content that can comprise each cell that to fill in the described data file, such as the position among Fig. 5 B " A2 " and data content " Zhang San ", position B2 and data content " 88 ", position " C2 " and data content " 91 " or the like.The position of described cell can be a deviation post, also can the absolute position.In another embodiment, since the cell that need fill in be determine with defined, therefore described data file also can not comprise the position of cell, and the content of only wrapping the cell that need fill in, such as the content among Fig. 5 C " Li Si ", " 80 ", " 78 ", " 90 " etc., these data contents can be according to putting in order resolved and identification, assert it is among the cell A2 such as first content " Li Si ", it is among the cell B2 that second content " 80 " is identified as.In another embodiment, described data file can be exactly an electronic form document.
Server 104 can be various computing machines or special server apparatus, operation has server program in it, and it comprises the data reception module 401 that receives the data file that each data acquisition equipment sends, described data file is resolved the data resolution module 402 that obtains image data and image data is gathered to form the data summarizing module 403 of database or tables of data.Data reception module 401 is connected to each other with data resolution module 402, and data resolution module 402 is connected to each other with data summarizing module 403.In one embodiment, the order of the data file that can send according to each data acquisition equipment is resolved it and is gathered, when concrete combined data, data summarizing module 403 can be with each data content in the data file according to the database of pre-defined rule typing correspondence successively or the relevant position of tables of data.When specific implementation, determine its respective regions according to the position of the data content in the data file in database or tables of data, the current location in subsequently should the zone is distributed to described data content, and next set positions that subsequently should the zone is a current location.For instance, described server 104 can be resolved the achievement data of the mathematics, chemistry, Chinese language, English and the physics that obtain Zhang San from the data file of the electronic form template correspondence shown in Fig. 5 B, and be aggregated in the correspondence position of the row of second in the summary sheet shown in Fig. 5 D, the achievement data of the mathematics to Li Si, chemistry, Chinese language, English and the physics that can resolve from the data file of the electronic form template correspondence shown in Fig. 3 C, and be aggregated in the correspondence position of the third line in the summary sheet shown in Fig. 5 D.Fig. 5 D only is the exemplary tables of data that server 104 carries out the data sink General Logistics Department that provided, and in other embodiments, the data after gathering can be stored with various forms, such as tables of data or database etc.In addition, the data that Fig. 5 D has only provided two data collecting devices gather, and gather and can constantly pool together according to same principle in the data of other data acquisition equipments.In one embodiment, described database or tables of data are an electronic form document, such as the EXCEL document.
Described server 104 can carry out the statistics and analysis of various needs, and can generate various statistical reports after obtaining the combined data table.In one embodiment, described server 104 also comprises the report generation module (not shown) according to database and tables of data generation statistical report.Here be that example is introduced still with the collection and the statistics of the student performance shown in Fig. 5 A-5D, such as the average mark that can analyze each topic, each student's average mark and total points, average mark is in the number of 60-70,70-80,80-90,90-100 and ratio etc.
In one embodiment, described data acquisition equipment 102 also includes the report acquisition module (not shown) that obtains report from server 104, obtain by the report acquisition module and to send statistical report and obtain order, described data acquisition equipment just can obtain statistical reports from server 104, and show described statistical report for the user referring to.
The mode of this data acquisition and statistics replaces going notes data by hand with machine fully, and task is greatly simplified, and can be very accurate, is difficult for makeing mistakes.In addition, can also the real-time statistics to typing carry out statistical study, process is very simple to operation.And the process of collecting data also becomes very easy, only need open the electrical form module corresponding data is filled in into corresponding template, submits to afterwards to get final product.Sum up, the data that data acquisition in the utility model and statistical project are gathered comprehensively, collection is convenient, tabulate statistics is easy, it is simple to analyze, can be used as the solution of existing various data acquisition and statistics application, can simplify work, raise the efficiency.
In one embodiment, owing in data acquisition equipment, may have multiple electronic form template, in order to distinguish the data file that does not form by electronic form template, can also store the template mark in the described data file, represent with this which electronic form template it belongs to.Described server 104 selects suitable manner that described data file is resolved according to described template mark, and the data after will resolving are aggregated in the database or tables of data of described template mark correspondence.Like this, just can realize the data acquisition and the statistics of various application based on the system in the utility model 100, Fig. 6 A-6D shows data acquisition and the application example of statistical system aspect vegetable price in the utility model.
It should be noted that Fig. 5 A-5D and Fig. 6 A-6D only exemplary provided data acquisition in the utility model and two of statistical system use examples, can not be interpreted as restriction with this to data acquisition of the present utility model and statistical project.
Above the utility model has been carried out the enough detailed description with certain singularity.Under those of ordinary skill in the field should be appreciated that the description among the embodiment only is exemplary, under the prerequisite that does not depart from true spirit of the present utility model and scope, make change and all should belong to protection domain of the present utility model.The utility model scope required for protection is limited by described claims, rather than limit by the foregoing description among the embodiment.

Claims (4)

1. data acquisition and statistical system, it is characterized in that: it comprises a plurality of data acquisition equipments and server,
Each data acquisition equipment comprises that the data of filling in data in electronic form template are filled in module, definite submission of submitting to is confirmed module, the electronic form template of filling in is encapsulated as the data encapsulation module of a data file and described data file is sent to data in server transmission module; Described server comprises the data reception module that receives the data file that each data acquisition equipment sends, described data file is resolved the data resolution module that obtains image data and image data is gathered to form the data summarizing module of database or tables of data.
2. data acquisition according to claim 1 and statistical system, it is characterized in that, described data acquisition equipment is implemented on the computer system, system storage, memory storage, input/output interface and network interface that described computer system comprises bus, central processing unit, is made up of random access memory and ROM (read-only memory).
3. data acquisition according to claim 1 and statistical system is characterized in that, data are filled in module and are connected to each other with submit to confirming module, submit to confirm module and the data encapsulation module is connected to each other, data encapsulation module and data transfer module are connected to each other.
4. data acquisition according to claim 1 and statistical system is characterized in that data reception module and data resolution module are connected to each other, and data resolution module and data summarizing module are connected to each other.
CN2010205850194U 2010-10-29 2010-10-29 Data collecting and counting system Expired - Lifetime CN201974846U (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN2010205850194U CN201974846U (en) 2010-10-29 2010-10-29 Data collecting and counting system

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN2010205850194U CN201974846U (en) 2010-10-29 2010-10-29 Data collecting and counting system

Publications (1)

Publication Number Publication Date
CN201974846U true CN201974846U (en) 2011-09-14

Family

ID=44579943

Family Applications (1)

Application Number Title Priority Date Filing Date
CN2010205850194U Expired - Lifetime CN201974846U (en) 2010-10-29 2010-10-29 Data collecting and counting system

Country Status (1)

Country Link
CN (1) CN201974846U (en)

Cited By (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN103235809A (en) * 2013-04-23 2013-08-07 长春吉联科技集团有限公司 Method for data acquisition of summary report

Cited By (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN103235809A (en) * 2013-04-23 2013-08-07 长春吉联科技集团有限公司 Method for data acquisition of summary report

Similar Documents

Publication Publication Date Title
CN101976394B (en) Data acquiring and counting system and method
CN104715052B (en) Generate the method and its system of report
US10812627B2 (en) Frontend process mining
CN104364781B (en) System and method for calculating classification ratio
CN107886439A (en) Insurance products development approach, device, equipment and computer-readable recording medium
CN106372113A (en) News content pushing method and system
CN107784111A (en) Data digging method, device, equipment and storage medium
CN106293554A (en) A kind of cloud print system and cloud printer
CN110263009A (en) Generation method, device, equipment and the readable storage medium storing program for executing of log classifying rules
CN103942184B (en) Collocation method, generation method and system with addition Item consolidated statement
CN107481172A (en) Interactive job management method and system based on wechat public platform
CN102339296A (en) Method and device for sorting query results
CN106649232A (en) Method for automatically converting financial data into data capable of being understood by non-financial staff
CN101751400A (en) System and method of technical data analysis and system of patent analysis
CN112115145A (en) Data acquisition method and device, electronic equipment and storage medium
CN107392560A (en) A kind of Excel list datas issue acquisition method and system based on internet
CN103593344A (en) Information acquisition method and device
CN111625567A (en) Data model matching method, device, computer system and readable storage medium
EP2913763A1 (en) System and method for electronic form(s) management
CN107346312A (en) A kind of big data processing method and system
CN201974846U (en) Data collecting and counting system
Almomani et al. Software process improvement initiatives in small and medium firms: a systematic review
CN108038089A (en) A kind of online electronic spreadsheet engine of property tax
CN115794804A (en) Engineering internal control data visualization processing system and method based on big data technology
CN103020033A (en) Electronic spreadsheet system supporting off-line use, construction method and electronic spreadsheet

Legal Events

Date Code Title Description
C14 Grant of patent or utility model
GR01 Patent grant
CP03 Change of name, title or address
CP03 Change of name, title or address

Address after: 214000 Jiangsu Province, Wuxi City District Zhenze Wuxi Road No. 18 (National) fish Software Park building D block

Patentee after: Evermore software Limited by Share Ltd

Address before: A road of national hi tech Industrial Development Zone, Wuxi City, Jiangsu province 214135 No. 18 Wuxi (National) software park D District 5, 6 layers of Taurus

Patentee before: Wuxi Evermore Software Co., Ltd.

CX01 Expiry of patent term
CX01 Expiry of patent term

Granted publication date: 20110914