The Application of Excel Macro in the Rapid Processing of Geoanalytical Data;

Excel subroutine is easy to be programmed,its outcome is displaying in Excel table,and its I/O operation of files is laborsaving,so that it can effectively decrease the mistakes in boresome manual operations.

In consideration of the problems in logging interpreting subzone water saturation for reserves calculation, Excel subroutine and functions are used to implement the methods of average calculation of pore volume of water saturation, saturation extreme and water saturation extreme and the extreme of pore volume of water saturation.

Automatic Rounding off of Numeric Values from Environmental Monitoring Data in Microsoft Excel;

Applying Microsoft Excel to Plot Percentile Boxplot for Monitoring Data;

The Dosage Regimen Design of Bolus Intravenous Administration Based on Microsoft Excel;

Describes the design principle and method of the calculation table, of surface air cooler based on excel software.

Several living examples are employed to introduce how to cleverly use Excel software to make a variance(analysis) of the t-test for single sample average,(ANOVA) for single-factor randomized complete block design and(ANOVA) for two-factor randomized complete block design,and find a suitable equation for two variables paired(observations).

This paper introduces the method how to treat the data of physics experiment by using Origin and Excel software,and compares Origin with Excel.