ML18337A412: Difference between revisions

From kanterella
Jump to navigation Jump to search
(Created page by program invented by StriderTol)
 
(StriderTol Bot change)
 
(2 intermediate revisions by the same user not shown)
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
* 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.
# of SGs 4
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
input
* 6.98E-04 0.01Calc-3# of pluggable flaws expected in K 15 to 16 6= Calc-1
# of tubes/SG 3300 input Total # of SG tubes 13200 Transferred to tabs "600TT" and "690TT" as input.
* 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.
input Tube material 600TT 690TT input Nth outage at EFPY 23 input N-1th outage at EFPY 21.7
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)
# of flaws created from K 21 to K 22 52 From tables 2.3-2 and 2.3-3: adjust as needed 25
* [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)
# 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
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.
# of large flaws expected in K 21.7 to K 23 0.05
Table 2.3-3 Flaw Estimates - 690TT690TTh(k) = mu*K + sigma= Hazard RateNflaws = (# of tubes)
= Calc-1
* [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)
* 6.98E-04 0.02 Calc-3
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.}}
# 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
# 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
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
# 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
# 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.}}

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.