Study of Cubic Splines and Fourier Series as Interpolation Techniques for Filling in Short Periods of Missing Building Energy Use and Weather Data Conference Paper uri icon


  • A study of cubic splines and Fourier series as interpolation techniques for filling in missing data in energy and meteorological time series is presented. The followed procedure created artificially missing points (pseudo-gaps) in measured data sets and was based on the local behavior of the data set around those pseudo-gaps. Five variants of the cubic spline technique and 12 variants of Fourier series were tested and compared with linear interpolation, for filling in gaps of 1 to 6 hours of data in 20 samples of energy use and weather data. Each of the samples is at least one year in length. The analysis showed that linear interpolation is superior to the spline and Fourier series techniques for filling in 16 hour gaps in time series dry bulb and dew point temperature data. For filling 16 hour gaps in building cooling and heating use, the Fourier series approach with 24 data points before and after each gap and six constants was found to be the most suitable. In cases where there are insufficient data points for the application of this approach, simple linear interpolation is recommended.

name of conference

  • Solar Energy

published proceedings

  • Solar Energy

author list (cited authors)

  • Baltazar, J., & Claridge, D. E.

citation count

  • 1

complete list of authors

  • Baltazar, Juan-Carlos||Claridge, David E

publication date

  • January 2002