NC0024406_Worksheets 003 decanting_20190322

1.7268647327833597
1.7337893355712553
1.7405516042941858
1.7471586486214969
1.7536171382224681
1.7599333370715822
1.7661131345964387
1.7721620739963184
1.7780853780223398
1.7838879724775023
1.7895745076660365
1.7951493779961472
1.8006167399177688
1.8059805283572341
1.8112444717932497
1.8164121061031941
1.8214867872950871
1.8264717032284963
1.8313698844169839
31

32
1
1.0303979964395695
1.0612546370358549
1.0921259099624938
1.1226053000255218
1.1523549642483841
1.1811205162608247
1.2087310150021613
1.2350890127151821
1.260155944433428
1.2839368763340528
1.3064669395024315
1.3278003938356036
1.348002401575999
1.3671431652526114
1.3852939455190758
1.4025244859221302
1.4189014457573408
1.4344875306422911
1.4493410912320677
1.4635160261204174
1.4770618748834468
1.4900240236575792
1.5024439715049727
1.5143596238054176
1.5258055912227502
1.536813481100533
1.5474121736709667
1.5576280790857508
1.5674853736094152
1.5770062147776795
1.586210936205851
1.5951182232327628
1.603745270837988
1.6121079253639843
1.6202208115705026
1.628097446485878
1.6357503414247838
1.643191093431599
1.6504304672933079
1.657478469152539
1.6643444126435694
1.6710369783741605
1.6775642674846736
1.6839338499333067
1.6901528080822932
1.696227776093846
1.7021649755861306
1.7079702479476528
1.7136490836627472
1.7192066489604634
1.7246478100636062
1.7299771552834073
1.735199015177705
1.7403174809662649
1.7453364213754858
1.7502594980658834
1.7550901797790912
1.7598317553265017
1.7644873455286203
1.7690599142027934
1.7735522782867743
32

33
1
1.0287352634510762
1.0578573622563809
1.0869476017336834
1.1156250819169902
1.1435754967211473
1.1705643225541176
1.1964361025719263
1.221104524082339
1.2445383017539651
1.266746629126694
1.2877663437664393
1.3076516488943664
1.3264664291637471
1.3442788101901439
1.3611574903565307
1.3771693914712539
1.3923782492241592
1.4068438503362619
1.4206217007507449
1.4337629716102469
1.4463146169461749
1.4583195912750182
1.4698171195115191
1.4808429883754961
1.4914298398923449
1.501607455258644
1.5114030224223423
1.520841384033925
1.5299452645345051
1.5387354764544479
1.5472311067723457
1.5554496846121149
1.5634073317594392
1.57111889754043
1.5785980795802335
1.5858575318837091
1.5929089615778074
1.5997632155409847
1.6064303580284487
1.6129197402888558
1.6192400630615889
1.6253994327455306
1.6314054119410006
1.6372650649861824
1.642984999037612
1.6485714011805193
1.6540300719983632
1.6593664559810322
1.6645856691072582
1.6696925238981177
1.6746915522044428
1.6795870259610992
1.6843829761147118
1.6890832099083182
1.6936913266860412
1.698210732362939
1.7026446526893511
1.7069961454251676
1.711268111527064
1.7154633054409145
1.719584344581929
33

34
1
1.0271342397057972
1.0545912800455721
1.0819768204486468
1.108934367641202
1.1351718086187832
1.1604731448930512
1.1846971779416853
1.2077676773263597
1.2296597799410289
1.2503861396013263
1.2699848029324106
1.2885095616032094
1.3060227825961153
1.3225903640746464
1.338278359695799
1.353150837705779
1.3672686152256872
1.3806885913437292
1.3934634767026635
1.4056417764946332
1.4172679283036915
1.4283825284252385
1.4390226029374871
1.4492218954137968
1.4590111537552219
1.4684184057004548
1.4774692172294877
1.4861869310910534
1.4945928845898535
1.5027066069369734
1.510545997147372
1.518127483831708
1.5254661683903754
1.5325759531513625
1.5394696559509853
1.5461591125704708
1.55265526833324
1.5589682600510426
1.565107489390146
1.5710816886166252
1.5768989795750543
1.5825669266589211
1.5880925844442644
1.593482540580188
1.5987429544605694
1.6038795921398485
1.6088978579015063
1.6138028228399934
1.6185992507748088
1.6232916217784348
1.6278841535673236
1.6323808209766344
1.6367853737143012
1.641101352568018
1.6453321042193363
1.6494807948020427
1.6535504223269559
1.65754382808206
1.6614637071052323
1.6653126178164717
1.6690929908874665
34

35
1
1.0255908439592207
1.0514475038868287
1.0771991894011332
1.10251267706697
1.1271167969485418
1.1508128420076105
1.1734727499130053
1.1950294156676817
1.2154636249244655
1.2347908949496376
1.2530500407847616
1.27029413220733
1.2865838124475946
1.3019826269367949
1.3165539203451615
1.3303588881315613
1.343455442118999
1.3558976298995267
1.3677354185424415
1.3790147091821208
1.3897774910168357
1.4000620734403344
1.4099033561783791
1.4193331118243553
1.4283802649751796
1.4370711586915845
1.445429803276743
1.453478105110324
1.4612360749944098
1.4687220165076407
1.4759526954582516
1.4829434918326427
1.4897085357591531
1.4962608290165991
1.5026123535600246
1.5087741684417857
1.5147564963940119
1.520568801220495
1.5262198570296865
1.5317178102299438
1.5370702351056733
1.5422841836996197
1.5473662306424172
1.5523225134953165
1.5571587691052711
1.561880366412508
1.5664923360987013
1.5709993974180565
1.5754059825134585
1.5797162584844844
1.5839341474431774
1.5880633447662891
1.5921073357288484
1.5960694106830231
1.5999526789278307
1.6037600813990975
1.6074944022948567
1.6111582797388213
1.6147542155735595
1.6182845843651961
1.6217516416929112
35

36
1
1.0241013748476995
1.0484179890538281
1.0726017164363231
1.0963415330622979
1.1193860475850157
1.1415527046215679
1.1627255487991597
1.1828457291303953
1.2018989807697742
1.2199031493559254
1.2368974272941673
1.2529338907671594
1.2680712824362563
1.2823706912518276
1.2958927039519541
1.3086956343989606
1.3208345090029499
1.3323605637005829
1.3433210752179419
1.3537594023844326
1.3637151527248281
1.3732244178270496
1.3823200407076448
1.3910318918846398
1.3993871399370528
1.4074105083338908
1.4151245142234379
1.4225496873668146
1.4297047689480926
1.4366068909173419
1.4432717370397845
1.4497136870792438
1.4559459456343364
1.4619806571354497
1.4678290084414805
1.4735013203747667
1.4790071294179428
1.4843552606783363
1.4895538931104315
1.4946106178786183
1.4995324906425955
1.5043260784573018
1.5089975018979913
1.513552472948692
1.5179963291282359
1.5223340642714542
1.5265703563334192
1.5307095925409075
1.5347558921769262
1.5387131272505974
1.5425849412752004
1.5463747663514291
1.5500858387302812
1.5537212130101521
1.557283775105327
1.5607762541077381
1.5642012331504165
1.5675611593692245
1.5708583530490383
1.5740950160313116
1.5772732394518552
36

37
1
1.0226624659284984
1.0454954315766365
1.0681726255642667
1.0904042148708941
1.1119575003922229
1.1326650234970363
1.1524219899332495
1.1711770074520087
1.1889201272578052
1.2056710427179851
1.2214689759983968
1.2363647716044068
1.2504151200741602
1.2636785685304279
1.2762129097484223
1.2880735757964046
1.2993127328473502
1.3099788477856871
1.3201165610874044
1.3297667504849757
1.3389667069706757
1.3477503711176111
1.3561485960618331
1.3641894159963748
1.3718983074029121
1.3792984357640687
1.3864108840706431
1.3932548617002778
1.3998478936355785
1.4062059908085554
1.4123438028054311
1.4182747543757541
1.4240111672515663
1.4295643687548572
1.4349447885929107
1.4401620451360666
1.4452250223564396
1.4501419384887673
1.4549204073615141
1.459567493240687
1.4640897599320559
1.4684933148000705
1.472783848283604
1.4769666694192094
1.4810467378212819
1.4850286925144569
1.4889168779661845
1.4927153676257952
1.4964279852399724
1.5000583241826275
1.5036097650092721
1.5070854914215359
1.5104885048060734
1.513821637493334
1.5170875648652269
1.5202888164262653
1.5234277859400616
1.5265067407219119
1.5295278301683473
1.5324930935958645
1.5354044674534018
37

38
1
1.0212710471117934
1.0426731817413204
1.0639012130646845
1.0846855477316877
1.1048111640315701
1.1241247221364004
1.1425317181350874
1.1599874913706418
1.1764858341685553
1.1920478551122169
1.2067124967072811
1.220529163041518
1.2335523628424458
1.2458380318214919
1.2574411436655089
1.2684142555661249
1.2788067028399359
1.288664227924847
1.2980288894985217
1.30693914455446
1.3154300309703566
1.3235334027564352
1.3312781872373038
1.3386906449987721
1.3457946211510454
1.352611781521506
1.359161830648125
1.365462710493321
1.371530780045837
1.3773809767014864
1.3830269606983792
1.3884812440522827
1.3937553054750627
1.3988596927173704
1.4038041136906831
1.4085975176157364
1.4132481673282475
1.4177637037570445
1.4221512034792727
1.4264172301548268
1.4305678805487028
1.434608825765928
1.4385453482487938
1.4423823750197138
1.4461245075945428
1.4497760489397291
1.4533410278015921
1.456823220696529
1.4602261718164151
1.4635532110732556
1.4668074704807281
1.4699918990471825
1.4731092763344076
1.476162224818802
1.4791532211760603
1.4820846065968858
1.4849585962292542
1.4877772878322981
1.4905426697175839
1.4932566280454223
1.4959209535366647
38

39
1
1.0199243114319698
1.0399451697052873
1.0597777239697164
1.0791717225997519
1.0979288719663332
1.1159090430098029
1.1330272191006336
1.1492448051236839
1.1645588117851102
1.1789913730481123
1.1925808759854253
1.2053751012044076
1.2174262649095393
1.2287876353469065
1.2395113512069429
1.2496471075915545
1.2592414416544337
1.2683374173816346
1.2769745660670087
1.2851889832455921
1.2930135152773681
1.3004779917229981
1.307609475479601
1.3144325133405501
1.3209693767455575
1.3272402871221356
1.3332636231854464
1.3390561094150122
1.3446329860427138
1.3500081615231248
1.3551943487860536
1.3602031867062245
1.3650453482412992
1.3697306366360025
1.3742680709985333
1.3786659624457374
1.3829319818982597
1.3870732204934109
1.3910962434761729
1.3950071383297431
1.3988115578171727
1.402514758525149
1.4061216354293813
1.4096367529377902
1.4130643728120709
1.4164084793193337
1.4196728019228244
1.4228608357833181
1.4259758603101336
1.4290209559721936
1.4319990195546313
1.4349127780246667
1.4377648011514363
1.4405575130077937
1.4432932024675147
1.4459740327985415
1.4486020504416646
1.4511791930541906
1.4537072968894558
1.4561881035753994
1.4586232663486716
39

40
1
1.018619686301403
1.0373058412643661
1.0557932455897652
1.0738501409986065
1.0912940728045135
1.1079972783297194
1.1238834864097207
1.1389195563519903
1.1531052411640803
1.1664633482929476
1.1790314633357937
1.1908555828842544
1.2019855364106227
1.212471880274911
1.2223639100582395
1.2317084763899047
1.2405493535321501
1.2489269739072906
1.256878395493116
1.2644374104030902
1.2716347331985483
1.2784982287912414
1.2850531544373789
1.2913224001828709
1.2973267186389648
1.3030849392017885
1.3086141645233442
1.3139299487104688
1.319046457723513
1.3239766130045121
1.3287322196435507
1.3333240804964197
1.3377620976651425
1.3420553626902121
1.3462122367079172
1.3502404217161097
1.3541470239782112
1.3579386104847704
1.3616212592881312
1.3652006044305975
1.3686818761004564
1.3720699365733946
1.3753693124287301
1.3785842234697936
1.3817186087250719
1.384776149860508
1.387760292292967
1.3906742642596102
1.3935210940671259
1.3963036257179193
1.3990245330868938
1.4016863328020222
1.4042913959639818
1.4068419588245096
1.4093401325294534
1.4117879120204808
1.4141871841788949
1.4165397352857829
1.4188472578645868
1.4211113569650222
1.4233335559409988
40

41
1
1.0173548085452884
1.0347501021670247
1.0519396153629452
1.0687092809581951
1.0848916494067009
1.1003705380874058
1.1150777349928269
1.128984992238222
1.1420943708749407
1.1544290337515664
1.1660255452806865
1.1769279773136285
1.187183692764882
1.1968405017051638
1.2059448550864627
1.2145407806433759
1.2226693269901645
1.2303683423670559
1.2376724649163668
1.2446132400051308
1.2512193082119787
1.2575166273321201
1.263528705266058
1.2692768297210049
1.2747802866231523
1.2800565629975487
1.2851215325129368
1.2899896233892154
1.2946739692497891
1.2991865439880002
1.3035382819513099
1.3077391848246172
1.311798416577733
1.3157243877720388
1.3195248304236449
1.3232068645110238
1.326777057104122
1.3302414749849685
1.3336057315300702
1.336875028533784
1.340054193569878
1.3431477134154843
1.3461597639970657
1.3490942372611701
1.3519547653229775
1.3547447422020336
1.3574673434165714
1.3601255436746091
1.3627221328711212
1.365259730575348
1.3677407991703243
1.3701676557875313
1.372542483162819
1.3748673395251134
1.3771441676166303
1.3793748029321022
1.3815609812546943
1.3837043455576599
1.385806452333231
1.3878687774035161
1.3898927212623611
41

42
1
1.0161275026402425
1.032273269657652
1.0482093407983273
1.0637385807269961
1.0787077622042724
1.0930115494065114
1.1065891535933259
1.1194167027877528
1.1314981693991448
1.1428567838033279
1.1535278928986812
1.1635535205316667
1.1729784957932852
1.1818478566984869
1.1902052136245924
1.1980917962213034
1.2055459661700865
1.2126030350820503
1.2192952739724336
1.2256520366948322
1.2316999457565665
1.2374631071578166
1.2429633333278907
1.2482203615396752
1.2532520606327346
1.2580746223814339
1.2627027360488681
1.2671497460117453
1.2714277931246982
1.2755479409152162
1.2795202878953851
1.2833540673313308
1.2870577357826609
1.2906390516489195
1.2941051448614138
1.2974625787511898
1.3007174050161838
1.303875212607658
1.3069411712606056
1.3099200703060987
1.3128163533257526
1.3156341491393846
1.3183772995559782
1.3210493842645261
1.3236537431944551
1.3261934966344111
1.3286715633625179
1.331090677010111
1.3334534008538712
1.3357621412077314
1.3380191595653201
1.3402265836258576
1.3423864173207425
1.3445005499444274
1.3465707644812777
1.3485987452096282
1.3505860846551221
1.3525342899573969
1.3544447887071149
1.3563189343041353
1.3581580108821771
42

43
1
1.0149357616791341
1.0298710301605811
1.0445955296750973
1.0589283375333269
1.0727297129859057
1.0859044823368582
1.0983986901103799
1.1101923638127551
1.1212910243542928
1.1317177088103498
1.141506371037982
1.1506968790341516
1.1593314717870777
1.167452396942946
1.1751004330674946
1.1823140391549392
1.1891289297275982
1.1955779272327782
1.2016909873542421
1.2074953261721881
1.213015602146015
1.2182741226579383
1.2232910562525792
1.2280846392969911
1.2326713707438497
1.237066191855255
1.2412826497288738
1.24533304466829
1.2492285621302337
1.252979390346092
1.2565948248752545
1.2600833613828719
1.2634527778961671
1.2667102077145942
1.2698622040508225
1.2729147973745436
1.2758735463272397
1.278743582977619
1.2815296530966371
1.2842361520488843
1.2868671568236547
1.289426454663914
1.2919175686941102
1.2943437808974978
1.2967081527497846
1.2990135437775985
1.3012626282769533
1.3034579103978465
1.3056017377758935
1.3076963138699229
1.3097437091453108
1.3117458712261973
1.3137046341251564
1.3156217266462491
1.3174987800462739
1.319337335029374
1.3211388481416315
1.3229046976248737
1.3246361887823654
1.3263345589033022
1.328000981787989
43

44
1
1.0137777306652149
1.0275394022018569
1.0410918289752957
1.0542696191423886
1.0669458260625166
1.079034798066977
1.0904888647869135
1.1012915135004764
1.1114494812847784
1.1209853753548431
1.1299315995472101
1.138325771808955
1.1462074943710474
1.1536162126346294
1.1605898860883361
1.16716423260477
1.1733723600377468
1.1792446488411474
1.1848087901451472
1.1900899144759887
1.1951107684104882
1.1998919118177753
1.2044519187490481
1.2088075719423235
1.2129740454030844
1.2169650723854604
1.2207930978775379
1.2244694157613867
1.2280042914245548
1.2314070709124316
1.2346862778403684
1.2378496993028185
1.240904461970703
1.2438570994873652
1.246713612176606
1.2494795199747295
1.2521599093991214
1.2547594752723148
1.2572825578346274
1.2597331758010835
1.2621150558492726
1.2644316589638538
1.2666862040097655
1.2688816888593324
1.2710209093575064
1.2731064763738436
1.2751408311587893
1.2771262591948962
1.2790649027101302
1.2809587720000697
1.282809755688028
1.2846196300367347
1.2863900674117155
1.2881226439848088
1.2898188467560014
1.2914800799628008
1.2931076709385276
1.2947028754740515
1.2962668827314301
1.2978008197526427
1.2993057556019234
44

45
1
1.0126516918040853
1.0252747038160075
1.0376923712832498
1.0497541863366466
1.0613453442469623
1.0723891162233952
1.0828436070756668
1.0926953575080467
1.1019520160257572
1.1106355452420476
1.1187766585637839
1.1264106417823034
1.1335744221603774
1.140304636538733
1.1466364414055947
1.1526028447162748
1.1582343885817843
1.1635590581729536
1.168602329750303
1.1733872989753817
1.1779348508894958
1.182263846957144
1.1863913140335491
1.1903326263719782
1.1941016758413356
1.1977110280960808
1.2011720640281196
1.2044951067742615
1.2076895350818597
1.2107638841011088
1.2137259347752174
1.2165827930042006
1.2193409597063056
1.2220063928197389
1.224584562192897
1.2270804982139187
1.2294988349358926
1.2318438483657026
1.2341194905037993
1.2363294196496846
1.238477027423416
1.2405654628966098
1.2425976541765362
1.2445763277433399
1.2465040258024731
1.2483831218813572
1.2502158348706411
1.2520042416854373
1.253750288700302
1.2554558020928879
1.2571224972148387
1.2587519870942798
1.2603457901618509
1.2619053372814102
1.2634319781571595
1.2649269871806395
1.2663915687738772
1.2678268622786393
1.2692339464362024
1.2706138434971757
1.2719675229966523
45

46
1
1.0115560515155193
1.023073523807591
1.0343917275926662
1.0453744247567265
1.0559183375117682
1.0659550984832078
1.0754481127190245
1.0843865983838303
1.0927788356688029
1.1006459474977415
1.1080168312690393
1.1149243692509425
1.1214027829431403
1.1274858991153258
1.1332060901362182
1.1385936865526007
1.143676705860843
1.1484807840686664
1.1530292311037038
1.1573431569263144
1.1614416336179374
1.1653418714279447
1.1690593953183108
1.1726082141831626
1.176000978559689
1.179249124943907
1.1823630062340158
1.185352008654436
1.1882246559723646
1.1909887020427445
1.1936512127970775
1.1962186387847429
1.1986968793199726
1.2010913392069775
1.2034069789246782
1.2056483590598595
1.207819679688489
1.2099248153221052
1.2119673459608498
1.2139505847272438
1.2158776024949767
1.2177512498743042
1.219574176869566
1.221348850484087
1.2230775705127459
1.224762483732045
1.2264055966711376
1.2280087871243222
1.2295738145456301
1.2311023294488823
1.232595881921539
1.2340559293476838
1.2354838434240627
1.2368809165432662
1.2382483676094693
1.2395873473446337
1.240898943136473
1.2421841834737137
1.2434440420091184
1.2446794412862934
1.245891256162398
46

47
1
1.0104893289310211
1.0209326963376026
1.0311848656323368
1.0411232847927649
1.0506556225361905
1.0597213461812063
1.0682887181498164
1.0763492858120149
1.0839117039864958
1.0909960785559794
1.0976293786279643
1.1038420211292961
1.1096654975219924
1.1151308271445861
1.1202676194706169
1.1251035611426372
1.1296641861814996
1.1339728268592799
1.1380506741255896
1.1419168998925697
1.1455888101377185
1.1490820092436855
1.1524105636832751
1.1555871582066877
1.1586232409344466
1.1615291557984648
1.1643142620166758
1.1669870410123144
1.1695551915837041
1.1720257143173023
1.1744049862963544
1.1766988271418093
1.1789125573644801
1.1810510499287219
1.1831187758410417
1.1851198444897943
1.1870580393788179
1.1889368498208208
1.1907594990865402
1.1925289694433738
1.1942480244620184
1.1959192289212435
1.1975449665985887
1.1991274561978731
1.2006687656323773
1.2021708248547025
1.2036354374001887
1.2050642907898454
1.2064589659205851
1.2078209455548243
1.2091516220078184
1.2104523041192385
1.211724223585154
1.2129685407175803
1.2141863496909198
1.2153786833277633
1.2165465174705299
1.2176907749801884
1.2188123293987034
1.2199120083078123
1.2209905964131929
47

48
1
1.0094501456791718
1.0188492783874019
1.0280671129610759
1.0369942284235545
1.0455486916390986
1.0536773099649424
1.0613527897872896
1.0685686847458584
1.0753337878491487
1.0816670266202633
1.0875933415339685
1.0931406308606424
1.0983376374876455
1.1032125795454981
1.107792326785032
1.1121019561836241
1.116164559279416
1.1200012092650959
1.12363102426529
1.1270712843098045
1.1303375744633086
1.1334439368262781
1.1364030209803684
1.1392262269393583
1.1419238375411638
1.1445051390130199
1.146978529529959
1.1493516162158846
1.1516313013732966
1.1538238588816694
1.1559350017472088
1.1579699417642271
1.1599334421900982
1.1618298642600207
1.1636632082859475
1.1654371500026253
1.1671550727465441
1.1688200959825812
1.1704351006290228
1.1720027515745515
1.1735255177304011
1.1750056899167034
1.1764453968434845
1.1778466194132331
1.1792112035428348
1.180540871677406
1.1818372331466775
1.1831017934956207
1.1843359629045658
1.1855410637998258
1.1867183377434714
1.1878689516801666
1.1889940036096436
1.1900945277452677
1.1911714992120723
1.1922258383314495
1.1932584145342982
1.1942700499397065
1.1952615226320882
1.1962335696660782
1.1971868898252884
48

