CN104462038A - Batch data processing method for quality detecting system based on EXCEL - Google Patents
Batch data processing method for quality detecting system based on EXCEL Download PDFInfo
- Publication number
- CN104462038A CN104462038A CN201410654091.0A CN201410654091A CN104462038A CN 104462038 A CN104462038 A CN 104462038A CN 201410654091 A CN201410654091 A CN 201410654091A CN 104462038 A CN104462038 A CN 104462038A
- Authority
- CN
- China
- Prior art keywords
- formula
- data
- excel
- detecting system
- quality detecting
- 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
Landscapes
- Document Processing Apparatus (AREA)
Abstract
The invention discloses a batch data processing method for a quality detecting system based on EXCEL. The method utilizes the EXCEL to integrate all formulae, and processes data in a one-time mode according to the rounding rule of banker's rounding. The method has the advantages that by the application of integral functions (ROUND) and condition functions (IF) in the EXCEL, the final result can be obtained in a one-time mode according to the rounding rule of banker's rounding only by inputting experimental data into cells in which the data need to be input. The method enables the working efficiency of a mechanism executing GB/T8170-2008 'numerical value rounding rule and expression and determination of limited numerical values' to be improved.
Description
Technical field
The present invention relates to a kind of method of batch execution data, specifically a kind of batch execution data method of the quality detecting system based on EXCEL.
Background technology
According to 3.2 regulations in standard GB/T/T8170-2008, " plan most the first from left bit digital of giving up numeral is 5, and nil or when being all 0, if the last figure retained is odd number, enter, namely the last figure of retention figures adds 1 thereafter; If the last figure retained is even number, then cast out ", this rule is called for short " four houses six enter five and gather idol ".Because numerous domestic testing agency all carries out the numerical value revision of the convention by this requirement, and the instrument abroad developed, the rule for rounding off of " rounding up " is only provided in the operation rule as the most frequently used EXCEL, cause domestic testing agency often can only carry out the progressively revision of the convention with the counter that efficiency is lower to calculate, day by day heavy Detection task cannot be adapted to.
Summary of the invention
The object of the invention is to overcome the deficiencies in the prior art, a kind of batch execution data method of the quality detecting system based on EXCEL is provided, utilize EXCEL to integrate all formula, carry out data processing according to the rule for rounding off of " four houses six enter five and gather idol " is disposable.
According to technical scheme provided by the invention, the batch execution data method of the described quality detecting system based on EXCEL is as follows:
(1) EXCEL data form contents processing title and every data formula is created, comprise: corresponding gauge outfit is set, rower is entitled as parallel sample numbering, and column heading relates to information and comprises: the formula participating in the title of the master data of data processing, code, unit and relate to;
(2) need the cell carrying out data processing, edit common formula A;
(3) utilize conditional function to make the formula A of participation data processing, according to the rule for rounding off process of " four houses six enter five and gather idol ", be defined as formula B;
Concrete formula B is IF ((A*10
n-0.5)/2=TRUNC ((A*10
n-0.5)/2), A-0.5* (1/10
n), A), wherein n is the decimal digits of the required revision of the convention; When need the decimal digits of the revision of the convention be respectively 0,1,2,3 ... time, the n in described formula B is respectively: 0,1,2,3,
(4) utilize ROUND function, retain the corresponding decimal digits of result of calculation, concrete formula C is ROUND (B, n),
Computing formula involved in table all must apply mechanically this formula C; The formula this step obtained inserts corresponding unit lattice;
(5) in the cell needing to input data, input the data of every batch, disposablely obtain net result.
In step (5), when relating to the constant data of changes little in formula, such as batch execution data do not need change and batch between need change constant data time, the constant data of described changes little is first inputted at corresponding cell, and preserves; The variable data of each change of input more afterwards.
Advantage of the present invention is: use bracket function (ROUND) and conditional function (IF) in EXCEL, only need input experimental data and can obtain net result according to the rule for rounding off of " four give up six enter five gather idol " is disposable.The method can make the mechanism of execution GB/T8170-2008 " rules of rounding off for numerical values & expression and judgement of limiting values " increase work efficiency.
Embodiment
Below in conjunction with specific embodiment, the invention will be further described.
Method of the present invention comprises the following steps:
(1) EXCEL data form contents processing title and every data formula is created;
Arrange corresponding gauge outfit, rower is entitled as parallel sample numbering, and column heading relates to information and comprises: the formula participating in the title of the master data of data processing, code, unit and relate to;
(2) need the cell carrying out data processing, edit common formula A;
(3) utilize conditional function to make the formula A of participation data processing, according to the rule for rounding off process of " four houses six enter five and gather idol ", be defined as formula B; Concrete formula B is
IF((A*10
n-0.5)/2＝TRUNC((A*10
n-0.5)/2),A-0.5*(1/10
n),A)，
In above formula, when need the decimal digits of the revision of the convention be respectively 0,1,2,3 ... time, the n in described formula B is respectively: 0,1,2,3,
(4) because the result of calculation of acquiescence when EXCEL calculates is the decimal digits of infinite place decimal instead of its display, therefore ROUND function need be utilized, retain corresponding decimal digits, the computation rule of simulating hand counter; Concrete formula C is
ROUND(B，n)；
Computing formula involved in table all must apply mechanically this formula;
(5) input the constant condition of changes little and preserve;
Can relate in some formula batch execution data do not need change and batch between need change constant data, as in embodiment two, the coefficient a of the equation of linear regression of certain typical curve, b are constant in a collection of experiment, can input at corresponding cell, and preserve;
(6) variable data needing to input the input of data and change at every turn, disposablely obtains net result.
The present invention utilizes EXCEL to show, and carries out data processing according to the method for " four houses six enter five and gather idol " in GB/T8170-2008 " rules of rounding off for numerical values & expression and judgement of limiting values ".Its principle be utilize conditional function carry out simulated data process meeting the rule for rounding off of " four houses six enter five gather idol "; Utilize bracket function, by the nonterminating and non-recurring decimal that EXCEL result of calculation is given tacit consent to, be converted to the decimal of corresponding figure place, and participate in follow-up data process.
All formula in this method integral data processing procedure, make data processing settle at one go.In one batch of similar test, only need input the constant of a changes little, experimental result secondary by the gross can be obtained.For the data of each change, input, as sampled quality, absorbance etc., EXCEL software just can calculate automatically, once obtains final data result, increases work efficiency at every turn.
Specifically please see following case study on implementation.
Embodiment one:
The calculating of moisture, with reference to GB5009.3-2010 first method.
When not using this patent, the data processed result of EXCEL table is in table one.
Table one
Corresponding formula is in table two.
Table two
During use this patent, the data processed result of EXCEL table is in table three.
Table three
Corresponding formula is in table four.
Table four
3 formula in table two are the common formula A described in step (2), corresponding, in table four according to the method for step (3) and (4) respectively by table two J8, in K8 and J9, three formula are defined as A, and be converted to formula C, insert D8 respectively, E8 and D9 cell.
Whenever D5, E5, D6, E6, D7, E7 cell input data, in D8, E8 and D9 cell, namely show corresponding result.
Embodiment two:
The calculating of nitrite, with reference to GB5009.33-2010 second method.
When not using this patent, the data processed result of EXCEL table is in table five.
Table five
Corresponding formula is in table six.
Table six
During use this patent, the data processed result of EXCEL table is in table seven.
Table seven
Corresponding formula is in table eight.
Table eight
5 formula in table six are the common formula A described in step (2), corresponding, in table eight according to the method for step (3) and (4) respectively by table six C5, D5, in C9, D9, C10,5 formula are defined as A, and be converted to formula C, insert C5 respectively, D5, C9, D9, C10 cell.
Relate to the constant data of the changes little mentioned in step (5) in C2, C3, C7, C8 cell, therefore by they first input block lattice, and preserve form; And then the C4 of each change of input, D4, C6, D6 cell data, namely show corresponding result in C5, D5, C9, D9, C10 cell thereupon.
Claims (3)
1., based on the batch execution data method of the quality detecting system of EXCEL, it is characterized in that, comprise the following steps:
(1) EXCEL data form contents processing title and every data formula is created, comprise: corresponding gauge outfit is set, rower is entitled as parallel sample numbering, and column heading relates to information and comprises: the formula participating in the title of the master data of data processing, code, unit and relate to;
(2) need the cell carrying out data processing, edit common formula A;
(3) utilize conditional function to make the formula A of participation data processing, according to the rule for rounding off process of " four houses six enter five and gather idol ", be defined as formula B;
Concrete formula B is IF ((A*10
n-0.5)/2=TRUNC ((A*10
n-0.5)/2), A-0.5* (1/10
n), A),
Wherein n is the decimal digits of the required revision of the convention;
(4) utilize ROUND function, retain the corresponding decimal digits of result of calculation, concrete formula C is ROUND (B, n),
Computing formula involved in table all must apply mechanically this formula C; The formula this step obtained inserts corresponding unit lattice;
(5) in the cell needing to input data, input the data of every batch, disposablely obtain net result.
2. as claimed in claim 1 based on the batch execution data method of the quality detecting system of EXCEL, it is characterized in that, in step (5), when relating to the constant data of changes little in formula, the constant data of described changes little is first inputted at corresponding cell, and preserves; The variable data of each change of input more afterwards.
3. as claimed in claim 1 based on the batch execution data method of the quality detecting system of EXCEL, it is characterized in that, when need the decimal digits of the revision of the convention be respectively 0,1,2,3 ... time, the n in described formula B, C is respectively: 0,1,2,3 ...
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201410654091.0A CN104462038A (en) | 2014-11-17 | 2014-11-17 | Batch data processing method for quality detecting system based on EXCEL |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201410654091.0A CN104462038A (en) | 2014-11-17 | 2014-11-17 | Batch data processing method for quality detecting system based on EXCEL |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN104462038A true CN104462038A (en) | 2015-03-25 |
Family
ID=52908110
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201410654091.0A Pending CN104462038A (en) | 2014-11-17 | 2014-11-17 | Batch data processing method for quality detecting system based on EXCEL |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN104462038A (en) |
Cited By (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105511595A (en) * | 2016-01-22 | 2016-04-20 | 中国石油化工股份有限公司 | Experimental data processing method and device |
| CN106326650A (en) * | 2016-08-22 | 2017-01-11 | 朱明伟 | EXCEL-based draft survey method and EXCEL-based draft survey system |
| CN110297798A (en) * | 2019-06-21 | 2019-10-01 | 江西洪都航空工业集团有限责任公司 | Embedded system and its yard and meter turn method with yard and meter turn function |
| CN116612180A (en) * | 2023-07-18 | 2023-08-18 | 湖南省计量检测研究院 | Commodity quantity detecting system capable of being maintained in real time |
Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102622202A (en) * | 2012-02-22 | 2012-08-01 | 浙江工业大学 | Intelligent selection and representation method for significant digits of significant figure operational result |
| CN103870920A (en) * | 2014-02-26 | 2014-06-18 | 浪潮软件股份有限公司 | Charging precision processing model used for hospital information systems |
-
2014
- 2014-11-17 CN CN201410654091.0A patent/CN104462038A/en active Pending
Patent Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102622202A (en) * | 2012-02-22 | 2012-08-01 | 浙江工业大学 | Intelligent selection and representation method for significant digits of significant figure operational result |
| CN103870920A (en) * | 2014-02-26 | 2014-06-18 | 浪潮软件股份有限公司 | Charging precision processing model used for hospital information systems |
Non-Patent Citations (1)
| Title |
|---|
| 赵鹏等: "用Excel函数在牛冻精质量检测结果计算中实现"四舍六入五留双"", 《上海畜牧兽医通讯》 * |
Cited By (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105511595A (en) * | 2016-01-22 | 2016-04-20 | 中国石油化工股份有限公司 | Experimental data processing method and device |
| CN106326650A (en) * | 2016-08-22 | 2017-01-11 | 朱明伟 | EXCEL-based draft survey method and EXCEL-based draft survey system |
| CN110297798A (en) * | 2019-06-21 | 2019-10-01 | 江西洪都航空工业集团有限责任公司 | Embedded system and its yard and meter turn method with yard and meter turn function |
| CN110297798B (en) * | 2019-06-21 | 2022-12-23 | 江西洪都航空工业集团有限责任公司 | Embedded system with metric/English system conversion function and metric/English system conversion method thereof |
| CN116612180A (en) * | 2023-07-18 | 2023-08-18 | 湖南省计量检测研究院 | Commodity quantity detecting system capable of being maintained in real time |
| CN116612180B (en) * | 2023-07-18 | 2023-10-03 | 湖南省计量检测研究院 | Commodity quantity detecting system capable of being maintained in real time |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN104462038A (en) | Batch data processing method for quality detecting system based on EXCEL | |
| CN106909901B (en) | Method and device for detecting object from image | |
| CN105225149A (en) | A kind of reference scoring defining method and device | |
| CN116522094B (en) | Analysis and measurement method, device, equipment and storage medium for regional carbon neutralization | |
| CN104572587A (en) | Data matrix multiplying acceleration computing method and device | |
| CN115730605A (en) | Data analysis method based on multi-dimensional information | |
| CN104504221A (en) | Evaluation data processing method and system | |
| CN112331266A (en) | Method for eliminating PCR fluorescence baseline period fluctuation | |
| CN110751400B (en) | Risk assessment method and device | |
| Akrami et al. | Numerical solutions for fractional black-scholes option pricing equation | |
| CN109616152B (en) | Method and device for establishing cancer-specific co-modulation network | |
| CN108715891B (en) | Expression quantification method and system for transcriptome data | |
| CN116108745A (en) | Multi-parameter calibration method for water environment model, terminal equipment and storage medium | |
| CN102930158A (en) | Variable selection method based on partial least square | |
| Thiramanus et al. | Integral inequalities with ‘maxima’and their applications to Hadamard type fractional differential equations | |
| CN105654106A (en) | Decision tree generation method and system thereof | |
| Khan et al. | A comparison between numerical methods for solving Fuzzy fractional differential equations | |
| CN110569285B (en) | Method and device for calculating background value of soil element | |
| Payan et al. | A ranking method based on common weights and benchmark point | |
| Arystanbekov et al. | Generalized Galerkin method for an infinite time-horizon economic growth problem | |
| Matusiak | Optimization for software implementation of fractional calculus numerical methods in an embedded system | |
| CN110838344B (en) | Water quality data analysis method | |
| CN103049627A (en) | Generating system and method for deviation range of measured data | |
| CN100365626C (en) | Database optimizing method | |
| Thanh Tung | Regional differences in measuring the technical efficiency of rice production in Vietnam: A metafrontier approach |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20150325 |
|
| RJ01 | Rejection of invention patent application after publication |