Abstract: When oil volume is metered with tank capacity,the interpolation calculation is often used to get corresponding volume data so as to determine the volumetric value of tank.Excel software can be used to realize the automation of interpolation calculation,that is,preparing a calculation table of tank capacity with Excel software,storing the value of tank capacity into the calculation table,thus the corresponding volume data can be obtained only after inputting the data of liquid level,with prompt and accurate characteristics.