49
1
1.0084372167907507
1.0168205297210784
1.0250341241977734
1.0329811820717185
1.0405896498288534
1.0478132098569597
1.0546286261859075
1.0610311589614447
1.0670295217206904
1.0726413168260294
1.0778893665172269
1.082799004674851
1.0873962121268788
1.0917064151095781
1.095753768432181
1.0995607741605358
1.1031481220678749
1.1065346700929679
1.1097375084785439
1.1127720700804988
1.1156522626337775
1.1183906078532444
1.1209983783102173
1.1234857269790079
1.1258618068700084
1.1281348797345969
1.1303124137708811
1.1324011707996424
1.1344072836640959
1.1363363247320304
1.1381933664075246
1.13998303453216
1.1417095554981536
1.1433767978240743
1.1449883088675756
1.1465473472744954
1.148056911692992
1.1495197662166081
1.1509384629618653
1.1523153621342166
1.153652649890599
1.1549523542669016
1.1562163594039043
1.1574464182749951
1.1586441640928002
1.1598111205491151
1.1609487110228982
1.162058266874052
1.1631410349259848
1.1641981842271729
1.1652308121708699
1.1662399500425054
1.1672265680559439
1.1681915799325324
1.1691358470705193
1.1700601823469092
1.1709653535889994
1.1718520867486204
1.1727210688084104
1.173572950446204
1.1744083484807755
49

50
1
1.0074493425805233
1.0148438950238221
1.0220818518480079
1.0290784946846316
1.0357711588953735
1.042119964335946
1.0481053713108306
1.0537240679480324
1.0589844877765064
1.063902774362413
1.0684995517816027
1.0727975505594907
1.0768199804309229
1.0805894877136457
1.0841275383731066
1.0874540946460625
1.0905874848788484
1.0935443947071384
1.096339930226192
1.0989877204031411
1.1015000376759767
1.1038879236565469
1.1061613121543481
1.1083291451823982
1.1103994797952497
1.1123795849637772
1.1142760285008138
1.1160947545103788
1.1178411520701372
1.1195201159563097
1.1211361002374267
1.1226931655330346
1.1241950206780542
1.1256450594665979
1.1270463930790509
1.1284018787279173
1.1297141449939856
1.130985614265984
1.1322185226445614
1.1334149376250371
1.1345767738325829
1.1357058070478652
1.1368036867301961
1.1378719472182852
1.1389120177654211
1.1399252315456876
1.1409128337503955
1.1418759888787928
1.1428157873140499
1.1437332512642091
1.1446293401379652
1.1455049554166492
1.1463609450763921
1.1471981076080118
1.1480171956765897
1.1488189194578056
1.1496039496838495
1.1503729204280013
1.1511264316537089
1.1518650515511275
1.1525893186815737
50

51
1
1.006485401383366
1.012916987941104
1.0192065202681797
1.0252809003683812
1.0310863876306195
1.0365891272579222
1.0417729374758338
1.0466356753690083
1.0511853095628148
1.0554364031490329
1.0594073108355735
1.0631181268753678
1.0665892847988423
1.069840665269389
1.0728910725719705
1.0757579643688029
1.0784573474527699
1.0810037772016783
1.0834104180978006
1.0856891371188149
1.087850611945977
1.0899044428285121
1.091859261511267
1.0937228335919131
1.0955021525469353
1.097203524819059
1.0988326460431919
1.100394668871669
1.1018942630539148
1.1033356685032558
1.104722742091683
1.1060589988818081
1.1073476484530764
1.1085916269180831
1.1097936251616547
1.1109561137741684
1.1120813650936321
1.1131714727192379
1.1142283688127661
1.1152538394633067
1.1162495383547819
1.1172169989444443
1.1181576453332691
1.119072801985534
1.1199637024344467
1.1208314970930047
1.1216772602739917
1.1225019965097975
1.1233066462513366
1.1240920910154568
1.1248591580416458
1.1256086245114463
1.1263412213775248
1.1270576368437377
1.1277585195326805
1.1284444813729253
1.1291161002344732
1.1297739223376762
1.1304184644580699
1.1310502159470461
1.1316696405861246
51

52
1
1.0055443430398148
1.0110375767829889
1.0164046023745938
1.0215834850002026
1.0265289673979763
1.031212831612901
1.0356219366972044
1.0397550675915608
1.043619557429831
1.0472282780265967
1.0505972513972841
1.0537439080147668
1.0566859035508378
1.0594403692411851
1.0620234757026992
1.0644502113177923
1.0667343006667684
1.0688882099888326
1.0709232035023599
1.0728494267487161
1.0746760017573926
1.0764111246824473
1.0780621604269114
1.0796357312683738
1.0811377980728816
1.082573733648641
1.0839483883592176
1.0852661484309849
1.0865309875457394
1.0877465123682404
1.0889160026596159
1.0900424465962784
1.0911285718661343
1.0921768730590722
1.0931896358128259
1.0941689581216154
1.0951167691651849
1.0960348459707747
1.096924828180343
1.0977882311598866
1.0986264576566342
1.0994408081828109
1.1002324902811953
1.1010026268073241
1.1017522633456287
1.1024823748615649
1.1031938716786927
1.1038876048583017
1.1045643710493835
1.1052249168682802
1.1058699428599763
1.1065001070866776
1.1071160283837527
1.1077182893183595
1.1083074388818808
1.108883994943668
1.1094484464904151
1.1100012556727128
1.110542859677915
1.1110736724463048
1.1115940862457003
52

53
1
1.0046251830407855
1.0092035716910994
1.0136727987606535
1.0179816563270112
1.0220929523832929
1.0259837392580908
1.0296436193989615
1.0330720810034504
1.0362756642315565
1.0392654487223663
1.0420550675988145
1.0446592648890609
1.0470929197986636
1.0493704320399164
1.0515053672367569
1.0535102797158218
1.0553966505991923
1.0571748971690651
1.058854423562698
1.0604436931331889
1.0619503099843566
1.06338110203625
1.064742201171675
1.0660391180695088
1.0672768106212474
1.0684597456139913
1.0695919538233531
1.0706770789119691
1.071718420651552
1.072718973029352
1.073681457796291
1.0746083539843989
1.0755019238786494
1.0763642358805652
1.0771971846528572
1.0780025088884146
1.0787818070045971
1.0795365510254928
1.0802680988807909
1.0809777053199334
1.0816665316140088
1.0823356541950631
1.0829860723627323
1.0836187151710077
1.0842344475931802
1.0848340760502539
1.0854183533771158
1.085987983291258
1.0865436244206161
1.0870858939400334
1.0876153708596779
1.0881325990034634
1.0886380897108772
1.0891323242916346
1.0896157562590951
1.0900888133653239
1.0905518994580565
1.0910053961775026
1.0914496645088945
1.091885046204929
1.0923118650906836
53

54
1
1.0037269972535665
1.0074130130937273
1.0110080189322512
1.0144711171267633
1.0177727839546595
1.0208949958909073
1.0238298195570978
1.0265772370196526
1.029142850002934
1.0315358541041386
1.0337674438028477
1.0358496583565018
1.0377946045808384
1.0396139699975733
1.0413187444148724
1.0429190831639477
1.044424262034348
1.045842688590549
1.0471819459277161
1.0484488531954628
1.0496495329742723
1.050789479468933
1.0518736240316944
1.0529063961624539
1.0538917791556701
1.0548333601837299
1.0557343749665382
1.0565977473720103
1.0574261243843235
1.0582219069065999
1.0589872768581274
1.0597242209996662
1.0604345518839999
1.0611199262889268
1.0617818614499148
1.0624217493717614
1.0630408694637667
1.0636403997116
1.0642214265712211
1.0647849537457792
1.0653319099850806
1.065863156028682
1.0663794907976141
1.0668816569258637
1.0673703457107862
1.0678462015512724
1.0683098259336017
1.0687617810172172
1.0692025928660327
1.0696327543651436
1.0700527278578509
1.0704629475336331
1.0708638215939588
1.0712557342196016
1.0716390473603381
1.0720141023654257
1.072381221471147
1.0727407091598444
1.073092853403228
1.0734379268013245
1.0737761876271712
54

55
1
1.0028489171616732
1.0056640612982635
1.0084073644110836
1.0110478410676849
1.0135632586374628
1.0159401906279153
1.0181729054986535
1.0202616838365817
1.022211054508098
1.0240282454482932
1.0257219685864314
1.0273015439725195
1.0287763124721472
1.0301552699595773
1.031446859968026
1.0326588736522724
1.0337984189340998
1.0348719319583624
1.0358852126985612
1.0368434728644329
1.0377513886453344

1.0386131537682757
1.0394325302783538
1.0402128956825443
1.0409572858660963
1.041668433654289
1.0423488031594164
1.0430006201956521
1.0436258991101994
1.0442264663983354
1.0448039814622598
1.0453599548513279
1.0458957642918927
1.046412668783292
1.0469118210050972
1.0473942782511116
1.0478610120785099
1.0483129168361724
1.0487508172147237
1.0491754749419013
1.049587594730403
1.0499878295710681
1.0503767854519031
1.0507550255727649
1.0511230741163353
1.0514814196280711
1.0518305180509799
1.0521707954551793
1.052502650497102
1.0528264566388241
1.0531425641541883
1.0534513019451179
1.0537529791886528
1.0540478868327787
1.0543362989569729
1.0546184740115092
1.0548946559479435
1.0551650752517792
1.0554299498870563
1.0556894861615345
1.0559438795201632
55

56
1
1.0019901255600501
1.0039549870901983
1.0058681134892054
1.00770805094976
1.0094594992784669
1.0111133196426851
1.0126657356795539
1.0141171441222048
1.0154708767075298
1.016732117625802
1.0179070576496152
1.0190022866730795
1.0200243881304125
1.0209796878106296
1.021874112757208
1.0227131244614951
1.0235016997573969
1.0242443407328259
1.0249451010685222
1.0256076206187195
1.0262351630956954
1.0268306537632883
1.0273967153787182
1.0279357014723527
1.0284497265826738
1.028940693380338
1.029410316796292
1.029860145364411
1.0302915800318448
1.0307058907012443
1.0311042307618408
1.0314876498493539
1.0318571050531826
1.0322134707664103
1.0325575473516075
1.0328900687743026
1.0332117093366959
1.0335230896269745
1.0338247817843111
1.0341173141663282
1.0344011754941593
1.0346768185401967
1.0349446634149171
1.0352051005016614
1.0354584930817941
1.0357051796870946
1.0359454762114375
1.0361796778096801
1.0364080606081194
1.0366308832478013
1.0368483882793005
1.037060803425303
1.0372683427253158
1.0374712075751094
1.0376695876719955
1.0378636618757355
1.0380535989937343
1.0382395584981832
1.0384216911819473
1.0386001397592268
1.0387750394163628
56

57
1
1.0011498526546943
1.0022841632250479
1.0033877074467199
1.0044481990548044
1.0054569290296769
1.006408753389201
1.0073016188566823
1.0081358679408905
1.0089135203222304
1.0096376472607649
1.0103118845782308
1.0109400841941689
1.011526082457278
1.012073557484868
1.0125859497576122
1.0130664252569663
1.0135178658069579
1.013942875875343
1.0143437986158819
1.0147227364739229
1.015081573430761
1.0154219971344733
1.015745519928321
1.0160534982727594
1.0163471503567758
1.0166275718731916
1.0168957500340532
1.0171525759550319
1.017398855560611
1.0176353191668392
1.0178626298932227
1.0180813910447406
1.018292152591959
1.0184954168635179
1.018691643551938
1.0188812541212111
1.0190646356933455
1.0192421444809068
1.0194141088236985
1.0195808318799384
1.0197425940155056
1.0198996549289865
1.0200522555451783
1.020200619705353
1.0203449556788331
1.0204854575171909
1.0206223062696129
1.020755671075561
1.0208857101488078
1.0210125716651406
1.0211363945644818
1.0212573092768555
1.0213754383804661
1.0214908971991596
1.0216037943456739
1.0217142322163257
1.0218223074421233
1.0219281113007241
1.0220317300931483
1.02213324548873
1.0222327348413933
57

58
1
1.0003273725222672
1.000650056714163
1.0009637380688436
1.0012649493671311
1.0015512478312423
1.0018212070000163
1.0020742781473846
1.0023105903055365
1.002530744783438
1.0027356370436311
1.0029263185351849
1.0031038981933476
1.0032694772304129
1.0034241092096507
1.0035687780292928
1.0037043879110363
1.0038317610339587
1.0039516397690642
1.0040646914750659
1.0041715145380798
1.0042726448349313
1.0043685621311875
1.0044596961402852
1.0045464321063864
1.0046291158574989
1.0047080583251966
1.0047835395553046
1.0048558122482738
1.0049251048739902
1.0049916244067845
1.0050555587246652
1.0051170787135462
1.0051763401133991
1.0052334851392117
1.0052886439057778
1.0053419356816933
1.0053934699946914
1.0054433476075089
1.0054916613809231
1.0055384970383541
1.0055839338444927
1.0056280452087079
1.0056708992225776
1.0057125591395981
1.0057530838040796
1.0057925280353044
1.0058309429722232
1.0058683763832896
1.0059048729454363
1.0059404744956943
1.0059752202585124
1.0060091470514592
1.0060422894716574
1.0060746800650184
1.0061063494800948
1.0061373266081635
1.0061676387109457
1.0061973115372267
1.0062263694294868
1.0062548354215215
1.0062827313279452
58

0
0.1
0.2
0.3
0.4
0.5
0.6
0.7
0.8
0.9
1
1.1000000000000001
1.2
1.3
1.4
1.5
1.6
1.7
1.8
1.9
2
2.1
2.2000000000000002
2.2999999999999998
2.4
2.5
2.6
2.7
2.8
2.9
3
3.1
3.2
3.3
3.4
3.5
3.6
3.7
3.8
3.9
4
4.0999999999999996
4.2
4.3
4.4000000000000004
4.5
4.5999999999999996
4.7
4.8
4.9000000000000004
5
5.0999999999999996
5.2
5.3
5.4
5.5
5.6
5.7
5.8
5.9
6
6.1

9/11/2013

10/30/2013

80
51.612903225806448
42.193548387096776
18.600000000000001
24.999999999999996
25
26.490857300376735
30.595351798790194
25
25

25
25

25
24.999999999999996

0.14894186714057803
0.81798763542966491
0.25249557720918481
0.58987911307921359
3.239611736850295

0.14894186714057803
0.50864341996156726
0.25249557720918481
0.58987911307921359
2.0144646713560923

23.813113368978001
183.06590693171381
0.20226449122363688
117.73254526741752
905.0817858548595

11
16
1
11
16

2.7393136541333787
3.6400696193855371
0.34760044138413848
7.8806391707256838
10.471993662870069

0.54096834392178628
13.882172793482731
0.18390125003894109
2.94162407165387
75.487104032969768

16.095897708649439
144.91783768523806
0.43232123555859853
37.231337220463082
335.20869614001487

25

0.06
0.29639788810883572
1
0.06
0.29639788810883572

36.497894063420418
36.201765105502204
0.28798937317506229
126.73347513150829
125.70521164159749

6.5
65
1
6.5
65

150
340
1
150
340

4Date:
1040000
-0.74360000000000004

1250000
-0.70379999999999998

2800000
-0.8

3360000
-9.3039999999999998E-2

4000000
-1.1307

490000
-0.57189999999999996

0.252

0.20200000000000001

1

0.34799999999999998

0.184

0.432

1

0.28799999999999998

n
BDL=1/2DL
Std Dev.
Mean
Stream Class
C.V.
Mult Factor =
Max. Pred Cw
Max. Value
Data
Cyanide
PQL
RECOMMENDED ACTION
PARAMETER
30Q2 (cfs)
Max Pred Cw
n =
Interpolate to find Mult. Factor
cv =
value 1 address =
value 1 =
value 2 address =
value 2 =
Interpolated MF value =
PRELIM. RESULTS
which truncates to
Pick upper & lower Mult. Factors and interpolate:
Round to 2 dec. places to get MF:
Date
Results
REASONABLE POTENTIAL RESULTS
Allowable Cw
No limit (Action Level parameter)
No limit
MaxPredCw << Acute
MaxPredCw < Acute
MaxPredCw > Chronic
MaxPredCw < Chronic
Monitoring not necessary in permit
MaxPredCw << Chronic
Hit(s)
# Det.
Monitor 1/month
Revise daily max. limit
C
Monitor 1/week
Continue to monitor at 2/month
Monitor 2/month
No limit - assuming no tox (Action Level parameter)
Units
ug/L
Facility Name
Acute:
Chronic:
MaxPredCw >> Chronic
MaxPredCw > Acute
MaxPredCw >> Acute
N/A
REMOVE?
MONITOR?
DAILY MAX LIMIT?
MO AVG LIMIT?
NO DATA
Daily max limit
Mo. avg. limit (keep wk. avg. if existing)
Sample recommendations:
LTMP
Y
N
Monitoring Frequencies
2B .0500
Parameter
Location
Class I
Class II
Class III
Class IV
Frequency
Effluent Limited
pH
E
2/Month
Daily
3/Week
Temp, C
BOD5
TSS
NH3-N
Fecal Col.
TN
TP
Water Quality Limited
D.O.
TRC
Conductivity
I, E
U, D
1/Week
1/Month
See notes below.
2/Week
3/Week*
Notes:
TN, TP Monitoring
All facilities >= 0.05 MGD will monitor TN and TP
Those < 0.05 MGD will monitor if discharging to NSW
For French Broad, Broad, Savannah, New Watauga, Little Tennessee, and Hiwassee:
-
>= 0.05 MGD
- monitor semi-annually
>= 1.0 MGD
- monitor quarterly
For all other river basins:
- monitor monthly
* Upstream and downstream monitoring in WQ-limited waters is to be conducted
3/Week during Jun, Jul, Aug, and Sep; and 1/Week during the rest of the year.</t
For the Neuse, Tar-Pamlico, and any other river basins classified as NSW, use limits
and monitoring requirements according to the basin's permitting strategy.</t><
7Q10s (cfs)
7Q10w (cfs)
QA (cfs)
Receiving Stream
Type
Chronic
Modifier
Acute
NPDES Permit
Outfall
Flow, Qw (MGD)
Name
Msg02
Msg03
Msg07
Msg04
Msg08
Msg05
Msg09
Msg06
Msg01
Msg10
Msg00
Fac_Name
IWC_30Q2
=rpa!$L$8
IWC_7Q10s
=rpa!$L$6
IWC_7Q10w
=rpa!$L$7
IWC_QA
=rpa!$L$9
NPDES
Stream_Class
WWTP_Grade
No chronic standard or criterion
No acute standard or 1/2 FAV
< No Data Entered >
Workbook Names:
Table 1. Project Information
Table 2. Parameters of Concern
=input!$B$10
=input!$B$11
=input!$B$12
=input!$B$13
=input!$B$14
=input!$B$5
=input!$B$6
=input!$B$7
=input!$B$8
=input!$B$9
=input!$E$5:$K$5
=input!$E$6:$K$6
=input!$E$7:$K$7
=input!$E$8:$K$8
=input!$E$9:$K$9
=input!$E$10:$K$10
=input!$E$11:$K$11
=input!$E$12:$K$12
=input!$E$13:$K$13
=input!$E$14:$K$14
=input!$E$15:$K$15
=input!$E$16:$K$16
=input!$E$17:$K$17
Find row in M.F. Table -
Find column in M.F. Table -
Data Source(s)
Par02
Par03
Par04
Par05
Par06
Par07
Par08
Par09
Par10
Par11
Par12
Par13
Par14
Par15
Par16
Par17
Par18
Par19
=input!$E$18:$K$18
=input!$E$19:$K$19
=input!$E$20:$K$20
=input!$E$21:$K$21
=input!$E$22:$K$22
1Q10s (cfs)
Jan. 09
<
Feb. 09
PQL = 10
No PQL or a lower PQL of 9
Per Memo Dated 7-15-2010

Arsenic
FW
HH
Beryllium
NC
Cadmium
Fluoride
Lead
Mercury
ng/L
Molybdenum
Nickel
A
Selenium
Par20
Par21
Par22
Qw (MGD) =
1Q10S (cfs) =
7Q10S (cfs) =
7Q10W (cfs) =
30Q2 (cfs) =
Avg. Stream Flow, QA (cfs) =
Receiving Stream:
Stream Class:
TR
WS
WWTP/WTP Class:
=input!$B$16
_1Q10__cfs
_7Q10s__cfs
_7Q10w__cfs
_30Q2__cfs
Qw__MGD
QA__cfs
=input!$B$15
HQWF
Par_01
Par_02
Par_03
Par_04
Par_05
Par_06
Par_07
Par_08
Par_09
Par_10
Par_11
Par_12
Par_13
Par_14
Par_15
Par_16
Par_17
Par_18
Par_19
Par_20
Par_21
Par_22
=input!$E$23:$K$23
=input!$E$24:$K$24
=input!$E$25:$K$25
=input!$E$26:$K$26
=input!$E$5:$E$26
=input!$G$5:$G$26
=input!$F$5:$F$26
=input!$H$5:$H$26
=input!$I$5:$I$26
=input!$J$5:$J$26
=input!$K$5:$K$26
=input!$N$6
=rpa!$L$5
IWC_1Q10S
Print_Area
Print_Titles
=rpa!$C1:$P$99
=rpa!$1:$2
RPA Tab only:
INPUT Tab only:
=input!$A$1:$K$26
DATA Tab only:
=data!$A$2:$GP$204
Receiving_Stream
No Data (new Permit, New Waste Stream) - apply Monthly Monitoring, Pollutant of concern

Follow directions for data entry. In some cases a comment menu list the available choices or a dropdown menu will provide a list you may select from. Error message occur if data entry
does not meet input criteria.
RPALIST
_Data01
_Data02
_Data03
_Data04
_Data05
_Data06
_Data07
_Data08
_Data09
_Data10
_Data11
_Data12
_Data13
_Data14
_Data15
_Data16
_Data17
_Data18
_Data19
_Data20
_Data21
_Data22
=data1$D5:$D$204
=data1$M5:$M$204
=data1$V5:$V$204
=data1$AE5:$AE$204
=data1$AN5:$AN$204
=data1$AW5:$AW$204
=data1$BF5:$BF$204
=data1$BO5:$BO$204
=data1$BX5:$BX$204
=data1$CG5:$CG$204
=data1$CP5:$CP$204
=data1$CY5:$CY$204
=data1$DH5:$DH$204
=data1$DQ5:$DQ$204
=data1$DZ5:$DZ$204
=data1$EI5:$EI$204
=data1$ER5:$ER$204
=data1$FA5:$FA$204
=data1$FJ5:$FJ$204
=data1$FS5:$FS$204
=data1$GB5:$GB$204
=data1$GK5:$GK$204
Û
REQUIRED DATA ENTRY
USE MENU BUTTON TO SELECT POSSIBLE "RECOMMENDED ACTION"
=rpa1$y$64:$y$77
UNITS
TYPE (1)
Applied Standard
PAR #
NO WQS
HH/WS
Total Phenolic Compounds
For
all dischargers
to all waters of the state:
For dischargers to Water Supply (WS) streams that
chlorinate
the effluent:
The following is a list of
Chlorinated
Phenolic Compounds
detected using US EPA Method 625:
at
1.0 ug/L.
Concentrations of all
chlorinated
phenolic compounds, detected above the PQL,
using
US EPA Method 625 data
, should be summed
*
and compared to the
1.0 ug/L
water supply water
quality standard for “
chlorinated
phenolic compounds”.
(EPA Parameter Code: 34034)
Additional
chlorinated
phenolic compounds

