CN103577572A - Intelligent batch drawing and processing method for data graphs - Google Patents
Intelligent batch drawing and processing method for data graphs Download PDFInfo
- Publication number
- CN103577572A CN103577572A CN201310538917.2A CN201310538917A CN103577572A CN 103577572 A CN103577572 A CN 103577572A CN 201310538917 A CN201310538917 A CN 201310538917A CN 103577572 A CN103577572 A CN 103577572A
- Authority
- CN
- China
- Prior art keywords
- data
- worksheet
- batches
- former
- chart
- 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
Images
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/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/248—Presentation of query results
Abstract
The invention discloses an intelligent batch drawing and processing method for data graphs. The method is characterized by comprising the steps as follows: (1) data information required to be processed in batches is obtained; (2) original data graphs of data analysis information are established; (3) the original graphs are drawn in batches; (4) initial processing is performed on the original graphs in batches; (5) correction processing is performed on initial graphs; and (6) the data graphs are output in batches. In order to overcome defects that existing graph drawing and processing methods are excessively tedious to operate and error-prone, the all-round intelligent batch drawing and processing method, which is high in openness, wide in applicability, simple to operate, quite high in efficiency, concise and convenient, for the conventional data graphs is provided.
Description
Technical field
The present invention relates to a kind of intelligentized data drawing list draws and disposal route in batches.
Background technology
For Monitoring Data or computational data, there is a Rational Unified Process of extracting data, deal with data, analysis data.With regard to taking the high slope in civil engineering work, be example, for high slope is carried out to safety monitoring, its inside has been buried numerous monitoring instruments underground, carries out comprehensive monitoring; For multiple dimensioned research high slope is subject to multifactor synergistic impact, high slope has been carried out to the computational analysis of the methods such as finite element model; Thereby a lot of monitorings and the computational data of high slope have been obtained.Especially prototype monitoring data, it is the result of the model test of 1:1, it is very big that it obtains difficulty, be disturbed factor many, in order to make full use of these valuable data, water conservancy, a lot of fields such as building or construction work all relate to the demonstration problem of data, the data reasonably demonstration of multi-angle are related to the follow-up a series of activities such as data analysis, but the data processing work of each designing institute or scientific research institutions is still in take artificial treatment as main at present, other softwares, or grand etc. be operating as auxiliary situation, often having caused a large amount of quality time all to expend is drawing, in processing graphics, this is a very lengthy and jumbled process, huge manpower and time have not only been expended, and there are a lot of data after drafting finishes, just to find that it is unavailable data, caused the operation of a large amount of repeatability and meaningless property, and the inconsistency that the figure of drawing causes data to show because of manual operation, and the great number of issues such as the difficult textual criticism of figure mistake, it has directly had influence on data analysis link.Analysis and research to engineering military service condition have seriously been hindered.
The problems such as the replacing of the renewal of mass data information, the corrigendum of error message, chart-information and change often run in engineering, and these need repeatedly operation again or problems of revising in enormous quantities can bring heavy repeated labor and the problem such as inevitably make mistakes.
Problem based on above-mentioned Practical Project background and prior art existence, the practical example that process runs into and a large amount of practice trial work, finally set up the method that a set of succinct data drawing list is processed, it processes the method for data drawing list in general sense for a kind of quick, accurate, intelligent mass, to such an extent as to provide a kind of reliable and former figure of data accurately to subsequent analysis, for engineering practical study, having important supporting role, is a kind of optimal way of carrying out effectively batch drafting, figure list processing (LISP) and output for big data quantity information.
Summary of the invention
Goal of the invention: the object of the invention is to for the deficiencies in the prior art, provide a kind of intelligentized data drawing list to draw in batches and disposal route.
Technical scheme: intelligentized data drawing list of the present invention is drawn and disposal route in batches, comprises the steps:
(1) obtain the data information that needs batch processing;
Data information is because the reason of Practical Project has larger difference, even if the same engineering moment data message difference different at different engineering positions is still larger, so need to first determine the data information of studying.
(2) build the data primitive figure of data analysis data;
For the military service condition of research engineering to greatest extent, embodiment project data is regular, this step is mainly according to the requirement of concrete actual conditions or engineering, manually draws a former figure of project data information that can meet the demands, and this point has also highly embodied opening of the present invention and dirigibility.
(3) former figure draws in batches, for high density data in enormous quantities, suggestion use manually copies former data plot and in conjunction with the thought that locks each worksheet and its former figure is stayed in each worksheet, former figure is organized in each worksheet, can according to user, need to selectively copy more fast, accurately and easily like this, then the stickup of property in batches, its process flow diagram is referring to accompanying drawing 2, and concrete grammar is as follows:
(31) determine and wait to copy former figure;
(32) select to copy former figure;
(33) choose in batches worksheet;
(34) choose the position that will paste in worksheet;
(35) the former figure copying is pasted to waiting area in batches;
(36) check whether be last worksheet, if so, this step finishes; If not, return to step (33) and enter next circulation;
(4) former figure batch initial treatment: the data drawing list that this place refers to is for having in general sense the data plot of coordinate in length and breadth, the data plot of cliping and pasting in each worksheet is carried out to the modification of transverse and longitudinal coordinate, the initial value replacement of tentatively data value of the data primitive figure in each worksheet being carried out in corresponding worksheet obtains initial graph, makes initial graph represent the essential information of this worksheet measuring point;
Mainly based on activating work at present table and automatically locking the initial row (n of its every row (m+j)
1) and end line (n
2) thought of value carries out the modification of transverse and longitudinal coordinate by the former figure of data pasting in this worksheet, wherein in m+j, m is initial column, and j is circulation exponent number, and m+j is current columns, n
1the initial line number that represents m+j row, n
2the footline number that represents m+j row.By the continuous idea of automatically confining N different pieces of information series in figure, different N values is set and reaches the multi-thread object of simultaneously revising of a figure, for transverse and longitudinal coordinate, can be selected by corresponding method.The former figure of data now has just represented the essential information of some measuring points in this worksheet substantially.
(5) correcting process of initial graph: it is subject to the restriction of the fixing transverse and longitudinal coordinate figure of graphics primitive data the data plot of processing in previous step, may there is lacking in figure date and measured value, even without situations such as values, need second-order correction its real transverse and longitudinal coordinate and inferior coordinate figure, based on this idea, set up comprise data source automatic change, data plot in length and breadth coordinate automatically revise, the map title batch modification method of the chart-information such as modification automatically.
The correcting process thought of chart initial graph can be with reference to the accompanying drawing 4 in embodiment, its basic thought is: the drawing interface of first controlling initial graph, lock bound, spacing number and the distance values of its transverse and longitudinal coordinate, in order more reasonably to distribute distance values size, need to set the distance values value in different interval ranges; In line with the general transverse and longitudinal coordinate of principle of can optimization drawing a diagram, be worth most by adding and subtracting doubly single or many times of corresponding distance values and determine.
This step is mainly that the initial graph based in above-mentioned steps is carried out the correction of the information such as transverse and longitudinal coordinate, and it is mainly to comprise the multi-thread modification of a figure in master coordinate system and inferior coordinate system.Set up spacing formula: D=(MA-MI)/NN, wherein, the spacing number of NN for needing to divide, D is distance values, the maximum that MA, MI are series of values and minimum value are basically identical for its basic operation of inferior coordinate system and above-mentioned principle.Idea based on revising its map title after automatic selection time coordinate system and Chart Title in the inventive method is this measuring point or other associative operations such as title corresponding to this worksheet by the name modifications of each chart, specifically comprises the steps:
(51) select initial graph;
(52) determine the maximal value MA of transverse and longitudinal coordinate, minimum M I, then sets up the spacing formula of maximin: D=(MA-MI)/NN, the spacing number of NN for needing minute wherein, D is distance values;
(53) the reasonable adjustment after, each being worth through the former figure major-minor coordinate transverse and longitudinal coordinate figure of initial treatment most;
(6) data drawing list is exported in batches: for unified regulation chart output format and name problem, and the overall process of supporting data processing intactly, based on this idea, set up the program that a set of intellectuality is published picture, comprise width requirement Intellectual power output in data based word to the program in word and automatically to chart name, specifically see accompanying drawing 5.By the chart of having handled well in advance, intrinsic call word software, by the form with character string is stored in a character array by chart title, needs automatically to export the information such as data plot and numbering of figure and chart title according to the rules.Specifically comprise the steps:
(61) call word application program;
(62) by chart name storage to array;
(63) select book k, select chart i;
(64) chart that extracts selection is in word;
(65) the chart name information that output prestores is automatically carried out chart name;
(66) determine whether last chart, if not, return to step (63) and enter next circulation; If so, step finishes.
The present invention sums up the shortcoming of the numerous engineering application of several data disposal route by research, rear a kind of more succinct method extremely strong with engineering practicability of quick and precisely and easily grasping, be relatively applicable to applying, the uniqueness of outstanding especially invention theory of the present invention and thought developed.Compared with prior art, its beneficial effect is: the inventive method is too lengthy and jumbled for existing graph making disposal route operation, the defect of fallibility, provide a set of opening strong, applicability is wide, simple to operate, efficiency is high, the succinct routine data chart of all-around intelligent is easily drawn and disposal route in batches, lengthy and jumbled manual operation and too complicated macro operation are through with, having reserved the more quality time carries out the analysis of late time data, and this method can also be exported fast chart and even draws other related data flag informations such as data feature values, there is extremely strong continuity, modularity is better, repeatable strong, use simple, convenient, function is efficient, for the even whole data processing field of field of civil engineering realizes a new breakthrough and practicable thinking is provided about the maximization of information processing.The present invention has really realized a figure to a whole set of processing module of all figure, set up a kind of comprehensively, data processing method accurately and rapidly.
Accompanying drawing explanation
Fig. 1 is the inventive method schematic flow sheet;
Fig. 2 is that former figure works out schematic flow sheet in batches;
Fig. 3 is the former figure of certain engineering comprehensive accumulation displacement component;
Fig. 4 is certain process chart batch processing main flow schematic diagram;
Fig. 5 is that chart is exported schematic flow sheet in batches.
Embodiment
Below technical solution of the present invention is elaborated, but protection scope of the present invention is not limited to described embodiment.
Embodiment 1: the intelligentized data drawing list of the present invention is drawn and disposal route in batches, and the process schematic diagram of its realization as shown in Figure 1, carries out as follows:
(1) obtain the data information that needs batch processing;
Data information because the reason of Practical Project its there is larger difference, even if the same engineering moment data message difference different at different engineering positions is still larger, so need to first determine the data information of studying.
This case history be mainly northwest Large Hydro-Junction high slope X during June 21～2 days July in 2012 in 2010, Y, Z, level to, vertically to, comprehensively accumulate displacement and counting rate model divides spirogram.First secondary development the running program of tens kinds of routine datas, such as, by judging one by one each cell, space is deleted if, still judge the data under this line number, until last cell, this deletion space thought guidance creation facilities program (CFP) language, utilization is similar to a plurality of routine operation handling procedures of setting up under this thought, has handled certain measuring point well and has comprehensively accumulated each water level of statistical model of displacement, the tables of data of timeliness component.
(2) build the data primitive figure of data analysis data;
In order to study to greatest extent the work condition of this high slope, according to the theory relevant to this project, the component of each dependent variable and water level environment parameter are drawn in a chart, accordingly, foundation can embody the former figure of project data information, and the former figure of statistical model component that wherein comprehensively accumulates displacement is specifically shown in accompanying drawing 3.
(3) former figure draws in batches, this step is the method for arbitrary data chart that about how developing rapid batch generates for nearly a year through inventor in the present invention, conceive a kind of succinctly, idea easily, about this project Data processing, accompanying drawing 3 is used and manually copied, in conjunction with choosing each worksheet and one of them cell to reach to determine the worksheet at figure to be pasted place and the program thought of concrete ranks position, determine that the position at the former figure of these data place is the capable R row of C, then service routine is pasted in batches, is finally organized in 57 worksheets.
(4) former figure batch initial treatment: the data drawing list that this place refers to is for having in general sense the data plot of coordinate (accompanying drawing 3) in length and breadth, based on the thought of embedding data series first, according to the data plot in each worksheet (accompanying drawing 3), according to activating work at present table and automatically locking the initial row (n of its every row (m+j)
1) and end line (n
2) thought of value, first the accompanying drawing 3 pasting in this worksheet is carried out to the modification of transverse and longitudinal coordinate, time data horizontal ordinate series in the present embodiment: m is initial column, m=1; J is circulation exponent number, j=0; n
1represent that m+j row are the initial line number of first row, n
1=2; n
2the footline number that represents m+j row, n
2=5000; For ordinate, be measuring point measured value in the present embodiment, by constantly automatically confining the idea of N different pieces of information series in figure, different pieces of information series be set, the object of revising when N=3 reaches Fig. 3 line.The method of inventing by this step can be preliminary the original value that carries out in corresponding worksheet of the data value by the former figure of data in each worksheet replace, the former figure of data so now has just represented the essential information of this worksheet measuring point substantially.
(5) correcting process of initial graph
Correcting process for chart initial graph is specifically shown in accompanying drawing 4, its basic thought is: the drawing interface of first controlling initial graph, lock bound, spacing number and the distance values of its transverse and longitudinal coordinate, in order more reasonably to distribute distance values size, need to set the distance values value in different interval ranges, the present embodiment has mainly been set 7 spacing ranges, corresponding also corresponding 7 possible spacing values, the concept that in the present embodiment, ordinate is the time, only round up, and then definite transverse and longitudinal coordinate distance values; For the value of transverse and longitudinal coordinate, in the present embodiment, in line with the principle of can optimization drawing a diagram, its minimum value deducts one times of corresponding distance values for its DS minimum value, and on the contrary, its maximal value adds one times of corresponding distance values for its DS maximal value.
It is subject to the restriction of the fixing transverse and longitudinal coordinate figure of graphics primitive data the data plot of processing in previous step, may there is lacking in figure date and measured value in it, even without situations such as values, so the transverse and longitudinal coordinate of the figure based in each worksheet of second-order correction and the thought of inferior coordinate figure, mainly for the initial graph in above-mentioned steps (accompanying drawing 3), carry out the correction of the information such as transverse and longitudinal coordinate, it is mainly the modification comprising Fig. 3 line in master coordinate system and inferior coordinate system.This step is by the idea of the cycle criterion of all data measured value and output more afterwards being determined to the maximal value 41092(2012-7-2 of horizontal ordinate), minimum value 40035(2010-6-21), then set up spacing formula: D=(MA-MI)/NN, wherein, the spacing number of NN for needing to divide, for NN the present embodiment, be chosen as 8 proper, D can calculate and 4 determine end values with reference to the accompanying drawings, basically identical for ordinate value and inferior its basic operation of coordinate system stage hydrograph and above-mentioned principle, by the theory of this step, realized and automatically changed the multi-thread primary and secondary corresponding correction operation such as coordinate scale value and chart title in length and breadth in each chart (accompanying drawing 3).
(6) data drawing list is exported in batches, specifically comprises the steps:
In order to reach unified regulation chart output format and name problem, and the thought of the overall process of supporting data processing intactly, accordingly, set up the method that a set of intellectuality is published picture, specifically see accompanying drawing 5, comprise and require Intellectual power output to program and name automatically in word width in data based word and every one page acceptance table number.Accordingly 570 charts of this engineering and each chart title are outputed in word automatically according to profile position of living in and classification etc.
As mentioned above, although represented and explained the present invention with reference to specific preferred embodiment, it shall not be construed as the restriction to the present invention self.Not departing under the spirit and scope of the present invention prerequisite of claims definition, can make in the form and details various variations to it.
Claims (1)
1. intelligentized data drawing list is drawn and a disposal route in batches, it is characterized in that comprising the steps:
(1) obtain the data information that needs batch processing;
(2) build the data primitive figure of data analysis data;
(3) former figure draws in batches, and concrete grammar is as follows:
(31) determine and wait to copy former figure;
(32) select to copy former figure;
(33) choose in batches worksheet;
(34) choose the position that will paste in worksheet;
(35) the former figure copying is pasted to waiting area in batches;
(36) check whether be last worksheet, if so, this step finishes; If not, return to step (33) and enter next circulation;
(4) former figure batch initial treatment: the data plot of cliping and pasting in each worksheet is carried out to the modification of transverse and longitudinal coordinate, the initial value replacement of tentatively data value of the data primitive figure in each worksheet being carried out in corresponding worksheet obtains initial graph, makes initial graph represent the essential information of this worksheet measuring point;
(5) correcting process of initial graph, specifically comprises the steps:
(51) select initial graph;
(52) determine the maximal value of transverse and longitudinal coordinate
mA, minimum value
mI, then set up the spacing formula of maximin:
, wherein
nNthe spacing number dividing for needs,
dfor distance values;
(53) the reasonable adjustment after, each being worth through the former figure major-minor coordinate transverse and longitudinal coordinate figure of initial treatment most;
(6) data drawing list is exported in batches, specifically comprises the steps:
(61) call word application program;
(62) by chart name storage to array;
(63) select book
k, select chart
i;
(64) chart that extracts selection is in word;
(65) the chart name information that output prestores is automatically carried out chart name;
(66) determine whether last chart, if not, return to step (63) and enter next circulation; If so, step finishes.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201310538917.2A CN103577572A (en) | 2013-11-01 | 2013-11-01 | Intelligent batch drawing and processing method for data graphs |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201310538917.2A CN103577572A (en) | 2013-11-01 | 2013-11-01 | Intelligent batch drawing and processing method for data graphs |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN103577572A true CN103577572A (en) | 2014-02-12 |
Family
ID=50049348
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201310538917.2A Pending CN103577572A (en) | 2013-11-01 | 2013-11-01 | Intelligent batch drawing and processing method for data graphs |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN103577572A (en) |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104899908A (en) * | 2015-06-12 | 2015-09-09 | 百度在线网络技术（北京）有限公司 | Method and device for generating evolution diagram of event group |
| CN111027294A (en) * | 2019-12-12 | 2020-04-17 | 中国联合网络通信集团有限公司 | Table summarizing method, device and system |
-
2013
- 2013-11-01 CN CN201310538917.2A patent/CN103577572A/en active Pending
Non-Patent Citations (4)
| Title |
|---|
| 华诚科技: "《Word/Excel/PowerPoint三合一办公应用》", 29 February 2012, 机械工业出版社 * |
| 李伦香: "《Excel图表活用范例大辞典》", 30 April 2013, 中国铁道出版社 * |
| 杨东远等: "VBA在Excel水文数据处理中的应用研究", 《水道港口》 * |
| 杨章伟等: "《EXCEL VBA语法辞典》", 31 January 2010, 机械工业出版社 * |
Cited By (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104899908A (en) * | 2015-06-12 | 2015-09-09 | 百度在线网络技术（北京）有限公司 | Method and device for generating evolution diagram of event group |
| CN104899908B (en) * | 2015-06-12 | 2018-09-11 | 百度在线网络技术（北京）有限公司 | The method and apparatus for generating event group evolution diagram |
| CN111027294A (en) * | 2019-12-12 | 2020-04-17 | 中国联合网络通信集团有限公司 | Table summarizing method, device and system |
| CN111027294B (en) * | 2019-12-12 | 2023-05-30 | 中国联合网络通信集团有限公司 | Method, device and system for summarizing table |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN110490249A (en) | Structural Damage Identification based on attribute class relations and few sample meta learning | |
| CN106777808A (en) | A kind of Internet resources generation method based on standardization CAD diagram paper | |
| Cabellos et al. | Propagation of nuclear data uncertainties for PWR core analysis | |
| CN109446696A (en) | Quick atmospheric environment capacity measuring method, storage medium and terminal based on CMAQ model | |
| CN107563557A (en) | Determine the method and device of oil well output lapse rate | |
| CN103489036A (en) | Emergent pre-warning grid dividing system and method based on hybrid space correlation analysis | |
| CN110442523A (en) | A kind of spanned item mesh Software Defects Predict Methods | |
| CN107798059A (en) | A kind of NCO meteorological datas structured storage method and apparatus | |
| Martinez Alzamora et al. | Fast and practical method for model reduction of large-scale water-distribution networks | |
| CN107103640A (en) | The three-dimensional modeling method and system of a kind of City Buried Pipeline | |
| CN103577572A (en) | Intelligent batch drawing and processing method for data graphs | |
| Kwang et al. | Landscape evolution models using the stream power incision model show unrealistic behavior when m∕ n equals 0.5 | |
| CN104573339A (en) | Method and device for determining geological parameters of shale gas reservoir | |
| Fiorina et al. | Creation of an OpenFOAM fuel performance class based on FRED and integration into the GeN-foam multi-physics code | |
| Zeng et al. | Uncertainty analysis of Light water reactor core simulations using statistic sampling method | |
| CN112580118B (en) | Method for batch bushing drawing to measure multiple section terrains | |
| Lila et al. | Predicting solar radiation with Artificial Neural Network based on urban geometrical classification | |
| Li | Marine Environmental Monitoring Data Based on Information Visualization | |
| CN107832537B (en) | Numerical simulation method for residual stress in complex form | |
| CN104832210B (en) | The gas absolute discharge Forecasting Methodology of Based PC A-FIG-SVM | |
| Hong | Application of data mining technology in software engineering | |
| Mitra | Linear optimal power flow system and method | |
| CN107100175A (en) | A kind of method that assigned base point quick and precisely arranges friction pile on roadbed side slope elevation | |
| Bao et al. | Machine Learning in Nuclear Thermal Hydraulics, Part 2: Opportunities and Perspectives | |
| Zhang et al. | Parallel Jacobian-free Newton Krylov discrete ordinates method for pin-by-pin neutron transport models |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| C53 | Correction of patent of invention or patent application | ||
| CB03 | Change of inventor or designer information |
Inventor after: Gu Chongshi Inventor after: Shao Chenfei Inventor after: Su Huaizhi Inventor after: Yang Meng Inventor before: Gu Chongshi Inventor before: Shao Chenfei Inventor before: Yang Meng |
|
| COR | Change of bibliographic data |
Free format text: CORRECT: INVENTOR; FROM: GU CHONGSHI SHAO CHENFEI YANG MENG TO: GU CHONGSHI SHAO CHENFEI SU HUAIZHI YANG MENG |
|
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20140212 |
|
| RJ01 | Rejection of invention patent application after publication |