units Columbia
missing
time_zone US/Pacific
value_format %8.2f
date_format " %e" "Day of Month"
interval 1d
window 1h
midnight 24
database ../../../common/web_service/data/hydro.db
mode html
literal
Grand Coulee Daily
end
include logos
literal
Grand Coulee Dam
%B %Y
end
define gen GCL.Power.Total.~1Day.1Day.CBT-RAW
define genavg gen / 24
define sserv GCL.Power-StationService.Total.~1Day.1Day.CBT-RAW
define inflow GCL.Flow-In.Ave.~1Day.1Day.CBT-REV
define outflow GCL.Flow-Out.Ave.~1Day.1Day.CBT-REV
define genflow GCL.Flow-Gen.Ave.~1Day.1Day.CBT-REV
define spill GCL.Flow-Spill.Ave.~1Day.1Day.CBT-REV
define midnight GCL.Elev-Forebay.Inst.1Hour.0.CBT-REV
define forebay GCL.Elev-Forebay.Ave.~1Day.1Day.CBT-REV
define tailwater GCL.Elev-Tailwater.Ave.~1Day.1Day.CBT-REV
define head forebay - tailwater
define bnk_flow BNK.Flow-Pumping.Ave.~1Day.1Day.CBT-RAW
define bnk_gen BNK-PumpGenerators.Energy.Total.~1Day.1Day.CBT-RAW
define bnk_elev BNK.Elev-Lake.Inst.~1Day.0.CBT-RAW + 1500
column gen 'Total Generation MWh' %6.0f TOT/AVG/MAX/MIN
column genavg 'Average Generation MW' %5.0f AVG
column sserv 'Station Use MWh' %5.0f TOT/AVG
column inflow 'Inflow kcfs' %8.2f AVG/MAX/MIN
column outflow 'Total Outflow kcfs' %7.2f AVG/MAX/MIN
column genflow 'Generation Flow kcfs' %7.2f AVG/MAX/MIN
column spill 'Spill kcfs' %7.2f AVG/MAX/MIN
column midnight 'Midnight Reservoir Elevation' %8.2f AVG/MAX/MIN
column forebay 'Average Forebay Elevation' %8.2f AVG/MAX/MIN
column tailwater 'Average Tailwater Elevation' %8.2f AVG/MAX/MIN
column head 'Average Head feet' %7.2f AVG/MAX/MIN
column bnk_flow 'Banks Lake Pump kcfs' %9.2f AVG/MAX/MIN
column bnk_gen 'Banks Lake Pump MWh' %8.0f AVG/MAX/MIN
column bnk_elev 'Banks Lake Elev' %9.2f AVG/MAX/MIN
report
stats line tot:TOT avg:AVG line max:MAX min:MIN
literal
end
include footer
literal
end