MAY

be reported.
<
If reported above the PQL, the
additional
chlorinated
compounds
should
be added to the five chlorinated compounds listed above
to calculate the total chlorinated phenolics in the sample. NOTE: these additional compounds are NOT
required to be reported by 40 CFR Part 136 regulations for US EPA Method 625.
summed
with the chlorinated data for comparison to the Water Supply standard for chlorinated phenolics:
Narrative a
esthetic
“
Total
Phenolic Compounds”

water quality standard
(300 ug/L). Data should be
supplied using
US EPA Method 420.1 (colorimetric) or US EPA Method 420.4 (automated colorimetric),
and will be labeled “Phenols” or “Total Recoverable Phenolics”.
(EPA Parameter Code: 32730)
“
Chlorinated
Phenolic Compounds”
in
Water Supply
classified waters is an a
esthetic
standard
*
The following US EPA Method 625 reported
non-chlorinated
phenolic compounds
SHOULD NOT be
4-chloro-2-methylphenol 6-chloro-3-methylphenol</t></si>
3-chlorophenol 4-chlorophenol 2,3-dichlorophenol </t></si>
2,3,6-trichlorophenol 2,4,5-trichlorophenol 2,3,4,6-tetrachlorophenol</t></si>
2,5-dichlorophenol 2,6-dichlorophenol 3,4-dichlorophenol </t></si>
p-cresol (4-methylphenol)     o-cresol (2-methylphenol)           </t></si>
2-Nitrophenol 4-Nitrophenol Phenol </t></si
2,4-Dimethylphenol 2,4-Dinitrophenol 2-Methyl-4,6-dinitrophenol </t></si
4-chloro-3-methylphenol pentachlorophenol</t></si><
mg/L
No RP , Predicted Max ≥ 50% of Allowable Cw - apply Quarterly Monitoring
No RP , Predicted Max ≥ 50% of Allowable Cw - defer to LTMP
No RP, Predicted Max < 50% of Allowable Cw - No Monitoring required
RP for Limited Dataset (n<8 samples) - apply Quarterly Monitoring
RP for Limited Dataset (n<8) but 2 values > Allowable Cw - apply Monthly Monitoring with Limit
WWTP/WTP Class
ppt
µg/L
lb/d
rdb
Use "PASTE SPECIAL-Values" then "COPY" . Maximum data points = 58
Statistically 58 points are the maximum number of points allowed under this RPA program. Data fields were estbalished to allow only 58 data point entries.
All worksheets are "Protected"
Reasonable Potential Multiplying Factors - Calculator
Confidence Level
Upper Boundary of the Effluent Distribution (Percentile Value Not To Exceed)
Coefficient of Variation
The "mf calculator" is password "Protected"

MAXIMUM DATA POINTS = 58
New freshwater RPA based on 95% probability/95% confidence
1) assumes only chroinc dilution known
A. When Model is applied (Check box activated):
B. When Model is not applied (Check box NOT activated):
OTHER CHANGES FROM PREVIOUS RPA PROGRAM:
Additional messages will appear to alert user if more than 58 data points were enter and no predicted values will be calculated
C. When paremeter's "Impaired?" check box is activated:
2) does NOT make any automatic adjustements to WQS calculations
1) automtically activtes the
"IMPAIRED"
message alert on the "RPA" page for that parameter
2) assumes user will insert appropriate flow values for
"7Q10s (cfs)", "7Q10w (cfs)", "30Q2 (cfs)", "QA (cfs)"
to define chronic dilution in terms of "
IWC %"
,
"IWC %"
is the same for all stream flows
NOTE: If new or expanding discharge and receiving stream impaired, will need to evaluate if additional waste load is allowed
3) automatically assigns the entered chronic IWC % to the
"IWC @ 7Q10s", "IWC @ 7Q10w", "IWC @ 30Q2", "IWC @ QA"
values used in chronic WQS calculations (See "RPA" page)
3)
"1Q10s (cfs)"
automatically defaults to no acute dilution, acute IWC = 100% ,
"IWC @ 1Q10s"
= 100% which is used in acute WQS calculatons (See "RPA" page)
3) automatically calculates chronic-based IWC % for the
"IWC @ 7Q10s", "IWC @ 7Q10w", "IWC @ 30Q2", "IWC @ QA"
values used in chronic WQS calculations (See "RPA" page)
1) assumes user will insert appropriate flow values for
"7Q10s (cfs)", "7Q10w (cfs)", "30Q2 (cfs)", "QA (cfs)" , "Flow Qw (MGD)
" for chronic IWC % calculations, IWC % will vary according to flows
3)
"1Q10s (cfs)"
is automatically calculated bases on entered
"7Q10s (cfs)"
flow

4) automatically calculates acute-based IWC% for the
"IWC @ 1Q10s"
value used in acute WQS calculations (See "RPA" page)
2) Added new calculation feature to count nondetects when both "<" and a value are entered for each data set, used to calculate detected entries
1) Amended
"ERR"
alert on data sets entreies to activate if "<" entered but no value entered, does not effect RPA calculation, ERR message only
3) Amended "Comments" drop down menu - per Juile
4) Turned the Chronic toxicity concentration message off on the RPA page - per Julie
2/10/14:
ON "data" page changed highlighted area from blue shades to gray
5/2/14 rdb
1) Increased rounding factor on all calculated IWC% to 7 decimals
2) Increased display for all calkculated to 6 decimals places.
5/5/14 rdb
Increased rounding factor on all calculated IWC% to 9 decimals
5/21/14 rdb
Removed ROUND function from all IWC% calculations
7/31/14 rdb
Moved RPA page tile blocks down one row so header text was separated
Combined Hardness Chronic
Combined Hardness Acute
In accordance with Federal Regulations, permit limitations must be written as Total Metals per 40 CFR 122.45(c)
Receiving Stream summer 7Q10 (CFS)
Receiving Stream summer 7Q10 (MGD)
Rec. Stream
Total Suspended Solids -Fixed Value-(mg/L)
Combined Hardness chronic (mg/L)
Combined Hardness Acute (mg/L)
Instream Wastewater Concentration (Chronic)
Instream Wastewater Concentration (Acute)
1Q10
Flow Limit
[MGD]
10
Dissolved Metals
US EPA
Translators
- using Default Partition Coefficients (streams)
Maximum Allowable Effluent Concentration (MAEC) as a
Total Metal =
Dissolved Metal
÷
Translator
[ug/l]
Cd -Trout streams</t>
Chromium VI
Chromium, Total
Beryllium
Arsenic (d)
Dissolved Metals & Hardness Determination
v. 5/27/2010</t></si><si><t>I. How to Determine Hardness for use with Dissolved Freshwater Standards for Permitting Purposes</t></si><si><r><t>HARDNESS - Use 25 mg/L, express
I. How to Determine Hardness for use with Dissolved Freshwater Standards for Permitting Purposes
HARDNESS - Use 25 mg/L, expressed as CaCO
3
or Ca+Mg, as the default Hardness
OR
To determine a Hardness value for permit limit development, use the following equation:
<
Hardness       
=
</
(Hardness instream
(a)
, mg/L * 7Q10, MGD)+(Hardness effluent
(b)
, mg/L* Plant flow, MGD)
(

mass balance
)
(7Q10, MGD + Plant flow, MGD)</t></r></si><si><t>(a)    Use the median instream Hardnes
(a)    Use the median instream Hardness value of the ambient 8-digit HUC data collected by the Division of Water Quality.  To find the 8-digit HUC hardness value for your facility, Click
Here.
(b)    For the purpose of this estimation, use the facility's median effluent Hardness value, if available.  The Division will request the permittee to sample effluent hardness once/month
and submit one to two years of data with the permit renewal application. If no effluent hardness data is submitted, a default of 25 mg/L will be applied.
II. To Develop Dissolved Metal concentrations for permitting purposes use the Freshwater Standards for Hardness Dependent Metals listed in Table A below.
Table A: Dissolved Freshwater Standards for Hardness Dependent Metals
Metal
Cadmium, Acute
{1.136672-[ln hardness](0.041838)} · e^{0.9151 [ln hardness]-3.1485} 
Cadmium, Acute (Trout Waters)
{1.136672-[ln hardness](0.041838)} · e^{0.9151[ln hardness]-3.6236}
Cadmium, Chronic
{1.101672-[ln hardness](0.041838)} · e^{0.7998[ln hardness]-4.4451}
Chromium III, Acute
0.316 · e^{0.8190[ln hardness]+3.7256}
Chromium III, Chronic
0.860 · e^{0.8190[ln hardness]+0.6848}
Copper, Acute
0.960 · e^{0.9422[ln hardness]-1.700}
Copper, Chronic
0.960 · e^{0.8545[ln hardness]-1.702}
Lead, Acute
{1.46203-[ln hardness](0.145712)} · e^{1.273[ln hardness]-1.460}
Lead, Chronic
{1.46203-[ln hardness](0.145712)} · e^{1.273[ln hardness]-4.705}
Nickel, Acute
0.998 · e^{0.8460[ln hardness]+2.255}
Nickel, Chronic
0.997 · e^{0.8460[ln hardness]+0.0584}
Silver, Acute
0.85 · e^{1.72[ln hardness]-6.59}
Silver, Chronic
Not applicable
Zinc, Acute
0.978 · e^{0.8473[ln hardness]+0.884}
Zinc, Chronic
0.986 · e^{0.8473[ln hardness]+0.884}
Complete information on all the proposed Surface Water Quality Standards can be viewed at: http://h2o.enr.state.nc.us/csu/trirev_SW.html.
US EPA Translators
using Default Partition Coefficients (DPC)
v. 6/2/2010</t></si><si><r><t xml:space="preserve">Translator equation using Default Partition Coefficients = </t></r><r><rPr><sz val="12"/><rFont val="Tahoma"/><fa
Translator equation using Default Partition Coefficients =
</
1                        </t></r></si><si><r><
[1 + (Kpo * TSS </t></r><r><rPr><vertAlign val="superscript"/><sz val="12"/><rFont val="Ta
(1+
a
)
* 10
-6
)]
Kpo
and 
a
 are constants that express the equilibrium relationship between dissolved and adsorbed forms of metals.
A default value

of 10 mg/L
Total Suspended Solids (TSS)
will be used.
Table A
contains the Default Partition Coefficients for the equation.
Table B
contains the calculated translators using the default partition coefficients for streams.
TABLE A. Default Partition Coefficients
STREAMS
Metal
(1)
Kpo
a
Cu
Zn
Pb
Cr (III)
(2)
Cd
Ni
(1)
Delos, C.G., et al. Technical Guidance for Performing Waste Load Allocations. Book II: Streams and Rivers. Chapter 3: Toxic Substances, For the U.S. EPA. (EPA-440/4-84-022)</t
(2)
Linear partition coefficients shall not apply to the Chromium VI numerical criterion. The approved analytical method for Chromium VI measures only the dissolved form. Therefore, permit
limits for Chromium VI shall be expressed in the dissolved form.  See 40 CFR § 122.45(c)(3).</t
TABLE B. US EPA Translators
Using stream Default Partition Coefficients
TSS = 10 mg/L
Chromium III
Copper
Silver
Zinc
Trout
Water Supply
Human Health Water Supply
Aquatic Life
WQS
Freshwater RPA - 95% Probability/95% Confidence Using Metal Translators
Human Health
COMBINED HARDNESS (mg/L)
9/9/15:
COMPLETED REVISIONS FOR METAL TRANSLATOR FEATURE
1) Added tabs for "HUC Hardness" (lookup table for HUC hardness values), "Hardness Equations" (summary of translator formulas, metals impacted, general info), "Dss to Total Hardness
Calculator"
(calcution sheet for metal translator, impacted chronic and acute wqs)</
2) Revised "Input" page Table 1:
3) Revised "Input" pade Table 2:
- Removed Par01 "Arsenic" line
- Revised Par02 " Arsenic" line to reflect Human Health and Water Supply criterion, Chronic = 10 mg/L, Acute = "N/A"

- Revised Par04 "Cadmium" line:
a) "WQS" input with drop down menu to select applicable criterion
c) "Modifier" input display only based on "WQS" selection including conditional method for info dispaly
- Revised Par05 "Chloride (AL)" line:
b) "Chronic" display only for applicable value including conditional method for info display based on "WQS" selection
d) "Name" display only based on "WQS" selection including conditional metdod fro info display
- New user input for "8 Digit HUC Number" uisng drop down menu for lookup HUC Hardness, required entry, brown highlight
- New display only for calculated "Effluent Hardness (Median)" including conditional method for info display, brown highlight
- New display only for designed "HUC Hardness (Median)" incuding conditionla method for info display, brown highlight
- New display only for calculated "Combined Hardness Chronic" for metal translator application, brown highlight
- New display only for calculated "Combined Hardness Acute" for metal translator application, brown highlight
d) Conditonal controls to activate error nessages, brown highlight
- Added new column for "WQS" designation incuding assigning applicable WQS where fixed
- Added new error message "CHECK WQS", conditonal control based on "WQS" entry for Cadmium, Chlorides, Molybdeum, Nickel
- Revised text in error message
- Revised "Chromium, Total" line:
a) Removed Par08 label
- Added new "Chromium III" line:
c) brown highlight
b) brown highlight
a) Assigned Par08 label, applicable text in "WQS", "Type", Modifier", Units"
a) Assigned applicable text in "WQS", "Type", Modifier", Units"
- Revised Par09 "Copper (AL)" line:
- Added new Par08 "Chromium VI" line:
- Revisd Par12 "Lead" line:
- Revised Par15 "Nickel" line:
- Revised Par14 "Molybdenum" lime:
e) Conditonal controls to activate error nessages
d) Conditonal controls to activate error nessages
- Revised Par17 "Silver (AL)" line:
- Revised Par18 "Zinc (AL)" line:
- Added new brown highlight "Metal Translator Data Entry" label box
3) Revised "Data" page:
a) Reference to Par01 "Arsenic" removed
b) New label "Effluent Hardness (monthly average)" added
c) "Mult Factor =" and "Max. Pred Cw" removed, text and calcuation
d) "10% value" and "Median value" added, text and calculation including conditional method for info display
e) Assigned name "Effluent_Median" and "effluent_10" to calculated values
- Revised Par01 "Arsenic" entry, text, and calculations ("1") - all effluent hardness data to be entered in this section for used to calculate eflluent hardness factors
- Removed "Impaired ?" column, conditional display, references
4) Revised "RPA" page:
- Removed all features assocaited with "Impairment"
- Added new display only for calculated "COMBINED HARDNESS (mg/L)", Chonic and Acute, conditional method for info display
- Assigned name for "HUC Number"
- Revised "Receiving Stream" display to include selected HUC Number in text
- Removed unused display features for WET % (previouly hidden)
- Revised "Arsenic" lines:
a) Par01 "Arsenic" line removed
b) "Allowable Cw" Acute" and "Chronic" conditional metfhod revised fro info display inculding rounding value
- Revised "Cadmium", "Chromium VI", "Copper (AL)", "Lead", "Nickel", "Silver (AL)", "Zinc (AL)" llines:
b) Par02 "Arsenic" references used for display to calculate "Acute" and Chronic" allowable Cw
a) "NC WQS/Chronic" and 1/2 FAV/Acute" conditional method revised for info display, no rounding
5) Revised "Dss to Total Metal Hardness Calculator" page
a) "CdMAE_AC" - Cadmium calculated metal translator Acute value
b) "CdMAE_CH" - Cadmium calculated metal translator Chronic value
c) "CuMAE_AC" - Copper calculatd metal translator Acute value
d) "CuMAE_CH" - Copper calculated metal translator Chronic value
e) "Cr_Total_AC" - Total Chromium calculated meatl translator Acute value
f) "Cr_Total_CH" - Total Chromium calculated metal translator Chronic value
h) "CrIIIMAE_CH" - Chromium III calculated metal tramslator Chronic value
g) "CrIIIMAE_AC" - Chromium III calculated metal translator Acute value.
i) "CrVIMAE_AC" - Chromium VI calculated metal translator Acute value

j) "CrVINAE_CH" - Chromium VI calculatd metal translator Chronic value
m) "PbMAE_CH" - Lead calculated metal translator Chronic value
k) "PbMAE_AC" - Lead calculated metal translator Acute value
n) "NiMAE_AC" - Nickel calculated metal translator Acute value
o) "NiMAE_CH" - Nickel calculated metal translator Chroniv value
q) "AuMAE_CH" - Silver calculated metal translator Chronic value
p) "AuMAE_AC" - Silver calculated metal translator Acute value
r) "ZnMAE-AC" - Zinc calculated metal translator Acute value
s) "ZnMAE_CH" - Zinc calculated metal translator Chronic value
t) "tss" - assigned TSS harness factor
u) "CHA" - calculated combined acute hardness value
v) "CHC" - calculated combined chronic hardness value
- Assigned names for:
b) "Chronic" and "Acute" inputs to display calculated metal translator values including conditional method for info display based on "WQS" selection, no rounding
b) "Chronic" and "Acute" inputs to display calculated metal translator values, no rounding
a) "Chronic" and "Acute" inputs to display calculated metal translator values, no rounding
- Added conditional methods to formulas for info display and to incorporate names, no rounding
6) Set up passwortd to protect all pages 'rpa2015'
f) PQL condition removed from calculation method for data displayed
Par01
Aquactic Life
Chronic (HH):

Chronic (FW):
1&2
IWC% @ 7Q10S = <
IWC% @ 1Q10S =
IWC% @ 7Q10W =
IWC% @ 30Q2 =
IW%C @ QA =
H
No detects
.
1/12/16 ADDED ARSENIC AQUATIC LIFE PARAMETER BACK TO ACTIVE RPA EVALUATION
1) Inserted "Aresenic, Aquatic Life, C, 50, FW, N/A, µg/L" in first row "INPUT" Table 2, Par01
2) Updated program names to reflect addition of new Arsenic Aquatic Life parameter
4) Amended labels on "Data" to show H for hardnes and Par01-Par22 for paremeters
1) Reformatted IWC calculation cells to show caculated value as general (number value will always be displayed)
2) Revised IWC calculation formula to x by 100 to mimic %
4) Revised all calculations using IWC values "Acute", "Chronic" to divide by 100 to correct for IWC % value
1/12/16 REVISED IWC CALCULATIONS TO SHOW FULL DISPLAY on "RPA"
3) Revised IWC calculation labels to include "%"
1/12/16 REVISED SPREADSHEET TO INDICATE NO DETECT AND MDL
2) Revised "RPA" all parameters Max Pred CW cell formatting to display
"
NO DETECTS"
when required to display no detects
1) Revised "Data" Par01-Par22 Max Value cell conditional statement to display "NO DETECTS" when data set has all no detects
3) Revised "RPA" alert message (under Chronic labels) conditional statement to display
"Max MDL = <2 x max adjusted data set value>"
when data set has all no detects
1/12/16:
Corrected formula error in mf formula Par01 to use corrected data set ("Data")
4) Revised "RPA" drop menu to add "No detects" to list and display
Revised "RPA" Cadmium, Copper, Lead, Nickel, Silver, Zinc Acute and Chronic cell conditional statements to have cell display blank if WQS is blank or WQS displays "NO DATA"
3) Inserted "Arsenic" Aquatic Life parameter and cell programming in Arsenic section "RPA" as Chronic and added drop down menu feature
Acute (FW):
!
Par23
Par24
Pa11
1/21-29/16:
1) Expanded parameter list and program features to add two additional parameters, (Par08) "Chromium III" & (Par09) "Chromium VI". This included adding two new data input sections on
"Data" tab with
2) For consistency rearranged display, "Input" & "RPA" tabs, to be "Chromium III", "Chromium VI", "Chromium, Total". All features and programing unique to each display was revised accordingly.
3) Corrected Arsenic - Aquatic Life, Berylium Chronic and Acute values on "Input" tab to be exported from metal translator table.
5) Revised combined hardness acute (CHA) and combined hardness chronic (CHC) conditional formulas to assign 25 as hardness value when HUC hardness is NA.
4) Revised "Input" tab HUC Hardness (median) display conditional formula to display "default 25 mg/L (HUC Hard Med = NA mg/l)" when HUC hardness is NA.
6) Revised "RPA" tab Chromium, Total Reasonable Potential Results section to remove Acute and Chronic labels and allowable Cw calulation/display, area now blank except for MDL feature
display.

8) Revised "RPA" tab Acute and Chronic conditional formulas for active parameters to display either
"IWC?"
or
"IWC/DATA?"
as default until appropraite data is provided.
9) Removed
label from "Input" tab.
7) Revised "RPA" tab Chromium III and Chromium VI Reasonable Potential Results sectons to remove display of values for n, #Det, Max Pred Cw, area blank except for display features from
added condtional
formulas that reference Chromium, Total display and data.</
new corresponding RPA evalutaion, non-detect evaluation, formulas for each new data input section; adding two new parameter summary sections to "RPA" tab; revising exsiting parameter
designation</
to new assigned name (Par10 - Par24), data set (_Data08 - _Data24), non-detects (_ND08 - _ND24).</
NOTE: All RPA evaluation data is generated on each parameter "Data" section and imported to that parameter's "RPA" section, thus, RPA evaluation data can be displayed/used when programmed
to do so.
2-chlorophenol 2,4-dichlorophenol 2,4,6-trichlorophenol</t></si><
10) Corrected chlorinated list ("Input" & "Data" tabs) lists, now shows correct 2,4,6-trichlorophenol for Method 625.
Par01 & Par02
Here’s the Chromium breakdown:<
a.
</t></
No Monitoring required if all Total Chromium samples are < the Chromium VI Allowable C
w
b.
</t><
Maintain Total Chromium monitoring or defer to LTMP if all Total Chromium samples are < 50 µg/L but
 >
the Allowable C
w
for Chromium VI.<
c.
</t></
Monitor Total Chromium and Chromium VI, along with a limit for Chromium VI if any Total Chromium sample is
 ≥  5
0 µg/L

and

 ≥
