Instruction for Using Static Load Profiles
These twenty-six normalized annual load profiles represent all of PG&E's major rate classes. Each load profile is presented in a separate .csv file (Comma Separated Value -- a text file with commas separating the columns of data that is easily read into any text or spreadsheet program). A table listing file names, profiles, and the corresponding rate schedules is provided below.
Format of the .csv files
- Each file represents a separate annual profile. The columns in each file represent time of day, in half-hour intervals. Accordingly, there are 48 columns (two for each hour of the day). The data is presented in half-hour intervals to accommodate non-residential TOU schedules, which split on the half-hour. The time of day refers to the period ending at that time. For example, interval 9:30 PM starts at 9:01 PM and ends at 9:30 PM.
- The rows in each file represent days of the year (currently mapped to 2005).
- The values in the file represent the fraction of annual usage occurring in that interval. The sum of all intervals for the year is normalized to equal 10,000. This constant was used instead of 1 to allow resolution without a large number of significant digits.
- If you have difficulties opening the .csv files in your spreadsheet, please refer to your software documentation.
- If you are using Internet Explorer version 3.01 or lower, use the VIEW-OPTIONS-PROGRAMS-FILE TYPES window in your browser to associate the .csv file with whatever spreadsheet program you normally use.
Example of Load Profile Usage
|Time of day||Half-hour values from worksheet|
|Time of day||Half-hour values from worksheet||MWh for 6 hour period||Adjusted Load Profile|
|12:30pm||0.68815||/ 10.14545 =||0.067828|
|1:00pm||0.70647||/ 10.14545 =||0.069634|
|1:30pm||0.73951||/ 10.14545 =||0.072891|
|2:00pm||0.76178||/ 10.14545 =||0.075086|
|2:30pm||0.79551||/ 10.14545 =||0.078411|
|3:00pm||0.81056||/ 10.14545 =||0.079894|
|3:30pm||0.85190||/ 10.14545 =||0.083969|
|4:00pm||0.89371||/ 10.14545 =||0.088090|
|4:30pm||0.93830||/ 10.14545 =||0.092485|
|5:00pm||0.96099||/ 10.14545 =||0.094721|
|5:30pm||0.98426||/ 10.14545 =||0.097015|
|6:00pm||1.01431||/ 10.14545 =||0.099977|
|Time of day||Adjusted Load Profile||MWh for 6 hour period||Load profiled MWh|
|12:30pm||0.067828||x 10 =||0.67828|
|1:00pm||0.069634||x 10 =||0.69634|
|1:30pm||0.072891||x 10 =||0.72891|
|2:00pm||0.075086||x 10 =||0.75086|
|2:30pm||0.078411||x 10 =||0.78411|
|3:00pm||0.079894||x 10 =||0.79894|
|3:30pm||0.083969||x 10 =||0.83969|
|4:00pm||0.088090||x 10 =||0.88090|
|4:30pm||0.092485||x 10 =||0.92485|
|5:00pm||0.094721||x 10 =||0.94721|
|5:30pm||0.097015||x 10 =||0.97015|
|6:00pm||0.099977||x 10 =||0.99977|
To obtain hourly values, add up the two intervals for that hour. For example, for the hour ending at 2 PM, add the intervals for 1:30 and 2PM: 0.72891 + 0.75086 = 1.47977 MWh.
back to top