ML18337A412: Difference between revisions

From kanterella
Jump to navigation Jump to search
(Created page by program invented by StriderTol)
 
(Created page by program invented by StriderTol)
Line 16: Line 16:
=Text=
=Text=
{{#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 1input# of SGs 4input# of tubes/SG 3300inputTotal # of SG tubes 13200Transferred to tabs "600TT" and "690TT" as input.inputTube material600TT690TTinputNth outage at EFPY 23inputN-1th outage at EFPY21.7# of flaws created from K 21 to K 22 52From tables 2.3-2 and 2.3-3: adjust as needed 25# of flaws created from K 22 to K 23 53From tables 2.3-2 and 2.3-3: adjust as needed 26Calc-1Total # of flaws created from K 21.7 to 23 68Adjust this equation as needed 34Calc-2# of large flaws expected in K 21.7 to K 230.05= Calc-1
 
* 6.98E-04 0.02Calc-3# of pluggable flaws expected in K 21.7 to K 23 8= Calc-1
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.
* 0.12 4Calc-4A quick estimate of conditional C-SGTR probability p(CSGTR)0.024assuming any large flaw leads to C-SGTR and accident occur in the middle of the time period0.012The 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-2Large 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-4Calc-4 = p(CSGTR) = Calc-2 / 2CAUTIONNumber 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.
input        Tube material                                            600TT                                                      690TT input        Nth outage at EFPY                                         23 input        N-1th outage at EFPY                                      21.7
Table 2.3-5 Example Calculation 2 - RASP Handbook EXCEL-2.xlsx input# of SGs 4input# of tubes/SG 3300inputTotal # of SG tubes 13200Transferred to tabs "600TT" and "690TT" as input.inputTube material600TT690TTinputNth outage at EFPY 16inputN-1th outage at EFPY 15# of flaws created from K 15 to K 16 47From tables 2.3-2 and 2.3-3: adjust as needed 21   Calc-1Total # of flaws created from K 15 to 16 47Adjust this equation as needed 21Calc-2# of large flaws expected in K 15 to K 160.03= Calc-1
              # of flaws created from K 21 to K 22                       52      From tables 2.3-2 and 2.3-3: adjust as needed       25
* 6.98E-04 0.01Calc-3# of pluggable flaws expected in K 15 to 16 6= Calc-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       # of large flaws expected in K 21.7 to K 23              0.05     = Calc-1
* 0.12 2Calc-4A quick estimate of conditional C-SGTR probability p(CSGTR)0.016assuming any large flaw leads to C-SGTR and accident occur in the middle of the time period0.007The 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-2Large 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-4Calc-4 = p(CSGTR) = Calc-2 / 2CAUTIONNumber 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.
* 6.98E-04                               0.02 Calc-3       # of pluggable flaws expected in K 21.7 to K 23             8     = Calc-1
FROM THE NUREG WORD FILE 0 to 1 cm 1 to 2 cm 2 to 3 cm 3 to 4 cm 4 to 5 cm 5 to 6 cm0 to 0.12.74E-034.62E-022.23E-025.38E-031.04E-031.80E-047.78E-020.1 to 0.21.86E-023.14E-011.52E-013.66E-027.08E-031.23E-035.29E-010.2 to 0.39.59E-031.62E-017.81E-021.89E-023.64E-036.31E-042.73E-010.3 to 0.43.09E-035.21E-022.52E-026.07E-031.17E-032.03E-048.78E-020.4 to 0.58.47E-041.43E-026.90E-031.66E-033.22E-045.57E-052.41E-020.5 to 0.62.14E-043.61E-031.74E-034.21E-048.13E-051.41E-056.08E-030.6 to 0.75.14E-058.67E-044.19E-041.01E-041.95E-053.38E-061.46E-030.7 to 0.81.19E-052.01E-049.73E-052.35E-054.54E-067.86E-073.39E-040.8 to 0.92.71E-064.57E-052.21E-055.32E-061.03E-061.78E-077.70E-050.9 to 1.0small3.52E-025.93E-012.86E-016.91E-021.34E-022.31E-03~11.00E+00WHEN NUREG WORD FILE IS IMPORTED INTO EXCEL AND ROW AND COLUMN SUMS ARE MADE 0 to 1 cm 1 to 2 cm 2 to 3 cm 3 to 4 cm 4 to 5 cm 5 to 6 cm0 to 0.12.74E-034.62E-022.23E-025.38E-031.04E-031.80E-047.78E-020.1 to 0.21.86E-023.14E-011.52E-013.66E-027.08E-031.23E-035.30E-010.2 to 0.39.59E-031.62E-017.81E-021.89E-023.64E-036.31E-042.73E-010.3 to 0.43.09E-035.21E-022.52E-026.07E-031.17E-032.03E-048.78E-020.4 to 0.58.47E-041.43E-026.90E-031.66E-033.22E-045.57E-052.41E-020.5 to 0.62.14E-043.61E-031.74E-034.21E-048.13E-051.41E-056.08E-030.6 to 0.75.14E-058.67E-044.19E-041.01E-041.95E-053.38E-061.46E-030.7 to 0.81.19E-052.01E-049.73E-052.35E-054.54E-067.86E-073.39E-040.8 to 0.92.71E-064.57E-052.21E-055.32E-061.03E-061.78E-077.70E-050.9 to 1.0small3.51E-025.93E-012.87E-016.92E-021.34E-022.32E-031.00E+001.00E+006.98E-04total probability of blue area1.20E-01total probability of yellow + blue areas1.19E-01total probability of yellow area1.00E+00total probability of table binsFlaw Depth %/100Total = TotalTable 2.3-1. Probability that a Detected Flaw Belongs to a Bin SizeFlaw LengthTotalFlaw Depth $/100Table 7-5. Probability that a Detected Flaw Belongs to a Bin SizeLength of FlawTotal Table 2.3-2 Flaw Estimates - 600TT600TTh(k) = mu*K + sigma= Hazard RateNflaws = (# of tubes)
* 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.
* [1.0  exp[= NFlawsAvg# of tubes 13200K = EFPYmu =6.42E-05 0 0sigma =1.32E-032.00E-041.00E-03Flaws generated since last EFPYTOTAL # of flaws detected at EFPY (1)
The probability of a large flaw is 6.98E-04 as defined in Table 2.3-1 by the flaws in the blue area.
K             EFPYVolumetricAxialCircumf.Total K              EFPYVolumetricAxialCircumf.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.
Calc-2        Large flaws are shown bu blue and yellow areas in Table 2.3-1.
Table 2.3-3 Flaw Estimates - 690TT690TTh(k) = mu*K + sigma= Hazard RateNflaws = (# of tubes)
Calc-3       For information only. It is not used in the above estimates for p(CSGTR), which is given by Calc-4.
* [1.0  exp[= NFlawsAvg# of tubes 13200K = EFPYmu =5.58E-050.00E+000.00E+00sigma =6.86E-040.00E+000.00E+00Flaws generated since last EFPYTOTAL # of flaws detected at EFPY (1)
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.
K             EFPYVolumetricAxialCircumf.Total K              EFPYVolumetricAxialCircumf.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.}}
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         # of SGs                                                   4 input        # 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 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.
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 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
 
Table 2.3-2 Flaw Estimates - 600TT                                        600TT h(k) = mu*K + sigma                                                     = Hazard Rate Nflaws = (# of tubes) * [1.0  exp[{(1/2) *
* k2 +
* k}]]          = 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)
K                                                                               K Volumetric            Axial          Circumf.       Total                   Volumetric    Axial  Circumf. Total (1)
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.
 
Table 2.3-3 Flaw Estimates - 690TT                                690TT h(k) = mu*K + sigma                                                     = Hazard Rate Nflaws = (# of tubes) * [1.0  exp[{(1/2) *
* k2 +
* k}]]          = 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)
K                                                                               K Volumetric          Axial        Circumf.         Total                   Volumetric    Axial  Circumf. Total (1)
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.}}

Revision as of 09:46, 20 October 2019

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 # of SGs 4 input # 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 # 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 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.

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 # of SGs 4 input # 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 # 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 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.

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 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

Table 2.3-2 Flaw Estimates - 600TT 600TT h(k) = mu*K + sigma = Hazard Rate Nflaws = (# of tubes) * [1.0 exp[{(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 K Volumetric Axial Circumf. Total Volumetric Axial Circumf. Total (1)

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.

Table 2.3-3 Flaw Estimates - 690TT 690TT h(k) = mu*K + sigma = Hazard Rate Nflaws = (# of tubes) * [1.0 exp[{(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 K Volumetric Axial Circumf. Total Volumetric Axial Circumf. Total (1)

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.