to the Allowable C
w
for Chromium VI but &< the Allowable Cw for Chromium III.
d.
</t><
Limit both Chromium III and Chromium VI when any Total Chromium sample is ≥ 50 µg/L and ≥
to the Allowable Cw for Chromium III. Monitor for Total Chromium and Chromium Vi, report the calculated Chromium III.
2/16/16:
1) Revised "Diss to Total Metal Calculator" page:
a- If HUC Hard Med = NA or less than 25 mg/L then default HUC Hard Med to 25 mg/L
b- If Effluent Hard Med less than 25 then default Effluent Hard Med to 25 mg/L
c- If stream class is WS and Effluent Hard Med is greater than 99.9999 mg/L then default Effluent Hard Med to 99 mg/L
revised the existing calculation input/display cells for Effluent & HUC Hardness Median to show the applied hardness value based on new conditional formula as follows
added new cells to display actual calculated Effluent & HUC Median values and to display "Apply Water Supply Criterion" when applicable (stream class is Water Supply based and Efflunet
Hard Med
exceeds 99.999 mg/L)
2) Revised "input" page dipplay HUC Hardness (Median) to show NA when HUC table value is NA.
See task notes
Revised "input"page model feature to
b- Revise cell formula 1Q10s (cfs) to display 1Q10s flow when model feature activated or calculate from 7Q10s flow when model feature NOT activated and 7Q10s flow displayed
c- Revised instructions narrartive that is visible only when model feature is activated
a- Add new model 1Q10S input cell that is visible on;y when model feature is activated
2/3/16:
2/9/16:
Revised "data" page Effluent Hardness (Median) cell formula to display 99 whenstream class is WS and Effluent Hard Med is greater than 99.999 mg/L
Revised "input" page Effluent Hardness (Median) cell formula to display "default 99 mg/L (Efflunet Hard Med = <actual value> mg/L)" when stream class is WS and Effluent Hard Med is greater
than 99.999 mg/L
Added new display messages to "rpa" page that are visible only when the steam class is water supply
Chromium, Total (t)
Ni - WS streams (t)
Par25
Chronic (WS):
Par17 & Par18
Chlorinated Phenolic Compounds
Added new WS WQC button to "input" page, activates effluent hardness to apply WS WQC standards, does NOT set parameter modifiers, still must do modifers individually
Set up both Nickel Par17 & Par18 to use same data entries
Added Nickel WS parameter to "input" page
Added Nichel WS to "rpa" page, revised both Nickel parametesr to share commom data, Nickel WS has no Acute standard so only list acute for FW

Changed Par22-25 modifier cells to be set automtically based on WQS entry.
17&18
Changed display font color phenols, chlorinared phenols menus
Cadmium (d)
Chromium III (d)(h)
Chromium VI (d)
Copper (d)(h)
Lead (d)(h)
Nickel (d)(h)
Silver (d)(h,acute)
Zinc (d)(h)
The Human Health standard for Nickel in Water Supply Streams is 25 mg/L which is Total Recoverable metal standard.</t></si>
The Human Health standard for Arsenic is 10 µg/L which is Total Recoverable metal standard.</t></si>
(d) = dissolved metal standard. See 15A NCAC 02B .0211 for more information.
(h) = hardness-dependent dissolved metal standard. See 15A NCAC 02B .0211 for more information.
(t) = based upon measurement of total recoveable metal. See 15A NCAC 02B .0211 for more information.
2/19/16:
2/22/16:
Make text changes per Julie direction.
Dissolved to Total Metal Calculator
COMMENTS (identify parameters to PERCS Branch to maintain in facility's LTMP/STMP):
2/24/16:
Added to " Diss to Total Metal Calculator" page:
1) Comment section for PERCS info or other to allow user to add commentary
2) Added Facility name to display based on input page
3) Added NPDES permit# to display based on input page
NOTE: User can either highlight desire print area or use GOTO feature to set up desired print arae. When in print mode set up, will need to designate "Print Selection".
4) Set up new Name "PERCS_page" as print area for table and other PERCS info for GOTO use.
`
HUC Number
Upstream Hardness
H1
H2
Average Value =
password all sheets = rpa2016a
10th Per value
3/18/16:
Added Upstream Hardness calculation feature using measured upstream data:
Removed HUC table and HUC hardness lookup features from calculations and program.
1) INPUT display shows "Upstream Hardess" status and how upstream data is applied
2) DATA has new Upstream Hardness input sheet to accept upstream hardness data used to calculate number of data enties, data set average, data set 10th percentile value
3) Diss to Total Metal Calculator determines which upstream hardness to apply, if the number of data entries exceed 30 then the average value is used, if the number of data enties are
less than 30 then the
10th percentile value is used. Anytime the applied upstream hardness is less than 25 mg/L then a default value of 25 mg/L is applied.</
Note: HUC number is an available option on the INPUT as an informational input only to use as a display label for other portion of the progam and has no Data Validation features.
Effluent Hardness
4/26/16:
1) Changed all upstream hardness median calculations to average calculations.
2) Removed any greater than 99.999 defaults from upstream hardness conditional statements. Upstream average will be actual execpt when less than 25, then 25 is the default.
3) Changed all effluent hardness median calculations to average calculations. Conditional statements for WS still apply, efflunet average value above 99.999 default to 99.
4) Any conditional statement referring to median hardness were revised.
5) Removed "(AL)" from parameter labels as no longer applicable.
Per Julia want to use average values for both the effluent and upstream hardness calculations. Defaults to be the same as was applied in the HUC base RPA.
6) Renamed RPA to describe features
ACCH
ACAH
4/27/16:
Per Julia when WS is being applied, the combined acute and chroinc hardness needs to default to 100 if the combined hardness exceeds 100. Made changes:
1) Set up new cells to calculate combined acute and chronic hardness, defined cells as program names ACCH & ACAH.
2) Revised the conditional statemenst for CHC and CHA to default to 100 if ACCH & ACAH exceed 100 when WS was applied.
4) Revised RPA page Combined Hardness Acut and Chronic displays conditional statemenst to indicate defaults
3) Revised INPUT page Combined Acute and Chronic display condtitional statements to indicate defaults
4/28/16: Note Action Level designation no longer allowed per EPA.
RP shown - apply Monthly Monitoring with Limit
4/28/16:
Revised RPA page drop menu "Recommended Action" list to remove RP Action Level text and change "RP non action level…" text to state "RP shown…".

Fixed programming errors so "NO DETECTS" display feature on RPA page for Nickel and Chromium VI now function.
Added statement to 2B .0500 RULES page "4/28/16: Note Action Level designation no long allowed per EPA."
4/29/16:
Added ROUND function to conditional statements on INPUT page hardess displays to limit hardness value display to 2 decimal points.
Revised upstream default conditional factor to 24.9999 on INPUT page to allow actual upstream hardness of 25 to be displayed as non-default value.
5/6/16:
Removed less than 25 mg/L default from all effluent and upstream hardness conditional programming
TotCh>50
≥
5/11/16:
Added new conditional display to Total Chromium Pred Cw box RPA page to compare Total Chromium data to Cr III and Cr VI Allowable Cw
Added new conditional display to Total Chromium Allowable Cw box RPA page to indicate maximum Total Chromium value entered
NC STANDARDS OR EPA CRITERIA
6/13/16:
Corrected INPUT tab to align Dats Source(s) text box at top.
Revised title block text RPA tab to state "NC STANDARDS OR EPA CRITERIA", removed "NC WQS" from Chronic label, and removed 1/2 FAV from Acute label.
Effluent Hardness Average (mg/L)
Upstream Hardness Average (mg/L)
6/14/16:
Revised conditions for calculated combined hardness acute and chroinc to default to 400 mg/L if calculated value exceeded 400 mg/L
Corrected label on DISS … page to indicate average for effluent and upstream hardness
Revised conditions for INPUT page display combined hardness acute and chroinc to indicate when default 400 mg/L applied
To appy a Model IWC %: Once the "Flow, Qw (MGD)" and and the "CHRONIC DILUTION FACTOR = " values are entered, the 7Q10s (cfs) flow is calculated and displayed. Enter the calculated "7Q10s
(cfs)" flow value in Table 1.
7/13/16:
User will need to enter calculated 7Q10s displayed in Model narrative box to Table 1 7Q10s, (cfs) entry box. 1Q10s is calculated once the calculated 7Q10s (cfs) is entered in Table1.

Revised Model input feature when activated to calculate Model 7Q10s (cfs) flow based on entry of Qw, MGD and CHRONIC DILITION FACTOR (from Model) and display in Model narrative box.
Revised narrative in Model narrative box with new instructions, new messages to alert user on actions needed and/or completed to correctly enter Model 7Q10s (cfs) in Table 1.
Remove conditions and features assocaited with entry of Model Acute IWC % .
Antimony
Barium
Sulfates
Thallum
Belews Steam Station
I
NC0024406
Dan River
WS-IV
no limit
add limit
003 -decanting
DMRs
evaluated separately

Must Designate One:

C = Carcinogen
NC = Non-carcinogen
WQS Standards Designate Applicable Standard:

A = Aesthetic Standard

FW = Freshwater Aquatic Life Standard

HH = Human Health Standard
for human consumption organism and water

TR = Trout Aquatic Life Standard

WS = Water Supply Standard
for human consumption water

This “npdes rpa” workbook was developed by and for the use of the North Carolina Division of Water Quality for the purpose of conducting Reasonable Potential Analyses under the NPDES
permit program. It is a working tool for DWQ staff and may be distributed to others at no charge so long as it contains this acknowledgement. Portions of the workbook are lightly protected
to prevent accidental alteration, and DWQ cannot guarantee that any copy so distributed is unaltered. Please contact the Point Source Branch to request an original copy.
</a:t></a:r><a:r><a:rPr lang="en-US" sz="1600" b="0" i
NCDWQ, 2009
Please see the 'user_guide' worksheet
for instructions on the use of this workbook.

CHECK IF HQW OR ORW WQS
CHECK TO APPLY MODEL
Apply WS Hardness WQC

DEFINE
DEFINE

Additional guidance on RPA 2010 revision v.Freshwater07282010:
I.
<
TABLE 1,
the Input page
:
a. The 1Q10 flow will automatically be determined when the 7Q10 is entered.
II. In
TABLE
2
, under the
Input page
, enter the parameter
Type
and
Modifier
as follows:

</a:t><
TYPE: MODIFIERS:
___
___________________________
<
C = Carcinogen
NC = Non-carcinogen
</a:t></a:r><
FW = Freshwater Aquatic Life Standards
<
</a:t></a:r><
A = Aesthetic
<
</a:t></a:r><
WS = Water Supply, human health associated with water & organism consumption
HH = Human Health associated with organism consumption</a:t></a:r><a:
</
III. When
entering sample results on the "data" sheet as shown to the right:
a. Data numbers (sample results) and &<'s can be copied and pasted but should be entered by clicking
Paste </a:
Special and Values.
b. If a PQL is listed, a sample result less than the PQL will be<
recognized at the PQL limit. Example
,
</a:
the PQL
for <
Cyanide
is
10 ug/L. Entering a
sample such as < 9
ug/L will result
in
a BDL=1/2

DL of

5 ug/L
because it recognizes the sample result is less than the PQL.
If you want the
sample to be recognized at that lower PQL level, d
ecrease or remove the PQL. In the example on the right, if you want the BDL=1/2

DL
to equal 4.5 the PQL on the Input Table for Cyanide would have to be removed or lowered.
IV. RPA sheet
and limit calculations:
Freshwater (FW)

To delete a parameter from the chart, simply click on the parameter number on the left , right click, hit delete and entire row.
Calculated limits are determined as follows:
a. Chronic and acute, Aquatic Life standards
for all parameters,
carcinogenic(C) or non-carcinogenic(NC),
will be divided by the 7Q10 and 1Q10, respectively.
b. Non-carcinogenic

(NC) parameters with
Human Health standards (HH and WS)
will be divided by the 7Q10
to give a chronic standard.

c
. Carcinogenic parameters with Human Health standards (HH and WS) will be divided by the mean annual average flow (QA) to give a chronic standard.
d. Parameters with
Aesthetic standards
such as Phenolic Compounds are divided by the 30Q2 flow.
Saltwater (S)
Go to the Saltwater RPA. All the rules
listed above are the same for saltwater aquatic life standards.
Instead of using FW (Freshwater) as the MODIFIER, use S (Saltwater).
If you would like No Dilution to be allowed, simply enter
the word
"<
Tidal"
under Stream Info.
on
Table 1
.

Dissolved to Total Metal Calculator
Do NOT enter any data directly into this spreadsheet.
Enter data onto “Table 1” under the Input Sheet and enter “Effluent Hardness” under the Data Sheet.
In accordance with 40 CFR 122.45 (c ), permits are, have and must be written as total metals.
This calculator has been inserted into the RPA to calculate Total Metal allowable allocations once Table 1 has been completed (Input Sheet) and Effluent hardness has been entered (Data
Sheet).
Following the spreadsheet from left to right. First the allowable allocations for the dissolved metals will appear for all the metals listed once Table 1 is complete
and effluent hardness entered. Use a default value of 25 mg/L if no hardness data is available. Second, the Dissolved Metal allocations are divided by the Translators
to determine the Total Metals that can be allocated to the Permittee. These Total Metals values are automatically inserted into Table 2 and are the allowable Total Metal allocations
determined for the Permittee prior to allowing for dilution. See Input sheet Table 2. The final acute and chronic values shown under the RPA sheet are the Total Metal values listed
in Table 2 divided by the acute and chronic IWC, respectively.

The
Translators
used in the freshwater RPA are the Partition Coefficients published by US EPA in 1984. They are TSS dependent equations and can be found listed with the WQS hardness dependent equations
under the sheet labeled Equations. A fixed TSS value of 10 mg/L is used to calculate the Translator values.

Pretreatment Facilities
–
PERCS will need a copy of the Dissolved to Total Metal Calculator spreadsheet and the RPA sheet along with the Final Permit.
Pretreatment Facilities are required to renew their Headwords Analysis after renewal of their permits. Since all their metal allocations are likely to change PERCS needs to see any
new metal permit limits and the allowable allocations for the dissolved metals to assess Maximum Allowable Headworks Loading (MAHL) numbers for each metal based on the Combined Hardness
values used in the permit writers RPA calculations.<
For Cadmium, Lead, Nickel, Chromium and Beryllium
, if all the effluent sampling data for the last three to five years shows the pollutant at concentrations less than the Practical Quantitative Level (PQL), it is not likely a limit
or monitoring will be put in the permit. However, if the estimated NPDES permit limit is less than the Practical Quantitative Limit (particularly, Cadmium and Lead) and the pollutant
is believed to be present, to assess compliance with the new standards and for future permit limit development, monitoring for the pollutant will be required. If the facility is monitoring
for the pollutant in its Pretreatment LTMP, no monitoring is needed in the permit.
For monitoring and compliance purposes
if Total Chromium < the Chromium VI chronic Total Metal limitation – no limit or monitoring is required.
</a:t></a:r></a:p></xdr:txBody></xdr:s

Example for Cadmium (streams)
Given
:
TSS
= 10 mg/L
Kpo
= 4.00E + 06
a
= -1.1307
Translator   = </a
1                             </a:t></a:r></a:p><a:p><a:pP
[1 + (Kpo * TSS </a:t></a:r><a:r><a:rPr lang="en
(1+
a
)
* 10
-6
)]
 </a:t></a:r><a:endPa
 = </a:t></a:r><a:r><a:
1                              </a:t></a:r></a:p><a:p><a:pP
 [1 + (4.00x10</a:t></a:r><a:r><a:rPr lang
6
* 10
1-1.1307)
* 10
-6
)]
 </a:t></a:r
 = </a:t></a:r><a:r><a:
1                              </a:t></a:r></a:p><a:p><a:pP
 [1+2.960465]</a:t></a:r></a:p><a:p><a:pPr algn="l" rtl
 </a:t></a:r><a:endPa
 = 0.252</a:t></a:r><a:endPa

Using the Tool
The general sequence of steps for completing the RPA is as follows:
Setup (‘in’ sheet)-Begin with a blank copy of the ‘npdes rpa 200403.xls’ file. (Permit writers: To generate a blank copy, double-click on the RPA template (‘npdes rpa 200403.xlt’)
or on the shortcut to the template, located on the NPDES server.)
-Enter the facility, receiving stream, and other project-specific information in Table 1 of the ‘in’ sheet. The information will automatically populate the ‘rpa’ sheet.
-Enter the parameter names, applicable standards, and other information for the Pollutants of Concern (POCs, up to 15) in Table 2 of the ‘in’ sheet. The POC names will automatically
populate both the ‘rpa’ and the ‘data’ sheets.
-Table 2 already includes relevant information on the most common parameters. Users can change the table’s contents to include different parameters or to adjust for a saltwater discharge.

DO NOT cut-and-paste or click-and-drag the existing POC cells in order to re-arrange them. Instead, copy-and-paste the cells, then go back and delete the originals. (Just trust me on
this.) -Hide any rows in the ‘rpa’ and ‘data’ sheets that are not needed for the RPA. The file includes a toolbar with custom to simplify this.
-Enter new POC information into the appropriate cells. Be sure to update all of the information for each parameter to be changed.
-Once the information is entered, you can sort it by Parameter (or whatever column you choose) to get it in the preferred order.
Data Entry -Prepare the raw effluent data for each POC and enter it in the appropriate columns in the ‘data’ sheet.
-There are three data columns for each parameter: the Date, the “<” indicator (if needed; any character will work), and the data value. Enter the data accordingly. It is sometimes easier
to use the ‘blank’ sheet or other sheet to arrange the raw data, and then copy it into the ‘data’ sheet.
-Values entered as “less than detection” using the “<” character (actually, any character in that column) will automatically be halved for the calculations that follow. The sheet also
counts any values less than the PQL (see Table 2 on the ‘in’ sheet) as “less than detection”.
User’s Guide
RPA Tool
March 21, 2009
The RPA Tool is an Excel workbook, ‘npdes rpa 200403.xls, developed and maintained by the NCDWQ’s NPDES Permitting Units. The Unit’ permit writers use the Tool to evaluate effluent data
from individual wastewater treatment plants and determine whether limits for certain pollutants of concern (typically, heavy metals, cyanide, and toxic organics) are warranted. It evaluates
the magnitude and variability of the data and determines whether there is a reasonable potential that the discharge will cause a contravention of applicable water quality standards
and criteria. If such reasonable potential is found, the permit writer uses the results of the analysis to determine appropriate permit limits for the parameter(s).
The Tool employs statistical methods described in the U.S. EPA’s Technical Support Document for Water Quality-based Toxics Control, March 1991, EPA/505/2-90-001, available for download
at http://yosemite.epa.gov/water/owrccatalog.nsf/e673c95b11602f2385256ae1007279fe/025cb4267d4d9fd585256b060072539a?OpenDocument&CartID=8774-040144.
Overview
The RPA workbook consists of six spreadsheets:
ack is the introductory screen and explains to terms of use of the RPA tool.
in is the initial data entry sheet for project-specific information and the pollutants of concern.
rpa is the main worksheet of the tool. It serves as a summary report of the RPA’s results and includes the permit writer’s recommendations for each parameter.
data contains the raw effluent data for each pollutant of concern. Most of the statistical calculations are carried out on this sheet.
mf table is the standard Multiplication Factor table used in the tool. The MF is a function of the number of samples (n) and the Coefficient of Variation (CV, the standard deviation
of a data set divided by its mean).
blank is a blank sheet which can be used to organize effluent data prior to entering the data in the ‘data’ sheet. Of course, you can add others if the need arises.
The first five sheets are “protected” to prevent unintentional (and undetected) changes in the spreadsheet’s programming or content. However, certain portions of the ‘in,’ ‘rpa,’ and
‘data’ sheets - highlighted in light blue - are unlocked for data entry.
Unfortunately, the “protect” feature in Excel prevents certain changes (some formatting, for instance) that would be useful and would not corrupt the workbook. To get around this, the
sheets include macros that allow the user to unlock (and re-lock) the sheets when changes are needed (more on that below).
Review Results-The ‘data’ sheet calculates the maximum predicted concentration for each POC and returns it to the ‘rpa’ sheet (Col. K). The ‘rpa’ sheet compares this result with the
maximum concentrations allowed by the acute standard (no instream dilution) and the chronic standard (dilution included) and reports whether the maximum predicted value is more than
or less than the maximum allowed (Col. L). It also presents an automated response, suggesting a permitting action based on these results.
Enter Recommendations - At this point, the permit writer must evaluate the results in the ‘rpa’ sheet, along with any other relevant factors, and recommend what limits and/or monitoring
to include in the new permit. Enter these notes in Column M.<
Misc. notes:
‘mf table’</w:t></w:r><w:r - n = 1-200, CV = 0.1-6.1- values based on 99% probability to not exceed, with 99% confidence
REASONABLE POTENTIAL ANALYSIS
Par05
Use "PASTE SPECIAL-
Values" then "COPY" .
Maximum data points = 58
Par06
Use "PASTE SPECIAL,
Values" then "COPY" .
Maximum data points
= 58
Par07
Use "PASTE SPECIAL-
Values" then "COPY" .
Maximum data points
= 58
Par08
Use "PASTE SPECIAL-
Values" then "COPY" .
Maximum data points
= 58
Par09
Use "PASTE SPECIAL -
Values" then "COPY" .
Maximum data points
= 58
Chlorides
Chlorinated Phenolic Compounds
Total Phenolic Compounds
Chromium Ill
Chromium VI
Date
Data BDL=1/2DL
Results
Date Data BDL=1/2DL Results
Date Data BDL=1/2DL
Results
Date Data BDL=1/2DL Results
Date Data BDL=1/2DL Results
1
570
570
Std Dev.
66.6815
1
Std Dev.
NO DATA
1
7.3
7.3
Std Dev.
0.0000
1
Std Dev.
NO DATA
1
Std Dev.
NO DATA
2
620
620
Mean 519.9
2
Mean NO DATA
2
Mean 7.3000
2
Mean NO DATA
2
Mean NO DATA
3
600
600
C.V. 0.1283
3
C.V. NO DATA
3
C.V. (default) 0.6000
3
C.V. NO DATA
3
C.V. NO DATA
4
590
590
n 34
4
n 0
4
n 1
4
n 0
4
n 0
5
550
550
5
5
5
5
6
560
560
Mult Factor = 1.0
6
Mult Factor = N/A
6
Mult Factor = 6.20
6
Mult Factor = N/A
6
Mult Factor = N/A
7
520
520
Max. Value 650.0 mg/L
7
Max. Value N/A ug/L
7
Max. Value 7.3 ug/L
7
Max. Value N/A pg/L
7
Max. Value N/A pg/L
8
560
560
Max. Pred Cw 669.5 mg/L
8
Max. Pred Cw N/A ug/L
8
Max. Pred Cw 45.3 ug/L
8
Max. Pred Cw N/A pg/L
8
Max. Pred Cw N/A pg/L
9
620
620
9
9
9
9
10
650
650
10
10
10
10
11
590
590
11
11
11
11
12
590
590
12
12
12
12
13
560
560
13
13
13
13
14
560
560
14
14
14
14
15
480
480
15
15
15
15
16
540
540
16
16
16
16
17
540
540
17
17
17
17
18
460
460
18
18
18
18
19
430
430
19
19
19
19
20
510
510
20
20
20
20
21
520
520
21
21
21
21
22
420
420
22
22
22
22
23
430
430
23
23
23
23
24
501
501
24
24
24
24
25
520
520
25
25
25
25
26
428
428
26
26
26
26
27
540
540
27
27
27
27
28
470
470
28
28
28
28
29
360
360
29
29
29
29
30
471.8
471.8
30
30
30
30
31
469.5
469.5
31
31
31
31
32
480.1
480.1
32
32
32
32
33
479.7
479.7
33
33
33
33
34
485.1
485.1
34
34
34
34
35
35
35
35
35
36
36
36
36
36
37
37
37
37
37
38
38
38
38
38
39
39
39
39
39
40
40
40
40
40
41
41
41
41
41
42
42
42
42
42
43
43
43
43
43
44
44
44
44
44
45
45
45
45
45
46
46
46
46
46
47
47
47
47
47
48
48
48
48
48
49
49
49
49
49
50
50
50
50
50
51
51
51
51
51
52
52
52
52
52
53
53
53
53
53
54
54
54
54
54
55
55
55
55
55
56
56
56
56
56
57
57
57
57
57
58
58
58
58
58
- 4 -
NC0024406_Worksheets 003 decanting_20190322, data
8/13/2021

REASONABLE POTENTIAL ANALYSIS
Par10
Use "PASTE SPECIAL,
Values" then "COPY" .
Maximum data points
= 58
Pall
Use "PASTE SPECIAL,
Values" then "COPY" .
Maximum data points
= 58
Par12
Use "PASTE SPECIAL-
Values" then "COPY" .
Maximum data points
= 58
Par13
Use "PASTE SPECIAL-
Values" then "COPY" .
Maximum data points
= 58
Par14
Use "PASTE SPECIAL -
Values" then "COPY" .
Maximum data points
= 58
Chromium, Total
Copper
Cyanide
Fluoride
Lead
Date Data
BDL=1/2DL
Results
Date Data
BDL=1/2DL
Results
Date Data
BDL=1/2DL
Results
Date Data BDL=1/2DL
Results
Date
BDL=1/2DL
Results
1 <
1
0.5
Std Dev.
0.0000
1
<
5
2.5
Std Dev.
171.0695
1
<
10
5
Std Dev.
0.0000
1
1000
1000
Std Dev.
134.6185
1
48.3
48.3
Std Dev.
37.1006
2 <
1
0.5
Mean 0.5000
2
<
5
2.5
Mean 32.5291
2
Mean 5.00
2
700
700
Mean 796.9565
2
64.3
64.3
Mean 39.0400
3 <
1
0.5
C.V. (default) 0.6000
3
<
5
2.5
C.V. 5.2590
3
C.V. (default) 0.6000
3
900
900
C.V. 0.1689
3
81.6
81.6
C.V. (default) 0.6000
4 <
1
0.5
n 5
4
<
5
2.5
n 32
4
n 1
4
900
900
n 23
4
<
1
0.5
n 5
5 <
1
0.5
5
<
5
2.5
5
5
1000
1000
5
<
1
0.5
6
Mult Factor = 2.32
6
<
5
2.5
Mult Factor = 1.73
6
Mult Factor = 6.20
6
900
900
Mult Factor = 1.08
6
Mult Factor = 2.32
7
Max. Value 0.5 pg/L
7
<
5
2.5
Max. Value 970.00 ug/L
7
Max. Value 5.0 ug/L
7
900
900
Max. Value 1000.0 ug/L
7
Max. Value 81.600 ug/L
8
Max. Pred Cw 0 DETECTS pg/L
8
<
5
2.5
Max. Pred Cw 1678.10 ug/L
8
Max. Pred Cw 0 DETECTS ug/L
8
800
800
Max. Pred Cw 1080.0 ug/L
8
Max. Pred Cw 189.312 ug/L
9
9
<
5
2.5
9
9
800
800
9
10
10
<
5
2.5
10
10
900
900
10
11
11
<
5
2.5
11
11
700
700
11
12
12
<
5
2.5
12
12
700
700
12
13
13
<
5
2.5
13
13
600
600
13
14
14
<
5
2.5
14
14
900
900
14
15
15
<
5
2.5
15
15
900
900
15
16
16
<
5
2.5
16
16
900
900
16
17
17
<
5
2.5
17
17
600
600
17
18
18
<
5
2.5
18
18
600
600
18
19
19
<
5
2.5
19
19
700
700
19
20
20
<
5
2.5
20
20
900
900
20
21
21
1
1
21
21
800
800
21
22
22
<
5
2.5
22
22
600
600
22
23
23
970
970
23
23
630
630
23
24
24
<
5
2.5
24
24
24
25
25
<
5
2.5
25
25
25
26
26
<
5
2.5
26
26
26
27
27
<
5
2.5
27
27
27
28
28
1.19
1.19
28
28
28
29
29
1.46
1.46
29
29
29
30
30
1.71
1.71
30
30
30
31
31
1.69
1.69
31
31
31
32
32
1.38
1.38
32
32
32
33
33
33
33
33
34
34
34
34
34
35
35
35
35
35
36
36
36
36
36
37
37
37
37
37
38
38
38
38
38
39
39
39
39
39
40
40
40
40
40
41
41
41
41
41
42
42
42
42
42
43
43
43
43
43
44
44
44
44
44
45
45
45
45
45
46
46
46
46
46
47
47
47
47
47
48
48
48
48
48
49
49
49
49
49
50
50
50
50
50
51
51
51
51
51
52
52
52
52
52
53
53
53
53
53
54
54
54
54
54
55
55
55
55
55
56
56
56
56
56
57
57
57
57
57
58
58
58
58
58
- 5 -
NC0024406_Worksheets 003 decanting_20190322, data
8/13/2021

REASONABLE POTENTIAL ANALYSIS
Par15
Use "PASTE SPECIAL,
Par16
Use "PASTE SPECIAL,
Par17 & Par18
Use "PASTE SPECIAL-
Par19
Use "PASTE SPECIAL-
Par20
Use "PASTE SPECIAL -
Values" then "COPY" .
Values" then "COPY" .
Values" then "COPY" .
Values" then "COPY" .
Values" then "COPY" .
Mercury
Maximum data points
Molybdenum
Maximum data points
Nickel
Maximum data points
Selenium
Maximum data points
Silver
Maximum data points
= 58
= 58
= 58
= 58
= 58
Date
Data BDL=1/2DL
Results
Date
Data
BDL=1/2DL
Results
Date Data
BDL=1/2DL
Results
Date
Data BDL=1/2DL
Results
Date
Data BDL=1/2DL
Results
1
Std Dev.
NO DATA
1
22
22
Std Dev.
11.0647
1
2.07
2.07
Std Dev.
2.2154
N 00 00 M I` Ln CO M CO U0 U0 CO O7 O7 O7 up M up CO I` M CD Ns O7 O7 U0 I` O 00 I`
I` O ti Cfl
Ln C'') C'') lf') 6QD QD 6 64 4 4 C'') N 4 4 CO QD 6 6 6 6 64 64 d7 6 6 I` ti 00 I` d7 O
QD ti QD QD O7
N CO CO M N- LO CO M CO L0 L0 CO O7 O7 O7 up 00 up CO I` M O7 Ns O7 O7 L0 I` O 00 I`
I` O Ns Cfl
l� C'') CO lf') 6Cfl QD 6 64 4 4 C'') N 4 4 CO CO 6 6 lf') lf') lf') 4 6� d7 lf') lf') I` ti 00 I` d7 O
QD ti QD QD O7
N CO (0 CO I` 00 O7 O N CO (0 CO I` 00 O7 O N CO (0 CO I` 00 O7 O N CO (0 CO I` 00 O7 O N CO (0 CO I` 00 O7 O N CO (0 CO I` 00
N N N N N N N N N N CO CO CO CO CO CO CO CO CO CO (0 up (0 up (0 up (0 up (0
O O O O O O O O O O O O O O O O O N O O O O O
N
V V V V V V V V V V V V V V V V V V V V V V
N CO Lc, CO ti CO O) O ,- N CO Lc, QD ti CO O) O ,- N CO Lc, QD ti CO O) O ,- N CO Lc, QD ti CO O7 O ,- N CO Lc, QD ti CO O7 O ,- N CO Lc, QD ti CO
N N N N N N N N N N CO CO CO CO CO CO CO CO CO CO lf) lf) lf) lf) lf) lf) lf) lf) lf)
2
Mean NO DATA
2
25
25
Mean 22.9667
2
4.24
4.24
Mean 5.0918
3
C.V. NO DATA
3
16
16
C.V. (default) 0.6000
3
5.41
5.41
C.V. 0.4351
4
n 0
4
16.3
16.3
n 6
4
6.4
6.4
n 11
5
5
14.5
14.5
5
1.48
1.48
6
Mult Factor = N/A
6
44
44
Mult Factor = 2.14
6
4.92
4.92
Mult Factor = 1.48
7
Max. Value N/A ng/L
7
Max. Value 44.0 ug/L
7
6.19
6.19
Max. Value 9.9 pg/L
8
Max. Pred Cw N/A ng/L
8
Max. Pred Cw 94.2 ug/L
8
5.23
5.23
Max. Pred Cw 14.6 pg/L
9
9
9
5.3
5.3
10
10
10
4.88
4.88
11
11
11
9.89
9.89
12
12
12
13
13
13
14
14
14
15
15
15
16
16
16
17
17
17
18
18
18
19
19
19
20
20
20
21
21
21
22
22
22
23
23
23
24
24
24
25
25
25
26
26
26
27
27
27
28
28
28
29
29
29
30
30
30
31
31
31
32
32
32
33
33
33
34
34
34
35
35
35
36
36
36
37
37
37
38
38
38
39
39
39
40
40
40
41
41
41
42
42
42
43
43
43
44
44
44
45
45
45
46
46
46
47
47
47
48
48
48
49
49
49
50
50
50
51
51
51
52
52
52
53
53
53
54
54
54
55
55
55
56
56
56
57
57
57
58
58
58
- 6 -
NC0024406_Worksheets 003 decanting_20190322, data
8/13/2021

