Time-Sensitive Value Calculator

Publication Type


Date Published




The Time-Sensitive Value Calculator (Calculator) is a publicly available, free, Excel-based tool by Berkeley Lab that estimates the value of energy efficiency and other distributed energy resource (DER) measures using hourly estimates of electricity system costs. The Calculator takes hourly profiles of up to six measures at a time and monetizes their value for six value streams, producing outputs in tabular and graphical formats. The Calculator was designed for public utility commissions, state energy offices, utilities and stakeholders to estimate the value of energy efficiency and DER measures under various future electricity system scenarios.

To access the Calculator, enter your name and email address in the form below. A zip file with four files will be available for download upon completion. In addition to the Calculator, the zip file contains an Auxiliary spreadsheet and two file launchers, one for Windows and one for Mac. To minimize run time, the launchers set Excel's calculations to "manual" before opening the Calculator. Please enable macros for the best user experience. 

Year of Publication



Research Areas

Related Files