WPS template for rapidly evaluating uncertainty report of measurement result of analytical instrument

Abstract

The invention discloses a WPS intelligent calculation template for rapidly evaluating the uncertainty of the measurement result of an analysis instrument and a report template capable of automatically generating an uncertainty evaluation report at the same time. Six templates are designed in total and comprise one intelligent computing template and five report templates, and the templates are subjected to programming design by using a WPS tool. The calculation template is designed to comprise notes, experiment information, uncertainty evaluation calculation, measurement result representation, uncertainty component contribution diagrams and other modules. Through program design, data processing can be automatically carried out only by inputting related experimental information data and a calculation template, a data result can be automatically transmitted to a corresponding report template, an uncertainty evaluation report is generated, manual data processing is replaced by an intelligent computer, errors caused by manual operation are avoided, and the reliability of the system is improved. According to the method, visualization, intellectualization and accuracy of uncertainty evaluation are achieved, a user does not need to be familiar with a complex uncertainty evaluation principle and carry out complex mathematical calculation, the method can be widely popularized and used, the requirement for uncertainty evaluation of measurement results of analysis instruments such as chromatography, spectrum and mass spectrum in a detection laboratory can be completely met, and the working efficiency is greatly improved.

Description

Technical Field

[0001] The invention relates to a WPS intelligent calculation and report template for uncertainty evaluation of measurement results of analytical instruments. Background Art

[0002] Measurement uncertainty is a parameter associated with the measurement result, which is used to characterize the dispersion of the value reasonably assigned to the measured value, and is usually composed of many components. There are many sources of uncertainty, but it is crucial to grasp the key points. The value of the combined uncertainty depends almost entirely on those important uncertainty components. Therefore, when evaluating uncertainty, the correct approach should be to focus on analyzing the uncertainty components that contribute the most. The assessment of uncertainty is a rather complicated task, which is highly technical and requires familiarity with its principles. It also requires strong statistical knowledge. The calculation process is cumbersome, the workload is large, and it is very time-consuming. With the development of computer science, some complex calculations will inevitably be replaced by visual and intelligent data processing tools to liberate manpower, improve work efficiency, and avoid errors caused by manual calculations. The ultimate goal of the uncertainty assessment of measurement results is to output a complete and accurate uncertainty assessment report. At present, there are few reports on intelligent tools suitable for the uncertainty assessment of analytical instrument measurement results. Summary of the invention

[0003] The present invention designs a WPS intelligent calculation template and report template for quickly evaluating the uncertain measurement results of analytical instruments. The designed calculation template is as follows Figure 1 As shown in the figure, the automatic data processing function is realized through program design. The five report templates designed are as follows Figures 2 to 6 As shown, it is equivalent to 5 pages of a complete uncertainty assessment report, designed according to the A4 paper size, which is convenient for printing and output, and its data are all quoted from the calculation template. All input operations are performed in the calculation template. Through program design, its data information will be automatically transmitted to the corresponding 5 report templates to automatically generate an uncertainty assessment report. The report template only needs to set the data format to print and output to quickly complete an uncertainty assessment report of the measurement results of the analytical instrument. The working principle of the present invention is: the data information of the experimental measurement is input into the calculation template, the calculation template automatically processes the data, and the result data will be transmitted to the corresponding 5 report templates at the same time to automatically generate an uncertainty assessment report. After setting the data format in the report template, it can be printed and output to complete a 5-page continuous and complete uncertainty assessment report of the measurement results of the analytical instrument. In short, the intelligent calculation template realizes the data input and processing functions, and the report template realizes the output and printing of the assessment report.

[0004] The specific design is as follows: (1) The calculation template is designed with five modules, including precautions, experimental information, uncertainty assessment calculation, measurement result representation and uncertainty contribution diagram. The uncertainty assessment calculation includes uncertainty calculation modules for standard value introduction, weighing introduction, pretreatment process introduction (including pipette introduction, single-line pipette introduction, graduated pipette introduction, constant volume introduction), sample measurement introduction and calibration curve calculation introduction. In order to avoid errors in the calculation results when the data information is filled with " / ", in addition to the commonly used operation functions AVERAGE, STDEV, SQRT, SUMSQ, etc., this module uses the non-operation function IFERROR for program design many times. When the calculation result is an error, the value 0 specified by this module is returned, otherwise the normal calculation result is returned.