REASONABLE POTENTIAL ANALYSIS
Par21
Use "PASTE SPECIAL,
then "COPY" .
Maximum data points
= 58
Par22
Use "PASTE SPECIAL,
Values" then "COPY" .
Maximum data points
= 58
Par23
Use "PASTE SPECIAL-
Values" then "COPY" .
Maximum data points
= 58
Par24
Use "PASTE SPECIAL-
Values" then "COPY" .
Maximum data points
= 58
Par25
Use "PASTE SPECIAL-
Values" then "COPY" .
Maximum data points
= 58
ZincValues"
Antimony
Barium
Sulfates
Thallum
Date Data
BDL=1/2DL
Results
Date Data
BDL=1/2DL
Results
Date
Data BDL=1/2DL
Results
Date Data BDL=1/2DL
Results
Date Data BDL=1/2DL
Results
1
2
2
Std Dev.
4.3417
1
1.22
1.22
Std Dev.
0.4387
1
0.075
0.075
Std Dev.
0.0108
1
160
160
Std Dev.
27.5124
1 1.35
1.35
Std Dev.
0.3652
2
6.75
6.75
Mean 7.1518
2
1.37
1.37
Mean 0.8180
2
0.076
0.076
Mean 0.0802
2
150
150
Mean 148.5759
2 1.09
1.09
Mean 0.9020
3
9.67
9.67
C.V. 0.6071
3
<
1
0.5
C.V. (default) 0.6000
3
0.077
0.077
C.V. (default) 0.6000
3
150
150
C.V. 0.1852
3 0.588
0.588
C.V. (default) 0.6000
4
5.25
5.25
n 11
4
<
1
0.5
n 5
4
0.077
0.077
n 6
4
150
150
n 58
4 0.583
0.583
n 6
5 <
1
0.5
5
<
1
0.5
5
0.074
0.074
5
140
140
5 0.561
0.561
6 <
5
2.5
Mult Factor = 1.69
6
Mult Factor = 2.32
6
0.102
0.102
Mult Factor = 2.14
6
160
160
Mult Factor = 1.00
6 1.24
1.24
Mult Factor = 2.14
7
6
6
Max. Value 13.0 ug/L
7
Max. Value 1.370000 pg/L
7
Max. Value 0.102000 mg/L
7
150
150
Max. Value 310.000000 mg/L
7
Max. Value 1.350000 pg/L
8
12
12
Max. Pred Cw 22.0 ug/L
8
Max. Pred Cw 3.178400 pg/L
8
Max. Pred Cw 0.218280 mg/L
8
170
170
Max. Pred Cw 310.000000 mg/L
8
Max. Pred Cw 2.889000 pg/L
9
12
12
9
9
9
160
160
9
10
9
9
10
10
10
170
170
10
11
13
13
11
11
11
150
150
11
12
12
12
12
140
140
12
13
13
13
13
150
150
13
14
14
14
14
140
140
14
15
15
15
15
150
150
15
16
16
16
16
150
150
16
17
17
17
17
150
150
17
18
18
18
18
310
310
18
19
19
19
19
230
230
19
20
20
20
20
150
150
20
21
21
21
21
150
150
21
22
22
22
22
140
140
22
23
23
23
23
140
140
23
24
24
24
24
140
140
24
25
25
25
25
140
140
25
26
26
26
26
150
150
26
27
27
27
27
140
140
27
28
28
28
28
150
150
28
29
29
29
29
140
140
29
30
30
30
30
140
140
30
31
31
31
31
140
140
31
32
32
32
32
120
120
32
33
33
33
33
140
140
33
34
34
34
34
150
150
34
35
35
35
35
140
140
35
36
36
36
36
130
130
36
37
37
37
37
130
130
37
38
38
38
38
140
140
38
39
39
39
39
140
140
39
40
40
40
40
130
130
40
41
41
41
41
120
120
41
42
42
42
42
120
120
42
43
43
43
43
140
140
43
44
44
44
44
150
150
44
45
45
45
45
140
140
45
46
46
46
46
150
150
46
47
47
47
47
140
140
47
48
48
48
48
150
150
48
49
49
49
49
140
140
49
50
50
50
50
170
170
50
51
51
51
51
170
170
51
52
52
52
52
160
160
52
53
53
53
53
160
160
53
54
54
54
54
147.9
147.9
54
55
55
55
55
137.5
137.5
55
56
56
56
56
116.6
116.6
56
57
57
57
57
117.9
117.9
57
58
58
58
58
117.5
117.5
58
- 7 -
NC0024406_Worksheets 003 decanting_20190322, data
8/13/2021

Belews Steam Station
NC0024406
Qw (MGD) = 18.60
1Q1OS (cfs) = 65.40
7Q 10S (cfs) = 80.00
7Q 10W (cfs) = 160.00
30Q2 (cfs) = 195.00
Avg. Stream Flow, QA (cfs) = 576.00
Receiving Stream: Dan River HUC WS-IV
Freshwater RPA - 95% Probability/95% Confidence Using Metal Translators
MAXIMUM DATA POINTS = 58
WWTP/WTP Class:
IWC% @ 1Q1OS = 30.5953518
IWC% @ 7Q 10S = 26.4908573
IWC% @ 7Q 1 OW = 15.26770111
IWC% @ 30Q2 = 12.88031095
IW%C @ QA = 4.766628639
Stream Class:
Outfall 003 -decanting
Qw=18.6MGD
COMBINED HARDNESS (mg/L)
Acute = 25 mg/L
Chronic = 25 mg/L
YOU HAVE DESIGNATED THIS RECEIVING
STREAM AS WATER SUPPLY
Effluent Hard: 0 value > 100 mg/L
Effluent Hard Avg = 25 mg/L
PARAMETER
TYPE
(1)
NC STANDARDS OR EPA CRITERIA
_i
a
N
H
REASONABLE POTENTIAL RESULTS
RECOMMENDED ACTION
Chronic Applied Acute
Standard
rl # Det. Max Pred Cw Allowable Cw
Arsenic
Arsenic
C
C
150 FW(7Q10s) 340
10 HH/WS(Qavg)
ug/L
ug/L
29 29
9.7
Acute (FW): 1,111.3
_ _ _ __ _ ______________________________
Chronic (FW)_566.2
Novalue > Allowable Cw______________________________
Chronic (HH): 209.8
No value > Allowable Cw
no limit
Cadmium
NC
0.5899 FW(7Q10s) 3.2396
ug/L
6 1
Note: n < 9
Limited data set
1.070
Default C.V.
Acute: 10.589
_ _ _ _ _ _ _ _ _ _______________________________
Chronic: 2.227
No value > Allowable Cw
no limit
Chlorides
NC
250 WS(7Q10s)
mg/L
34 34
669.5
Acute: NO WQS
—_ _ _ _
-Chronic: ---- 943.7 -—
No value > Allowable Cw
no limit
-—-—-—-—-—-—-—-—-—-—-—-—-—-—
Chromium III
NC
117.7325 FW(7Q10s) 905.0818
µg/L
0 0
N/A
Acute: 2,958.2
--Chron_ _
ic: - — -— 444.4 -—
no limit
-—-—-—-—-—-—-—-—-—-—-—-—-—-—
Chromium VI
NC
11 FW(7Q10s) 16
µg/L
0 0
N/A
Acute: 52.3
Chronic:-----41.5 ------------------------------
no limit
Chromium, Total
NC
µg/L
5 0
Note: n < 9
Limited data set
NO DETECTS
Max MDL = 1
no limit
Copper
NC
7.8806 FW(7Q10s) 10.4720
ug/L
32 7
1,678.10
Acute: 34.23
—_ _ ---- _ _
-Chronic: 29.75 ------------------------------
1 value(s) > Allowable Cw
add limit
Fluoride
NC
1800 FW(7Q10s)
ug/L
23 23
1,080.0
Acute: NO WQS
Chronic: 6,794.8
No value > Allowable Cw
no limit
Lead
NC
2.9416 FW(7Q10s) 75.4871
ug/L
5 3
Note: n < 9
Limited data set
189.312
Default C.V.
Acute: 246.727
___ _ ____ _ ____add
Chronic: 11.104
3 value(s) > Allowable Cw
limit
___________________________
Page 8 of 21
NC0024406_Worksheets 003 decanting_20190322, rpa
8/13/2021

Belews Steam Station
NC0024406
Freshwater RPA - 95% Probability/95% Confidence Using Metal Translators
Outfall 003 -decanting
Qw=18.6MGD
Mercury
NC
12 FW(7Q10s)
0.5
ng/L
0 0
N/A
Acute: NO WQS
Chronic:-----45.3 -----------------------------
evaluated separately
Molybdenum
NC
160 WS(7Q10s)
ug/L
6 6
Note: n < 9
Limited data set
94.2
Default C.V.
Acute: NO WQS
___ _ ____ _ ______________________________
Chronic: 604.0
No value > Allowable Cw
no limit
Nickel
Nickel
NC
NC
37.2313 FW(7Q10s) 335.2087
25.0000 WS(7Q10s)
µg/L
µg/L
11 11
14.6
Acute (FW): 1,095.6
_ _ _ ____ ______________________________
Chronic (FW)_140.5
No value > Allowable Cw__
Chronic (WS): 94.4
No value > Allowable Cw
no limit
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
Selenium
NC
5 FW(7Q10s) 56
ug/L
43 43
11.1
Acute: 183.0
Chronic:-----18.9 -----------------------------
No value > Allowable Cw
no limit
Zinc
NC
126.7335 FW(7Q10s) 125.7052
ug/L
11 9
22.0
Acute: 410.9
--Chron_ _
ic: - — -— 47_8.4 -----------------------------
No value > Allowable Cw
no limit
Antimony
NC
5.6 WS(7Q10s)
µg/L
5 2
Note: n < 9
Limited data set
3.17840
Default C.V.
Acute: NO WQS
___ _ ____ _ _ _____________________________
Chronic: 21.13937
No value > Allowable Cw
no limit
Barium
NC
1 WS(7Q10s)
mg/L
6 6
Note: n < 9
Limited data set
0.21828
Default C.V.
Acute: NO WQS
___ _ ____ _ ______________________________
Chronic: 3.77489
No value > Allowable Cw
no limit
Sulfates
NC
250 WS(7Q10s)
mg/L
58 58
310.00000
Acute: NO WQS
Chronic: --- 943.72182
No value > Allowable Cw
no limit
Thallum
NC
2 HH(7Q10s)
µg/L
6 6
Note: n < 9
Limited data set
2.88900
Default C.V.
Acute: NO WQS
_ _ _ _ _ _ _ _ ______________________________
Chronic: 7.54977
No value > Allowable Cw
no limit
Page 9 of 21
NC0024406_Worksheets 003 decanting_20190322, rpa
8/13/2021

Monitoring Frequencies
2B .0500 Effluent Limited
pH E
Temp, C E
BOD5 I, E
TSS I, E
NH3-N E
Fecal Col. E
TN E
TP E
Water Quality Limited
Parameter Location
D.O.
D.O.
pH
Temp, C
Temp, C
BOD5
TSS
NH3-N
TRC
Fecal Col.
Fecal Col.
Conductivi
Conductivi
TN
TP
E
U, D
E
E
U, D
I, E
I, E
E
E
E
U, D
E
U, D
E
E
2/Month
1/Week
2/Month
2/Month
1/Month
2/Month
1/Week 3/Week
1/Week 3/Week
1/Week 3/Week
1/Week 3/Week
2/Month 1/Week
1/Week 3/Week
See notes below.
See notes below.
Frequency
Daily
Daily
Daily
Daily
3/Week
Daily
Class I
1/Week
1/Week
2/Month
Daily
1/Week
2/Month
2/Month
1/Month
2/Week
2/Month
2/Month
1/Week
1/Week
Class II
1/Week
1/Week
1/Week
Daily
1/Week
1/Week
1/Week
2/Month
2/Week
1/Week
1/Week
1/Week
Class III
3/Week
3/Week*
3/Week
Daily
3/Week*
3/Week
3/Week
1/Week
3/Week
3/Week
3/Week*
3/Week
1/Week 3/Week*
See notes below.
See notes below.
Class IV
Daily
3/Week*
Daily
Daily
3/Week*
Daily
Daily
3/Week
Daily
Daily
3/Week*
Daily
3/Week*
Notes:
* Upstream and downstream monitoring in WQ-limited waters is to be conducted
3/Week during Jun, Jul, Aug, and Sep; and 1/Week during the rest of the year.
TN, TP Monitoring
All facilities >= 0.05 MGD will monitor TN and TP
Those < 0.05 MGD will monitor if discharging to NSW
For the Neuse, Tar -Pamlico, and any other river basins classified as NSW, use limits
and monitoring requirements according to the basin's permitting strategy.
For French Broad, Broad, Savannah, New Watauga, Little Tennessee, and Hiwassee:
- >= 0.05 M - monitor semi-annually
- >= 1.0 MG - monitor quarterly
For all other river basins:
- >= 0.05 M - monitor quarterly
- >= 1.0 MG - monitor monthly
Per Memo Dated 7-15-2010
RPA Condition
Pennit Monitoring Frequency
1 RPA Exists
Monitor Monthly and add Permit Limit
2.RPA Exists but Action Levels (Cu, Zn, Ag ,Fe, Cl)
Monitor Quarterly in conjunction with Tox Test
3a.RPA Exists but Dataset Limited (n< 8 samples)
3b. RPA exists, dataset limited, but 2 values >
allowable Cw
Monitor Quarterly
Monitor Monthly and add Permit Limit
4.No RPA (Predicted Max > 50% of Allowable)
Monitor Quarterly (or defer to Pretreat LTMP)
5.NoRPA (Predicted Max < 50% Allowable)
No Monitoring
6a.No Data (New Permit, New Waste Stream)
6b. New Greensand or Conventional WTP
Monitor Monthly for Toxic Pollutants of Concern
Monitor Quarterly for Toxic Pollutants of Concern
password all sheets = rpa2016a
4/28/16: Note Action Level designation no longer allowed per EPA.
Msg00
Msg01
Msg02
Msg03
Msg04
Msg05
Msg06
Msg07
Msg08
Msg09
Msg10
< No Data Entered >
MaxPredCw < Acute
MaxPredCw < Chronic
MaxPredCw « Acute
MaxPredCw « Chronic
MaxPredCw > Acute
MaxPredCw > Chronic
MaxPredCw » Acute
MaxPredCw » Chronic
No acute standard or 1/2 FAV
No chronic standard or criterion
NO DATA
MONITOR?
MONITOR?
REMOVE?
REMOVE?
DAILY MAX LIMIT?
MO AVG LIMIT?
DAILY MAX LIMIT?
MO AVG LIMIT?
N/A
N/A
Sample recommendations:
Daily max limit
Monitor 1/month
Monitor 1/week
Monitor 2/month
Monitoring not necessary in permit
No limit
No limit - assuming no tox (Action Level parameter)
No limit (Action Level parameter)
Continue to monitor at 2/month
Mo. avg. limit (keep wk. avg. if existing)
Revise daily max. limit

