CN107169294A - The secondary judgement processing method of Excel forms in a kind of ATS for Environmental Test - Google Patents
The secondary judgement processing method of Excel forms in a kind of ATS for Environmental Test Download PDFInfo
- Publication number
- CN107169294A CN107169294A CN201710361040.2A CN201710361040A CN107169294A CN 107169294 A CN107169294 A CN 107169294A CN 201710361040 A CN201710361040 A CN 201710361040A CN 107169294 A CN107169294 A CN 107169294A
- Authority
- CN
- China
- Prior art keywords
- test
- interpretation
- excel
- excel forms
- thresholding
- 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
Classifications
-
- G—PHYSICS
- G16—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR SPECIFIC APPLICATION FIELDS
- G16Z—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR SPECIFIC APPLICATION FIELDS, NOT OTHERWISE PROVIDED FOR
- G16Z99/00—Subject matter not provided for in other main groups of this subclass
Landscapes
- Machine Translation (AREA)
Abstract
The invention discloses a kind of secondary judgement processing method of Excel forms in ATS for Environmental Test, and in particular to technical field of measurement and test.The secondary judgement processing method of Excel forms in the ATS for Environmental Test, carries out judgement processing using the mutual cooperation between Excel forms parsing module, Test Information management module, Excel forms reading module and Excel report files, specifically includes：Excel forms parsing module extracts Test Information from Excel report files, and Test Information is shown in Test Information management module, and the selection of Test Information management module needs the test event of interpretation and test parameter therein, and change interpretation thresholding again；Excel forms reading module is judged test data, and sentence read result and interpretation thresholding are write in Excel report files according to the test event of interpretation again the need for selection.
Description
Technical field
The present invention relates to technical field of measurement and test, and in particular to Excel forms two in a kind of ATS for Environmental Test
Secondary judgement processing method.
Background technology
In environmental test, due to long to the measured piece testing time, sometimes up to 1 month, therefore Auto-Test System is surveyed
Data volume is tried very big, sometimes, it is necessary to inquire about, process, therefore the generation Excel form consumptions such as browse before export Excel forms
When it is long.But after export Excel forms, sometimes due to test data interpretation thresholding sets wrong, or demand changes
Become, corresponding thresholding interpretation condition is accomplished by changing, but experiment has been completed, if experiment will waste plenty of time, people again
Power, and engaged test resource, and do not allow for testing again sometimes due to being pressed for time.
The content of the invention
The purpose of the present invention is to be directed to existing suitable environment auto Testing System above shortcomings, it is proposed that
It is a kind of that interpretation is only carried out to corresponding test result in Excel forms according to replacement interpretation thresholding, and update interpretation door in form
The secondary judgement processing method of Excel forms in the ATS for Environmental Test of limit and sentence read result.
The present invention, which has, to be adopted the following technical scheme that：
The secondary judgement processing method of Excel forms in a kind of ATS for Environmental Test, is parsed using Excel forms
Mutual cooperation between module, Test Information management module, Excel forms reading module and Excel report files is judged
Processing, is specifically included：
Excel forms parsing module extracts Test Information from Excel report files, and Test Information is shown in Test Information
In management module, the selection of Test Information management module needs the test event of interpretation and test parameter therein, and change again
Interpretation thresholding；
Excel forms reading module judged test data according to the test event of interpretation again the need for selection,
And write sentence read result and interpretation thresholding in Excel report files.
Preferably, the test report that the Excel report files generate for ATS for Environmental Test, including form
Header and test information, report heading information include testing time, tested information and tester, and test information includes test
Project name and test data form.
Preferably, the Table Header information of the test data form include sequence number, the testing time, environment temperature, test parameter,
Variable, the different test event of the columns and Table Header information of test result, threshold value and sentence read result, wherein test data form
Comprising test parameter number it is different.
Preferably, the Test Information management module resets interpretation management process：Selection needs the test item of interpretation first
Mesh title, shows that it tests Table Header information automatically；Then, selection needs the test parameter, interpretation thresholding, interpretation knot of interpretation respectively
Really, and these are recorded arranged in tables of data；Finally, interpretation thresholding is changed.
Preferably, the Excel forms reading module positions Excel report file test data interpretation ranges first；So
Afterwards, according to interpretation thresholding inspection test data is reset, sentence read result is obtained；Finally, update and interpretation thresholding and sentence in Excel forms
Read result.
Preferably, the Excel forms reading module assignment test data interpretation scope, line range is by Excel form solutions
The test data original position and line number that analysis module obtains test event determine that row are surveyed as selected by Test Information management module records
Parameter column position in tables of data is tried to determine；Interpretation thresholding and the row of sentence read result are respectively by Test Information management module records institute
Interpretation thresholding and the sentence read result column position in tables of data is selected to determine.
The present invention has the advantages that：By resetting interpretation thresholding only to corresponding test result in Excel forms
Interpretation is carried out, and update interpretation thresholding and sentence read result in form, it is to avoid re-start environmental test, and avoid cumbersome
Excel forms export process, are that environmental test saves plenty of time, manpower and test resource.
Brief description of the drawings
Fig. 1 is the secondary structured flowchart for judging processing method of Excel forms；
Fig. 2 is Excel form reading module interpretation flow charts.
Wherein, 1 is Excel form parsing modules, and 2 be Test Information management module, and 3 be Excel form reading modules, 4
For Excel report files.
Embodiment
The embodiment of the present invention is described further with specific embodiment below in conjunction with the accompanying drawings：
As shown in Figure 1 to Figure 2, the secondary judgement processing method of Excel forms in a kind of ATS for Environmental Test, is adopted
With between Excel forms parsing module 1, Test Information management module 2, Excel forms reading module 3 and Excel report files 4
Mutual cooperation carry out judgement processing, specifically include：
Excel forms parsing module 1 extracts Test Information from Excel report files 4, and Test Information is shown in experiment letter
Cease in management module 2, the selection of Test Information management module 2 needs the test event of interpretation and test parameter therein again, and
Change interpretation thresholding；
Excel forms reading module 3 is sentenced according to the test event of interpretation again the need for selection to test data
It is disconnected, and sentence read result and interpretation thresholding are write in Excel report files 4.
The test report that Excel report files 4 generate for ATS for Environmental Test, including form header and survey
Try information, report heading information includes testing time, tested information and tester, test information include test event title and
Test data form.
The Table Header information of test data form includes sequence number, testing time, environment temperature, test parameter, test result, door
The columns and Table Header information of limit value and sentence read result, wherein test data form are variable, the survey that different test events is included
Try number of parameters different.Test data form is similar to shown in table 1.
Table 1
Test event title
| Sequence number | Testing time | Environment temperature | Test parameter | Test result | Interpretation thresholding | Sentence read result |
Test Information management module resets interpretation management process：Selection needs the test event title of interpretation first, automatically
Show that it tests Table Header information；Then, selection needs the test parameter, interpretation thresholding, sentence read result of interpretation respectively, and records this
A little items are arranged in tables of data；Finally, interpretation thresholding is changed.
Excel forms reading module positions Excel report file test data interpretation ranges first；Then, according to replacement
Interpretation thresholding checks test data, obtains sentence read result；Finally, interpretation thresholding and sentence read result in Excel forms are updated.
Excel form reading module assignment test data interpretation scopes, line range is surveyed by Excel form parsing modules
The test data original position and line number of examination project determine, row as selected by Test Information management module records test parameter in data
Column position is determined in table；Interpretation thresholding and the row of sentence read result respectively as selected by Test Information management module records interpretation thresholding and
Sentence read result column position in tables of data is determined.
The secondary judgement processing method of Excel forms, is to rely on environmental test in above-mentioned ATS for Environmental Test
Auto-Test System realizes processing, is to realize the secondary processing unit for judging processing of Excel forms.
Certainly, described above is not limitation of the present invention, and the present invention is also not limited to the example above, this technology neck
The variations, modifications, additions or substitutions that the technical staff in domain is made in the essential scope of the present invention, should also belong to the present invention's
Protection domain.
Claims (6)
1. the secondary judgement processing method of Excel forms in a kind of ATS for Environmental Test, mould is parsed using Excel forms
Mutual cooperation between block, Test Information management module, Excel forms reading module and Excel report files is carried out at judgement
Reason, it is characterised in that specifically include：
Excel forms parsing module extracts Test Information from Excel report files, and Test Information is shown in Test Information management
In module, the selection of Test Information management module needs the test event of interpretation and test parameter therein, and change interpretation again
Thresholding；
Excel forms reading module judged test data according to the test event of interpretation again the need for selection, and will
In sentence read result and interpretation thresholding write-in Excel report files.
2. the secondary judgement processing method of Excel forms in a kind of ATS for Environmental Test as claimed in claim 1, its
It is characterised by, the test report that the Excel report files generate for ATS for Environmental Test, including form header
With test information, report heading information includes testing time, tested information and tester, and test information includes test event name
Claim and test data form.
3. the secondary judgement processing method of Excel forms in a kind of ATS for Environmental Test as claimed in claim 2, its
It is characterised by, the Table Header information of the test data form includes sequence number, testing time, environment temperature, test parameter, test knot
Really, the columns and Table Header information of threshold value and sentence read result, wherein test data form are variable, and different test events are included
Test parameter number it is different.
4. the secondary judgement processing method of Excel forms in a kind of ATS for Environmental Test as claimed in claim 1, its
It is characterised by, the Test Information management module resets interpretation management process：Selection needs the test event title of interpretation first,
Automatically show that it tests Table Header information；Then, selection needs the test parameter, interpretation thresholding, sentence read result of interpretation respectively, and remembers
These are recorded to arrange in tables of data；Finally, interpretation thresholding is changed.
5. the secondary judgement processing method of Excel forms in a kind of ATS for Environmental Test as claimed in claim 1, its
It is characterised by, the Excel forms reading module positions Excel report file test data interpretation ranges first；Then, according to
Reset interpretation thresholding and check test data, obtain sentence read result；Finally, interpretation thresholding and sentence read result in Excel forms are updated.
6. the secondary judgement processing method of Excel forms in a kind of ATS for Environmental Test as claimed in claim 2, its
It is characterised by, the Excel forms reading module assignment test data interpretation scope, line range is by Excel form parsing modules
The test data original position and line number for obtaining test event are determined, arrange the test parameter as selected by Test Information management module records
Column position is determined in tables of data；The interpretation as selected by Test Information management module records respectively of interpretation thresholding and the row of sentence read result
Thresholding and the sentence read result column position in tables of data are determined.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710361040.2A CN107169294A (en) | 2017-05-22 | 2017-05-22 | The secondary judgement processing method of Excel forms in a kind of ATS for Environmental Test |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710361040.2A CN107169294A (en) | 2017-05-22 | 2017-05-22 | The secondary judgement processing method of Excel forms in a kind of ATS for Environmental Test |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN107169294A true CN107169294A (en) | 2017-09-15 |
Family
ID=59815286
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201710361040.2A Pending CN107169294A (en) | 2017-05-22 | 2017-05-22 | The secondary judgement processing method of Excel forms in a kind of ATS for Environmental Test |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN107169294A (en) |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110908356A (en) * | 2019-10-11 | 2020-03-24 | 成都飞机工业（集团）有限责任公司 | Flight control test data rapid fault positioning method |
| CN111931460A (en) * | 2020-07-02 | 2020-11-13 | 上海微亿智造科技有限公司 | Variable-row-supporting Excel file analysis method and system |
| CN112364613A (en) * | 2020-10-30 | 2021-02-12 | 中国运载火箭技术研究院 | Automatic generation system for aircraft test data interpretation report |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101650711A (en) * | 2009-08-18 | 2010-02-17 | 深圳市科陆电子科技股份有限公司 | Method for generating report |
| CN105701072A (en) * | 2015-06-09 | 2016-06-22 | 深圳Tcl数字技术有限公司 | Method and device for filtering test contents of multiple projects based on excel form |
| CN105893634A (en) * | 2016-06-17 | 2016-08-24 | 中国银行股份有限公司 | Method and device for generating report |
-
2017
- 2017-05-22 CN CN201710361040.2A patent/CN107169294A/en active Pending
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101650711A (en) * | 2009-08-18 | 2010-02-17 | 深圳市科陆电子科技股份有限公司 | Method for generating report |
| CN105701072A (en) * | 2015-06-09 | 2016-06-22 | 深圳Tcl数字技术有限公司 | Method and device for filtering test contents of multiple projects based on excel form |
| CN105893634A (en) * | 2016-06-17 | 2016-08-24 | 中国银行股份有限公司 | Method and device for generating report |
Cited By (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110908356A (en) * | 2019-10-11 | 2020-03-24 | 成都飞机工业（集团）有限责任公司 | Flight control test data rapid fault positioning method |
| CN111931460A (en) * | 2020-07-02 | 2020-11-13 | 上海微亿智造科技有限公司 | Variable-row-supporting Excel file analysis method and system |
| CN111931460B (en) * | 2020-07-02 | 2021-09-10 | 上海微亿智造科技有限公司 | Variable-row-supporting Excel file analysis method and system |
| CN112364613A (en) * | 2020-10-30 | 2021-02-12 | 中国运载火箭技术研究院 | Automatic generation system for aircraft test data interpretation report |
| CN112364613B (en) * | 2020-10-30 | 2024-05-03 | 中国运载火箭技术研究院 | Automatic generation system for aircraft test data interpretation report |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN106445795B (en) | A kind of database SQL Efficiency testing method and device | |
| Sidone et al. | Scholarly publication and collaboration in B razil: The role of geography | |
| CN103473672A (en) | System, method and platform for auditing metadata quality of enterprise-level data center | |
| CN105138461A (en) | Interface testing method and device for application program | |
| CN105956410B (en) | A kind of Universal-purpose quick detection method of IEC61850 full models | |
| Timmermans et al. | The impact of student composition on schools’ value-added performance: a comparison of seven empirical studies | |
| CN107169294A (en) | The secondary judgement processing method of Excel forms in a kind of ATS for Environmental Test | |
| CN107545043A (en) | A kind of data application method and device based on data quality checking | |
| CN104574141A (en) | Service influence degree analysis method | |
| Lehtinen | Derivational robustness and indirect confirmation | |
| KR20120072130A (en) | Apparatus and method for evaluating basic software configuration based on autosar meta file | |
| CN106202776A (en) | A kind of carrier rocket structural mechanism Reliability Assessment method | |
| Lu et al. | Interval censored sampling plans for the gamma lifetime model | |
| Hu et al. | Statistical equivalency and optimality of simple step‐stress accelerated test plans for the exponential distribution | |
| Franceschini et al. | A novel approach for estimating the omitted‐citation rate of bibliometric databases with an application to the field of bibliometrics | |
| CN103164335B (en) | The method and system of inspection unit test mass | |
| Juddoo et al. | A qualitative assessment of machine learning support for detecting data completeness and accuracy issues to improve data analytics in big data for the healthcare industry | |
| CN101236136A (en) | Curve plotting method characterizing aeroplane service lifetime degree and applications | |
| CN105653445B (en) | A kind of implementation method for meeting DO 178C test results | |
| CN112486841A (en) | Method and device for checking data collected by buried point | |
| CN105373473B (en) | CDR accuracys method of testing and test system based on original signaling decoding | |
| CN101673200A (en) | Method and device for detecting user input model | |
| CN106991050A (en) | A kind of static test null pointer dereference defect false positive recognition methods | |
| CN105989095A (en) | Association rule significance test method and device capable of considering data uncertainty | |
| CN106649501B (en) | Consistency checking system and method for access model of substation monitoring database and SCD |
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 | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20170915 |
|
| RJ01 | Rejection of invention patent application after publication |