[0005] (2) Notes module The calculation template uses three colors of fonts to distinguish operations. The data information marked in red needs to be entered manually; the data information marked in blue is automatically calculated or quoted from other places in the calculation template; the data information marked in purple is fixed. The data format in the calculation template can be set as needed. All data information input operations are performed in the calculation template.

[0006] Experiment information module Data information such as experimental temperature (°C), experimental humidity (%), test method, sample name, test items and experimental principle are directly input into this module.

[0007] (4) Uncertainty module introduced by standard value determination The standard number, standard name, purity or concentration C , measurement units and expanded uncertainty U ( k =2) and other data information are input into this module. If not, fill in " / ". Through program design, data processing is automatically performed and standard uncertainty is output. u and relative uncertainty u ref (1). Standard uncertainty u The programming of this article involves using the IFERROR function.

[0008] (5) Uncertainty module introduced by weighing The name of the standard / sample, the number of the analytical balance and the eccentricity error given in the balance calibration certificate ( ERR 1) Repeatability error ( ERR 2) and indication error ( ERR3) Enter the expanded uncertainty, sample weight, weighing times and measurement unit into this module. If not, fill in " / ". Use the functions IFERROR, SUMSQ and SQRT to design a program to automatically process data and output the relative standard uncertainty components introduced by each weighing. u rel and the combined relative uncertainty u ref (2) (6) Uncertainty module introduced in the pre-processing process The uncertainty introduced in the preprocessing process is composed of five components: the uncertainty introduced by the pipette, the uncertainty introduced by the single-marked pipette, the uncertainty introduced by the graduated pipette, and the uncertainty introduced by the fixed volume. Therefore, this module also designs uncertainty modules introduced by the pipette, the uncertainty introduced by the single-marked pipette, the graduated pipette, and the fixed volume.

[0009] 1) Uncertainty module introduced by pipette The input data includes the pipette number, number of times used, and the relative error of the volume given in the calibration certificate ( ERR 1) Measurement repeatability error ( ERR 2) and measurement units. If there are unused numbers, fill in " / ", and fill in "0" for the corresponding number of uses, relative error of volume, and measurement repeatability. Use the functions SUMSQ and SQRT to design a program to automatically process data and output the relative uncertainty components introduced by each pipette. and the combined relative uncertainty component .

[0010] 2) Uncertainty module introduced by single-line pipette Enter the number of the single-line pipette, the number of times it has been used, and the volume deviation given in the calibration certificate ( ERR ) and other information. If there is an unused number, fill in " / ", and fill in "0" for the corresponding number of uses and capacity deviation. Use the functions ABS, SUMSQ, and SQRT to design a program to automatically process data and output the relative uncertainty caused by the volume change of each single-line pipette. u rel(1) , relative uncertainty caused by temperature changes u rel(2) and the composite relative uncertainty component u rel(3) .

[0011] 3) Uncertainty module introduced by graduated pipette Enter the pipette number, number of times used, and volume deviation given in the calibration certificate ( ERR) and other data information. If there is an unused number, fill in " / ", and fill in "0" for the corresponding number of uses and capacity deviation. Use the functions ABS, SUMSQ, and SQRT to design a program to automatically output the relative uncertainty caused by the volume change of each graduated pipette u rel(1) , relative uncertainty caused by temperature changes u rel(2) and the composite relative uncertainty component u rel(3) .

[0012] 4) Uncertainty module introduced by constant volume Enter the volumetric flask number, number of times used, volume deviation given in the calibration certificate and other data information. If there is an unused number, fill in " / ", and fill in "0" for the corresponding number of times used and volume deviation. Use the functions ABS, SUMSQ, and SQRT to design a program to automatically output the relative uncertainty caused by the change in each fixed volume. u rel(1) , relative uncertainty caused by temperature changes u rel(2) and relative composite uncertainty components u rel(3) .