Reasonable Potential Multiplying Factors - Calculator
95.0%
Confidence Level
Upper Boundary of the Effluent Distribution (Percentile Value Not To Exceed)
95.0%
Coefficient of Variation
Coefficient of Variation
n
0.0
0.1
0.2
0.3
0.4
0.5
0.6
0.7
0.8
0.9
1.0
1.1
1.2
1.3
1.4
1.5
1.6
1.7
1.8
1.9
2.0
2.1
2.2
2.3
2.4
2.5 2.6
2.7
2.8
2.9
3.0 3.1
3.2
3.3
3.4
3.5 3.6
3.7
3.8
3.9
4.0 4.1
4.2
1
1.00
1.39
1.92
2.63
3.55
4.73
6.20
7.98
####
12.60
1.4i
18.72
22.35
26.38
30.78
35.57
40.73
46.26
52.14
58.37
64.94
71.84
79.06
86.58
94.41
102.53
#####
119.62
128.56
137.76
147.21
156.91
16b.84
177.00
187.38
197.98
208.78
219.79
231.00
242.40
253.99
265.76
277.71
2
1.00
1.27
1.61
2.03
2.53
3.11
3.79
4.57
5.43
6.38
7.41
8.51
9.69
10.94
12.25
13.61
15.03
16.49
18.00
19.55
21.14
22.75
24.40
26.08
27.79
29.51
31.26
33.03
34.82
36.63
38.45
40.28
42.13
43.99
45.86
47.74
49.64
51.54
53.44
55.36
57.28
59.21
61.15
3
1.00
1.22
1.48
1.79
2.15
2.55
3.00
3.49
4.03
4.60
5.20
5.84
6.49
7.17
7.87
8.59
9.32
10.06
10.81
11.58
12.34
13.12
13.90
14.68
15.46
16.25
17.04
17.83
18.62
19.41
20.21
21.00
21.79
22.58
23.36
24.15
24.94
25.72
26.50
27.28
28.06
28.84
29.61
4
1.00
1.19
1.40
1.65
1.93
2.25
2.59
2.95
3.34
3.74
4.16
4.60
5.04
5.50
5.96
6.42
6.89
7.36
7.84
8.31
8.79
9.26
9.73
10.20
10.68
11.14
11.61
12.07
12.54
13.00
13.45
13.91
14.36
14.81
15.25
15.70
16.14
16.58
17.01
17.44
17.87
18.30
18.72
5
1.00
1.16
1.35
1.56
1.80
2.05
2.32
2.61
2.91
3.23
3.55
3.87
4.21
4.54
4.88
5.21
5.55
5.89
6.22
6.56
6.89
7.22
7.54
7.87
8.19
8.51
8.82
9.13
9.44
9.75
10.05
10.36
10.65
10.95
11.24
11.53
11.82
12.10
12.38
12.66
12.94
13.21
13.48
6
1.00
1.15
1.31
1.50
1.70
1.91
2.14
2.38
2.63
2.88
3.14
3.40
3.66
3.92
4.18
4.44
4.70
4.96
5.21
5.46
5.71
5.96
6.20
6.44
6.68
6.91
7.14
7.37
7.60
7.82
8.04
8.25
8.47
8.68
8.89
9.10
9.30
9.50
9.70
9.90
10.09
10.29
10.48
7
1.00
1.13
1.28
1.45
1.62
1.81
2.01
2.21
2.42
2.63
2.84
3.06
3.27
3.48
3.69
3.90
4.11
4.32
4.52
4.72
4.91
5.10
5.29
5.48
5.67
5.85
6.02
6.20
6.37
6.54
6.71
6.88
7.04
7.20
7.36
7.51
7.67
7.82
7.97
8.12
8.26
8.41
8.55
8
1.00
1.12
1.26
1.40
1.56
1.73
1.90
2.07
2.25
2.44
2.62
2.80
2.98
3.16
3.33
3.51
3.68
3.85
4.01
4.17
4.33
4.49
4.64
4.79
4.94
5.09
5.23
5.37
5.51
5.64
5.78
5.91
6.03
6.16
6.29
6.41
6.53
6.65
6.77
6.88
6.99
7.11
7.22
9
1.00
1.11
1.24
1.37
1.51
1.66
1.81
1.97
2.12
2.28
2.44
2.60
2.75
2.90
3.05
3.20
3.34
3.49
3.62
3.76
3.89
4.02
4.15
4.27
4.40
4.52
4.63
4.75
4.86
4.97
5.08
5.19
5.29
5.40
5.50
5.60
5.69
5.79
5.88
5.98
6.07
6.16
6.25
10
1.00
1.10
1.22
1.34
1.47
1.60
1.74
1.88
2.02
2.16
2.30
2.43
2.57
2.70
2.83
2.95
3.08
3.20
3.32
3.43
3.55
3.66
3.77
3.87
3.97
4.07
4.17
4.27
4.36
4.46
4.55
4.64
4.72
4.81
4.89
4.97
5.06
5.13
5.21
5.29
5.36
5.44
5.51
11
1.00
1.10
1.20
1.32
1.43
1.55
1.68
1.80
1.93
2.05
2.18
2.30
2.41
2.53
2.64
2.75
2.86
2.97
3.07
3.17
3.27
3.36
3.46
3.55
3.63
3.72
3.80
3.89
3.97
4.05
4.12
4.20
4.27
4.34
4.41
4.48
4.55
4.62
4.68
4.75
4.81
4.87
4.94
12
1.00
1.09
1.19
1.29
1.40
1.51
1.63
1.74
1.85
1.96
2.07
2.18
2.29
2.39
2.49
2.59
2.68
2.78
2.87
2.95
3.04
3.12
3.20
3.28
3.36
3.43
3.50
3.57
3.64
3.71
3.78
3.84
3.90
3.97
4.03
4.09
4.15
4.20
4.26
4.31
4.37
4.42
4.47
13
1.00
1.09
1.18
1.27
1.37
1.48
1.58
1.68
1.79
1.89
1.99
2.08
2.18
2.27
2.36
2.45
2.53
2.61
2.69
2.77
2.84
2.92
2.99
3.06
3.12
3.19
3.25
3.31
3.37
3.43
3.49
3.55
3.60
3.66
3.71
3.76
3.81
3.86
3.91
3.96
4.00
4.05
4.09
14
1.00
1.08
1.17
1.26
1.35
1.44
1.54
1.63
1.73
1.82
1.91
2.00
2.08
2.17
2.25
2.32
2.40
2.47
2.54
2.61
2.68
2.74
2.81
2.87
2.93
2.98
3.04
3.09
3.15
3.20
3.25
3.30
3.35
3.39
3.44
3.48
3.53
3.57
3.61
3.66
3.70
3.74
3.77
15
1.00
1.08
1.16
1.24
1.33
1.41
1.50
1.59
1.68
1.76
1.84
1.92
2.00
2.07
2.15
2.22
2.29
2.35
2.41
2.48
2.54
2.59
2.65
2.70
2.76
2.81
2.86
2.91
2.95
3.00
3.04
3.09
3.13
3.17
3.21
3.25
3.29
3.33
3.36
3.40
3.44
3.47
3.51
16
1.00
1.07
1.15
1.23
1.31
1.39
1.47
1.55
1.63
1.71
1.78
1.85
1.93
1.99
2.06
2.12
2.19
2.24
2.30
2.36
2.41
2.46
2.51
2.56
2.61
2.65
2.70
2.74
2.78
2.83
2.86
2.90
2.94
2.98
3.01
3.05
3.08
3.12
3.15
3.18
3.21
3.24
3.28
17
1.00
1.07
1.14
1.21
1.29
1.36
1.44
1.51
1.59
1.66
1.73
1.79
1.86
1.92
1.98
2.04
2.10
2.15
2.20
2.25
2.30
2.35
2.39
2.44
2.48
2.52
2.56
2.60
2.64
2.67
2.71
2.74
2.78
2.81
2.84
2.87
2.90
2.93
2.96
2.99
3.02
3.05
3.08
18
1.00
1.06
1.13
1.20
1.27
1.34
1.41
1.48
1.55
1.62
1.68
1.74
1.80
1.86
1.91
1.97
2.02
2.07
2.11
2.16
2.20
2.25
2.29
2.33
2.36
2.40
2.44
2.47
2.51
2.54
2.57
2.60
2.63
2.66
2.69
2.72
2.75
2.77
2.80
2.83
2.85
2.88
2.90
19
1.00
1.06
1.12
1.19
1.26
1.32
1.39
1.45
1.51
1.58
1.64
1.69
1.75
1.80
1.85
1.90
1.95
1.99
2.03
2.08
2.12
2.15
2.19
2.23
2.26
2.30
2.33
2.36
2.39
2.42
2.45
2.48
2.51
2.53
2.56
2.58
2.61
2.63
2.66
2.68
2.70
2.72
2.75
20
1.00
1.06
1.12
1.18
1.24
1.30
1.36
1.42
1.48
1.54
1.59
1.65
1.70
1.75
1.79
1.84
1.88
1.92
1.96
2.00
2.04
2.07
2.11
2.14
2.17
2.20
2.23
2.26
2.29
2.31
2.34
2.37
2.39
2.42
2.44
2.46
2.48
2.51
2.53
2.55
2.57
2.59
2.61
21
1.00
1.05
1.11
1.17
1.23
1.29
1.34
1.40
1.45
1.51
1.56
1.61
1.65
1.70
1.74
1.78
1.82
1.86
1.90
1.93
1.96
2.00
2.03
2.06
2.09
2.12
2.14
2.17
2.19
2.22
2.24
2.27
2.29
2.31
2.33
2.35
2.37
2.39
2.41
2.43
2.45
2.47
2.49
22
1.00
1.05
1.11
1.16
1.22
1.27
1.32
1.38
1.43
1.48
1.52
1.57
1.61
1.65
1.69
1.73
1.77
1.80
1.84
1.87
1.90
1.93
1.96
1.99
2.01
2.04
2.06
2.09
2.11
2.13
2.15
2.18
2.20
2.22
2.24
2.25
2.27
2.29
2.31
2.33
2.34
2.36
2.37
23
1.00
1.05
1.10
1.15
1.20
1.25
1.31
1.35
1.40
1.45
1.49
1.53
1.57
1.61
1.65
1.68
1.72
1.75
1.78
1.81
1.84
1.87
1.89
1.92
1.94
1.97
1.99
2.01
2.03
2.05
2.07
2.09
2.11
2.13
2.15
2.16
2.18
2.20
2.21
2.23
2.24
2.26
2.27
24
1.00
1.05
1.09
1.14
1.19
1.24
1.29
1.33
1.38
1.42
1.46
1.50
1.54
1.57
1.61
1.64
1.67
1.70
1.73
1.76
1.78
1.81
1.83
1.86
1.88
1.90
1.92
1.94
1.96
1.98
2.00
2.02
2.03
2.05
2.07
2.08
2.10
2.11
2.13
2.14
2.16
2.17
2.18
25
1.00
1.04
1.09
1.14
1.18
1.23
1.27
1.32
1.36
1.40
1.43
1.47
1.51
1.54
1.57
1.60
1.63
1.66
1.68
1.71
1.73
1.76
1.78
1.80
1.82
1.84
1.86
1.88
1.90
1.91
1.93
1.95
1.96
1.98
1.99
2.01
2.02
2.04
2.05
2.06
2.08
2.09
2.10
26
1.00
1.04
1.09
1.13
1.17
1.21
1.26
1.30
1.34
1.37
1.41
1.44
1.48
1.51
1.54
1.56
1.59
1.62
1.64
1.66
1.69
1.71
1.73
1.75
1.77
1.79
1.80
1.82
1.84
1.85
1.87
1.88
1.90
1.91
1.93
1.94
1.95
1.97
1.98
1.99
2.00
2.01
2.02
27
1.00
1.04
1.08
1.12
1.16
1.20
1.24
1.28
1.32
1.35
1.39
1.42
1.45
1.48
1.50
1.53
1.55
1.58
1.60
1.62
1.64
1.66
1.68
1.70
1.72
1.73
1.75
1.77
1.78
1.80
1.81
1.82
1.84
1.85
1.86
1.88
1.89
1.90
1.91
1.92
1.93
1.94
1.95
28
1.00
1.04
1.08
1.12
1.15
1.19
1.23
1.26
1.30
1.33
1.36
1.39
1.42
1.45
1.47
1.50
1.52
1.54
1.56
1.58
1.60
1.62
1.64
1.66
1.67
1.69
1.70
1.72
1.73
1.74
1.76
1.77
1.78
1.79
1.81
1.82
1.83
1.84
1.85
1.86
1.87
1.88
1.89
29
1.00
1.04
1.07
1.11
1.15
1.18
1.22
1.25
1.28
1.31
1.34
1.37
1.40
1.42
1.44
1.47
1.49
1.51
1.53
1.55
1.56
1.58
1.60
1.61
1.63
1.64
1.66
1.67
1.68
1.70
1.71
1.72
1.73
1.74
1.75
1.76
1.77
1.78
1.79
1.80
1.81
1.82
1.83
30
1.00
1.03
1.07
1.10
1.14
1.17
1.20
1.24
1.27
1.29
1.32
1.35
1.37
1.39
1.42
1.44
1.46
1.48
1.49
1.51
1.53
1.54
1.56
1.57
1.59
1.60
1.61
1.63
1.64
1.65
1.66
1.67
1.68
1.69
1.70
1.71
1.72
1.73
1.74
1.75
1.76
1.76
1.77
31
1.00
1.03
1.06
1.10
1.13
1.16
1.19
1.22
1.25
1.28
1.30
1.33
1.35
1.37
1.39
1.41
1.43
1.45
1.46
1.48
1.50
1.51
1.52
1.54
1.55
1.56
1.57
1.59
1.60
1.61
1.62
1.63
1.64
1.65
1.66
1.66
1.67
1.68
1.69
1.70
1.71
1.71
1.72
32
1.00
1.03
1.06
1.09
1.12
1.15
1.18
1.21
1.24
1.26
1.28
1.31
1.33
1.35
1.37
1.39
1.40
1.42
1.43
1.45
1.46
1.48
1.49
1.50
1.51
1.53
1.54
1.55
1.56
1.57
1.58
1.59
1.60
1.60
1.61
1.62
1.63
1.64
1.64
1.65
1.66
1.66
1.67
33
1.00
1.03
1.06
1.09
1.12
1.14
1.17
1.20
1.22
1.24
1.27
1.29
1.31
1.33
1.34
1.36
1.38
1.39
1.41
1.42
1.43
1.45
1.46
1.47
1.48
1.49
1.50
1.51
1.52
1.53
1.54
1.55
1.56
1.56
1.57
1.58
1.59
1.59
1.60
1.61
1.61
1.62
1.63
34
1.00
1.03
1.05
1.08
1.11
1.14
1.16
1.18
1.21
1.23
1.25
1.27
1.29
1.31
1.32
1.34
1.35
1.37
1.38
1.39
1.41
1.42
1.43
1.44
1.45
1.46
1.47
1.48
1.49
1.49
1.50
1.51
1.52
1.53
1.53
1.54
1.55
1.55
1.56
1.57
1.57
1.58
1.58
35
1.00
1.03
1.05
1.08
1.10
1.13
1.15
1.17
1.20
1.22
1.23
1.25
1.27
1.29
1.30
1.32
1.33
1.34
1.36
1.37
1.38
1.39
1.40
1.41
1.42
1.43
1.44
1.45
1.45
1.46
1.47
1.48
1.48
1.49
1.50
1.50
1.51
1.51
1.52
1.53
1.53
1.54
1.54
36
1.00
1.02
1.05
1.07
1.10
1.12
1.14
1.16
1.18
1.20
1.22
1.24
1.25
1.27
1.28
1.30
1.31
1.32
1.33
1.34
1.35
1.36
1.37
1.38
1.39
1.40
1.41
1.42
1.42
1.43
1.44
1.44
1.45
1.46
1.46
1.47
1.47
1.48
1.48
1.49
1.49
1.50
1.50
37
1.00
1.02
1.05
1.07
1.09
1.11
1.13
1.15
1.17
1.19
1.21
1.22
1.24
1.25
1.26
1.28
1.29
1.30
1.31
1.32
1.33
1.34
1.35
1.36
1.36
1.37
1.38
1.39
1.39
1.40
1.41
1.41
1.42
1.42
1.43
1.43
1.44
1.45
1.45
1.45
1.46
1.46
1.47
38
1.00
1.02
1.04
1.06
1.08
1.10
1.12
1.14
1.16
1.18
1.19
1.21
1.22
1.23
1.25
1.26
1.27
1.28
1.29
1.30
1.31
1.32
1.32
1.33
1.34
1.35
1.35
1.36
1.37
1.37
1.38
1.38
1.39
1.39
1.40
1.40
1.41
1.41
1.42
1.42
1.43
1.43
1.43
39
1.00
1.02
1.04
1.06
1.08
1.10
1.12
1.13
1.15
1.16
1.18
1.19
1.21
1.22
1.23
1.24
1.25
1.26
1.27
1.28
1.29
1.29
1.30
1.31
1.31
1.32
1.33
1.33
1.34
1.34
1.35
1.36
1.36
1.37
1.37
1.37
1.38
1.38
1.39
1.39
1.40
1.40
1.40
40
1.00
1.02
1.04
1.06
1.07
1.09
1.11
1.12
1.14
1.15
1.17
1.18
1.19
1.20
1.21
1.22
1.23
1.24
1.25
1.26
1.26
1.27
1.28
1.29
1.29
1.30
1.30
1.31
1.31
1.32
1.32
1.33
1.33
1.34
1.34
1.35
1.35
1.35
1.36
1.36
1.37
1.37
1.37
41
1.00
1.02
1.03
1.05
1.07
1.08
1.10
1.12
1.13
1.14
1.15
1.17
1.18
1.19
1.20
1.21
1.21
1.22
1.23
1.24
1.24
1.25
1.26
1.26
1.27
1.27
1.28
1.29
1.29
1.29
1.30
1.30
1.31
1.31
1.32
1.32
1.32
1.33
1.33
1.33
1.34
1.34
1.34
42
1.00
1.02
1.03
1.05
1.06
1.08
1.09
1.11
1.12
1.13
1.14
1.15
1.16
1.17
1.18
1.19
1.20
1.21
1.21
1.22
1.23
1.23
1.24
1.24
1.25
1.25
1.26
1.26
1.27
1.27
1.28
1.28
1.28
1.29
1.29
1.29
1.30
1.30
1.30
1.31
1.31
1.31
1.32
43
1.00
1.01
1.03
1.04
1.06
1.07
1.09
1.10
1.11
1.12
1.13
1.14
1.15
1.16
1.17
1.18
1.18
1.19
1.20
1.20
1.21
1.21
1.22
1.22
1.23
1.23
1.24
1.24
1.25
1.25
1.25
1.26
1.26
1.26
1.27
1.27
1.27
1.28
1.28
1.28
1.28
1.29
1.29
44
1.00
1.01
1.03
1.04
1.05
1.07
1.08
1.09
1.10
1.11
1.12
1.13
1.14
1.15
1.15
1.16
1.17
1.17
1.18
1.18
1.19
1.20
1.20
1.20
1.21
1.21
1.22
1.22
1.22
1.23
1.23
1.23
1.24
1.24
1.24
1.25
1.25
1.25
1.25
1.26
1.26
1.26
1.26
45
1.00
1.01
1.03
1.04
1.05
1.06
1.07
1.08
1.09
1.10
1.11
1.12
1.13
1.13
1.14
1.15
1.15
1.16
1.16
1.17
1.17
1.18
1.18
1.19
1.19
1.19
1.20
1.20
1.20
1.21
1.21
1.21
1.22
1.22
1.22
1.22
1.23
1.23
1.23
1.23
1.24
1.24
1.24
46
1.00
1.01
1.02
1.03
1.05
1.06
1.07
1.08
1.08
1.09
1.10
1.11
1.11
1.12
1.13
1.13
1.14
1.14
1.15
1.15
1.16
1.16
1.17
1.17
1.17
1.18
1.18
1.18
1.19
1.19
1.19
1.19
1.20
1.20
1.20
1.20
1.21
1.21
1.21
1.21
1.21
1.22
1.22
47
1.00
1.01
1.02
1.03
1.04
1.05
1.06
1.07
1.08
1.08
1.09
1.10
1.10
1.11
1.12
1.12
1.13
1.13
1.13
1.14
1.14
1.15
1.15
1.15
1.16
1.16
1.16
1.16
1.17
1.17
1.17
1.17
1.18
1.18
1.18
1.18
1.19
1.19
1.19
1.19
1.19
1.19
1.20
48
1.00
1.01
1.02
1.03
1.04
1.05
1.05
1.06
1.07
1.08
1.08
1.09
1.09
1.10
1.10
1.11
1.11
1.12
1.12
1.12
1.13
1.13
1.13
1.14
1.14
1.14
1.14
1.15
1.15
1.15
1.15
1.16
1.16
1.16
1.16
1.16
1.17
1.17
1.17
1.17
1.17
1.17
1.18
49
1.00
1.01
1.02
1.03
1.03
1.04
1.05
1.05
1.06
1.07
1.07
1.08
1.08
1.09
1.09
1.10
1.10
1.10
1.11
1.11
1.11
1.12
1.12
1.12
1.12
1.13
1.13
1.13
1.13
1.13
1.14
1.14
1.14
1.14
1.14
1.14
1.15
1.15
1.15
1.15
1.15
1.15
1.15
50
1.00
1.01
1.01
1.02
1.03
1.04
1.04
1.05
1.05
1.06
1.06
1.07
1.07
1.08
1.08
1.08
1.09
1.09
1.09
1.10
1.10
1.10
1.10
1.11
1.11
1.11
1.11
1.11
1.12
1.12
1.12
1.12
1.12
1.12
1.13
1.13
1.13
1.13
1.13
1.13
1.13
1.13
1.14
51
1.00
1.01
1.01
1.02
1.03
1.03
1.04
1.04
1.05
1.05
1.06
1.06
1.06
1.07
1.07
1.07
1.08
1.08
1.08
1.08
1.09
1.09
1.09
1.09
1.09
1.10
1.10
1.10
1.10
1.10
1.10
1.10
1.11
1.11
1.11
1.11
1.11
1.11
1.11
1.11
1.12
1.12
1.12
52
1.00
1.01
1.01
1.02
1.02
1.03
1.03
1.04
1.04
1.04
1.05
1.05
1.05
1.06
1.06
1.06
1.06
1.07
1.07
1.07
1.07
1.07
1.08
1.08
1.08
1.08
1.08
1.08
1.09
1.09
1.09
1.09
1.09
1.09
1.09
1.09
1.09
1.10
1.10
1.10
1.10
1.10
1.10
53
1.00
1.00
1.01
1.01
1.02
1.02
1.03
1.03
1.03
1.04
1.04
1.04
1.04
1.05
1.05
1.05
1.05
1.06
1.06
1.06
1.06
1.06
1.06
1.06
1.07
1.07
1.07
1.07
1.07
1.07
1.07
1.07
1.07
1.08
1.08
1.08
1.08
1.08
1.08
1.08
1.08
1.08
1.08
54
1.00
1.00
1.01
1.01
1.01
1.02
1.02
1.02
1.03
1.03
1.03
1.03
1.04
1.04
1.04
1.04
1.04
1.04
1.05
1.05
1.05
1.05
1.05
1.05
1.05
1.05
1.05
1.06
1.06
1.06
1.06
1.06
1.06
1.06
1.06
1.06
1.06
1.06
1.06
1.06
1.06
1.07
1.07
55
1.00
1.00
1.01
1.01
1.01
1.01
1.02
1.02
1.02
1.02
1.02
1.03
1.03
1.03
1.03
1.03
1.03
1.03
1.03
1.04
1.04
1.04
1.04
1.04
1.04
1.04
1.04
1.04
1.04
1.04
1.04
1.04
1.05
1.05
1.05
1.05
1.05
1.05
1.05
1.05
1.05
1.05
1.05
56
1.00
1.00
1.00
1.01
1.01
1.01
1.01
1.01
1.01
1.02
1.02
1.02
1.02
1.02
1.02
1.02
1.02
1.02
1.02
1.02
1.03
1.03
1.03
1.03
1.03
1.03
1.03
1.03
1.03
1.03
1.03
1.03
1.03
1.03
1.03
1.03
1.03
1.03
1.03
1.03
1.03
1.03
1.03
57
1.00
1.00
1.00
1.00
1.00
1.01
1.01
1.01
1.01
1.01
1.01
1.01
1.01
1.01
1.01
1.01
1.01
1.01
1.01
1.01
1.01
1.02
1.02
1.02
1.02
1.02
1.02
1.02
1.02
1.02
1.02
1.02
1.02
1.02
1.02
1.02
1.02
1.02
1.02
1.02
1.02
1.02
1.02
58
1.00
1.00
1.00
1.00
1.00
1.00
1.00
1.00
1.00
1.00
1.00
1.00
1.00
1.00
1.00
1.00
1.00
1.00
1.00
1.00
1.00
1.00
1.00
1.00
1.00
1.00
1.00
1.00
1.00
1.00
1.00
1.01
1.01
1.01
1.01
1.01
1.01
1.01
1.01
1.01
1.01
1.01
1.01
0.0
0.1
0.2
0.3
0.4
0.5
0.6
0.7
0.8
0.9
1.0
1.1
1.2
1.3
1.4
1.5
1.6
1.7
1.8
1.9
2.0
2.1
2.2
2.3
2.4
2.5 2.6
2.7
2.8
2.9
3.0 3.1
3.2
3.3
3.4
3.5 3.6
3.7
3.8
3.9
4.0 4.1
4.2

