1 HDD and CDD Reading

Please read the linked notes on heating and cooling degree days and answer the following questions.

  • How are heating degree days related to q = UA \Delta T?
  • Why do you think HDD or CDD will be more important for energy use in the coming years?

2 Estimate degree days from temperature plot

Description:

We will estimate the quantity of degree-days from a plot of temperature data. This graph shows the outside temperature over a period of 24 hours. Assume a thermostat temperature of 15 degrees celsius.

Instructions:

  • Shade the area representing the heating degree days. This is the time that a heater would be running.
  • Explain your choice of area.
  • Estimate the number of heating degree days in units of Celsius-days from your area in the data shown below.
Exterior Temperature Time Series. Source: Generated by author.

3 Estimate energy use from temperature plot

Description:

Simple estimate of energy use given degree-days from plot A home with a UA value of 150 W/K sees the outside temperature in the plot above. Assume a thermostat setting of 15C.

Instructions:

  • Describe your method to estimate the energy use of the home.
  • Compute your estimate of the energy use in units of joules.

4 Spreadsheet Logic Video

Please watch the linked video on using logic in spreadsheets and answer the following classes.

  • Can you provide an example of where an “if” would be useful for an energy calculation?
  • Can you provide an example of where an “and” would be useful for an energy calculation?

5 Estimate Degree Days using spreadsheet

Spreadsheet estimate of degree days using meteorological data (TMY or NOAA)

Description:

Find the heating and cooling degree days for a site over the course of a year.

In this exercise, we will:

  • Identify and download data set
  • Compute hourly temperature differences for the year by subtracting outside temperature from desired indoor temperature
  • Sum only positive numbers for heating degree days using spreadsheet logic
  • Convert sum to degree-day units

Instructions:

  • Find a source for meteorological data. This could be a TMY (Typical meteorological year) file or historical data from NOAA.
  • Download a year of data from the file to your local computer.
  • Open the file in a spreadsheet.
  • Identify the column with the outside temperature.
  • Decide on the internal temperature.
  • Determine the time between data points in the data set. (Usually one hour.)
  • Discuss how to structure the data to perform a sum over the year.
  • Discuss the units of the temperature differences, are they temperature or temperature-time? How do you ensure they are temperature-time?
  • Discuss how to use the if-then statement.
  • Discuss how to structure the subtraction and if-then to get heating or cooling values.
  • Implement the subtraction in a separate column
  • Implement the if-then result in a separate column
  • Perform the sum.
  • Convert the units of the sum to degree days.
  • Comment on the readability of your spreadsheet.
  • Does your answer agree with the totals published online?

6 Manually estimate degree-day slope over time

Description:

In this exercise, you will determine the rate at which degree days are changing in an area or community you are interested in.

Instructions:

  • Navigate to the Cal-Adapt site, choose degree-days, and a region
  • Interpret the graph axes
  • What are the dimensions and units of the slope?
  • What is the sign of the CDD slope and the HDD slope?
  • Discuss the implications of these slopes for energy use of buildings in the area.
  • Visualize an average or fit line through the data.
  • Estimate the slope from now until 2050 by estimating the rise and run in the data.
  • Estimate the change in energy use for a building in the area you chose for heating and cooling.

7 Use Spreadsheet to find slope of degree-day projections

Description:

You will use a spreadsheet to compute the line that best fits the degree day projection data provided by Cal-Adapt.

Instructions:

  • Navigate to the Cal-Adapt site, choose degree-days, and a region
  • Interpret the graph axes
  • What are the units of the slope?
  • What is the sign of the CDD slope and the HDD slope?
  • Download the Cal-Adapt degree-day projections onto your computer.
  • Load the data into a spreadsheet
  • Discuss structure of data in spreadsheet (different models)
  • Create spreadsheet plot of data
  • Discuss which forecasts models you will use (or you could make a slope for each model)
  • Review the columns and choose the a column to calculate the slope for
  • Read documentation for slope(y_values, x_values) and intercept(y_values, x_values) functions
  • Discuss the units of the slope
  • Compare your computed slope to your estimate in the previous activity
  • Create a column for the linear prediction y = mx + b where m is from slope function and b is from the intercept function
  • Verify on a plot that the linear prediction follows the data
  • Discuss the implications of the values of these slopes

8 Energy use projections

Estimate of energy use increases from Cal-Adapt data

Description:

You will use the degree-day projections from Cal-Adapt to determine the energy use increases for an area or community you are interested in.

Instructions:

  • Choose an area and determine the rates of change of the HDD and CDD over time
  • Describe the heating and cooling technologies in a real or hypothetical building in your chosen area
  • Will the energy for heating increase or decrease?
  • Will the energy for cooling increase or decrease?
  • Will natural gas increase or decrease? Why?
  • Will electricity use increase or decrease? Why?
  • Estimate the rate of change in natural gas use each year
  • Estimate the rate of change in electricity use each year