[0013] After the data processing of the uncertainties introduced by the pipette, the single-line pipette, the graduated pipette and the constant volume is completed, the program is designed using the functions SUMSQ and SQRT to automatically output the relative uncertainty introduced by the pre-processing process of this module. .

[0014] (7) Uncertainty module introduced by sample measurement The uncertainty introduced by sample measurement is composed of two components: the uncertainty introduced by instrument measurement error and the uncertainty introduced by repeated measurement. Therefore, this module also designs the uncertainty introduced by instrument measurement error and the uncertainty introduced by repeated measurement. The instrument number, instrument name, instrument quantitative repeatability error given in the instrument calibration certificate ( ERR 1) and linear error ( ERR 2) Input the data information such as the measurement unit, sample parallel measurement results and their measurement units into this module. If there is no data, fill in " / ". Use the functions AVERAGE, STDEV, SQRT, SUMSQ, and IFERROR to design a program to automatically output the relative uncertainty components of this module. , and relative uncertainty .

[0015] (8) Uncertainty module introduced by standard curve calculation The concentration of the standard curve xIts measurement unit and its corresponding instrument response intensity or peak area y (If there are 5 detection points, the 6th point x and y The module is used to input the value of the sample into the module, and the sample concentration and other information are input into the module. This module is designed with more intermediate data output transitions to solve the complex calculation process. The functions IFERROR, INDEX, LINEST, CORREL, AVERAGE, COUNT, POWER, SUM, SQRT are used to design the program, automatically process the data, and output the intercept a, slope b and linear correlation coefficient of the linear equation. R , average concentration of standard curve, number of points of standard curve n =5 or 6, number of parallel measurements of samples p , average concentration of sample parallel measurement and intermediate data of calibration curve calculation, relative uncertainty introduced by calibration curve calculation Waiting for the result data.

[0016] (9) Measurement result display module According to the uncertainty component result data output by the previous modules, this module automatically outputs the synthetic standard uncertainty and expanded uncertainty through program design. The final measurement result is expressed as X ± U .

[0017] (10) Uncertainty contribution diagram The uncertainty of the measurement results of analytical instruments is mainly composed of five components: standard value (SD), weighing (M), sample pre-process (V), sample measurement (YQ) and standard curve calculation process (BQ). Combined with the results output by the previous modules, this module is designed to use the WPS drawing tool to automatically output the contribution bar chart of each component of uncertainty.

[0018] (11) Report template The data information in black fonts in the designed 5 report templates are fixed, the data information in blue fonts are all quoted from the calculation template, and all comments are used to explain the source of data information or calculation formulas. The designed 5 report templates constitute a continuous and complete measurement uncertainty assessment report. Each report template is designed with an A4 paper area for easy printing and output, and the company name and report number can be edited in the report header. The report templates are all designed using the INDEX function to transfer data information from the calculation template to the corresponding report template.

[0019] The present invention makes full use of the powerful calculation function of WPS, combines the uncertainty evaluation principle and calculation formula in the national standard, and develops an intelligent and visual evaluation tool for uncertainty. Users do not need to be familiar with the complex uncertainty evaluation principle. They only need to input the experimental data to obtain a complete and accurate uncertainty evaluation report of the analytical instrument measurement result, realizing the "fool-proof" operation of uncertainty evaluation, which can greatly improve work efficiency and save costs, and has broad application prospects. The main sources of uncertainty in the measurement results of analytical instruments are: (1) uncertainty introduced by standard value determination; (2) uncertainty introduced by standard and sample weighing; (3) uncertainty introduced by pipetting and quantitative vessels used in sample pretreatment; (4) uncertainty introduced by sample measurement; (5) uncertainty introduced by calibration curve calculation. Therefore, the uncertainty of the measurement results of analytical instruments is mainly composed of these five uncertainty components. The present invention uses WPS as a template, combines the main sources of uncertainty in the measurement results of analytical instruments, and realizes intuitive, visual, and intelligent rapid evaluation of the uncertainty of the measurement results of analytical instruments through program design and automatically generates an evaluation report. The designed template is a general template for evaluating the uncertainty of measurement results of analytical instruments. It is suitable for evaluating the uncertainty of measurement results of analytical instruments such as chromatography, spectroscopy, and mass spectrometry. On this basis, it can be simplified and improved as needed. The measurement result uncertainty evaluation report template suitable for conventional physical and chemical testing and microbiological testing methods can also be designed based on the principle of this template.

[0020] The present invention develops a WPS intelligent calculation and report template for simply, quickly, intuitively and intelligently evaluating the uncertainty of the measurement results of analytical instruments. Compared with the prior art, the present invention has the following innovations: The template designed by the present invention can be used for the evaluation of the uncertainty of the measurement results of analytical instruments and the automatic generation of evaluation reports. It is suitable for the evaluation of the uncertainty of the measurement results of analytical instruments such as chromatography, spectroscopy, and mass spectrometry. It is highly innovative. Currently, there are few reports on the complete design from uncertainty evaluation to report output. The present invention adopts the currently commonly used office application software WPS design template, which is simple and intuitive to operate. It does not require familiarity with the complex principles of uncertainty assessment and complex and tedious calculations. It only needs to simply input experimental data information and set the data format to complete the work from assessment to report output of the uncertainty of the analytical instrument measurement results, which greatly improves work efficiency. It can be operated by laboratory technicians, has low cost and is easy to popularize and promote. The present invention innovatively makes full use of the WPS calculation function and its application functions, invents and designs intelligent, efficient and fast calculation and report templates for uncertain measurement results of evaluation and analysis instruments, improves the accuracy of output data information, and has good application prospects. BRIEF DESCRIPTION OF THE DRAWINGS

[0021] Figure 1It is a calculation template; Figure 2 It is report template 1; Figure 3 It is report template 2; Figure 4 It is report template 3; Figure 5 It is report template 4; Figure 6 This is report template 5. In the figure: Report Template 1 The basic content module of the experiment was designed, and program design was used to realize the uncertainty module introduced by the experimental information in the calculation template and the sample measurement, and the report template 1 was designed as the first page of the uncertainty assessment report.

[0022] Report Template 2 The modules of relative uncertainty introduced by standard value, relative uncertainty introduced by weighing, and relative uncertainty introduced by pipette are designed. The data information in blue font is referenced from the modules of uncertainty introduced by standard value, uncertainty introduced by weighing, and uncertainty introduced by pipette in the calculation template using program design. Report template 2 is designed as page 2 of the uncertainty assessment report.

[0023] Report Template 3 The relative uncertainty modules introduced by the single-line pipette and the relative uncertainty modules introduced by the graduated pipette were designed. The data information in blue font was referenced from the uncertainty modules introduced by the single-line pipette and the graduated pipette in the calculation template using program design. Report template 3 is designed as page 3 of the uncertainty assessment report.

[0024] Report Template 4 The modules of relative uncertainty introduced by constant volume, relative uncertainty introduced by instrument measurement error, and relative uncertainty introduced by repeated measurement are designed. The data information in blue font is referenced from the modules of uncertainty introduced by constant volume and sample measurement in the calculation template using program design. Report template 4 is designed as page 4 of the uncertainty assessment report.

[0025] Report Template 5 The modules of relative uncertainty, expanded uncertainty and result report, and contribution diagram of each component of uncertainty introduced by the calibration calculation are designed. The data information in blue font is referenced from the calculation template, the uncertainty introduced by the calibration calculation, the representation of measurement results, and the contribution diagram of each component of uncertainty are realized. The WPS drawing tool is used to automatically output the column chart of the contribution of each component of uncertainty. For the sake of aesthetics, the graph can be covered with the data table used for drawing. DETAILED DESCRIPTION

[0026] The present invention is further described below by means of specific examples.

[0027] Example 1: Uncertainty Assessment of the Results of Determination of Fenpyraclostrobin Residues in Fruits The relevant experimental and standard curve data information are shown in Tables 1 and 2.

[0028]

[0029]

[0030] All input operations are performed in the calculation template. The report template only needs to set the data format to print out. The operation steps are: (1) Experimental information module (calculation template): Input the experimental temperature, humidity, test method, sample name, test item, experimental method and experimental principle in Table 1 directly into this module. After the input is completed, the relevant data information will be transmitted to the corresponding report template 1.

[0031] (2) Uncertainty module introduced by standard value determination (calculation template): Input the experimental information such as standard type, standard number, standard name, concentration, concentration unit, and standard expanded uncertainty in Table 1 into this module, and automatically output the relative uncertainty introduced by the standard value determination: =0.00253. The corresponding data information will be transferred to report template 2.

[0032] (3) Uncertainty module introduced by weighing (calculation template): Input the names of the weighing standards and samples in Table 1, the serial number of the electronic balance, the expanded uncertainty of the eccentric load error, repeatability error and indication error given in the calibration certificate, the sample weight, the number of weighings and other information into this module, and the relative uncertainty introduced by weighing will be automatically output: =0.02333. The corresponding data information will be transmitted to report template 2.

[0033] (4) Uncertainty module introduced by the pretreatment process (calculation template): Input the relevant data information of the utensils used in Table 1 into this module, including the use of 2 (equivalent to 2 times) 50 mL and 5 (equivalent to 5 times) 10 mL single-marked volumetric flasks, 5 mL marked pipettes used 3 times, 1 mL pipettes used 2 times, 0.5 mL graduated pipettes used once, and the capacity relative error, measurement repeatability, capacity deviation, etc. given in the calibration certificate, and automatically output the relative uncertainty introduced by the pretreatment process: =0.00610. The corresponding data information will be transmitted to report templates 2 to 4.

[0034] (5) Uncertainty module introduced by sample measurement (calculation template): Input the data information such as the measuring instrument number, instrument name, instrument quantitative repeatability error given in the calibration certificate and sample parallel measurement results in Table 1 into this module, and automatically output the relative uncertainty introduced by the instrument measurement: =0.01130. The corresponding information data will be transmitted to report template 4.

[0035] (6) Uncertainty component module introduced by standard curve calculation (calculation template): Input the sample parallel measurement concentration results in Table 1 and the standard series concentrations in Table 2 into this module, and automatically output the intercept a=-3405, slope b=27612, and linear correlation coefficient of the linear equation. R =0.99996, number of marking points n =5, relative uncertainty of intermediate data and the relative uncertainty of the calibration calculation =0.06983. The corresponding information data will be transmitted to report template 5.

[0036] (7) Module for displaying measurement results (calculation template): This module does not require input operations. The sample measurement results in the uncertainty module introduced by the previous sample measurement are c =0.208 mg / kg and the corresponding measurement units will be transmitted to this module, which will automatically output the combined standard uncertainty based on the uncertainty component results output by the previous modules. u =0.0155 mg / kg, expanded uncertainty U =0.031 mg / kg( k =2), and finally the measurement result with uncertainty evaluation result is expressed as c ± U That is, 0.21±0.03 mg / kg (according to the requirements of the standard, the result is retained to 2 significant figures). The corresponding information data will be transmitted to report template 5.

[0037] (8) Uncertainty component contribution diagram module (calculation template): The data processed by the previous modules will be automatically transferred to this module. According to the proportion of each component, the uncertainty component contribution diagram is automatically drawn. The proportion of each component uncertainty can be intuitively seen from the diagram.

[0038] (9) Preparation and printing of evaluation reports: After the calculation template completes the data information input operation, the corresponding result data will be automatically transferred to the five report templates. The data format in the report template, such as font, valid figures, etc., can be set as needed, and the report template can be printed to complete a five-page continuous, complete and scientific uncertainty evaluation report on the measurement results of the analytical instrument.

Claims

1. A WPS template for rapid assessment of uncertainty reports of analytical instrument measurement results, characterized by: Six templates were designed, including one intelligent calculation template and five report templates. The calculation template also designed modules such as experimental information, uncertainty assessment calculation, expression of measurement results, and contribution diagram of each component of uncertainty. The experimental information module is used to input basic information of the experiment, including experimental temperature, humidity, detection method, sample name, detection item, and experimental principle. The uncertainty assessment calculation module is composed of modules such as standard value introduction, weighing introduction, pretreatment process introduction, sample measurement introduction, and uncertainty introduced by calibration curve calculation, which are used for data processing of corresponding uncertainty components. The uncertainty introduction module of the pretreatment process is composed of modules such as pipette introduction, single-line pipette introduction, graduated pipette introduction, and uncertainty introduced by constant volume, which are used for data processing of corresponding uncertainty components. The uncertainty introduction module of sample measurement is composed of modules such as instrument measurement error introduction and repeated measurement introduction, which are used for data processing of corresponding uncertainty components. The measurement result representation module is used to display the final measurement results with uncertainty assessment results. The contribution diagram of each component of uncertainty is used to intuitively display the bar chart of the uncertainty proportion of each component. The five report templates designed are equivalent to five pages of a complete uncertainty assessment report, and each report template is designed in A4 size for easy printing and output. The purpose of designing calculation templates and report templates is to enable the calculation template to realize data input and processing functions, and the report template to realize the output and printing functions of the uncertainty assessment report. When using the built-in functions of WPS for program design, users only need to input relevant experimental data information, and the calculation template will automatically process the data. The calculation results will be automatically transmitted to the corresponding five report templates, so as to automatically complete a complete uncertainty assessment report on the measurement results of the analytical instrument. All input operations are performed in the calculation template, and the report template only needs to set the data format as required to print and output. The present invention is suitable for the evaluation of the uncertainty of measurement results of analytical instruments such as chromatography, spectroscopy, and mass spectrometry in testing laboratories; The specific steps are as follows: (1) Experimental information module of the calculation template: input basic experimental information such as experimental temperature, humidity, test method, sample name, test items and experimental principle; (2) Uncertainty module introduced by the standard value calculation template: Input the standard number, name, purity or concentration given in the standard value certificate and expanded uncertainty, and automatically calculate the standard uncertainty and relative uncertainty introduced by the standard value; (3) Module for calculating the uncertainty introduced by weighing in the calculation template: Input the name of the standard or sample to be weighed, and use the number of the analytical balance and the expanded uncertainty of the eccentric load error, repeatability error and indication error given in the calibration certificate, the sample weight, the number of weighings, etc. to automatically calculate the relative uncertainty introduced by weighing; (4) Uncertainty module introduced in the pre-processing process of the calculation template: including four modules: pipette introduction, single-line pipette introduction, graduated pipette introduction, and fixed volume introduction. Input the number of the vessel used in the experiment, the maximum range, the number of times used, the relative error or capacity deviation given in the calibration certificate, and the measurement repeatability error, automatically calculate the relative uncertainty introduced by each vessel, and finally combine them into the relative uncertainty introduced in the pre-processing process; (5) Calculation template for the uncertainty module introduced by sample measurement: including the uncertainty module introduced by instrument measurement error and repeated measurement. Input the instrument number, instrument name, instrument quantitative repeatability and linear error given in the calibration certificate, and automatically calculate the standard uncertainty and relative uncertainty introduced by the instrument measurement error; input the sample parallel measurement results, and automatically calculate the measurement average, measurement standard deviation, standard uncertainty and relative uncertainty introduced by parallel measurement; finally, synthesize them into the relative uncertainty introduced by sample measurement; (6) Uncertainty module introduced by calculation of standard curve of calculation template: input the concentration of standard curve and the corresponding instrument response intensity, measure the concentration of sample in parallel, and automatically calculate the intercept, slope and linear correlation coefficient of linear equation R、 Average concentration of standard curve , mark points n、 The average concentration of the sample and the intermediate data of the calibration curve calculation, etc., finally get the relative uncertainty introduced by the calibration curve calculation; (7) Module for displaying the measurement results of the calculation template: Automatically calculate the combined standard uncertainty based on the results of the previous uncertainty components u , expanded uncertainty U Finally, the measurement result with uncertainty evaluation result is obtained, which is expressed as c ± U； (8) Module for calculating the contribution diagram of each component of uncertainty in the calculation template: SD (standard product), M (weighing), V (pretreatment process), YQ (instrument measurement), and BQ (standard curve) respectively represent the uncertainty of each component introduced by the standard product value, weighing, pretreatment process, sample measurement, and standard curve calculation. This module does not require data processing design, and automatically references the corresponding calculation results. The design uses the WPS drawing function to automatically draw the contribution diagram of each component and intuitively display the bar chart of the proportion of each uncertainty component; (9) Five report templates: Through program design, after the experimental data is input into the calculation template, the calculation template will automatically process the data and transfer the data results to the corresponding five report templates to automatically generate an uncertainty assessment report. The data can be formatted and printed out as required to complete a 5-page uncertainty assessment report.

2. The WPS template for rapidly evaluating the uncertainty report of the measurement results of analytical instruments according to claim 1 is characterized in that: (1) The experimental temperature and humidity, sample name, test item, test method and experimental principle and other data information need to be entered into the experimental information module.

3. The WPS template for rapidly evaluating the uncertainty report of the measurement results of analytical instruments according to claim 1 is characterized in that: The data information such as the standard sample number, purity or concentration of the standard sample and the expanded uncertainty mentioned in (2) needs to be input into the uncertainty module introduced by the standard sample value. The data processing program design of this module involves the use of the function IFERROR.

4. The WPS template for rapidly evaluating the uncertainty report of the measurement results of analytical instruments according to claim 1 is characterized in that: The analytical balance number mentioned in (3), the eccentric load error, repeatability error, expanded uncertainty of indication error and other data information of the analytical balance need to be input into the uncertainty module introduced by weighing. The data processing program design of this module involves the use of functions IFERROR, SUMSQ and SQRT.

5. The WPS template for rapid evaluation of uncertainty report of analytical instrument measurement results according to claim 1 is characterized in that: The data information such as the relative error of capacity, capacity deviation, repeatability error, etc. of the vessels used in the pre-treatment process described in (4) needs to be input into the uncertainty module introduced in the pre-treatment process. The data processing program design of this module involves the use of functions ABS, SUMSQ, and SQRT.

6. The WPS template for rapid evaluation of uncertainty report of analytical instrument measurement results according to claim 1 is characterized in that: The data information such as the instrument number, instrument name, sample parallel measurement results, instrument quantitative repeatability and linear error mentioned in (5) need to be input into the uncertainty module introduced by the sample measurement. The data processing program design of this module involves the use of functions AVERAGE, STDEV, SQRT, SUMSQ, and IFERROR.

7. The WPS template for rapidly evaluating the uncertainty report of the measurement results of analytical instruments according to claim 1 is characterized in that: The data information such as standard concentration, response intensity / peak area and sample parallel measurement concentration described in (6) needs to be input into the uncertainty module introduced in the standard curve calculation. The data processing program design of this module involves the use of functions IFERROR, INDEX, LINEST, CORREL, AVERAGE, COUNT, POWER, SUM, and SQRT.

8. The WPS template for rapid evaluation of uncertainty report of analytical instrument measurement results according to claim 1 is characterized in that: The programming of the representation of the measurement results described in (7) involves the use of functions SQRT and SUMSQ.

9. The WPS template for rapidly evaluating the uncertainty report of the measurement results of analytical instruments according to claim 1, characterized in that: The contribution diagram of each uncertainty component described in (8) is implemented using the WPS drawing tool, and the program design involves the use of the SUM function.

10. The WPS template for rapid evaluation of uncertainty report of analytical instrument measurement results according to claim 1, characterized in that: The data information in the calculation template described in (9) will be automatically transferred to the corresponding five report templates to generate an uncertainty assessment report. The program design involves the use of the INDEX function.

Images