ML18337A412: Difference between revisions

From kanterella
Jump to navigation Jump to search
(Created page by program invented by StriderTol)
(StriderTol Bot change)
 
(One intermediate revision by the same user not shown)
Line 17: Line 17:
{{#Wiki_filter:This excel file is to provide calculation summary of the example that was used to estimate the conditional C-SGTR fraction for different SG ages as documented in Appendix 2-E of the RASP Handbook Volume 5.
{{#Wiki_filter:This excel file is to provide calculation summary of the example that was used to estimate the conditional C-SGTR fraction for different SG ages as documented in Appendix 2-E of the RASP Handbook Volume 5.


Table 2.3-4 Example Calculation 1 input         # of SGs                                                   4 input         # of tubes/SG                                             3300 input         Total # of SG tubes                                     13200     Transferred to tabs "600TT" and "690TT" as input.
Table 2.3-4 Example Calculation 1 input
input         Tube material                                           600TT                                                       690TT input         Nth outage at EFPY                                         23 input         N-1th outage at EFPY                                     21.7
# of SGs 4
              # of flaws created from K 21 to K 22                       52     From tables 2.3-2 and 2.3-3: adjust as needed       25
input
              # of flaws created from K 22 to K 23                       53     From tables 2.3-2 and 2.3-3: adjust as needed       26 Calc-1       Total # of flaws created from K 21.7 to 23                 68     Adjust this equation as needed                     34 Calc-2       # of large flaws expected in K 21.7 to K 23               0.05     = Calc-1
# of tubes/SG 3300 input Total # of SG tubes 13200 Transferred to tabs "600TT" and "690TT" as input.
* 6.98E-04                               0.02 Calc-3       # of pluggable flaws expected in K 21.7 to K 23             8     = Calc-1
input Tube material 600TT 690TT input Nth outage at EFPY 23 input N-1th outage at EFPY 21.7
* 0.12                                     4 A quick estimate of conditional C-SGTR probability                 assuming any large flaw leads to C-SGTR and Calc-4                                                                0.024                                                      0.012 p(CSGTR)                                                          accident occur in the middle of the time period The fraction, 0.12 of tubes expected to be plugged is taken from Table 2.3-1 as the probability of flaws that are 0.30 deep or deeper, as represented by the yellow and blue areas in the table.
# of flaws created from K 21 to K 22 52 From tables 2.3-2 and 2.3-3: adjust as needed 25
# of flaws created from K 22 to K 23 53 From tables 2.3-2 and 2.3-3: adjust as needed 26 Calc-1 Total # of flaws created from K 21.7 to 23 68 Adjust this equation as needed 34 Calc-2
# of large flaws expected in K 21.7 to K 23 0.05
= Calc-1
* 6.98E-04 0.02 Calc-3
# of pluggable flaws expected in K 21.7 to K 23 8
= Calc-1
* 0.12 4
Calc-4 A quick estimate of conditional C-SGTR probability p(CSGTR) 0.024 assuming any large flaw leads to C-SGTR and accident occur in the middle of the time period 0.012 The fraction, 0.12 of tubes expected to be plugged is taken from Table 2.3-1 as the probability of flaws that are 0.30 deep or deeper, as represented by the yellow and blue areas in the table.
The probability of a large flaw is 6.98E-04 as defined in Table 2.3-1 by the flaws in the blue area.
The probability of a large flaw is 6.98E-04 as defined in Table 2.3-1 by the flaws in the blue area.
Calc-2       Large flaws are shown bu blue and yellow areas in Table 2.3-1.
Calc-2 Large flaws are shown bu blue and yellow areas in Table 2.3-1.
Calc-3       For information only. It is not used in the above estimates for p(CSGTR), which is given by Calc-4.
Calc-3 For information only. It is not used in the above estimates for p(CSGTR), which is given by Calc-4.
Calc-4       Calc-4 = p(CSGTR) = Calc-2 / 2 CAUTION       Number of flaws from Tables 2.3-2 and 2.3-3 MUST BE CHANGED if EFPY input is changed.
Calc-4 Calc-4 = p(CSGTR) = Calc-2 / 2 CAUTION Number of flaws from Tables 2.3-2 and 2.3-3 MUST BE CHANGED if EFPY input is changed.
The equation for Calc-1 in cells C12 and E12 MUST BE ADJUSTED by the user if the EFPY input is changed.
The equation for Calc-1 in cells C12 and E12 MUST BE ADJUSTED by the user if the EFPY input is changed.
Other calculations are hard-wired.
Other calculations are hard-wired.
This EXCEL worksheet allows changing number of SGTs, duration between refueling, and SGT age.
This EXCEL worksheet allows changing number of SGTs, duration between refueling, and SGT age.
Note:         Although this EXCEL workbook can also be used to calculate p(CSGTR) for different number of SG tubes, it is recommended that the p(SGTR) values given in Tables 2.4-1 and 2.4-2 be used as is for LERF estimates, regardless of the number of tubes or loops in a plant of interest.
Note:
Although this EXCEL workbook can also be used to calculate p(CSGTR) for different number of SG tubes, it is recommended that the p(SGTR) values given in Tables 2.4-1 and 2.4-2 be used as is for LERF estimates, regardless of the number of tubes or loops in a plant of interest.


Table 2.3-5 Example Calculation 2                     - RASP Handbook EXCEL-2.xlsx input         # of SGs                                                   4 input         # of tubes/SG                                             3300 input         Total # of SG tubes                                     13200     Transferred to tabs "600TT" and "690TT" as input.
Table 2.3-5 Example Calculation 2
input         Tube material                                           600TT                                                       690TT input         Nth outage at EFPY                                         16 input         N-1th outage at EFPY                                       15
- RASP Handbook EXCEL-2.xlsx input
              # of flaws created from K 15 to K 16                       47     From tables 2.3-2 and 2.3-3: adjust as needed       21 Calc-1       Total # of flaws created from K 15 to 16                   47     Adjust this equation as needed                     21 Calc-2       # of large flaws expected in K 15 to K 16                 0.03     = Calc-1
# of SGs 4
* 6.98E-04                               0.01 Calc-3       # of pluggable flaws expected in K 15 to 16                 6     = Calc-1
input
* 0.12                                     2 A quick estimate of conditional C-SGTR probability                 assuming any large flaw leads to C-SGTR and Calc-4                                                                0.016                                                      0.007 p(CSGTR)                                                          accident occur in the middle of the time period The fraction, 0.12 of tubes expected to be plugged is taken from Table 2.3-1 as the probability of flaws that are 0.30 deep or deeper, as represented by the yellow and blue areas in the table.
# of tubes/SG 3300 input Total # of SG tubes 13200 Transferred to tabs "600TT" and "690TT" as input.
input Tube material 600TT 690TT input Nth outage at EFPY 16 input N-1th outage at EFPY 15
# of flaws created from K 15 to K 16 47 From tables 2.3-2 and 2.3-3: adjust as needed 21 Calc-1 Total # of flaws created from K 15 to 16 47 Adjust this equation as needed 21 Calc-2
# of large flaws expected in K 15 to K 16 0.03
= Calc-1
* 6.98E-04 0.01 Calc-3
# of pluggable flaws expected in K 15 to 16 6
= Calc-1
* 0.12 2
Calc-4 A quick estimate of conditional C-SGTR probability p(CSGTR) 0.016 assuming any large flaw leads to C-SGTR and accident occur in the middle of the time period 0.007 The fraction, 0.12 of tubes expected to be plugged is taken from Table 2.3-1 as the probability of flaws that are 0.30 deep or deeper, as represented by the yellow and blue areas in the table.
The probability of a large flaw is 6.98E-04 as defined in Table 2.3-1 by the flaws in the blue area.
The probability of a large flaw is 6.98E-04 as defined in Table 2.3-1 by the flaws in the blue area.
Calc-2       Large flaws are shown bu blue and yellow areas in Table 2.3-1.
Calc-2 Large flaws are shown bu blue and yellow areas in Table 2.3-1.
Calc-3       For information only. It is not used in the above estimates for p(CSGTR), which is given by Calc-4.
Calc-3 For information only. It is not used in the above estimates for p(CSGTR), which is given by Calc-4.
Calc-4       Calc-4 = p(CSGTR) = Calc-2 / 2 CAUTION       Number of flaws from Tables 2.3-2 and 2.3-3 MUST BE CHANGED if EFPY input is changed.
Calc-4 Calc-4 = p(CSGTR) = Calc-2 / 2 CAUTION Number of flaws from Tables 2.3-2 and 2.3-3 MUST BE CHANGED if EFPY input is changed.
The equation for Calc-1 in cells C12 and E12 MUST BE ADJUSTED by the user if the EFPY input is changed.
The equation for Calc-1 in cells C12 and E12 MUST BE ADJUSTED by the user if the EFPY input is changed.
Other calculations are hard-wired.
Other calculations are hard-wired.
This EXCEL worksheet allows changing number of SGTs, duration between refueling, and SGT age.
This EXCEL worksheet allows changing number of SGTs, duration between refueling, and SGT age.


FROM THE NUREG WORD FILE Table 7-5. Probability that a Detected Flaw Belongs to a Bin Size Length of Flaw Total 0 to 1 cm  1 to 2 cm  2 to 3 cm 3 to 4 cm  4 to 5 cm  5 to 6 cm 0 to 0.1     2.74E-03   4.62E-02   2.23E-02 5.38E-03     1.04E-03   1.80E-04   7.78E-02 0.1 to 0.2   1.86E-02   3.14E-01   1.52E-01 3.66E-02     7.08E-03   1.23E-03   5.29E-01 Flaw Depth $/100 0.2 to 0.3   9.59E-03   1.62E-01   7.81E-02 1.89E-02     3.64E-03   6.31E-04   2.73E-01 0.3 to 0.4   3.09E-03   5.21E-02   2.52E-02 6.07E-03     1.17E-03   2.03E-04   8.78E-02 0.4 to 0.5   8.47E-04   1.43E-02   6.90E-03 1.66E-03     3.22E-04   5.57E-05   2.41E-02 0.5 to 0.6   2.14E-04   3.61E-03   1.74E-03 4.21E-04     8.13E-05   1.41E-05   6.08E-03 0.6 to 0.7   5.14E-05   8.67E-04   4.19E-04 1.01E-04     1.95E-05   3.38E-06   1.46E-03 0.7 to 0.8   1.19E-05   2.01E-04   9.73E-05 2.35E-05     4.54E-06   7.86E-07   3.39E-04 0.8 to 0.9   2.71E-06   4.57E-05   2.21E-05 5.32E-06     1.03E-06   1.78E-07   7.70E-05 0.9 to 1.0     small Total 3.52E-02   5.93E-01   2.86E-01   6.91E-02   1.34E-02   2.31E-03       ~1 1.00E+00 WHEN NUREG WORD FILE IS IMPORTED INTO EXCEL AND ROW AND COLUMN SUMS ARE MADE Table 2.3-1. Probability that a Detected Flaw Belongs to a Bin Size Flaw Length Total 0 to 1 cm  1 to 2 cm  2 to 3 cm 3 to 4 cm  4 to 5 cm  5 to 6 cm 0 to 0.1     2.74E-03   4.62E-02   2.23E-02 5.38E-03     1.04E-03   1.80E-04   7.78E-02 0.1 to 0.2   1.86E-02   3.14E-01   1.52E-01 3.66E-02     7.08E-03   1.23E-03   5.30E-01 Flaw Depth %/100 0.2 to 0.3   9.59E-03   1.62E-01   7.81E-02 1.89E-02     3.64E-03   6.31E-04   2.73E-01 0.3 to 0.4   3.09E-03   5.21E-02   2.52E-02 6.07E-03     1.17E-03   2.03E-04   8.78E-02 0.4 to 0.5   8.47E-04   1.43E-02   6.90E-03 1.66E-03     3.22E-04   5.57E-05   2.41E-02 0.5 to 0.6   2.14E-04   3.61E-03   1.74E-03 4.21E-04     8.13E-05   1.41E-05   6.08E-03 0.6 to 0.7   5.14E-05   8.67E-04   4.19E-04 1.01E-04     1.95E-05   3.38E-06   1.46E-03 0.7 to 0.8   1.19E-05   2.01E-04   9.73E-05 2.35E-05     4.54E-06   7.86E-07   3.39E-04 0.8 to 0.9   2.71E-06   4.57E-05   2.21E-05 5.32E-06     1.03E-06   1.78E-07   7.70E-05 0.9 to 1.0     small Total = 3.51E-02   5.93E-01   2.87E-01   6.92E-02   1.34E-02   2.32E-03   1.00E+00 1.00E+00 6.98E-04                       total probability of blue area 1.20E-01                       total probability of yellow + blue areas 1.19E-01                       total probability of yellow area 1.00E+00                       total probability of table bins
FROM THE NUREG WORD FILE 0to 1cm 1to 2cm 2to 3cm 3to 4cm 4to 5cm 5to 6cm 0 to 0.1 2.74E-03 4.62E-02 2.23E-02 5.38E-03 1.04E-03 1.80E-04 7.78E-02 0.1 to 0.2 1.86E-02 3.14E-01 1.52E-01 3.66E-02 7.08E-03 1.23E-03 5.29E-01 0.2 to 0.3 9.59E-03 1.62E-01 7.81E-02 1.89E-02 3.64E-03 6.31E-04 2.73E-01 0.3 to 0.4 3.09E-03 5.21E-02 2.52E-02 6.07E-03 1.17E-03 2.03E-04 8.78E-02 0.4 to 0.5 8.47E-04 1.43E-02 6.90E-03 1.66E-03 3.22E-04 5.57E-05 2.41E-02 0.5 to 0.6 2.14E-04 3.61E-03 1.74E-03 4.21E-04 8.13E-05 1.41E-05 6.08E-03 0.6 to 0.7 5.14E-05 8.67E-04 4.19E-04 1.01E-04 1.95E-05 3.38E-06 1.46E-03 0.7 to 0.8 1.19E-05 2.01E-04 9.73E-05 2.35E-05 4.54E-06 7.86E-07 3.39E-04 0.8 to 0.9 2.71E-06 4.57E-05 2.21E-05 5.32E-06 1.03E-06 1.78E-07 7.70E-05 0.9 to 1.0 small 3.52E-02 5.93E-01 2.86E-01 6.91E-02 1.34E-02 2.31E-03
~1 1.00E+00 WHEN NUREG WORD FILE IS IMPORTED INTO EXCEL AND ROW AND COLUMN SUMS ARE MADE 0to 1cm 1to 2cm 2to 3cm 3to 4cm 4to 5cm 5to 6cm 0 to 0.1 2.74E-03 4.62E-02 2.23E-02 5.38E-03 1.04E-03 1.80E-04 7.78E-02 0.1 to 0.2 1.86E-02 3.14E-01 1.52E-01 3.66E-02 7.08E-03 1.23E-03 5.30E-01 0.2 to 0.3 9.59E-03 1.62E-01 7.81E-02 1.89E-02 3.64E-03 6.31E-04 2.73E-01 0.3 to 0.4 3.09E-03 5.21E-02 2.52E-02 6.07E-03 1.17E-03 2.03E-04 8.78E-02 0.4 to 0.5 8.47E-04 1.43E-02 6.90E-03 1.66E-03 3.22E-04 5.57E-05 2.41E-02 0.5 to 0.6 2.14E-04 3.61E-03 1.74E-03 4.21E-04 8.13E-05 1.41E-05 6.08E-03 0.6 to 0.7 5.14E-05 8.67E-04 4.19E-04 1.01E-04 1.95E-05 3.38E-06 1.46E-03 0.7 to 0.8 1.19E-05 2.01E-04 9.73E-05 2.35E-05 4.54E-06 7.86E-07 3.39E-04 0.8 to 0.9 2.71E-06 4.57E-05 2.21E-05 5.32E-06 1.03E-06 1.78E-07 7.70E-05 0.9 to 1.0 small 3.51E-02 5.93E-01 2.87E-01 6.92E-02 1.34E-02 2.32E-03 1.00E+00 1.00E+00 6.98E-04 total probability of blue area 1.20E-01 total probability of yellow + blue areas 1.19E-01 total probability of yellow area 1.00E+00 total probability of table bins Flaw Depth %/100 Total =
Total Table 2.3-1. Probability that a Detected Flaw Belongs to a Bin Size Flaw Length Total Flaw Depth $/100 Table 7-5. Probability that a Detected Flaw Belongs to a Bin Size Length of Flaw Total


Table 2.3-2 Flaw Estimates - 600TT                                         600TT h(k) = mu*K + sigma                                                     = Hazard Rate Nflaws = (# of tubes) * [1.0  exp[{(1/2) *
Table 2.3-2 Flaw Estimates - 600TT 600TT h(k)=mu*K+sigma
* k2 +
= Hazard Rate Nflaws = (# of tubes)*[1.0exp[{(1/2)* *k2 +*k}))
* k}]]          = NFlawsAvg
= NFlawsAvg
# of tubes       13200                                         K = EFPY             mu =   6.42E-05       0         0 sigma =   1.32E-03   2.00E-04 1.00E-03 Flaws generated since last EFPY                                             TOTAL # of flaws detected at EFPY (1)
# of tubes 13200 K = EFPY mu =
K                                                                               K Volumetric           Axial         Circumf.       Total                   Volumetric     Axial Circumf. Total (1)
6.42E-05 0
EFPY                                                                              EFPY 15             30                 0               0           30               15       357         0         0       357 16             31                 3               13           47               16       388         3       13       403 17             32                 3               13           48               17       419         5       26       451 18             33                 3               13           49               18       451         8       40       499 19             34                 3               13           49               19       484         11       53       547 20             34                 3               13           50               20       518         13       66       597 21             35                 3               13           51               21       552         16       79       647 22             36                 3               13           52               22       588         18       92       699 23             37                 3               13           53               23       624         21       106       751 24             38                 3               13           54               24       661         24       119       804 25             39                 3               13           54               25       699         26       132       857 26             39                 3               13           55               26       737         29       145       912 27             40                 3               13           56               27       777         32       158       967 28             41                 3               13           57               28       817         34       172     1023 29             42                 3               13           58               29       858         37       185     1080 30             43                 3               13           59               30       900         40       198     1137 31             44                 3               13           60               31       942         42       211     1196 32             45                 3               13           60               32       986         45       224     1255 33             45                 3               13           61               33       1030         48       238     1315 34             46                 3               13           62               34       1075         50       251     1376 35             47                 3               13           63               35       1120         53       264     1437 (1) Total is not adjusted for # of flaws that are already plugged.
0 sigma =
1.32E-03 2.00E-04 1.00E-03 Flaws generated since last EFPY TOTAL # of flaws detected at EFPY (1)
K EFPY Volumetric Axial Circumf.
Total K
EFPY Volumetric Axial Circumf.
Total (1) 15 30 0
0 30 15 357 0
0 357 16 31 3
13 47 16 388 3
13 403 17 32 3
13 48 17 419 5
26 451 18 33 3
13 49 18 451 8
40 499 19 34 3
13 49 19 484 11 53 547 20 34 3
13 50 20 518 13 66 597 21 35 3
13 51 21 552 16 79 647 22 36 3
13 52 22 588 18 92 699 23 37 3
13 53 23 624 21 106 751 24 38 3
13 54 24 661 24 119 804 25 39 3
13 54 25 699 26 132 857 26 39 3
13 55 26 737 29 145 912 27 40 3
13 56 27 777 32 158 967 28 41 3
13 57 28 817 34 172 1023 29 42 3
13 58 29 858 37 185 1080 30 43 3
13 59 30 900 40 198 1137 31 44 3
13 60 31 942 42 211 1196 32 45 3
13 60 32 986 45 224 1255 33 45 3
13 61 33 1030 48 238 1315 34 46 3
13 62 34 1075 50 251 1376 35 47 3
13 63 35 1120 53 264 1437 (1) Total is not adjusted for # of flaws that are already plugged.


Table 2.3-3 Flaw Estimates - 690TT                                 690TT h(k) = mu*K + sigma                                                     = Hazard Rate Nflaws = (# of tubes) * [1.0  exp[{(1/2) *
Table 2.3-3 Flaw Estimates - 690TT 690TT h(k)=mu*K+sigma
* k2 +
= Hazard Rate Nflaws = (# of tubes)*[1.0exp[{(1/2)* *k2 +*k}))
* k}]]          = NFlawsAvg
= NFlawsAvg
# of tubes         13200                                       K = EFPY                 mu = 5.58E-05 0.00E+00 0.00E+00 sigma = 6.86E-04 0.00E+00 0.00E+00 Flaws generated since last EFPY                                             TOTAL # of flaws detected at EFPY (1)
# of tubes 13200 K = EFPY mu =
K                                                                               K Volumetric         Axial       Circumf.         Total                   Volumetric   Axial Circumf. Total (1)
5.58E-05 0.00E+00 0.00E+00 sigma =
EFPY                                                                              EFPY 15             20               0               0             20               15       219       0         0       219 16             21               0               0             21               16       239       0         0       239 17             22               0               0             22               17       260       0         0       260 18             22               0               0             22               18       282       0         0       282 19             23               0               0             23               19       304       0         0       304 20             24               0               0             24               20       328       0         0       328 21             25               0               0             25               21       352       0         0       352 22             25               0               0             25               22       376       0         0       376 23             26               0               0             26               23       402       0         0       402 24             27               0               0             27               24       428       0         0       428 25             27               0               0             27               25       455       0         0       455 26             28               0               0             28               26       482       0         0       482 27             29               0               0             29               27       510       0         0       510 28             30               0               0             30               28       539       0         0       539 29             30               0               0             30               29       569       0         0       569 30             31               0               0             31               30       599       0         0       599 31             32               0               0             32               31       630       0         0       630 32             33               0               0             33               32       662       0         0       662 33             33               0               0             33               33       694       0         0       694 34             34               0               0             34               34       727       0         0       727 35             35               0               0             35               35       761       0         0       761 (1) Total is not adjusted for # of flaws that are already plugged.}}
6.86E-04 0.00E+00 0.00E+00 Flaws generated since last EFPY TOTAL # of flaws detected at EFPY (1)
K EFPY Volumetric Axial Circumf.
Total K
EFPY Volumetric Axial Circumf.
Total (1) 15 20 0
0 20 15 219 0
0 219 16 21 0
0 21 16 239 0
0 239 17 22 0
0 22 17 260 0
0 260 18 22 0
0 22 18 282 0
0 282 19 23 0
0 23 19 304 0
0 304 20 24 0
0 24 20 328 0
0 328 21 25 0
0 25 21 352 0
0 352 22 25 0
0 25 22 376 0
0 376 23 26 0
0 26 23 402 0
0 402 24 27 0
0 27 24 428 0
0 428 25 27 0
0 27 25 455 0
0 455 26 28 0
0 28 26 482 0
0 482 27 29 0
0 29 27 510 0
0 510 28 30 0
0 30 28 539 0
0 539 29 30 0
0 30 29 569 0
0 569 30 31 0
0 31 30 599 0
0 599 31 32 0
0 32 31 630 0
0 630 32 33 0
0 33 32 662 0
0 662 33 33 0
0 33 33 694 0
0 694 34 34 0
0 34 34 727 0
0 727 35 35 0
0 35 35 761 0
0 761 (1) Total is not adjusted for # of flaws that are already plugged.}}

Latest revision as of 08:54, 5 January 2025

C-SGTR RASP Handbook Vol 5 Worksheet Estimate C-SGTR Due to SG Ages Public v3
ML18337A412
Person / Time
Issue date: 12/04/2018
From:
NRC/NRR/DRA/APOB
To:
References
Download: ML18337A412 (6)


Text

This excel file is to provide calculation summary of the example that was used to estimate the conditional C-SGTR fraction for different SG ages as documented in Appendix 2-E of the RASP Handbook Volume 5.

Table 2.3-4 Example Calculation 1 input

  1. of SGs 4

input

  1. of tubes/SG 3300 input Total # of SG tubes 13200 Transferred to tabs "600TT" and "690TT" as input.

input Tube material 600TT 690TT input Nth outage at EFPY 23 input N-1th outage at EFPY 21.7

  1. of flaws created from K 21 to K 22 52 From tables 2.3-2 and 2.3-3: adjust as needed 25
  1. of flaws created from K 22 to K 23 53 From tables 2.3-2 and 2.3-3: adjust as needed 26 Calc-1 Total # of flaws created from K 21.7 to 23 68 Adjust this equation as needed 34 Calc-2
  1. of large flaws expected in K 21.7 to K 23 0.05

= Calc-1

  • 6.98E-04 0.02 Calc-3
  1. of pluggable flaws expected in K 21.7 to K 23 8

= Calc-1

  • 0.12 4

Calc-4 A quick estimate of conditional C-SGTR probability p(CSGTR) 0.024 assuming any large flaw leads to C-SGTR and accident occur in the middle of the time period 0.012 The fraction, 0.12 of tubes expected to be plugged is taken from Table 2.3-1 as the probability of flaws that are 0.30 deep or deeper, as represented by the yellow and blue areas in the table.

The probability of a large flaw is 6.98E-04 as defined in Table 2.3-1 by the flaws in the blue area.

Calc-2 Large flaws are shown bu blue and yellow areas in Table 2.3-1.

Calc-3 For information only. It is not used in the above estimates for p(CSGTR), which is given by Calc-4.

Calc-4 Calc-4 = p(CSGTR) = Calc-2 / 2 CAUTION Number of flaws from Tables 2.3-2 and 2.3-3 MUST BE CHANGED if EFPY input is changed.

The equation for Calc-1 in cells C12 and E12 MUST BE ADJUSTED by the user if the EFPY input is changed.

Other calculations are hard-wired.

This EXCEL worksheet allows changing number of SGTs, duration between refueling, and SGT age.

Note:

Although this EXCEL workbook can also be used to calculate p(CSGTR) for different number of SG tubes, it is recommended that the p(SGTR) values given in Tables 2.4-1 and 2.4-2 be used as is for LERF estimates, regardless of the number of tubes or loops in a plant of interest.

Table 2.3-5 Example Calculation 2

- RASP Handbook EXCEL-2.xlsx input

  1. of SGs 4

input

  1. of tubes/SG 3300 input Total # of SG tubes 13200 Transferred to tabs "600TT" and "690TT" as input.

input Tube material 600TT 690TT input Nth outage at EFPY 16 input N-1th outage at EFPY 15

  1. of flaws created from K 15 to K 16 47 From tables 2.3-2 and 2.3-3: adjust as needed 21 Calc-1 Total # of flaws created from K 15 to 16 47 Adjust this equation as needed 21 Calc-2
  1. of large flaws expected in K 15 to K 16 0.03

= Calc-1

  • 6.98E-04 0.01 Calc-3
  1. of pluggable flaws expected in K 15 to 16 6

= Calc-1

  • 0.12 2

Calc-4 A quick estimate of conditional C-SGTR probability p(CSGTR) 0.016 assuming any large flaw leads to C-SGTR and accident occur in the middle of the time period 0.007 The fraction, 0.12 of tubes expected to be plugged is taken from Table 2.3-1 as the probability of flaws that are 0.30 deep or deeper, as represented by the yellow and blue areas in the table.

The probability of a large flaw is 6.98E-04 as defined in Table 2.3-1 by the flaws in the blue area.

Calc-2 Large flaws are shown bu blue and yellow areas in Table 2.3-1.

Calc-3 For information only. It is not used in the above estimates for p(CSGTR), which is given by Calc-4.

Calc-4 Calc-4 = p(CSGTR) = Calc-2 / 2 CAUTION Number of flaws from Tables 2.3-2 and 2.3-3 MUST BE CHANGED if EFPY input is changed.

The equation for Calc-1 in cells C12 and E12 MUST BE ADJUSTED by the user if the EFPY input is changed.

Other calculations are hard-wired.

This EXCEL worksheet allows changing number of SGTs, duration between refueling, and SGT age.

FROM THE NUREG WORD FILE 0to 1cm 1to 2cm 2to 3cm 3to 4cm 4to 5cm 5to 6cm 0 to 0.1 2.74E-03 4.62E-02 2.23E-02 5.38E-03 1.04E-03 1.80E-04 7.78E-02 0.1 to 0.2 1.86E-02 3.14E-01 1.52E-01 3.66E-02 7.08E-03 1.23E-03 5.29E-01 0.2 to 0.3 9.59E-03 1.62E-01 7.81E-02 1.89E-02 3.64E-03 6.31E-04 2.73E-01 0.3 to 0.4 3.09E-03 5.21E-02 2.52E-02 6.07E-03 1.17E-03 2.03E-04 8.78E-02 0.4 to 0.5 8.47E-04 1.43E-02 6.90E-03 1.66E-03 3.22E-04 5.57E-05 2.41E-02 0.5 to 0.6 2.14E-04 3.61E-03 1.74E-03 4.21E-04 8.13E-05 1.41E-05 6.08E-03 0.6 to 0.7 5.14E-05 8.67E-04 4.19E-04 1.01E-04 1.95E-05 3.38E-06 1.46E-03 0.7 to 0.8 1.19E-05 2.01E-04 9.73E-05 2.35E-05 4.54E-06 7.86E-07 3.39E-04 0.8 to 0.9 2.71E-06 4.57E-05 2.21E-05 5.32E-06 1.03E-06 1.78E-07 7.70E-05 0.9 to 1.0 small 3.52E-02 5.93E-01 2.86E-01 6.91E-02 1.34E-02 2.31E-03

~1 1.00E+00 WHEN NUREG WORD FILE IS IMPORTED INTO EXCEL AND ROW AND COLUMN SUMS ARE MADE 0to 1cm 1to 2cm 2to 3cm 3to 4cm 4to 5cm 5to 6cm 0 to 0.1 2.74E-03 4.62E-02 2.23E-02 5.38E-03 1.04E-03 1.80E-04 7.78E-02 0.1 to 0.2 1.86E-02 3.14E-01 1.52E-01 3.66E-02 7.08E-03 1.23E-03 5.30E-01 0.2 to 0.3 9.59E-03 1.62E-01 7.81E-02 1.89E-02 3.64E-03 6.31E-04 2.73E-01 0.3 to 0.4 3.09E-03 5.21E-02 2.52E-02 6.07E-03 1.17E-03 2.03E-04 8.78E-02 0.4 to 0.5 8.47E-04 1.43E-02 6.90E-03 1.66E-03 3.22E-04 5.57E-05 2.41E-02 0.5 to 0.6 2.14E-04 3.61E-03 1.74E-03 4.21E-04 8.13E-05 1.41E-05 6.08E-03 0.6 to 0.7 5.14E-05 8.67E-04 4.19E-04 1.01E-04 1.95E-05 3.38E-06 1.46E-03 0.7 to 0.8 1.19E-05 2.01E-04 9.73E-05 2.35E-05 4.54E-06 7.86E-07 3.39E-04 0.8 to 0.9 2.71E-06 4.57E-05 2.21E-05 5.32E-06 1.03E-06 1.78E-07 7.70E-05 0.9 to 1.0 small 3.51E-02 5.93E-01 2.87E-01 6.92E-02 1.34E-02 2.32E-03 1.00E+00 1.00E+00 6.98E-04 total probability of blue area 1.20E-01 total probability of yellow + blue areas 1.19E-01 total probability of yellow area 1.00E+00 total probability of table bins Flaw Depth %/100 Total =

Total Table 2.3-1. Probability that a Detected Flaw Belongs to a Bin Size Flaw Length Total Flaw Depth $/100 Table 7-5. Probability that a Detected Flaw Belongs to a Bin Size Length of Flaw Total

Table 2.3-2 Flaw Estimates - 600TT 600TT h(k)=mu*K+sigma

= Hazard Rate Nflaws = (# of tubes)*[1.0exp[{(1/2)* *k2 +*k}))

= NFlawsAvg

  1. of tubes 13200 K = EFPY mu =

6.42E-05 0

0 sigma =

1.32E-03 2.00E-04 1.00E-03 Flaws generated since last EFPY TOTAL # of flaws detected at EFPY (1)

K EFPY Volumetric Axial Circumf.

Total K

EFPY Volumetric Axial Circumf.

Total (1) 15 30 0

0 30 15 357 0

0 357 16 31 3

13 47 16 388 3

13 403 17 32 3

13 48 17 419 5

26 451 18 33 3

13 49 18 451 8

40 499 19 34 3

13 49 19 484 11 53 547 20 34 3

13 50 20 518 13 66 597 21 35 3

13 51 21 552 16 79 647 22 36 3

13 52 22 588 18 92 699 23 37 3

13 53 23 624 21 106 751 24 38 3

13 54 24 661 24 119 804 25 39 3

13 54 25 699 26 132 857 26 39 3

13 55 26 737 29 145 912 27 40 3

13 56 27 777 32 158 967 28 41 3

13 57 28 817 34 172 1023 29 42 3

13 58 29 858 37 185 1080 30 43 3

13 59 30 900 40 198 1137 31 44 3

13 60 31 942 42 211 1196 32 45 3

13 60 32 986 45 224 1255 33 45 3

13 61 33 1030 48 238 1315 34 46 3

13 62 34 1075 50 251 1376 35 47 3

13 63 35 1120 53 264 1437 (1) Total is not adjusted for # of flaws that are already plugged.

Table 2.3-3 Flaw Estimates - 690TT 690TT h(k)=mu*K+sigma

= Hazard Rate Nflaws = (# of tubes)*[1.0exp[{(1/2)* *k2 +*k}))

= NFlawsAvg

  1. of tubes 13200 K = EFPY mu =

5.58E-05 0.00E+00 0.00E+00 sigma =

6.86E-04 0.00E+00 0.00E+00 Flaws generated since last EFPY TOTAL # of flaws detected at EFPY (1)

K EFPY Volumetric Axial Circumf.

Total K

EFPY Volumetric Axial Circumf.

Total (1) 15 20 0

0 20 15 219 0

0 219 16 21 0

0 21 16 239 0

0 239 17 22 0

0 22 17 260 0

0 260 18 22 0

0 22 18 282 0

0 282 19 23 0

0 23 19 304 0

0 304 20 24 0

0 24 20 328 0

0 328 21 25 0

0 25 21 352 0

0 352 22 25 0

0 25 22 376 0

0 376 23 26 0

0 26 23 402 0

0 402 24 27 0

0 27 24 428 0

0 428 25 27 0

0 27 25 455 0

0 455 26 28 0

0 28 26 482 0

0 482 27 29 0

0 29 27 510 0

0 510 28 30 0

0 30 28 539 0

0 539 29 30 0

0 30 29 569 0

0 569 30 31 0

0 31 30 599 0

0 599 31 32 0

0 32 31 630 0

0 630 32 33 0

0 33 32 662 0

0 662 33 33 0

0 33 33 694 0

0 694 34 34 0

0 34 34 727 0

0 727 35 35 0

0 35 35 761 0

0 761 (1) Total is not adjusted for # of flaws that are already plugged.