ExcelFlux
← Solar operations

Facility Energy Budget and Peak Load Scenario

Compare peak consumption, extra charges and modelled load shifting across facilities.

Premium workbook preview · Member downloads are not yet available

Results from the sample workbook

Total consumption (kWh)
107,520
Total cost
368,676
Load shifting impact
12,171.6

Who can use it, and for what?

Energy managers, production and facilities operations

Compare facilities against budget and identify where shiftable load has the most impact.

A worked example from the workbook

K-001 uses 107,520 kWh with a total cost of 368,676. Under the sample load shifting assumption, the impact is 12,171.60.

Worksheet from the completed Excel sample
View from the Excel workbook. Open the image to enlarge it.
MeasureSample result
Total consumption (kWh)107,520
Total cost368,676
Load shifting impact12,171.6

How do you start with your own data?

  1. Set daytime, peak and off-peak unit rates and the energy budget by facility.
  2. Split consumption by tariff window and post extra charges on the relevant date.
  3. Set the report start, end and scenario on Ayarlar. Both boundary dates are included.
  4. Review per-record calculations on Analiz and totals and selected cards such as K-001 on Panel. Resolve unmatched codes, missing dates and duplicate records on Kontrol.

Test a different scenario

Raise the shifting share in Ayarlar B9 from 15% to 20%. The base cost holds at 368,676 while the shift effect grows from 12,171.60 to 16,228.80. Keep K-001 selected on Panel and compare the result. Restore the original input when you finish.

Hücre adresleri ve formüller için Türkçe kılavuzu aç