Instruction for Using Static Load Profiles

Static Load Profiles For the current years, Agricultural and Street Lighting are the only rate classes that use Static profiles in settlements. All other classes must use Dynamic load profiles. Therefore, you are only able to find Agricultural and Street Lighting Rate Classes 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

To apply a load profile to a given level of consumption for a given period of time, follow these steps:

(1) Add up the half-hourly values for the period in question. For this example, residential class E-7 and the period between noon and 6 PM on August 10, 1998, are used.

Time of day	Half-hour values from worksheet
12:30pm	0.68815
1:00pm	0.70647
1:30pm	0.73951
2:00pm	0.76178
2:30pm	0.79551
3:00pm	0.81056
3:30pm	0.85190
4:00pm	0.89371
4:30pm	0.93830
5:00pm	0.96099
5:30pm	0.98426
6:00pm	1.01431
	10.14545

(2) Divide each interval value by the sum of all intervals. The resulting values are the adjusted load profile for the period in question, and adds up to one for this period.

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
	10.14545		1.000000

(3) Convert consumption for the period into a load profile by multiplying it by each of the adjusted load profile values obtained above. For this example, assume a consumption of 10 MWh for the period in question.

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
	1.000000		10.000000

Note:
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.

The user is refered to PG&E's applicable tariffs for specific information on time-of-use periods for each rate schedule.