A study of cubic splines and Fourier series as interpolation techniques for filling in missing hourly data in energy and meteorological time series data sets is presented. The procedure developed in this paper is based on the local patterns of the data around the gaps. Artificial gaps, or “pseudogaps,” created by deleting consecutive data points from the measured data sets, were filled using four variants of the cubic spline technique and 12 variants of the Fourier series technique. The accuracy of these techniques was compared to the accuracy of results obtained using linear interpolation to fill the same pseudogaps. The pseudogaps filled were 1–6 data points in length created in 18 year-long sets of hourly energy use and weather data. More than 1000 pseudogaps of each gap length were created in each of the 18 data sets and filled using each of the 17 techniques evaluated. Use of mean bias error as the selection criterion found that linear interpolation is superior to the cubic spline and Fourier series methodologies for filling gaps of dry bulb and dew point temperature time series data. For hourly building cooling and heating use data, the Fourier series approach with 24 data points before and after each gap and six terms was found to be the most suitable; where there are insufficient data points to apply this approach, simple linear interpolation is recommended.

1.
IPMVP
, 2001,
International Performance Measurement & Verification Protocol: Concepts and Options for Determining Energy and Water Savings
,
U.S. Department of Energy
,
Washington, DC
, Vol.
1
, DOE∕GO-102001-1187.
2.
ASHRAE
, 2002,
ASHRAE Guideline 14-2002: Measurement of Energy and Demand Savings
,
American Society of Heating, Refrigerating and Air-Conditioning Engineers
,
Atlanta
.
3.
Sonderegger
,
R. C.
, 2003, “
Automated Building Energy Analysis for Tens of Thousands of Meters
,”
Seminar on Using Monitored Data to Solve Engineering Problems, ASHRAE Semiannual Meeting, Chicago
, January 25–29.
4.
Turner
,
W. D.
, 1990, “
Overview of the LoanSTAR Monitoring Program
,”
7th Symposium on Improving Building Systems in Hot and Humid Climates
, Fort Worth, October, pp.
28
34
.
5.
Haberl
,
J. S.
,
Thamilseran
,
S.
,
Reddy
,
T. A.
,
Claridge
,
D. E.
,
O’Neal
,
D.
, and
Turner
,
W. D.
, 1998, “
Baseline Calculations for Measurement and Verification of Energy and Demand Savings in a Revolving Loan Program in Texas
,”
ASHRAE Trans.
0001-2505,
104
(
2
), pp.
841
858
.
6.
Chen
,
H.
, 1999, “
Rehabilitating Missing Energy Use and Weather Data When Determining Retrofit Energy Savings in Commercial Buildings
,” M.S. thesis, Mechanical Engineering Department, Texas A&M University, College Station.
7.
Hittle
,
D. C.
, and
Pedersen
,
C. O.
, 1981, “
Periodic and Stochastic Behavior of Weather Data
,”
ASHRAE Trans.
0001-2505,
87
(
2
), pp.
173
194
.
8.
Hokoi
,
S.
,
Matsumoto
,
M.
, and
Kagawa
,
M.
, 1990, “
Stochastic Models of Solar Radiation and Outdoor Temperature
,”
ASHRAE Trans.
0001-2505,
87
(
2
) pp.
245
252
.
9.
Hansen
,
J. E.
, and
Driscoll
,
D. M.
, 1977, “
A Mathematical Model for the Generation of Hourly Temperatures
,”
J. Appl. Meteorol.
0021-8952,
16
, pp.
935
948
.
10.
McCutchan
,
M. H.
, 1979, “
Determining the Diurnal Variation of Surface Temperature in Mountainous Terrain
,”
J. Appl. Meteorol.
0021-8952,
5
, pp.
1224
1229
.
11.
Atkinson
,
D.
, and
Lee
,
R. F.
, 1992, “
Procedures for Substituting Values for Missing NWS Meteorological Data for Use in Regulatory Air Quality Models
,” http://www.epa.gov/scram001/surface/missdata.txthttp://www.epa.gov/scram001/surface/missdata.txt
12.
Tang
,
W. Y.
,
Kassim
,
A. H. M.
, and
Abubakar
,
S. H.
, 1996, “
Comparative Studies of Various Missing Data Treatment Methods—The Malaysian Experience
,”
Atmos. Res.
0169-8095,
42
, pp.
247
262
.
13.
Makhuvha
,
T.
,
Pegram
,
G.
,
Sparks
,
R.
, and
Zucchini
,
W.
, 1997, “
Patching Rainfall Data Using Regression Methods: 1. Best Subset Selection, EM, and Pseudo-EM Methods: Theory
,”
J. Hydrol.
0022-1694,
198
, pp.
289
307
.
14.
Bennis
,
S.
,
Berrada
,
F.
, and
Kang
,
N.
, 1997, “
Improving Single-Variable and Multivariable Techniques for Estimating Missing Hydrological Data
,”
J. Hydrol.
0022-1694,
191
, pp.
87
105
.
15.
Colliver
,
D. G.
,
Zhang
,
H.
,
Gates
,
R. S.
, and
Priddy
,
K. T.
, 1995, “
Determination of the 1%, 2.5%, and 5% Occurrences of Extreme Dew-Point Temperatures and Mean Coincident Dry-Bulb Temperatures
,”
ASHRAE Trans.
0001-2505,
101
(
2
), pp.
265
286
.
16.
Chen
,
H.
, and
Claridge
,
D. E.
, 2000, “
Procedures for Filling Short Gaps in Energy Use and Weather Data
,”
12th Symposium on Improving Building Systems in Hot and Humid Climates
, San Antonio, May, pp.
314
326
.
17.
Baltazar-Cervantes
,
J. C.
, 2000, “
Study of Cubic Splines and Fourier Series as Interpolation Techniques for Filling in Short Periods of Missing Building Energy Use and Weather Data
,” M.S. thesis, Mechanical Engineering Department, Texas A&M University, College Station.
18.
Baltazar
,
J. C.
, and
Claridge
,
D. E.
, 2002, “
Restoration of Short Periods of Missing Energy Use and Weather Data Using Cubic Spline and Fourier Series Approaches: Qualitative Analysis
,”
13th Symposium on Improving Building Systems in Hot and Humid Climates
, Houston, May, pp.
214
219
.
You do not currently have access to this content.