DER-CAM Tools

The Investment & Planning DER-CAM uses up to three representative day-types per month to describe hourly energy loads: week-day, weekend-day, and peak-day. This spreadsheet tool was developed to support users in the process of converting loads to the DER-CAM format. It can take data in 15-min, 30-min, and 1-hour time steps as input and process loads to the appropriate format. Week-day and weekend-day loads are obtained by calculating average values, and peak-day loads can be obtained either by filtering the maximum observed loads or a user-specified load percentile. Once data has been processed in this spreadsheet it can be easily be exported to DER-CAM using standard copy-paste procedures.