model overview two independent models –recurrence analysis model defines setpoint conditions for...
TRANSCRIPT
![Page 1: Model Overview Two independent models –Recurrence analysis model Defines setpoint conditions for pH and temperature Provides input to reach model –Mass](https://reader035.vdocuments.us/reader035/viewer/2022070404/56649f345503460f94c51ca9/html5/thumbnails/1.jpg)
Model Overview
• Two independent models– Recurrence analysis model
• Defines setpoint conditions for pH and temperature
• Provides input to reach model
– Mass balance reach model• Defines downstream trajectory of ammonia standard
• Defines downstream trajectory of ammonia concentration
• Provides mechanism for setting permit limits such that the instream concentration will not exceed the standard at any point downstream
![Page 2: Model Overview Two independent models –Recurrence analysis model Defines setpoint conditions for pH and temperature Provides input to reach model –Mass](https://reader035.vdocuments.us/reader035/viewer/2022070404/56649f345503460f94c51ca9/html5/thumbnails/2.jpg)
Recurrence Model Organization
• Tasks are segregated onto 10 separate pages
• Some pages do not require attention– In simplest case, entries are needed on 3 pages
• “Controls”
• “Raw Data”
• “Chronic”
• sometimes also “Select pHT”
– Output is on one page
open “Test Recur Model.xls” now
![Page 3: Model Overview Two independent models –Recurrence analysis model Defines setpoint conditions for pH and temperature Provides input to reach model –Mass](https://reader035.vdocuments.us/reader035/viewer/2022070404/56649f345503460f94c51ca9/html5/thumbnails/3.jpg)
ControlsA m m o n i a T o x i c i t y M o d e l ( A M M T O X )C o n t r o l P a n e l
p H a n d t e m p e r a t u r ec h a r a c t e r i s t i c s i n u s e
C h a r a c t e r i s t i c s o f t h e d a t a s e t M o n t h p H T e m p ( ° C ) p H T e m p ( ° C )S i t e N a m e : Y o u r S i t e S t a r t D a t e 2 1 - J a n - 9 3 J a n 0 . 2 0 1 . 0 1 4 : 0 0 1 7 : 0 0S a l m o n i d s p r e s e n t ? Y E n t e r Y o r N E n d D a t e 0 9 - A p r - 0 2 F e b 0 . 2 0 2 . 0 1 4 : 0 0 1 7 : 0 0
P e r i o d o f R e c o r d 9 . 2 1 y e a r s M a r 0 . 2 0 4 . 0 1 5 : 0 0 1 7 : 0 0A m p l i t u d e s a n d T i m e s o f M a x i m a # R e c o r d s 9 1 A p r 0 . 2 0 4 . 0 1 5 : 0 0 1 7 : 0 0p H a m p l i t u d e M E n t e r H , M , L , o r U s e r M e d i a n I n t e r v a l 3 7 . 4 d a y s M a y 0 . 3 0 4 . 0 1 6 : 0 0 1 7 : 0 0T i m e o f p H m a x D e f a u l t E n t e r D e f a u l t o r U s e r # I n t e r v a l s > 3 0 d 4 6 J u n 0 . 3 0 4 . 0 1 6 : 0 0 1 7 : 0 0T e m p e r a t u r e a m p l i t u d e D e f a u l t E n t e r D e f a u l t o r U s e r J u l 0 . 3 0 4 . 0 1 6 : 0 0 1 7 : 0 0T i m e o f t e m p e r a t u r e m a x D e f a u l t E n t e r D e f a u l t o r U s e r A u g 0 . 3 0 4 . 0 1 6 : 0 0 1 7 : 0 0
S e p 0 . 3 0 4 . 0 1 6 : 0 0 1 7 : 0 0C o n s t a n t s ( e d i t n u m e r i c a l v a l u e s o n " C o n s t a n t s " p a g e ) O c t 0 . 3 0 2 . 0 1 5 : 0 0 1 7 : 0 0F A V 1 1 . 2 3 d e p e n d s o n " S a l m o n i d s p r e s e n t ? " N o v 0 . 2 0 2 . 0 1 5 : 0 0 1 7 : 0 0R ( a c u t e ) 0 . 0 0 7 0 4 D e c 0 . 2 0 1 . 0 1 4 : 0 0 1 7 : 0 0R ( c h r o n i c ) 0 . 0 2 3 2p H T ( a c u t e ) 7 . 2 0 4
p H T ( c h r o n i c ) 7 . 6 8 8 M o d e l I n i t i a t i o n C o n t r o l s M o d e l R e s e t C o n t r o l s
M o n t h P r e s e n t ? ( Y / N )J a n u a r y NF e b r u a r y NM a r c h NA p r i l NM a y NJ u n e NJ u l y NA u g u s t NS e p t e m b e r NO c t o b e r NN o v e m b e r ND e c e m b e r N
E a r l y L i f e S t a g e s P r e s e n t ?
U s e r - s u p p l i e d I n f o r m a t i o nA m p l i t u d e T i m e o f M a x
1 . R a w D a t a P r e p a r a t i o n
3 . A c u t e / C h r o n i c C a lc u la t i o n s3 . A c u t e / C h r o n i c C a lc u la t i o n s
2 . A c c e p t D a t a S e t
C l e a r R a w D a t a
R e s e t C a l c u l a t i o n s
![Page 4: Model Overview Two independent models –Recurrence analysis model Defines setpoint conditions for pH and temperature Provides input to reach model –Mass](https://reader035.vdocuments.us/reader035/viewer/2022070404/56649f345503460f94c51ca9/html5/thumbnails/4.jpg)
Constants (you are unlikely to change)Set Constant Values on this sheet
Salmonids Present 11.23 fish GMCV (no ELS) = 8.78Salmonids Absent 16.80 fish GMCV (with ELS) = 2.85
invertebrate GMCV = 1.45slope = 0.028reference temperature = 25
R = 0.00704 acute low temperature cutoff = 70.0232 chronic adjustment factor = 0.854
pHT = 7.204 acute7.688 chronic
B = 6.95 acute2.91 chronic
Temperature Component of Standard
B (calculated from pHT and R)
FAV
R
pHT
Region VII web page is useful source of info and calculation sheets
![Page 5: Model Overview Two independent models –Recurrence analysis model Defines setpoint conditions for pH and temperature Provides input to reach model –Mass](https://reader035.vdocuments.us/reader035/viewer/2022070404/56649f345503460f94c51ca9/html5/thumbnails/5.jpg)
Select pHT
Time of Time of DailyMonth maximum High Medium Low maximum amplitudeJan 14:00 0.3 0.2 0.2 Not entered Not enteredFeb 14:00 0.3 0.2 0.2 Not entered Not enteredMar 15:00 0.3 0.2 0.2 Not entered Not enteredApr 15:00 0.3 0.2 0.2 Not entered Not enteredMay 16:00 0.5 0.3 0.2 Not entered Not enteredJun 16:00 0.5 0.3 0.2 Not entered Not enteredJul 16:00 0.5 0.3 0.2 Not entered Not enteredAug 16:00 0.5 0.3 0.2 Not entered Not enteredSep 16:00 0.5 0.3 0.2 Not entered Not enteredOct 15:00 0.5 0.3 0.2 Not entered Not enteredNov 15:00 0.3 0.2 0.2 Not entered Not enteredDec 14:00 0.3 0.2 0.2 Not entered Not entered
Default pH SelectionsDaily Amplitude (s.u.)
User Supplied Values
Same pattern for temperature, but only one set of default amplitudes
![Page 6: Model Overview Two independent models –Recurrence analysis model Defines setpoint conditions for pH and temperature Provides input to reach model –Mass](https://reader035.vdocuments.us/reader035/viewer/2022070404/56649f345503460f94c51ca9/html5/thumbnails/6.jpg)
Raw DataEarliest Date Min Time Min pH Min Temp Min Interval # Intervals > 30 d Days in P.O.R.
21-Jan-93 10:00 AM 6.65 9 21 46 3366Latest Date Max Time Max pH Max Temp Avg Interval
9-Apr-02 2:05 PM 8.09 22.8 37.4
Date Time pH Temp Interval1/21/1993 11:25 7.25 11.9 212/11/1993 11:30 7.13 11.7 54
4/6/1993 10:45 7.16 13.8 355/11/1993 11:25 6.65 16.3 57
7/7/1993 11:00 7.54 17.5 348/10/1993 11:45 7.71 20.5 29
9/8/1993 11:40 7.71 20.5 3510/13/1993 11:50 7.45 18 21
11/3/1993 10:45 6.81 16.5 3512/8/1993 11:00 6.7 13 28
1/5/1994 11:00 8.09 11 783/24/1994 12:10 7.5 13.7 27
![Page 7: Model Overview Two independent models –Recurrence analysis model Defines setpoint conditions for pH and temperature Provides input to reach model –Mass](https://reader035.vdocuments.us/reader035/viewer/2022070404/56649f345503460f94c51ca9/html5/thumbnails/7.jpg)
Data Screening
• Review data carefully before loading in model (graphs are good)
• Blanks are not acceptable• Judgment is required (check max and min);
nothing is eliminated automatically• pH receives more attention than
temperature– Outliers– Missing values
• Big gaps in time are not desirable
![Page 8: Model Overview Two independent models –Recurrence analysis model Defines setpoint conditions for pH and temperature Provides input to reach model –Mass](https://reader035.vdocuments.us/reader035/viewer/2022070404/56649f345503460f94c51ca9/html5/thumbnails/8.jpg)
Initiate Screening
• Return to Controls page
• Under “Model Initiation Controls”, select button 1. “Raw Data Preparation”
• Will see 10 data errors (list in Appendix A)
• Make changes and compare with max/min table
• There will be three probable outliers (blue)
![Page 9: Model Overview Two independent models –Recurrence analysis model Defines setpoint conditions for pH and temperature Provides input to reach model –Mass](https://reader035.vdocuments.us/reader035/viewer/2022070404/56649f345503460f94c51ca9/html5/thumbnails/9.jpg)
Conclude Screening
• After entries have been completed or revised, return to Controls page
• Under “Model Initiation Controls”, select button 2. “Accept Data Set”
• Continue by pressing button 3. “Acute/Chronic Calculations”
• Wait until macro ends and cursor is on cell Q2 of the “Chronic” page
![Page 10: Model Overview Two independent models –Recurrence analysis model Defines setpoint conditions for pH and temperature Provides input to reach model –Mass](https://reader035.vdocuments.us/reader035/viewer/2022070404/56649f345503460f94c51ca9/html5/thumbnails/10.jpg)
Set Chronic Threshold
• Adjust threshold value until exceedances per year (cell Q4) is <0.33
• Approach to threshold is steep; can’t get very close without going over
• Click on “Accept Threshold” button to conclude this step
• Move to “Setpoint” page to view results
• Setpoints must be transferred manually to the reach model
![Page 11: Model Overview Two independent models –Recurrence analysis model Defines setpoint conditions for pH and temperature Provides input to reach model –Mass](https://reader035.vdocuments.us/reader035/viewer/2022070404/56649f345503460f94c51ca9/html5/thumbnails/11.jpg)
Setpoint
Just Another StreamSetpoint Conditions
January February March April May JuneChronic Median Temp 2.4 4.2 8.8 11.6 14.5 16.2Chronic pH 8.41 8.51 8.49 8.32 8.18 8.04Acute pH 8.76 8.90 8.84 8.68 8.93 8.67
![Page 12: Model Overview Two independent models –Recurrence analysis model Defines setpoint conditions for pH and temperature Provides input to reach model –Mass](https://reader035.vdocuments.us/reader035/viewer/2022070404/56649f345503460f94c51ca9/html5/thumbnails/12.jpg)
Reach Model Organization
• One page controls model operation
• Three pages hold input data
• Separate pages carry out the mass balance calculations for acute and chronic conditions
• User input may be required on every page (look for cells with yellow background)
![Page 13: Model Overview Two independent models –Recurrence analysis model Defines setpoint conditions for pH and temperature Provides input to reach model –Mass](https://reader035.vdocuments.us/reader035/viewer/2022070404/56649f345503460f94c51ca9/html5/thumbnails/13.jpg)
ControlAMMTOXControl Panel
Scenario Definition Entered In UseMonth 7 J uly
ELS Absent
User-supplied Information
Site Name: u-name-itNominal Reach Length, mi 0.1
Salmonids present? (Y or N) Y Salmonids PresentELS present? (Y or N)
J an N ELS AbsentFeb N ELS AbsentMar N ELS AbsentApr N ELS Absent
May N ELS AbsentJ un N ELS AbsentJ ul N ELS Absent
Aug N ELS AbsentSep N ELS AbsentOct N ELS AbsentNov N ELS AbsentDec N ELS Absent
Rebound Rates
Temperature, oC/mi 0.70 DefaultpH, s.u./mi 0.20 Default
Velocity Equation
coefficient a, V=aQb0.30 Default
exponent b, V=aQb0.40 Default
Seepage Conditions
Accrual Rate, cfs/mi 0.0 DefaultAmmonia conc, mg/L 0.0 Default
Ammonia Removal Rate
K3 at 20 oC 6.0 DefaultTemperature Adj Factor 1.080
![Page 14: Model Overview Two independent models –Recurrence analysis model Defines setpoint conditions for pH and temperature Provides input to reach model –Mass](https://reader035.vdocuments.us/reader035/viewer/2022070404/56649f345503460f94c51ca9/html5/thumbnails/14.jpg)
Control (continued)Things you can change, but probably shouldn'tFAV, Salmonids Present 11.23 DefaultFAV, Salmonids Absent 16.80 Default
FAV in use 11.23R, acute 0.00704 DefaultR, chronic 0.02320 DefaultpHT, acute 7.204 DefaultpHT, chronic 7.688 DefaultB, acute 6.946B, chronic 2.913
Fish GMCV (ELS) 2.85 DefaultFish GMCV (no ELS) 8.78 Default
Fish GMCV in use in J uly 8.78invertebrate GMCV 1.45 Defaultinvertebrate slope 0.028 Defaultinvertebrate reference Temp 25 Defaultinvertebrate low temp cutoff 7 DefaultAdjustment Factor 0.854 Default
![Page 15: Model Overview Two independent models –Recurrence analysis model Defines setpoint conditions for pH and temperature Provides input to reach model –Mass](https://reader035.vdocuments.us/reader035/viewer/2022070404/56649f345503460f94c51ca9/html5/thumbnails/15.jpg)
SetpointSetpoint
SITE Offset J AN FEB MAR APR MAY J UN J UL AUG SEP OCT NOV DECSetpoint 1 1Setpoint 2 2Setpoint 3 3Setpoint 4 4Setpoint 5 5Setpoint 6 6
SetpointSITE Offset J AN FEB MAR APR MAY J UN J UL AUG SEP OCT NOV DECSetpoint 1 1Setpoint 2 2Setpoint 3 3Setpoint 4 4Setpoint 5 5Setpoint 6 6
Chronic Setpoint pH
Acute Setpoint pH
• Abbreviated to facilitate viewing
• Must copy setpoints from recur model (loaded in test model)
• Chronic setpoint temperature is applied to acute conditions solely for purpose of tracking ambient K3
![Page 16: Model Overview Two independent models –Recurrence analysis model Defines setpoint conditions for pH and temperature Provides input to reach model –Mass](https://reader035.vdocuments.us/reader035/viewer/2022070404/56649f345503460f94c51ca9/html5/thumbnails/16.jpg)
ChemCHEMISTRY INPUT DATA SETS
WWTP Source Temperature, °CSITE Number Offset J AN FEB MAR APR MAY J UN J UL AUG SEP OCT NOV DECHeadwater Conditions
Source 1 0 1Source 2 0 2Source 3 0 3Source 4 0 4Source 5 0 5Source 6 0 6Source 7 0 7Source 8 0 8Source 9 0 9Source 10 0 10Source 11 0 11
• Similar blocks for pH and total ammonia
• Dimensioned for up to 30 source entries
• Already loaded in test model
![Page 17: Model Overview Two independent models –Recurrence analysis model Defines setpoint conditions for pH and temperature Provides input to reach model –Mass](https://reader035.vdocuments.us/reader035/viewer/2022070404/56649f345503460f94c51ca9/html5/thumbnails/17.jpg)
FlowEffluents must use Design FlowsSee Graphs Below
CHRONIC FLOWS, cfsOffset SITE J AN FEB MAR APR MAY J UN J UL AUG SEP OCT NOV DEC
Headwater
1 Source 12 Source 23 Source 34 Source 45 Source 56 Source 67 Source 78 Source 89 Source 9
10 Source 1011 Source 11
• Same layout as Chem page; up to 30 sources possible; Source names linked to Chem page
• Acute columns not shown• Graphs at bottom• Data already loaded on test model
![Page 18: Model Overview Two independent models –Recurrence analysis model Defines setpoint conditions for pH and temperature Provides input to reach model –Mass](https://reader035.vdocuments.us/reader035/viewer/2022070404/56649f345503460f94c51ca9/html5/thumbnails/18.jpg)
ChronicMod
• AcuteMod page has same layout, but 3 columns hidden (linked to chronic for Reach length, Source and Setpoint offsets
• You must enter offsets
![Page 19: Model Overview Two independent models –Recurrence analysis model Defines setpoint conditions for pH and temperature Provides input to reach model –Mass](https://reader035.vdocuments.us/reader035/viewer/2022070404/56649f345503460f94c51ca9/html5/thumbnails/19.jpg)
Defining Offsets
• In this example, only sources are two WWTPs; define offsets on ChronicMod– Enter “1” in cell D28 (WWTP A)– Enter “2” in cell D159 (WWTP B)
• Setpoint offset must be entered in every reach (row) to which it applies; only one– Enter 1 in Cells D28:D209– Guides rebound at all points downstream of
WWTP A– Use more offsets if more setpoints defined
![Page 20: Model Overview Two independent models –Recurrence analysis model Defines setpoint conditions for pH and temperature Provides input to reach model –Mass](https://reader035.vdocuments.us/reader035/viewer/2022070404/56649f345503460f94c51ca9/html5/thumbnails/20.jpg)
Return to Control Page
• Enter source offsets for WWTPs
• Enter trial values for chronic ammonia (e.g., 20 mg/L in all months
• Define scenario month in cell B5; start with January
• Adjust until standard met; usually good to set both WWTPs equal initially
• Proceed to next month...then Acute
![Page 21: Model Overview Two independent models –Recurrence analysis model Defines setpoint conditions for pH and temperature Provides input to reach model –Mass](https://reader035.vdocuments.us/reader035/viewer/2022070404/56649f345503460f94c51ca9/html5/thumbnails/21.jpg)
Output on Control page
Enter SourceWWTP Offset Here J AN FEB MAR APR MAY J UN J UL AUG SEP OCT NOV DECWWTP A 1 12.5 11.5 10.5 9.5 8.5 7.5 7.5 7.5 8.5 9.5 10.5 11.5WWTP B 2 12.5 11.5 10.5 9.5 8.5 7.5 7.5 7.5 8.5 9.5 10.5 11.5not in usenot in use
CHRONIC TOTAL AMMONIA, mg/L
Chronic conditions
0.0
1.0
2.0
3.0
4.0
5.0
6.0
0 5 10 15 20 25
Distance, mi
Tota
l Am
mo
nia
, mg
/L
Total Chronic Std