PRRIP Governance Committee Meeting and Materials

Home Browse Search

eye on the total reregulation space being utilized in column 23). The worksheet currently does not simulate a situation where EA inflow is being primarily re-regulated into Johnson Lake while a smaller • volume is simultaneously flowing out the J-2 return. Although the formula in column 22 (EA reregulation volume) accounts for that potential situation, the formula in column 25, discussed next, forces the condition of re-regulating all EA inflow into .Iohnson Lake and setting EA outflow to zero if the reregulation flag=0. This general rule can be over-ridden as described in the notes for column 25. Column 25 is the EA J-2 outflow in cfs, and is computed as follows: If the flag in column 24 is set to re- regulate EA inflow (flag=0), then the EA J-2 outflow is zero. If the flag in column 24 indicates to pulse the EA out of J-2 (e.g. co124=1), then the EA J-2 outflow in cfs is the smaller of: a) the EA volume available in Johnson (co122, previous day) converted to cfs plus the EA inflow occurring that day (co121), or b) the remaining space available at J-2, which is determined as the J-2 capacity (cell B40) minus the "hydrocycling" cfs outflow (co120). In the worksheet, the rate of cfs available from the hydrocycling operations fills the J-2 canal first, and is then topped off with the EA water cfs rate available, up to the J-2 capacity. To " ane-tune " the EA pulse with flow arriving at Overton, and/or onCy partially re-regulating the hydrocycling andlor EA inflow, the above general formulas for re-regulating all hydrocycling inflow and EA inflow and having zero J-2 Return outflow may be over-ridden by entering the desired amount of J-2 cfs outflow from both, or either, source in columns 20 & 25, respectively. In this case, it does not matter whether the appropriate flag in column 19 and/or column 24 is set to "1 ". When you are satisfied with an example scenario, especially after having specified EA Bypasses and .Iohnson Lake operations (i. e., replacing formulas with specific values), it is best to save the worksheet with a different name, rather than over-writing the basic worksheet and its formulas. ? Column 26: Total J-2 cfs outflow is the sum of the hydrocycling J-2 outflow (co120) plus the EA J-2 outflow (co125). The J-2 canal capacity check has been previously considered. PLATTE RIVER AT OVERTON Column 27: These are the estimated gains from North Platte/CNPPID Diversion dam to the Overton gage. These cells should be adjusted using the anticipated gains prior to and during the EA pulse. The values shown in the example illustrate that gains are anticipated to decrease while EA flows rise and crest. Column 28: The total flow which bypassed the CNPPID diversion (col 14) arrives 2 days later at Overton. The flow is multiplied by a factor to represent higher initial losses which diminish over time as EA releases down the mainstem Platte River continue. The first factor (day 11) is 0.5, and subsequent days are: 0.6 0.7 0.75 0.8 0.85 and 0.90. These factors should be adjusted as necessary, based on the timing of any EA bypass, experience, and application of USBR's unsteady flow and bank-storage model. Column 29: The total flow at Overton is the sum of the total J-2 outflow (co126), plus the North Platte to Overton gains (co127), plus the flow passing the CNPPID diversion described previously (co128). Note in the example that the actual instantaneous peak flow at Overton is dependant on matching the J-2 outflow with the peak at Overton, and if the last day of J-2 outflow is less than capacity, then the actual instantaneous peak at Overton would be higher than the daily average shown. E Water Year 2008 EA AOP 41 October 15, 2007