Coefficient of Variation
4.3
4.4
4.5 4.6
4.7
4.8
4.9
5.0 5.1
5.2
5.3
5.4
5.5 5.6
5.7
5.8
5.9
6.0 6.1
n
289.83
302.12
314.57
327.19
339.96
352.88
365.95
37J.1i
3jz.53
406.03
419.66
433.43
447.33
461.35
475.50
489.76
504.15
518.65
533.27
1
63.09
65.03
66.98
68.93
70.89
72.85
74.81
76.78
78.75
80.72
82.69
84.67
86.64
88.62
90.60
92.58
94.56
96.54
98.52
2
30.38
31.15
31.92
32.68
33.44
34.20
34.96
35.72
36.47
37.22
37.97
38.71
39.46
40.20
40.93
41.67
42.40
43.13
43.86
3
19.14
19.56
19.98
20.39
20.80
21.21
21.61
22.02
22.42
22.82
23.21
23.61
24.00
24.39
24.77
25.16
25.54
25.92
26.30
4
13.75
14.02
14.28
14.55
14.81
15.06
15.32
15.57
15.82
16.07
16.32
16.56
16.81
17.05
17.29
17.53
17.76
18.00
18.23
5
10.66
10.85
11.04
11.22
11.40
11.58
11.76
11.93
12.10
12.28
12.45
12.62
12.78
12.95
13.11
13.28
13.44
13.60
13.76
6
8.69
8.83
8.96
9.10
9.23
9.37
9.50
9.63
9.75
9.88
10.01
10.13
10.25
10.37
10.49
10.61
10.73
10.85
10.96
7
7.33
7.43
7.54
7.65
7.75
7.85
7.95
8.05
8.15
8.25
8.34
8.44
8.53
8.63
8.72
8.81
8.90
8.99
9.08
8
6.34
6.42
6.51
6.59
6.67
6.76
6.84
6.91
6.99
7.07
7.15
7.22
7.30
7.37
7.44
7.52
7.59
7.66
7.73
9
5.58
5.65
5.72
5.79
5.86
5.93
5.99
6.06
6.12
6.19
6.25
6.31
6.37
6.43
6.49
6.55
6.61
6.66
6.72
10
5.00
5.05
5.11
5.17
5.23
5.28
5.34
5.39
5.44
5.50
5.55
5.60
5.65
5.70
5.75
5.80
5.85
5.89
5.94
11
4.52
4.57
4.62
4.67
4.72
4.77
4.81
4.86
4.90
4.95
4.99
5.03
5.08
5.12
5.16
5.20
5.24
5.28
5.32
12
4.14
4.18
4.22
4.26
4.30
4.35
4.38
4.42
4.46
4.50
4.54
4.57
4.61
4.65
4.68
4.72
4.75
4.78
4.82
13
3.81
3.85
3.89
3.92
3.96
3.99
4.03
4.06
4.10
4.13
4.16
4.19
4.22
4.26
4.29
4.32
4.35
4.37
4.40
14
3.54
3.57
3.60
3.64
3.67
3.70
3.73
3.76
3.79
3.82
3.84
3.87
3.90
3.93
3.95
3.98
4.00
4.03
4.05
15
3.30
3.33
3.36
3.39
3.42
3.44
3.47
3.50
3.52
3.55
3.57
3.60
3.62
3.65
3.67
3.69
3.71
3.74
3.76
16
3.10
3.13
3.15
3.18
3.20
3.23
3.25
3.27
3.30
3.32
3.34
3.36
3.38
3.40
3.42
3.44
3.46
3.48
3.50
17
2.92
2.95
2.97
2.99
3.01
3.03
3.06
3.08
3.10
3.12
3.14
3.16
3.17
3.19
3.21
3.23
3.25
3.26
3.28
18
2.77
2.79
2.81
2.83
2.85
2.87
2.89
2.90
2.92
2.94
2.96
2.97
2.99
3.01
3.02
3.04
3.06
3.07
3.09
19
2.63
2.65
2.66
2.68
2.70
2.72
2.73
2.75
2.77
2.78
2.80
2.81
2.83
2.84
2.86
2.87
2.89
2.90
2.91
20
2.50
2.52
2.54
2.55
2.57
2.58
2.60
2.61
2.63
2.64
2.66
2.67
2.68
2.70
2.71
2.72
2.74
2.75
2.76
21
2.39
2.41
2.42
2.44
2.45
2.46
2.48
2.49
2.50
2.52
2.53
2.54
2.56
2.57
2.58
2.59
2.60
2.61
2.63
22
2.29
2.30
2.32
2.33
2.34
2.36
2.37
2.38
2.39
2.40
2.42
2.43
2.44
2.45
2.46
2.47
2.48
2.49
2.50
23
2.20
2.21
2.22
2.23
2.25
2.26
2.27
2.28
2.29
2.30
2.31
2.32
2.33
2.34
2.35
2.36
2.37
2.38
2.39
24
2.11
2.12
2.13
2.15
2.16
2.17
2.18
2.19
2.20
2.21
2.22
2.23
2.24
2.25
2.25
2.26
2.27
2.28
2.29
25
2.03
2.04
2.06
2.07
2.08
2.09
2.09
2.10
2.11
2.12
2.13
2.14
2.15
2.16
2.16
2.17
2.18
2.19
2.20
26
1.96
1.97
1.98
1.99
2.00
2.01
2.02
2.03
2.04
2.04
2.05
2.06
2.07
2.07
2.08
2.09
2.10
2.10
2.11
27
1.90
1.91
1.91
1.92
1.93
1.94
1.95
1.96
1.96
1.97
1.98
1.99
1.99
2.00
2.01
2.01
2.02
2.03
2.03
28
1.84
1.84
1.85
1.86
1.87
1.88
1.88
1.89
1.90
1.90
1.91
1.92
1.92
1.93
1.94
1.94
1.95
1.95
1.96
29
1.78
1.79
1.79
1.80
1.81
1.82
1.82
1.83
1.84
1.84
1.85
1.85
1.86
1.87
1.87
1.88
1.88
1.89
1.89
30
1.73
1.73
1.74
1.75
1.75
1.76
1.77
1.77
1.78
1.78
1.79
1.80
1.80
1.81
1.81
1.82
1.82
1.83
1.83
31
1.68
1.68
1.69
1.70
1.70
1.71
1.71
1.72
1.72
1.73
1.74
1.74
1.75
1.75
1.76
1.76
1.76
1.77
1.77
32
1.63
1.64
1.64
1.65
1.65
1.66
1.66
1.67
1.67
1.68
1.68
1.69
1.69
1.70
1.70
1.71
1.71
1.72
1.72
33
1.59
1.59
1.60
1.60
1.61
1.61
1.62
1.62
1.63
1.63
1.64
1.64
1.65
1.65
1.65
1.66
1.66
1.67
1.67
34
1.55
1.55
1.56
1.56
1.57
1.57
1.58
1.58
1.58
1.59
1.59
1.60
1.60
1.60
1.61
1.61
1.61
1.62
1.62
35
1.51
1.51
1.52
1.52
1.53
1.53
1.53
1.54
1.54
1.55
1.55
1.55
1.56
1.56
1.56
1.57
1.57
1.57
1.58
36
1.47
1.48
1.48
1.49
1.49
1.49
1.50
1.50
1.50
1.51
1.51
1.51
1.52
1.52
1.52
1.53
1.53
1.53
1.54
37
1.44
1.44
1.45
1.45
1.45
1.46
1.46
1.46
1.47
1.47
1.47
1.48
1.48
1.48
1.48
1.49
1.49
1.49
1.50
38
1.41
1.41
1.41
1.42
1.42
1.42
1.43
1.43
1.43
1.43
1.44
1.44
1.44
1.45
1.45
1.45
1.45
1.46
1.46
39
1.38
1.38
1.38
1.38
1.39
1.39
1.39
1.40
1.40
1.40
1.40
1.41
1.41
1.41
1.41
1.42
1.42
1.42
1.42
40
1.35
1.35
1.35
1.35
1.36
1.36
1.36
1.37
1.37
1.37
1.37
1.37
1.38
1.38
1.38
1.38
1.39
1.39
1.39
41
1.32
1.32
1.32
1.33
1.33
1.33
1.33
1.34
1.34
1.34
1.34
1.34
1.35
1.35
1.35
1.35
1.35
1.36
1.36
42
1.29
1.29
1.30
1.30
1.30
1.30
1.31
1.31
1.31
1.31
1.31
1.32
1.32
1.32
1.32
1.32
1.32
1.33
1.33
43
1.27
1.27
1.27
1.27
1.28
1.28
1.28
1.28
1.28
1.28
1.29
1.29
1.29
1.29
1.29
1.29
1.30
1.30
1.30
44
1.24
1.24
1.25
1.25
1.25
1.25
1.25
1.26
1.26
1.26
1.26
1.26
1.26
1.26
1.27
1.27
1.27
1.27
1.27
45
1.22
1.22
1.22
1.22
1.23
1.23
1.23
1.23
1.23
1.23
1.24
1.24
1.24
1.24
1.24
1.24
1.24
1.24
1.25
46
1.20
1.20
1.20
1.20
1.20
1.21
1.21
1.21
1.21
1.21
1.21
1.21
1.21
1.22
1.22
1.22
1.22
1.22
1.22
47
1.18
1.18
1.18
1.18
1.18
1.18
1.18
1.19
1.19
1.19
1.19
1.19
1.19
1.19
1.19
1.19
1.20
1.20
1.20
48
1.16
1.16
1.16
1.16
1.16
1.16
1.16
1.16
1.17
1.17
1.17
1.17
1.17
1.17
1.17
1.17
1.17
1.17
1.17
49
1.14
1.14
1.14
1.14
1.14
1.14
1.14
1.14
1.14
1.15
1.15
1.15
1.15
1.15
1.15
1.15
1.15
1.15
1.15
50
1.12
1.12
1.12
1.12
1.12
1.12
1.12
1.12
1.12
1.13
1.13
1.13
1.13
1.13
1.13
1.13
1.13
1.13
1.13
51
1.10
1.10
1.10
1.10
1.10
1.10
1.10
1.11
1.11
1.11
1.11
1.11
1.11
1.11
1.11
1.11
1.11
1.11
1.11
52
1.08
1.08
1.08
1.08
1.09
1.09
1.09
1.09
1.09
1.09
1.09
1.09
1.09
1.09
1.09
1.09
1.09
1.09
1.09
53
1.07
1.07
1.07
1.07
1.07
1.07
1.07
1.07
1.07
1.07
1.07
1.07
1.07
1.07
1.07
1.07
1.07
1.07
1.07
54
1.05
1.05
1.05
1.05
1.05
1.05
1.05
1.05
1.05
1.05
1.05
1.05
1.05
1.05
1.05
1.06
1.06
1.06
1.06
55
1.03
1.04
1.04
1.04
1.04
1.04
1.04
1.04
1.04
1.04
1.04
1.04
1.04
1.04
1.04
1.04
1.04
1.04
1.04
56
1.02
1.02
1.02
1.02
1.02
1.02
1.02
1.02
1.02
1.02
1.02
1.02
1.02
1.02
1.02
1.02
1.02
1.02
1.02
57
1.01
1.01
1.01
1.01
1.01
1.01
1.01
1.01
1.01
1.01
1.01
1.01
1.01
1.01
1.01
1.01
1.01
1.01
1.01
58
4.3
4.4
4.5
4.6
4.7
4.8
4.9
5.0
5.1
5.2
5.3
5.4
5.5
5.6
5.7
5.8
5.9
6.0
6.1 I

Multiplication Factor
RPMFs as
f(n,CV,Confidence,UpperBound)
400.00
350.00
300.00
250.00
200.00
150.00
100.00
50.00
0.00
y
1.1
0.1
1 4 7 10 13 16 19 22 25
n
❑ 350.00-400.00
❑ 300.00-350.00
❑ 250.00-300.00
❑ 200.00-250.00
❑ 150.00-200.00
❑ 100.00-150.00
❑ 50.00-100.00
❑ 0.00-50.00

9/11/2013 rdb
New freshwater RPA based on 95% probability/95% confidence
Statistically 58 points are the maximum number of points allowed under this RPA program. Data fields were estbalished to allow only 58 data point entries.
Additional messages will appear to alert user if more than 58 data points were enter and no predicted values will be calculated
All worksheets are "Protected"
The "mf calculator" is password "Protected"
OTHER CHANGES FROM PREVIOUS RPA PROGRAM:
A. When Model is applied (Check box activated):
1) assumes only chroinc dilution known
2) assumes user will insert appropriate flow values for "7Q10s (cfs)", "7Q10w (cfs)", "30Q2 (cfs)", "QA (cfs)" to define chronic dilution in terms of "IWC %", "IWC %" is the same for all stream flows
3) automatically assigns the entered chronic IWC % to the "IWC @ 7Q10s", "IWC @ 7Q10w", "IWC @ 30Q2", "IWC @ QA" values used in chronic WQS calculations (See "RPA" page)
3) "1 Q10s (cfs)" automatically defaults to no acute dilution, acute IWC = 100% ,"IWC @ 1 Q10s" = 100% which is used in acute WQS calculatons (See "RPA" page)
B. When Model is not applied (Check box NOT activated):
1) assumes user will insert appropriate flow values for "7Q10s (cfs)", "7Q10w (cfs)", "30Q2 (cfs)", "QA (cfs)" , "Flow Qw (MGD)" for chronic IWC % calculations, IWC % will vary according to flows
3) automatically calculates chronic -based IWC % for the "IWC @ 7Q10s", "IWC @ 7Q10w", "IWC @ 30Q2", "IWC @ QA" values used in chronic WQS calculations (See "RPA" page)
3) "1 Q10s (cfs)" is automatically calculated bases on entered "7Q10s (cfs)" flow
4) automatically calculates acute -based IWC% for the "IWC @ 1 Q10s" value used in acute WQS calculations (See "RPA" page)
C. When paremeter's "Impaired?" check box is activated:
1) automtically activtes the "IMPAIRED" message alert on the "RPA" page for that parameter
2) does NOT make any automatic adjustements to WQS calculations
NOTE: If new or expanding discharge and receiving stream impaired, will need to evaluate if additional waste load is allowed
10/30/2013 rdb
1) Amended "ERR" alert on data sets entreies to activate if "<" entered but no value entered, does not effect RPA calculation, ERR message only
2) Added new calculation feature to count nondetects when both "<" and a value are entered for each data set, used to calculate detected entries
3) Amended "Comments" drop down menu - per Juile
4) Turned the Chronic toxicity concentration message off on the RPA page - per Julie
2/10/14:
ON "data" page changed highlighted area from blue shades to gray
5/2/14 rdb
1) Increased rounding factor on all calculated IWC% to 7 decimals
2) Increased display for all calkculated to 6 decimals places.
5/5/14 rdb
Increased rounding factor on all calculated IWC% to 9 decimals
5/21/14 rdb
Removed ROUND function from all IWC% calculations
7/31/14 rdb
Moved RPA page tile blocks down one row so header text was separated
9/9/15: COMPLETED REVISIONS FOR METAL TRANSLATOR FEATURE
1) Added tabs for "HUC Hardness" (lookup table for HUC hardness values), "Hardness Equations" (summary of translator formulas, metals impacted, general info), "Dss to Total Hardness Calculator"
(calcution sheet for metal translator, impacted chronic and acute wqs)
2) Revised "Input" page Table 1:
- New user input for "8 Digit HUC Number" uisng drop down menu for lookup HUC Hardness, required entry, brown highlight
- New display only for calculated "Effluent Hardness (Median)" including conditional method for info display, brown highlight
- New display only for designed "HUC Hardness (Median)" incuding conditionla method for info display, brown highlight
- New display only for calculated "Combined Hardness Chronic" for metal translator application, brown highlight
- New display only for calculated "Combined Hardness Acute" for metal translator application, brown highlight
- Assigned name for "HUC Number"
3) Revised "Input" pade Table 2:
- Removed "Impaired ?" column, conditional display, references
- Added new column for "WQS" designation incuding assigning applicable WQS where fixed
- Added new error message "CHECK WQS", conditonal control based on "WQS" entry for Cadmium, Chlorides, Molybdeum, Nickel
- Revised text in error message
- Added new brown highlight "Metal Translator Data Entry" label box
- Removed Par01 "Arsenic" line
- Revised Par02 " Arsenic" line to reflect Human Health and Water Supply criterion, Chronic = 10 mg/L, Acute = "N/A"
- Revised Par04 "Cadmium" line:

a) "WQS" input with drop down menu to select applicable criterion
b) "Chronic" and "Acute" inputs to display calculated metal translator values including conditional method for info display based on "WQS" selection, no rounding
c) "Modifier" input display only based on "WQS" selection including conditional method for info dispaly
d) Conditonal controls to activate error nessages, brown highlight
- Revised Par05 "Chloride (AL)" line:
a) "WQS" input with drop down menu to select applicable criterion
b) "Chronic" display only for applicable value including conditional method for info display based on "WQS" selection
c) "Modifier" input display only based on "WQS" selection including conditional method for info dispaly
d) "Name" display only based on "WQS" selection including conditional metdod fro info display
e) Conditonal controls to activate error nessages
- Revised "Chromium, Total" line:
a) Removed Par08 label
b) "Chronic" and "Acute" inputs to display calculated metal translator values, no rounding
c) brown highlight
- Added new "Chromium III" line:
a) Assigned applicable text in "WQS", "Type", Modifier", Units"
b) "Chronic" and "Acute" inputs to display calculated metal translator values, no rounding
c) brown highlight
- Added new Par08 "Chromium VI" line:
a) Assigned Par08 label, applicable text in "WQS", "Type", Modifier", Units"
b) "Chronic" and "Acute" inputs to display calculated metal translator values, no rounding
c) brown highlight
- Revised Par09 "Copper (AL)" line:
a) "Chronic" and "Acute" inputs to display calculated metal translator values, no rounding
b) brown highlight
- Revisd Par12 "Lead" line:
a) "Chronic" and "Acute" inputs to display calculated metal translator values, no rounding
b) brown highlight
- Revised Par14 "Molybdenum" lime:
a) "WQS" input with drop down menu to select applicable criterion
b) "Chronic" display only for applicable value including conditional method for info display based on "WQS" selection
c) "Modifier" input display only based on "WQS" selection including conditional method for info dispaly
d) Conditonal controls to activate error nessages
- Revised Par15 "Nickel" line:
a) "WQS" input with drop down menu to select applicable criterion
b) "Chronic" and "Acute" inputs to display calculated metal translator values including conditional method for info display based on "WQS" selection, no rounding
c) "Modifier" input display only based on "WQS" selection including conditional method for info dispaly
d) Conditonal controls to activate error nessages, brown highlight
- Revised Par17 "Silver (AL)" line:
a) "Chronic" and "Acute" inputs to display calculated metal translator values, no rounding
b) brown highlight
- Revised Par18 "Zinc (AL)" line:
a) "Chronic" and "Acute" inputs to display calculated metal translator values, no rounding
b) brown highlight
3) Revised "Data" page:
- Revised Par01 "Arsenic" entry, text, and calculations ("1 ") - all effluent hardness data to be entered in this section for used to calculate eflluent hardness factors
a) Reference to Par01 "Arsenic" removed
b) New label "Effluent Hardness (monthly average)" added
c) "Mult Factor =" and "Max. Pred Cw" removed, text and calcuation
d) "10% value" and "Median value" added, text and calculation including conditional method for info display
e) Assigned name "Effluent_Median" and "effluent_10" to calculated values
f) PQL condition removed from calculation method for data displayed
4) Revised "RPA" page:
- Removed all features assocaited with "Impairment"
- Added new display only for calculated "COMBINED HARDNESS (mg/L)", Chonic and Acute, conditional method for info display
- Revised "Receiving Stream" display to include selected HUC Number in text
- Removed unused display features for WET % (previouly hidden)

