units columbia missing date_format %k Hour value_format %8.2f window 30m midnight 24 interval 1h time_zone US/Pacific database ../../../common/web_service/data/hydro.db mode html text_time start Bonneville Hourly - %A %B %e, %Y end include logos literal

Bonneville Dam

%A %B %e, %Y

New Date:

end define outflow BON.Flow-Out.Ave.1Hour.1Hour.CBT-REV define genflow BON.Flow-Gen.Ave.1Hour.1Hour.CBT-REV define spill BON.Flow-Spill.Ave.1Hour.1Hour.CBT-REV define ph1fb BON-PH1.Elev-Forebay.Inst.1Hour.0.CBT-REV define ph1tw BON-PH1.Elev-Tailwater.Inst.1Hour.0.CBT-REV define ph1head ph1fb - ph1tw define projfb BON.Elev-Forebay.Inst.1Hour.0.CBT-REV define steven STVW.Elev.Inst.1Hour.0.CBT-REV define projtw BON.Elev-Tailwater.Inst.1Hour.0.CBT-REV column outflow 'Total Outflow kcfs' %8.2f AVG/MAX/MIN column genflow 'Generation Flow kcfs' %7.2f AVG/MAX/MIN column spill 'Spill kcfs' %6.2f AVG/MAX/MIN column ph1fb 'PH 1 Forebay Elevation' %8.2f AVG/MAX/MIN column ph1tw 'Tailwater Elevation' %8.2f AVG/MAX/MIN column ph1head 'Average Head' %7.2f AVG/MAX/MIN column projfb 'Project Forebay Elevation' %8.2f AVG/MAX/MIN column steven 'Stevenson Gage Elevation' %8.2f AVG/MAX/MIN column projtw 'Project Tailwater Elevation' %9.2f AVG/MAX/MIN report stats line avg:AVG line max:MAX min:MIN literal

end new_columns # # Values specific to Powerhouse 1 are the project # total minus the values specific to Powerhouse 2. # define genflow_tot BON.Flow-Gen.Ave.1Hour.1Hour.CBT-REV define genflow_ph2 BON-PH2.Flow-Gen.Ave.1Hour.1Hour.CBT-RAW define genflow_ph1 genflow_tot - genflow_ph2 define fb_ph1 BON-PH1.Elev-Forebay.Inst.1Hour.0.CBT-REV define fb BON.Elev-Forebay.Inst.1Hour.0.CBT-REV define gates BON.Count-Gates-Open.Inst.1Hour.0.CBT-RAW define spill BON.Flow-Spill.Ave.1Hour.1Hour.CBT-REV define flow BON.Flow-Out.Ave.1Hour.1Hour.CBT-REV define misc_flow flow - spill - genflow_tot column genflow_ph1 'Generation Flow kcfs' %6.2f AVG/MAX/MIN column fb_ph1 'Forebay Elevation' %8.1f AVG/MAX/MIN column fb 'Forebay Elevation' %10.1f AVG/MAX/MIN column genflow_ph2 'Generation Flow kcfs' %9.2f AVG/MAX/MIN column gates 'Spillway Gates in Use' %9.0f AVG/MAX/MIN column misc_flow 'Miscellaneous Flow kcfs*' %9.1f AVG/MAX/MIN report stats line avg:AVG line max:MAX min:MIN literal
  Powerhouse 1 Powerhouse 2 Project

* Miscellaneous Flow includes fish ladders, PH1 sluiceway, navigation lock, PH2 DSM, UMT, and PH2 corner collector (B2CC). When all routes are in operation (March-August), total Misc Flow will be ~12.4 kcfs. Flow through the B2CC is ~5 kcfs, so fluctuations of +/-5 kcfs at any time of year indicate the B2CC is open/closed.

end include footer literal end