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 Bonneville Daily end include logos literal

Bonneville Dam & Lake on Columbia River

%B %Y

end define gen BON.Power.Total.~1Day.1Day.CBT-RAW define genavg gen / 24 define sserv BON.Power-StationService.Total.~1Day.1Day.CBT-RAW define inflow BON.Flow-In.Ave.~1Day.1Day.CBT-REV define outflow BON.Flow-Out.Ave.~1Day.1Day.CBT-REV define genflow BON.Flow-Gen.Ave.~1Day.1Day.CBT-REV define spill BON.Flow-Spill.Ave.~1Day.1Day.CBT-REV define midnight BON-PH1.Elev-Forebay.Inst.1Hour.0.CBT-REV define forebay BON-PH1.Elev-Forebay.Ave.~1Day.1Day.CBT-REV define tailwater BON-PH1.Elev-Tailwater.Ave.~1Day.1Day.CBT-REV define head forebay - tailwater define avg_tw BON.Elev-Tailwater.Ave.~1Day.1Day.CBT-REV define ph2_power BON-PH2.Power.Total.~1Day.1Day.CBT-REV define ph2_flow BON-PH2.Flow-Out.Ave.~1Day.1Day.CBT-RAW 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 avg_tw 'Project Average Tailwater' %9.2f AVG/MAX/MIN column ph2_power '2nd Powerhouse Total MWh' %6.0f AVG/MAX/MIN column ph2_flow '2nd Powerhouse Flow kcfs' %8.2f AVG/MAX/MIN report stats line tot:TOT avg:AVG line max:MAX min:MIN literal

end include footer literal end