- Revised "Arsenic" lines:
a) Par01 "Arsenic" line removed
b) Par02 "Arsenic" references used for display to calculate "Acute" and Chronic" allowable Cw
- Revised "Cadmium", "Chromium VI", "Copper (AL)", "Lead", "Nickel", "Silver (AL)", "Zinc (AL)" (lines:
a) "NC WQS/Chronic" and 1/2 FAV/Acute" conditional method revised for info display, no rounding
b) "Allowable Cw" Acute" and "Chronic" conditional metfhod revised fro info display inculding rounding value
5) Revised "Dss to Total Metal Hardness Calculator" page
- Assigned names for:
a) "CdMAE_AC" - Cadmium calculated metal translator Acute value
b) "CdMAE_CH" - Cadmium calculated metal translator Chronic value
c) "CuMAE_AC" - Copper calculatd metal translator Acute value
d) "CuMAE_CH" - Copper calculated metal translator Chronic value
e) "Cr_Total_AC" - Total Chromium calculated meatl translator Acute value
f) "Cr_Total_CH" - Total Chromium calculated metal translator Chronic value
g) "CrIIIMAE_AC" - Chromium III calculated metal translator Acute value.
h) "CrIIIMAE_CH" - Chromium III calculated metal tramslator Chronic value
i) "CrVIMAE_AC" - Chromium VI calculated metal translator Acute value
j) "CrVINAE_CH" - Chromium VI calculatd metal translator Chronic value
k) "PbMAE_AC" - Lead calculated metal translator Acute value
m) "PbMAE_CH" - Lead calculated metal translator Chronic value
n) "NiMAE_AC" - Nickel calculated metal translator Acute value
o) "NiMAE_CH" - Nickel calculated metal translator Chroniv value
p) "AuMAE_AC" - Silver calculated metal translator Acute value
q) "AuMAE_CH" - Silver calculated metal translator Chronic value
r) "ZnMAE-AC" - Zinc calculated metal translator Acute value
s) "ZnMAE_CH" - Zinc calculated metal translator Chronic value
t) "tss" - assigned TSS harness factor
u) "CHA" - calculated combined acute hardness value
v) "CHC" - calculated combined chronic hardness value
- Added conditional methods to formulas for info display and to incorporate names, no rounding
6) Set up passwortd to protect all pages 'rpa2015'
1/12/16 ADDED ARSENIC AQUATIC LIFE PARAMETER BACK TO ACTIVE RPA EVALUATION
1) Inserted "Aresenic, Aquatic Life, C, 50, FW, N/A, pg/L" in first row "INPUT" Table 2, Par01
2) Updated program names to reflect addition of new Arsenic Aquatic Life parameter
3) Inserted "Arsenic" Aquatic Life parameter and cell programming in Arsenic section "RPA" as Chronic and added drop down menu feature
4) Amended labels on "Data" to show H for hardnes and Par01-Par22 for paremeters
1/12/16 REVISED IWC CALCULATIONS TO SHOW FULL DISPLAY on "RPA"
1) Reformatted IWC calculation cells to show caculated value as general (number value will always be displayed)
2) Revised IWC calculation formula to x by 100 to mimic
3) Revised IWC calculation labels to include "%"
4) Revised all calculations using IWC values "Acute", "Chronic" to divide by 100 to correct for IWC % value
1/12/16 REVISED SPREADSHEET TO INDICATE NO DETECT AND MDL
1) Revised "Data" Par01-Par22 Max Value cell conditional statement to display "NO DETECTS" when data set has all no detects
2) Revised "RPA" all parameters Max Pred CW cell formatting to display "NO DETECTS" when required to display no detects
3) Revised "RPA" alert message (under Chronic labels) conditional statement to display "Max MDL = <2 x max adjusted data set value> when data set has all no detects
4) Revised "RPA" drop menu to add "No detects" to list and display
1/12/16:
Corrected formula error in mf formula Par01 to use corrected data set ("Data")
Revised "RPA" Cadmium, Copper, Lead, Nickel, Silver, Zinc Acute and Chronic cell conditional statements to have cell display blank if WQS is blank or WQS displays "NO DATA"
1/21-29/16:
1) Expanded parameter list and program features to add two additional parameters, (Par08) "Chromium III" & (Par09) "Chromium VI". This included adding two new data input sections on "Data" tab with
new corresponding RPA evalutaion, non -detect evaluation, formulas for each new data input section; adding two new parameter summary sections to "RPA" tab; revising exsiting parameter designation

to new assigned name (Par10 - Par24), data set (_Data08 - _Data24), non -detects (_ND08 - _ND24).
2) For consistency rearranged display, "Input" & "RPA" tabs, to be "Chromium III", "Chromium VI", "Chromium, Total". All features and programing unique to each display was revised accordingly.
3) Corrected Arsenic - Aquatic Life, Berylium Chronic and Acute values on "Input" tab to be exported from metal translator table.
4) Revised "Input" tab HUC Hardness (median) display conditional formula to display "default 25 mg/L (HUC Hard Med = NA mg/I)" when HUC hardness is NA.
5) Revised combined hardness acute (CHA) and combined hardness chronic (CHC) conditional formulas to assign 25 as hardness value when HUC hardness is NA.
6) Revised "RPA" tab Chromium, Total Reasonable Potential Results section to remove Acute and Chronic labels and allowable Cw calulation/display, area now blank except for MDL feature display.
7) Revised "RPA" tab Chromium III and Chromium VI Reasonable Potential Results sectons to remove display of values for n, #Det, Max Pred Cw, area blank except for display features from added condtional
formulas that reference Chromium, Total display and data.
NOTE: All RPA evaluation data is generated on each parameter "Data" section and imported to that parameter's "RPA" section, thus, RPA evaluation data can be displayed/used when programmed to do so.
8) Revised "RPA" tab Acute and Chronic conditional formulas for active parameters to display either "IWC?" or "IWC/DATA?" as default until appropraite data is provided.
9) Removed label from "Input" tab.
10) Corrected chlorinated list ("Input" & "Data" tabs) lists, now shows correct 2,4,6-trichlorophenol for Method 625.
See task notes
2/3/16:
Revised "input"page model feature to
a- Add new model 1 Q10S input cell that is visible on;y when model feature is activated
b- Revise cell formula 1 Q10s (cfs) to display 1 Q10s flow when model feature activated or calculate from 7Q10s flow when model feature NOT activated and 7Q10s flow displayed
c- Revised instructions narrartive that is visible only when model feature is activated
2/9/16:
Revised "input" page Effluent Hardness (Median) cell formula to display "default 99 mg/L (Efflunet Hard Med = <actual value> mg/L)" when stream class is WS and Effluent Hard Med is greater than 99.999 mg/L
Revised "data" page Effluent Hardness (Median) cell formula to display 99 whenstream class is WS and Effluent Hard Med is greater than 99.999 mg/L
Added new display messages to "rpa" page that are visible only when the steam class is water supply
2/16/16:
1) Revised "Diss to Total Metal Calculator" page:
added new cells to display actual calculated Effluent & HUC Median values and to display "Apply Water Supply Criterion" when applicable (stream class is Water Supply based and Efflunet Hard Med
exceeds 99.999 mg/L)
revised the existing calculation input/display cells for Effluent & HUC Hardness Median to show the applied hardness value based on new conditional formula as follows
a- If HUC Hard Med = NA or less than 25 mg/L then default HUC Hard Med to 25 mg/L
b- If Effluent Hard Med less than 25 then default Effluent Hard Med to 25 mg/L
c- If stream class is WS and Effluent Hard Med is greater than 99.9999 mg/L then default Effluent Hard Med to 99 mg/L
2) Revised "input" page dipplay HUC Hardness (Median) to show NA when HUC table value is NA.
2/19/16:
Added new WS WQC button to "input" page, activates effluent hardness to apply WS WQC standards, does NOT set parameter modifiers, still must do modifers individually
Added Nickel WS parameter to "input" page
Added Niche! WS to "rpa" page, revised both Nickel parametesr to share commom data, Nickel WS has no Acute standard so only list acute for FW
Set up both Nickel Par17 & Par18 to use same data entries
Changed Par22-25 modifier cells to be set automtically based on WQS entry.
Changed display font color phenols, chlorinared phenols menus
2/22/16:
Make text changes per Julie direction.
2/24/16:
Added to " Diss to Total Metal Calculator" page:
1) Comment section for PERCS info or other to allow user to add commentary
2) Added Facility name to display based on input page
3) Added NPDES permit# to display based on input page
4) Set up new Name "PERCS_page" as print area for table and other PERCS info for GOTO use.
NOTE: User can either highlight desire print area or use GOTO feature to set up desired print arae. When in print mode set up, will need to designate "Print Selection".
3/18/16:
Removed HUC table and HUC hardness lookup features from calculations and program.

Note: HUC number is an available option on the INPUT as an informational input only to use as a display label for other portion of the progam and has no Data Validation features.
Added Upstream Hardness calculation feature using measured upstream data:
1) INPUT display shows "Upstream Hardess" status and how upstream data is applied
2) DATA has new Upstream Hardness input sheet to accept upstream hardness data used to calculate number of data enties, data set average, data set 10th percentile value
3) Diss to Total Metal Calculator determines which upstream hardness to apply, if the number of data entries exceed 30 then the average value is used, if the number of data enties are less than 30 then the
10th percentile value is used. Anytime the applied upstream hardness is less than 25 mg/L then a default value of 25 mg/L is applied.
4/26/16:
Per Julia want to use average values for both the effluent and upstream hardness calculations. Defaults to be the same as was applied in the HUC base RPA.
1) Changed all upstream hardness median calculations to average calculations.
2) Removed any greater than 99.999 defaults from upstream hardness conditional statements. Upstream average will be actual execpt when less than 25, then 25 is the default.
3) Changed all effluent hardness median calculations to average calculations. Conditional statements for WS still apply, efflunet average value above 99.999 default to 99.
4) Any conditional statement referring to median hardness were revised.
5) Removed "(AL)" from parameter labels as no longer applicable.
6) Renamed RPA to describe features
4/27/16:
Per Julia when WS is being applied, the combined acute and chroinc hardness needs to default to 100 if the combined hardness exceeds 100. Made changes:
1) Set up new cells to calculate combined acute and chronic hardness, defined cells as program names ACCH & ACAH.
2) Revised the conditional statemenst for CHC and CHA to default to 100 if ACCH & ACAH exceed 100 when WS was applied.
3) Revised INPUT page Combined Acute and Chronic display condtitional statements to indicate defaults
4) Revised RPA page Combined Hardness Acut and Chronic displays conditional statemenst to indicate defaults
4/28/16:
Fixed programming errors so "NO DETECTS" display feature on RPA page for Nickel and Chromium VI now function.
Revised RPA page drop menu "Recommended Action" list to remove RP Action Level text and change "RP non action level..." text to state "RP shown...".
Added statement to 2B .0500 RULES page "4/28/16: Note Action Level designation no long allowed per EPA."
4/29/16:
Added ROUND function to conditional statements on INPUT page hardess displays to limit hardness value display to 2 decimal points.
Revised upstream default conditional factor to 24.9999 on INPUT page to allow actual upstream hardness of 25 to be displayed as non -default value.
5/6/16:
Removed less than 25 mg/L default from all effluent and upstream hardness conditional programming
5/11/16:
Added new conditional display to Total Chromium Pred Cw box RPA page to compare Total Chromium data to Cr III and Cr VI Allowable Cw
Added new conditional display to Total Chromium Allowable Cw box RPA page to indicate maximum Total Chromium value entered
6/13/16:
Revised title block text RPA tab to state "NC STANDARDS OR EPA CRITERIA", removed "NC WQS" from Chronic label, and removed 1/2 FAV from Acute label.
Corrected INPUT tab to align Dats Source(s) text box at top.
6/14/16:
Revised conditions for calculated combined hardness acute and chroinc to default to 400 mg/L if calculated value exceeded 400 mg/L
Revised conditions for INPUT page display combined hardness acute and chroinc to indicate when default 400 mg/L applied
Corrected label on DISS ... page to indicate average for effluent and upstream hardness
7/13/16:
Revised Model input feature when activated to calculate Model 7Q10s (cfs) flow based on entry of Qw, MGD and CHRONIC DILITION FACTOR (from Model) and display in Model narrative box.
User will need to enter calculated 7Q10s displayed in Model narrative box to Table 1 7Q10s, (cfs) entry box. 1 Q10s is calculated once the calculated 7Q10s (cfs) is entered in Tablel .
Revised narrative in Model narrative box with new instructions, new messages to alert user on actions needed and/or completed to correctly enter Model 7Q10s (cfs) in Table 1.
Remove conditions and features assocaited with entry of Model Acute IWC % .

Date: 8/13/2021
Dissolved to Total Metal Calculator
Do NOT enter any data directly into this spreadsheet.
Enter data onto "Table 1" under the Input Sheet and enter
"Effluent Hardness" under the Data Sheet.
In accordance with 40 CFR 122.45 (c ), permits are, have and
must be written as total metals.
This calculator has been inserted into the RPA to calculate
Total Metal allowable allocations once Table 1 has been
completed (Input Sheet) and Effluent hardness has been
entered (Data Sheet).
1) Following the spreadsheet from left to right.
First the allowable allocations for the dissolved metals will
appear for all the metals listed once Table 1 is complete
and effluent hardness entered. Use a default value of 25
mg/L if no hardness data is available.
Second, the Dissolved Metal allocations are divided by the
Translators to determine the Total Metals that can be
allocated to the Permittee. These Total Metals values are
automatically inserted into Table 2 and are the allowable
Total Metal allocations determined for the Permittee
prior to allowing for dilution. See Input sheet Table 2. The
final acute and chronic values shown under the RPA sheet
are the Total Metal values listed in Table 2 divided by the
acute and chronic IWC, respectively.
2) The Translators used in the freshwater RPA are the
Partition Coefficients published by US EPA in 1984. They
are TSS dependent equations and can be found listed with
the WQS hardness dependent equations under the sheet
labeled Equations. A fixed TSS value of 10 mg/L is used to
calculate the Translator values.
3) Pretreatment Facilities - PERCS will need a copy of the
Dissolved to Total Metal Calculator spreadsheet and the
RPA sheet along with the Final Permit. Pretreatment
Facilities are required to renew their Headwords Analysis
after renewal of their permits. Since all their metal
allocations are likely to change PERCS needs to see any
new metal permit limits and the allowable allocations for
the dissolved metals to assess Maximum Allowable
Headworks Loading (MAHL) numbers for each metal
based on the Combined Hardness values used in the
permit writers RPA calculations.
4) For Cadmium, Lead, Nickel, Chromium and Beryllium, if
all the effluent sampling data for the last three to five
years shows the pollutant at concentrations less than the
Practical Quantitative Level (PQL), it is not likely a limit or
monitoring will be put in the permit. However, if the
estimated NPDES permit limit is less than the Practical
Quantitative Limit (particularly, Cadmium and Lead) and
the pollutant is believed to be present, to assess
compliance with the new standards and for future permit
limit development, monitoring for the pollutant will be
required. If the facility is monitoring for the pollutant in its
Pretreatment LTMP, no monitoring is needed in the
permit.
5) For monitoring and compliance purposes if Total
FACILITY: Belews Steam Station
NPDES PERMIT: NC0024406
Dissolved to Total Metal Calculator
In accordance with Federal Regulations, permit limitations must be written as Total Metals per 40 CFR 122.45(c)
Receiving
Stream
summer
7Q10 (CFS)
PARAMETER
80.0000
Receiving
Stream
summer 7Q10
(MGD)
Rec. Stream
1Q10
[MGD]
51.6129 42.1935
NPDES
Flow Limit
[MGD]
Total Suspended
Solids
-Fixed Value-
(mg/L)
18.6000 1 10
Dissolved Metals
Chronic
Acute
[ug/l]
[ug/l]
US EPA
Translators- using
Default Partition
Coefficients
(streams)
Maximum Allowable Effluent Concentration
(MAEC) as a Total Metal
=Dissolved Metal Translator
Chronic
Acute
Combined
Hardness
chronic
(mg/L)
25.000
Combined
Hardness
Acute (mg/L)
25.000
Instream
Wastewater
Concentration
(Chronic)
26.4909
Instream
Wastewater
Concentration
(Acute)
30.5954
Upstream
Hardness
Average (mg/L)
25
Upstream Hard Avg (mg/L) =
EFF Hard Avg (mg/L) =
Effluent
Hardness
Average
(mg/L)
25
25
25
[ug/I]
[ug/I]
Cadmium (d)
Cd -Trout streams
Chromium III (d)(h)
Chromium VI (d)
Chromium, Total (t)
Copper (d)(h)
Lead (d)(h)
Nickel (d)(h)
Ni - WS streams (t)
Silver (d)(h,acute)
Zinc (d)(h)
0.15
0.15
24
11
2.7
0.54
16
0.06
36
0.82
0.51
183
16
3.6
14
145
0.30
36
0.252
0.252
0.202
1.000
0.348
0.184
0.432
1.000
0.288
0.59
0.59
117.73
11.00
N/A
7.88
2.94
37.23
3.24
2.01
905.08
16.00
N/A
10.47
75.49
335.21
25 N/A
0.06
0.30
126.73 125.71
Beryllium
Arsenic (d)
6.5
150
65
340
1.000
1.000
6.5
150
65
340
COMMENTS (identify parameters to PERCS Branch to maintain in facility's LTMP/STMP):
(d) = dissolved metal standard. See 15A NCAC 02B .0211 for more information.
(h) = hardness -dependent dissolved metal standard. See 15A NCAC 02B .0211 for more information.
(t) = based upon measurement of total recoveable metal. See 15A NCAC 02B .0211 for more information.
The Human Health standard for Nickel in Water Supply Streams is 25 mg/L which is Total Recoverable metal standard.
The Human Health standard for Arsenic is 10 µg/L which is Total Recoverable metal standard.
ACAH
ACCH

Dissolved Metals & Hardness Determination
v. 5/27/2010
I. How to Determine Hardness for use with Dissolved Freshwater Standards for Permitting Purposes
HARDNESS - Use 25 mg/L, expressed as CaCO, or Ca+Mg, as the default Hardness
OR
To determine a Hardness value for permit limit development, use the following equation:
Hardness
(mass balance)
(Hardness instream(a), mg/L * 7Q10, MGD)+(Hardness effluent(b), mg/L* Plant flow, MGD)
(7Q10, MGD + Plant flow, MGD)
(a) Use the median instream Hardness value of the ambient 8-digit HUC data collected by the Division of Water Quality. To find the 8-digit HUC hardness value for your facility Click Here.
(b) For the purpose of this estimation, use the facility's median effluent Hardness value, if available. The Division will request the permittee to sample effluent hardness once/month and submit one to two years of data with the permit renewal application. If no effluent hardness data is submitted, a default of 25 mg/L will be applied.
II. To Develop Dissolved Metal concentrations for permitting purposes use the Freshwater Standards for Hardness Dependent Metals listed in Table A below.
Table A: Dissolved Freshwater Standards for Hardness Dependent Metals
Metal
pg/L
Cadmium, Acute
{1.136672-[In hardness](0.041838)} • e^{0.9151 [In hardness]-3.1485}
Cadmium, Acute (Trout Waters)
{1.136672-[In hardness](0.041838)} • e^{0.9151[In hardness]-3.6236}
Cadmium, Chronic
{1.101672-[In hardness](0.041838)} • e^{0.7998[In hardness]-4.4451}
Chromium III, Acute
0.316 • e^{0.8190[In hardness]+3.7256}
Chromium III, Chronic
0.860 • e^{0.8190[In hardness]+0.6848}
Copper, Acute
0.960 • e^{0.9422[In hardness]-1.700}
Copper, Chronic
0.960 • e^{0.8545[In hardness]-1.702}
Lead, Acute
{1.46203-[In hardness](0.145712)} • e^{1.273[In hardness]-1.460}
Lead, Chronic
{1.46203-[In hardness](0.145712)} • e^{1.273[In hardness]-4.705}
Nickel, Acute
0.998 • e^{0.8460[In hardness]+2.255}
Nickel, Chronic
0.997 • e^{0.8460[In hardness]+0.0584}
Silver, Acute
0.85 • e^{1.72[In hardness]-6.59}
Silver, Chronic
Not applicable
Zinc, Acute
0.978 • e^{0.8473[In hardness]+0.884}
Zinc, Chronic
0.986 • e^{0.8473[In hardness]+0.884}
Complete information on all the proposed Surface Water Quality Standards can be viewed at: http://h2o.enr.state.nc.us/csu/trirev SW.html.

US EPA Translators
using Default Partition Coefficients (DPC)
Translator equation using Default Partition Coefficients =
1
v. 6/2/2010
[1 + (Kpo * TSS (1+a) * 10-6)]
Kpo and a are constants that express the equilibrium relationship between dissolved and adsorbed forms of metals.
A default value of 10 mg/L Total Suspended Solids (TSS) will be used.
Table A contains the Default Partition Coefficients for the equation.
Table B contains the calculated translators using the default partition coefficients for streams.
TABLE A. Default Partition Coefficients
STREAMS
Metal (1)
Kpo
a
Cu
1.04E+06
-0.7436
Zn
1.25E+06
-0.7038
Pb
2.80E+06
-0.8
Cr (III) (2)
3.36E+06
-0.09304
Cd
4.00E+06
-1.1307
Ni
4.90E+05
-0.5719
(1) Delos, C.G., et al. Technical Guidance for Perfo ming Waste Load Allocations. Book II: Streams and Rivers. Chapter 3: Toxic Substances, For the U.S. EPA. (EPA-440/4-84-022)
(2) Linear partition coefficients shall not apply to the Chromium VI numerical criterion. The approved analytical method for Chromium VI measures only the dissolved form. Therefore,
TABLE B. US EPA Translators
PARAMETER
US EPA Translators
Using stream Default Partition Coefficients
TSS = 10 mg/L
Cadmium
0.252
Chromium III
0.202
Chromium VI
1
Chromium, Total
N/A
Copper
0.348
Lead
0.184
Nickel
0.432
Silver
1
Zinc
0.288
Example for Cadmium (streams)
Given:
TSS = 10 mg/L
Kpo = 4.00E + 06
a =-1.1307
Translator = 1
[1 + (Kpo * TSS (1*00 * 10-6)]
[1 + (4.00x106 * 101-1.13°0 * 10-6)]
[1+2.960465]
= 0.252