CNL-21-072, TVA Nuclear Calculation Coversheet/ Ecm Metadata Update

From kanterella
Jump to navigation Jump to search
TVA Nuclear Calculation Coversheet/ Ecm Metadata Update
ML21239A122
Person / Time
Site: Sequoyah  Tennessee Valley Authority icon.png
Issue date: 08/13/2021
From:
Tennessee Valley Authority
To:
Office of Nuclear Reactor Regulation
Shared Package
ML21239A124 List:
References
CNL-21-072
Download: ML21239A122 (26)
v • d • e


Text

TVA NUCLEAR CALCULATION COVERSHEET/ ECM METADATA UPDATE Page 1 REV O ECM/EDMS/RIMS NO. ECM TYPE: ECM ACCESSION NO (N/A for REV. O}

B41 201110 001 CALCULATIONS (NUCLEAR) N/A Cale

Title:

Manual Computation of Grid Point PMP Depths ORG PLANT BRANCH NUMBER CUR REV NEW REV CALC ID NUC GEN CEB CD00000002020000153 000 ECM UPDATE ONLY 0 NO ECM CHANGES 0 (Verifier and Approval Signatures Not Required) (For calc revision, ECM has been reviewed and no ECM changes required)

UNIT (check one) SYSTEMS UNIDS o 181 . 1 . 2 . 3 D 0 0 0 N/A ECP. N/A APPLICABLE DESIGN DOCUMENT(S) CLASSIFICATION See** Below N/A E QUALITY I SAFETY RELATED? UNVERIFIED SPECIAL REQUIREMENTS DESIGN OUTPUT SAR/TS and/or ISFSI RELATED?

Yes 181 No D (If yes, QR= yes)

Yes 181 No D ASSUMPTION Yes No181 I AND/OR LIMITING CONDITIONS?

Yes No 181 ATTACHMENT?

Yes No 181 SAR/Coe AFFECTED Yes 181 No COMPANY Barge Design Solutions. Inc.

I PREPARINGc°ISCIPLINE VERIFICATION METHOD Design Review NEW METHOD OF ANALYSIS 181 Yes No PREPARER (PRINT NAME AND SIGN) DATE CHECKER (PRINT,~ N~

71 ~

ATE Stuart N. Henry _}).;71,,, 11/04/2020

/

Janelle Schlamp / j//~ / I LJ/2v~ ()

VERIFIER (PRIN( NAM~ D~ J)L-t I DATE APPROVAL (PRINT NAME AND SIGN) DATE 101\ v * "'T * \\}LJ j}dl Digitally signed by Simril, Brenda F Andrew Murr~\' (\ (\(J,(t IA.J (\"\~ ( Simril, Brenda F ,

Date: 2020.11.10 12:53:56 -07'00' STATEMENT OF PROBLEM/ABSTRACT The purpose of this calculation is to manually compute Probable Maximum Precipitation (PMP) data sets for comparison use in subsequent calculations.

This calculation will support development of calculations to support License Amendment Requests (LARs) for revision of the Watts Bar (WBN) and Sequoyah (SON) Nuclear Plant design basis river flooding analysis and may support revision to the Browns Ferry (BFN) Nuclear Plant Flood Hazard Re-evaluation river flooding analysis. This calculation will support a re-evaluation of flood mechanism parameters to demonstrate the flood mechanism is bounded as documented in the Focused Evaluation for SON. WBN. and BFN.

NOTE: Utilization of the contents of this calculation for the BFN Design Basis requires NRC approval via a LAR.

    • SON - DCN 23628 WBN - DCN 66358 MICROFICHE/EFICHE Yes D No 181 FICHE NUMBER(S) NIA TVA40532 Page 1 of2 NEDP-2-1 [01-14-2019)

TVA NUCLEAR CALCULATION COVERSHEET / ECM METADATA UPDATE Page 2 CALC ID

_ I ORG I PLANT I BRANCH I NUMBER I REV I I NUC I GEN I CEB I CDQ0000002020000153 I 000 I BUILDING ROOM ELEVATION COORD/AZIM FIRM NA I NA I NA I NA I Barge CATEGORIES KEYWORDS (A-add, D-delete)

ACTION KEYWORD A/D KEYWORD (A/D)

A INFLOWS A PMP A HYDROLOGY CROSS-REFERENCES (A-add, D-delete)

ACTION XREF XREF XREF XREF XREF (A/D) CODE PLANT TYPE NUMBER REV A P GEN Calculation CDQ0000002016000041 001 ECM METADATA ONLY UPDATES:

Following are required only when making keyword/cross reference ECM Metadata updates and page 1 of form NEDP-2-1 is not included:

PREPARER (PRINT NAME AND SIGN) DATE CHECKER (PRINT NAME AND SIGN) DATE PREPARER PHONE NO. ECM ACCESSION NO. N/A TVA 40532 Page 2 of 2 NEDP-2-1 [01-14-2019]

Page 3 TVA NUCLEAR CALCULATION RECORD OF REVISION CALCULATION IDENTIFIER CDQ0000002020000153 Title Manual Computation of Grid Point PMP Depths Revision DESCRIPTION OF REVISION No.

000 Initial issue (17 pages)

UFSARs for SQN, WBN and BFN have been reviewed and are affected by this calculation. A License Amendment Request would be required to adopt this analysis into the design basis.

Review was performed by H.L. Smith Sawyer with knowledge of the analysis inputs and methodologies which are described in each UFSAR. This review does not represent a 50.59 or 72.48 review in accordance with NPG-SPP-09.4 and NPG-SPP-09.9, as applicable.

This calculation may support planned LARs for revision of the SQN and WBN design basis river flooding analysis and will support a re-evaluation of flood mechanism parameters to demonstrate the flood mechanism is bounded as documented in the Focused Evaluation for BFN.

Barge Design software controls for QA software applications meet the intent of NPG-SPP-12.7.

TVA 40709 [12-2015] Page 1 of 1 NEDP-2-2 [12-18-2015]

Page 4 TVA NUCLEAR CALCULATION TABLE OF CONTENTS Calculation Identifier: CDQ000000202000000153 I Revision: I 000 TABLE OF CONTENTS SECTION TITLE PAGE Coversheet 1 ECM Metadata Update Sheet 2 Record of Revision 3 Table of Contents 4 Verification Form 5 Computer Input Sheet 6 Computer Program Application Form 7 1 Purpose 10 2 References 10 3 Assumptions 11 4 Design Input Data 11 5 Special Requirements / Limiting Conditions 11 6 Computation Basis 11 7 Manual Computations 14 8 Results and Conclusions 18 Electronic File Attachments Appendix A CDQ0000002020000153_Appendix_A.pdf (DAD/SAF Data Export Evaluation) 5 pages Appendix B CDQ0000002020000153_Appendix_B.pdf (Extracted DAD and Grid Point Data) N/A Appendix C CDQ0000002020000153_Appendix_C.pdf (Manual Calculations and Results) N/A Note: Attachments are stored in FILEKEEPER. See Electronic File Attachments Form.

TVA 40710 [12-2015] Page 1 of 1 NEDP-2-3 [12-18-2015]

PaQe 5 TVA NUCLEAR CALCULATION VERIFICATION FORM Calculation Identifier CDQ0000002020000153 Revision 000 Method of verification used:

1. Design Review ~
2. Alternate Calculation
3. Qualification Test Comments:

Calculation CDQ0000002020000153 Revision 000 entitled, "Manual Computation of Grid Point PMP Depths" was verified by independent design review. The process involved a critical review of the calculation to ensure that it is correct and complete, uses appropriate methodologies, and achieves its intended purpose. The inputs were reviewed and determined to be appropriate inputs for this calculation. The results of the calculation were reviewed and were found to be reasonable and consistent with the inputs provided. Backup files and documents were consulted as necessary to verify data and analysis details found in the calculation.

Detailed comments and editorial suggestions for the changes made in this revision were transmitted to the author and reviewer by email.

This calculation has been approved for release by authorized personnel. The Barge Design Solutions, Inc.

approver ensures that the calculation has been developed, reviewed, and verified by trained and qualified project personnel.

TVA 40533 [12-2015) Page 1 of 1 NEDP-2-4 [12-18-2015]

Page 6 TVA NUCLEAR COMPUTER INPUT FILE STORAGE INFORMATION SHEET Document CDQ0000002020000153 I Rev. 000 I Plant: GEN I

Subject:

Manual Computation of Grid Point PMP Depths Electronic storage of the input files for this calculation is not required. Comments:

~ Input files for this calculation have been stored electronically and sufficient identifying information is provided below for each input file. (Any retrieved file requires re-verification of its contents before use.)

The following listed Appendix PDF files are electronically attached to the parent Adobe PDF calculation file.

Click on the Attachments tab within Acrobat Reader to view the attachment listing, to access and view the files as needed.

CDQ0000002020000153_Appendix_A.pdf CDQ0000002020000153_Appendix_B.pdf CDQ0000002020000153_Appendix_C.pdf CDQ0000002020000153_Electronic_File_Attachments.pdf CDQ0000002020000153_NativeFiles.zip.txt Additional input, calculation, and output files have been stored in FILEKEEPER and are listed on the Electronic File Attachments form.

Microfiche/eFiche TVA 40535 [12-2015] Page 1 of 1 NEDP-2-6 [12-18-2015]

CALCULATION Calculation No: CDQ0000002020000153 Rev 000 Page 7

Title:

Manual Computation of Grid Point PMP Depths Preparer SNH Checker JTS COMPUTER PROGRAM APPLICATION Program Name: Note 3 Microsoft Excel Description of Program:

I Program Version:

Office 365 ProPlus Microsoft Excel is a spreadsheet application that features calculating, graphing, and macro programming.

Excel organizes, analyzes, and formats data.

Description of the supporting application or function of the Computer Program to the Calculation:

Microsoft Excel was used as a calculator.

EVALUATION COMPUTER PROGRAM APPLICATION QUESTIONS RESULTS

1. Is the Computer Program and version in the Software Library with an acceptable status Yes No of Active for use for the final design? Note 2
  • If No, STOP and consult the Project Manager or list computer program as an unverified assumption.
2. Is the Computer Program and version in the Software Library the same as used in the Yes No calculation? Note 1
3. Is the Computer Program a preverified program? Yes No
  • If No, discuss below in Comments or additional clarification.

Verified for each application.

Verified by alternate calculation.

  • If Yes, list the Software Dedication Report (SDR) number below.

SDR with Revision:

Is the scope of this calculation within the capabilities and limitations of the SDR? Note 1 Yes No

4. Are the computer program inputs listed or identified in the calculation? Note 1 Yes No
5. Are the computer program outputs listed or identified in the calculation? Note 1 Yes No
6. Are there any outstanding computer program errors that could affect the results? Yes No
  • If Yes, is the issue listed as an unverified assumption or otherwise identified? Yes No
7. Was the analysis performed on a computer designated to run the Computer Program? Yes No List the verification method used (See QA-CP-06, Computer Program Applications) for the computer program where results are verified for each application or by alternate calculation:

Manual review.

Comments or additional clarification (a No response to questions 2-5 or 7, or a Yes to question 6 requires an explanation):

Results were verified by manual review.

Note:

1. A No response to questions 2-5 or 7, or a Yes to question 6 indicates the calculation is incomplete or requires an explanation in the comments block for special circumstances.
2. Consult the Software Library for a listing of Barge approved Computer Programs or software and associated user manuals.
3. Utilize a separate page for each Computer Program used in the calculation.

QA-DE-01-F05, Rev 1

CALCULATION Calculation No: CDQ0000002020000153 Rev 000 Page 8

Title:

Manual Computation of Grid Point PMP Depths Preparer SNH Checker JTS COMPUTER PROGRAM APPLICATION Program Name: Note 3 ArcGIS Description of Program:

I Program Version: 10.2.2 ArcGIS is geographic information system (GIS) software. GIS integrates hardware, software, and data for capturing, managing, analyzing, and displaying all forms of geographically referenced information. GIS allows users to view, understand, question, interpret, and visualize data in many ways that reveal relationships, patterns, and trends in the form of maps, globes, reports, and charts.

Description of the supporting application or function of the Computer Program to the Calculation:

Software was used to check the extraction of Depth-Area-Duration (DAD) and Storm Adjustment Factor (SAF) data as provided by Reference 2.3 geodatabase.

EVALUATION COMPUTER PROGRAM APPLICATION QUESTIONS RESULTS

1. Is the Computer Program and version in the Software Library with an acceptable status Yes No of Active for use for the final design? Note 2
  • If No, STOP and consult the Project Manager or list computer program as an unverified assumption.
2. Is the Computer Program and version in the Software Library the same as used in the Yes No calculation? Note 1
3. Is the Computer Program a preverified program? Note 1 Yes No
  • If No, discuss below in Comments or additional clarification.

Verified for each application.

Verified by alternate calculation.

  • If Yes, list the Software Dedication Report (SDR) number below.

SDR with Revision:

Is the scope of this calculation within the capabilities and limitations of the SDR? Note 1 Yes No

4. Are the computer program inputs listed or identified in the calculation? Note 1 Yes No
5. Are the computer program outputs listed or identified in the calculation? Note 1 Yes No
6. Are there any outstanding computer program errors that could affect the results? Yes No
  • If Yes, is the issue listed as an unverified assumption or otherwise identified? Note 1 Yes No
7. Was the analysis performed on a computer designated to run the Computer Program? Yes No Note 1 List the verification method used (See QA-CP-06, Computer Program Applications) for the computer program where results are verified for each application or by alternate calculation:

Alternate analyses using comparable software were performed using the same input data. Comparison of the output from both primary and alternate implementations is included in Appendix A.

Comments or additional clarification (a No response to questions 2-5 or 7, or a Yes to question 6 requires an explanation):

ArcGIS operation verified using QGIS.

Note:

1. A No response to questions 2-5 or 7, or a Yes to question 6 indicates the calculation is incomplete or requires an explanation in the comments block for special circumstances.
2. Consult the Software Library for a listing of Barge approved Computer Programs or software and associated user manuals.
3. Utilize a separate page for each Computer Program used in the calculation.

QA-DE-01-F05, Rev 1

CALCULATION Calculation No: CDQ0000002020000153 Rev 000 Page 9

Title:

Manual Computation of Grid Point PMP Depths Preparer SNH Checker JTS COMPUTER PROGRAM APPLICATION Program Name: Note 3 Quantum GIS (QGIS)

Description of Program:

I Program Version: 2.8.2 QGIS is a geographic information system (GIS) software package that integrates spatial data capture, management, analysis and display.

Description of the supporting application or function of the Computer Program to the Calculation:

QGIS software was used to validate ArcGIS software operation in checking the extraction of Depth-Area-Duration (DAD) and Storm Adjustment Factor (SAF) data as provided by Reference 2.3 geodatabase.

EVALUATION COMPUTER PROGRAM APPLICATION QUESTIONS RESULTS

1. Is the Computer Program and version in the Software Library with an acceptable status Yes No of Active for use for the final design? Note 2
  • If No, STOP and consult the Project Manager or list computer program as an unverified assumption.
2. Is the Computer Program and version in the Software Library the same as used in the Yes No calculation? Note 1
3. Is the Computer Program a preverified program? Note 1 Yes No
  • If No, discuss below in Comments or additional clarification.

Verified for each application.

Verified by alternate calculation.

  • If Yes, list the Software Dedication Report (SDR) number below.

SDR with Revision:

Is the scope of this calculation within the capabilities and limitations of the SDR? Note 1 Yes No

4. Are the computer program inputs listed or identified in the calculation? Note 1 Yes No
5. Are the computer program outputs listed or identified in the calculation? Note 1 Yes No
6. Are there any outstanding computer program errors that could affect the results? Yes No
  • If Yes, is the issue listed as an unverified assumption or otherwise identified? Note 1 Yes No
7. Was the analysis performed on a computer designated to run the Computer Program? Yes No Note 1 List the verification method used (See QA-CP-06, Computer Program Applications) for the computer program where results are verified for each application or by alternate calculation:

Alternate analyses using comparable software were performed using the same input data. Comparison of the output from both primary and alternate implementations is included in Appendix A.

Comments or additional clarification (a No response to questions 2-5 or 7, or a Yes to question 6 requires an explanation):

QGIS was used to verify ArcGIS operation.

Note:

1. A No response to questions 2-5 or 7, or a Yes to question 6 indicates the calculation is incomplete or requires an explanation in the comments block for special circumstances.
2. Consult the Software Library for a listing of Barge approved Computer Programs or software and associated user manuals.
3. Utilize a separate page for each Computer Program used in the calculation.

QA-DE-01-F05, Rev 1

CALCULATION Calculation No: CDQ0000002020000153 Rev 000 Page 10

Title:

Manual Computation of Grid Point PMP Depths Preparer SNH Checker JTS 1.0 Purpose The purpose of this calculation is to manually compute Probable Maximum Precipitation (PMP) data sets for comparison use in subsequent calculations.

In the previous PMP development for evaluation of the Probable Maximum Flood (PMF) at TVA nuclear sites, rainfall depths were generated based on Hydrometeorological Report (HMR) 41 (Reference 2.1) or HMR-47 (Reference 2.2). These methodologies have not been updated since publication. This calculation uses an alternate approach to evaluate PMP depths based on current methodologies by applying an updated storm database and a new approach (Reference 2.3) to compute PMP depths for defined grid points across the Tennessee Valley. The NRC documented their approval of this new approach (Topical Report TVA-NPG-AWA16-A) in Reference 2.6.

In the Topical Report, precipitation depths at grid points across the Tennessee Valley are generated by the PMP Evaluation tool software included with that report. This software was excluded from the NRC review and approval of the Topical Report. To document the acceptability of the PMP Evaluation tool software, TVA performed a Software Dedication Report. The NRC review of the Software Dedication Report (SDR) generated draft Requests for Additional Information (RAIs) in regard to the method used in the SDR to perform an alternate calculation check of the PMP Evaluation tool results. To provide the NRC additional assurance of the acceptability of the PMP Evaluation tool, this calculation performs independent 10 CFR 50 Appendix B safety related manual calculations to produce the digital point precipitation data using only the NRC approved SPAS data as inputs, and the NRC approved equations and methods for storm maximization and transportability from the Topical Report. The manual calculations herein were based on the written documentation in Reference 2.3 and DO NOT directly translate the Python scripts utilized in the PMP Evaluation tool nor employ any portion of the PMP Evaluation tool that was not evaluated and thus excluded by the NRC in Reference 2.7. The manual computations follow the equations and written documentation published in Reference 2.3 to compute PMP depths for defined grid points across the Tennessee Valley.

2.0 References 2.1 Schwarz, Francis K., Probable Maximum and TVA Precipitation over the Tennessee River Basin above Chattanooga, Hydrometeorological Report No. 41, Hydrometeorological Section, Office of Hydrology, U.S. Weather Bureau, U.S. Department of Commerce, Washington, D.C., dated June 1965 - For Information Only.

2.2 Schwarz, Francis K., Meteorological Criteria for Extreme Floods for Four Basins in the Tennessee and Cumberland River Watersheds, Hydrometeorological Report No. 47, Hydrometeorological Branch, Office of Hydrology, National Oceanic and Atmospheric Administration, U.S. Department of Commerce, Silver Spring, Maryland, dated May 1973 -

For Information Only.

2.3 Tennessee Valley Authority, Calculation CDQ0000002016000041, TVA Overall Basin Probable Maximum Precipitation and Local Intense Precipitation Analysis, Revision 001.

2.4 Tennessee Valley Authority, Calculation CDQ0000002014000021, HEC-RAS Model Set-up, Revision 004 - For Information Only.

2.5 Drainage Areas for Streams in Tennessee River Basin, TVA Report No. 0-5829-R-2, TVA Division of Water Control Planning, Hydraulic Data Branch, Knoxville, Tennessee, March, 1970.

QA-DE-01-F07, Rev 1

CALCULATION Calculation No: CDQ0000002020000153 Rev 000 Page 11

Title:

Manual Computation of Grid Point PMP Depths Preparer SNH Checker JTS 2.6 Undine Shoop (NRC) to Joseph Shea (TVA), Letter, Verification Letter of the Approval Version of Tennessee Valley Authority Topical Report, TVA Overall Basin Probable Maximum Precipitation and Local Intense Precipitation Analysis Calculation CDQ0000002016000041, Revision 1 (EPID L-2016-TOP-0011), ADAMS ML19158A395.

2.7 Nuclear Regulatory Commission, Final Safety Evaluation by the Office of Nuclear Reactor Regulation, Topical Report, TVA Overall Basin Probable Maximum Precipitation and Local Intense Precipitation Analysis Calculation CDQ0000002016000041, ADAMS ML19010A274.

3.0 Assumptions 3.1 General Assumptions - None 3.2 Unverified Assumptions - None 4.0 Design Input Data Table 4 - Design Input Parameters Sec. Input Parameter Source Location Value/Description SPAS event DAD and grid point data SPAS DAD and Appendix A 4.1 Reference 2.3 (developed in Reference 2.3) and Grid Point Data through C I I included in the source ArcGIS database.

5.0 Special Requirements / Limiting Conditions - None 6.0 Computation Basis 6.1 Data provided in the NRC approved Reference 2.3 ArcGIS dataset includes data for a uniform grid across the Tennessee Valley watershed at a resolution of 0.025 x 0.025 decimal degrees (dd), or 90 arc-seconds resulting in 17,938 grid points across the Tennessee Valley. The provided data include output from the Storm Precipitation Analysis System (SPAS) which uses gridded storm analysis techniques to provide both spatial and temporal analyses for extreme rainfall storm events. The NRC approved Reference 2.3 provides three storm types (31 General, 8 Tropical and 19 Local) for a total of 58 SPAS data sets. The SPAS data sets include Depth-Area-Duration (DAD) data for each event as well as grid point Total Adjustment Factors (TAFs) and an event transpositionability flag for each event at each grid point.

Additional grid point data (i.e. elevations, In Place Maximization Factor (IPMF), Moisture Transposition Factor (MTF), Orographic Transposition Factor (OTF), etc.) were not directly used in these manual computations.

6.2 Data extraction from the ArcGIS dataset was checked in Appendix A using QGIS as an alternate software. Nine of the fifty-eight files (three of each SPAS event type for General, Tropical and Local) were extracted with both ArcGIS and QGIS software and results were compared in the included Excel files. Excel files were manually reviewed for proper comparison operation. Differences noted between individual values from the ArcGIS and QGIS output for DAD data or TAF values were less than 5x10-12 inches and were considered negligible. Therefore, input SPAS data were extracted for all 58 SPAS events representing the three storm event types using ArcGIS and the resulting *.dbf files are included in Appendix B.

QA-DE-01-F07, Rev 1

CALCULATION Calculation No: CDQ0000002020000153 Rev 000 Page 12

Title:

Manual Computation of Grid Point PMP Depths IPreparer Checker I SNH JTS I 6.3 The SPAS data include a DAD data set for each SPAS event. When extracted from the data base, DAD data are arranged to represent the paired area-rainfall depth data in a tabular format with the areas (in square miles) in the leftmost column, and the rainfall depths (in inches) for each duration at the corresponding area to the right with a header that identifies the corresponding duration (in hours). A partial example of the data format is shown in the following Table 6.3 from General Event - SPAS1208_1 (Appendix B-2, General, SPAS_1208_1.dbf).

Table 6.3 -SPAS Data Set Format (example is partial data from General Event - SPAS1208_1)

AREASQMI H_01 H_02 H_03 H_04 H_05 H_06 H_12 H_18 H_24 H_36 H_48 H_72 H_96 H_120 1000 2.27 2.27 5.26 5.26 5.26 8.99 12.55 13.27 13.5 16.39 16.86 17.05 17.05 17.05 2000 1.79 1.79 4.19 4.19 4.19 7.41 11.11 11.96 12.62 15.72 16.14 16.37 16.37 16.37 5000 1.38 1.38 3 3 3 5.23 9.24 10.3 10.93 14.12 14.79 15 15 15 I 10000 I I I I I I I 0.99 0.99 2.28 2.28 2.28 3.76 7.39 I 8.42 I8.64 I 12.21 I13 I 13.13 I13.13 I 13.13 I Rainfall depths are computed for all user selected durations in the DAD data set following the guidance in Section 5 of Reference 2.3 stating that durations of 1-, 6-, 12-, 18-, 24-, 48-, 72-,

96- and 120-hours should be selected for the General and Tropical event types and durations of 1-, 2-, 3-, 4-, 5-, 6-, 12-, and 24-hours should be selected for the Local event type.

The number of columns in the SPAS event data sets are consistent across all SPAS events but can vary in the number of rows (i.e. areas). As discussed in Appendix D of Reference 2.3, the unknown rainfall depth for the desired watershed area size is computed from the SPAS DAD data set using linear interpolation where the desired watershed area is a value between those listed in the DAD data set. Interpolated grid point rainfall depth values are computed only within the SPAS data set limits. For paired SPAS DAD data set values (i.e. area and rainfall depth for a selected duration) ordered as shown in Table 6.3, variables are defined as follows:

Variable Definition Variable Definition A1 Area from DAD table d1 Duration depth from DAD table A2 User input watershed area d2 Unknown rainfall depth A3 Area from DAD table d3 Duration depth from DAD table For a system of paired DAD data where the user input A2 value is between A1 and A3, the following relationship representing linear slope between points must be true:

d3 d1 d 2 d1

-=-

A3 A1 A2 A1 For the manual calculations, this relationship was rearranged to solve for the unknown rainfall depth as follows:

A2 A1

(

d2 = d1 + d3 d1 x ) A3 A1 QA-DE-01-F07, Rev 1

CALCULATION Calculation No: CDQ0000002020000153 Rev 000 Page 13

Title:

Manual Computation of Grid Point PMP Depths I I Preparer Checker SNH JTS Example calculation using data from General Event - SPAS 1208_1 (Appendix B-2, General, SPAS_1208_1.dbf) for 1-hour duration and a 7,500-square-mile watershed:

Variable Area (in sq.mi.) Variable Rainfall Depth (in inches)

A1 5000 d1 1.38 A2 7500 d2 Unknown rainfall depth A3 10000 d3 0.99 7500 5000 d 2 = 1.38 + ( 0.99 1.38) x - = 1.185xinches 10000 5000 6.4 Computed rainfall depths for each duration applicable to the respective storm type are then used to calculate rainfall depths at the respective durations at each listed grid point. Each SPAS data set contains unique data for each specific SPAS event at each grid point in the Tennessee Valley. As discussed in Reference 2.3, the provided SPAS event databases include object identifier, counter, SPAS event identifier, longitude, latitude, transposition zone, elevation, IPMF, MTF, OTF, TAF and transpositionability flag for each grid point for that specific SPAS event. Development of the IPMF, the MTF, the OTF, the TAF and the transpositionability flag are described in Section 5 of Reference 2.3. The DAD dataset, the final SPAS event TAF and the transpositionability flag for each grid point contained in the Reference 2.3 SPAS event database files are the only data used directly in the manual calculations. The transpositionability flag value is binary (i.e. value is either one or zero) as discussed in Reference 2.3. The rainfall depths are multiplied by the grid point TAF and the transpositionability flag to compute the final durational depth at that grid point for that SPAS event. Computations are as follows:

d SPAS = TAF x TRANS x d where:

dSPAS = rainfall depth for the respective SPAS event at a given grid point for a given duration TAF = total adjustment factor (from ArcGIS data base)

TRANS = transpositionability flag (from ArcGIS data base, binary - either 1 or 0) d = durational rainfall depth from DAD for input watershed area QA-DE-01-F07, Rev 1

CALCULATION Calculation No: CDQ0000002020000153 Rev 000 Page 14

Title:

Manual Computation of Grid Point PMP Depths Preparer SNH Checker JTS Example calculation using data from SPAS 1208_1 for a selected unique longitude -86.525, latitude 34.125 (Appendix B-2, General, SPAS_1208_1.dbf), with the 1-hour duration and a 7,500-square-mile watershed rainfall depth calculated in Section 6.3:

d SPAS -- 1.289706x 1 x 1.185 -- 1.528302 Note that in the example calculations shown, the numbers are truncated for clarity. In the spreadsheets performing the manual computations, the numbers used are not modified (i.e.

not rounded or truncated) and are carried at the allowed precision of Excel into the final results data sets.

6.5 After the above computations for each SPAS event at each unique grid point are complete, these intermediate results are filtered using the Excel MAX function. The maximum value of all the calculated SPAS event rainfall depths at each unique grid point is selected as the final PMP depth result for the respective duration for the user input watershed area.

7.0 Manual Computations Due to the extensive data set, Excel spreadsheets were used as a calculator to efficiently perform the manual computations and are included in Appendix C-1. One Excel file is required for each storm type and input watershed area. Each file is set up with multiple tabs, varying dependent on the number of SPAS events applicable to the storm type. Tabs are used for data inputs, computations, and final outputs. The Excel file template used for manual computation was consistent for all input watershed areas and template configuration is outlined in the following sections.

7.1 The first tab in each spreadsheet is for input of the desired watershed area. The tab setup is shown in Table 7.1.

Table 7.1 - "Input Area" tab Column/Cell Calculation Description Example Cell A1 Label for input data in cell below (A2) In cell A1, value = Input Area Sq.Mi.

Cell A2 User input of PMP storm area in square-miles In cell A2, value = 127 QA-DE-01-F07, Rev 1

CALCULATION Calculation No: CDQ0000002020000153 Rev 000 Page 15

Title:

Manual Computation of Grid Point PMP Depths Preparer SNH Checker JTS 7.2 A tab with the respective SPAS event DAD data is provided for each SPAS event applicable to the storm type under review. The rainfall depths for all durations are interpolated on this tab for the input watershed area as defined in section 6.3. The number of these tabs varies depending on the number of SPAS events applicable for the storm type under review. The tab setup is as follows. Note that **** represents the SPAS event number.

Table 7.2 - "SPAS_****_DAD" tabs Column/Cell Calculation Description Example Input Depth-Area-Duration data as taken from the ArcGIS Columns A to O from row geodatabase files in Appendix H of Reference 2.3 and In cell C1, value = H_02 1 through row 22 extracted into the Appendix B *.dbf files to include column labels in row 1.

Combined label and check of SPAS event SAF input by In cell A23, value =

Cell A23 referencing cell B4 of corresponding storm adjustment factor CONCATENATE("Interpolation Check (SAF) tab SPAS_",SPAS_****_1!B4)

Cell A24 Input data label for cell below In cell A24, value = Input The square mileage of PMP storm area input by the user is Cell A25 copied to this cell for visibility by referencing cell A2 of "Input In cell A25, value = 'Input Area'!$A$2 Area" tab Columns A to O , row 27 DAD column labels copied from row 1 In cell A27, value = A1 The area in the input DAD data with the next closest area In cell A28, value =

smaller than or equal to the area requested by the user for Cell A28 OFFSET($A$1,MATCH($A$25,$A$2:$A$22,1),0, the PMP storm event area is returned by use of the Excel 1,1)

OFFSET and MATCH functions The area in the input DAD data with the next closest area In cell A30, value =

larger that area requested by the user for the PMP storm Cell A30 OFFSET($A$1,MATCH($A$25,$A$2:$A$22,1)+1, event area is returned by use of the Excel OFFSET and MATCH 0,1,1) functions The PMP depth from the input DAD data corresponding to the In cell B28, value =

Columns B through O, row area in column A is copied into the cell by by use of the Excel OFFSET($A$1,MATCH($A$25,$A$2:$A$22,1),

28 OFFSET, MATCH and COUNT functions COUNT($A$3:A3),1,1)

In cell B29, value =

Columns B through O, row The PMP depth for each duration corresponding to the user IF($A25>MAX($A2:$A22),0,B28+(B30-B28)*

29 input area is interpolated (see section 6.3)

(($A25-$A28)/($A30-$A28)))

The PMP depth from the input DAD data corresponding to the In cell B30, value =

Columns B through O, row area in column A is copied into the cell by by use of the Excel OFFSET($A$1,MATCH($A$25,$A$2:$A$22,1)+1, 30 OFFSET, MATCH and COUNT functions COUNT($A$3:A3),1,1)

QA-DE-01-F07, Rev 1

CALCULATION Calculation No: CDQ0000002020000153 Rev 000 Page 16

Title:

Manual Computation of Grid Point PMP Depths Preparer SNH Checker JTS 7.3 A tab with the respective SPAS event storm adjustment factor grid point data is provided for each SPAS event applicable to the storm type under review. This storm adjustment factor grid point data is copied into the tab from the extracted *.dbf data files. The rainfall depths for all durations calculated in the respective DAD data tab are imported from that tab. The rainfall depths are multiplied by the respective TAF and transpositionability flag for each grid point as outlined in section 6.4 above. The number of these tabs varies depending on the number of SPAS events applicable for the storm type under review. Tab setup is as follows. Note that

        • in Table 7.3 represents the SPAS event number.

Table 7.3 - "SPAS_****_SAF" tabs Column/Cell Calculation Description Example Cell A1 Label for cell B1 In cell A1, value = Storm Area (Sq.Mi.)

Cell A2 Label for cell B2 In cell A2, value = Dataset Check:

The square mileage of PMP storm area input by the Cell B1 user is copied to this cell for visibility by referencing In cell B1, value = 'Input Area'!$A$2 cell A2 of "Input Area" tab Check to ensure dataset completeness by counting Cell B2 In cell B2, value = COUNT(A:A) cells in column A using the Excel COUNT function Input Storm Adjustment Factor data as taken from Columns A to K, rows 3 through the ArcGIS geodatabase files in Appendix H of In cell C3, value = LON 17941 Reference 2.3 and extracted into the Appendix B

  • .dbf files to include column identifiers in row 3 Columns M through U, row 2 Input column labels for PMP durations In cell M2, value = 1-Hour Cell L3 Row label In cell L3, value = Interp. Depth Interpolated depth for each duration is copied by Columns M through U, row 3 In cell M3, value = SPAS_****_DAD!B29 referencing corresponding SPAS event DAD tab Grid Point PMP depths for each duration calculated Columns M through U, rows 4 by multiplication of interpolated depth by TAF and In cell M4, value = M$3*$J4*$K4 through 17941 Transpositionability flag (see section 6.4)

QA-DE-01-F07, Rev 1

CALCULATION Calculation No: CDQ0000002020000153 Rev 000 Page 17

Title:

Manual Computation of Grid Point PMP Depths Preparer SNH Checker JTS 7.4 The last tab in all spreadsheets extracts the final rainfall depths at each applicable duration at each grid point. Calculations on this tab review the rainfall depths at each grid point for each SPAS event and select the maximum as the final value as outlined in section 6.5. Note that the SPAS names (i.e. A, B, C, etc.) in Table 7.4 are placeholders. The actual sheet formula will reflect the SPAS event tab names in the respective spreadsheet. Tab setup is as follows.

Table 7.4 - "Final Manual Data" tab Column/Cell Calculation Description Example Cell A1 Label for cell B1 In cell A1, value = Storm Area (Sq.Mi.)

Cell A2 Label for cell B2 In cell A2, value = Dataset Check:

The square mileage of PMP storm area input by the user is Cell B1 copied to this cell for visibility by referencing cell A2 of In cell B1, value = 'Input Area'!$A$2 "Input Area" tab Check to ensure dataset completeness by counting cells in Cell B2 In cell B2, value = COUNT(A:A) column A using the Excel COUNT function Input Storm Adjustment Factor data (including headers) as Column A to E, rows 3 taken from the ArcGIS geodatabase files in Appendix H of In cell C3, value = LAT through 17941 Reference 2.3 and extracted into the Appendix B *.dbf files to include column identifiers in row 3 Columns L through T, Column labels specifying PMP duration In cell M2, value = 6-Hour row 2 Maximum 1-Hour adjusted PMP depth calculated for each In cell L4, value =

Column L, rows 4 grid point by use of Excel MAX function on adjusted PMP MAX(SPAS_A!M4,SPAS_B!M4,SPAS_C!M4, through 17941 depth from each SAF tab SPAS_D!M4,...,SPAS_Z!M4)

Maximum 6-Hour adjusted PMP depth calculated for each In cell M4, value =

Column M, rows 4 grid point by use of Excel MAX function on adjusted PMP MAX(SPAS_A!N4,SPAS_B!N4,SPAS_C!N4, through 17941 depth from each SAF tab SPAS_D!N4, ...,SPAS_Z!N4)

Maximum 12-Hour adjusted PMP depth calculated for each In cell N4, value =

Column N, rows 4 grid point by use of Excel MAX function on adjusted PMP MAX(SPAS_A!O4,SPAS_B!O4,SPAS_C!O4, through 17941 depth from each SAF tab SPAS_D!O4,...,SPAS_Z!O4)

Maximum 18-Hour adjusted PMP depth calculated for each In cell O4, value =

Column O, rows 4 grid point by use of Excel MAX function on adjusted PMP MAX(SPAS_A!P4,SPAS_B!P4,SPAS_C!P4, through 17941 depth from each SAF tab SPAS_D!P4,...,SPAS_Z!P4)

Maximum 24-Hour adjusted PMP depth calculated for each In cell P4, value =

Column P, rows 4 grid point by use of Excel MAX function on adjusted PMP MAX(SPAS_A!Q4,SPAS_B!Q4,SPAS_C!Q4, through 17941 depth from each SAF tab SPAS_D!Q4,...,SPAS_Z!Q4)

Maximum 48-Hour adjusted PMP depth calculated for each In cell Q4, value =

Column Q, rows 4 grid point by use of Excel MAX function on adjusted PMP MAX(SPAS_A!R4,SPAS_B!R4,SPAS_C!R4, through 17941 depth from each SAF tab SPAS_D!R4,...,SPAS_Z!R4)

Maximum 72-Hour adjusted PMP depth calculated for each In cell R4, value =

Column R, rows 4 grid point by use of Excel MAX function on adjusted PMP MAX(SPAS_A!S4,SPAS_B!S4,SPAS_C!S4, through 17941 depth from each SAF tab SPAS_D!S4,...,SPAS_Z!S4)

Maximum 96-Hour adjusted PMP depth calculated for each In cell S4, value =

Column S, rows 4 grid point by use of Excel MAX function on adjusted PMP MAX(SPAS_A!T4,SPAS_B!T4,SPAS_C!T4, through 17941 depth from each SAF tab SPAS_D!T4,...,SPAS_Z!T4)

Maximum 120-Hour adjusted PMP depth calculated for each In cell T4, value =

Column T, rows 4 grid point by use of Excel MAX function on adjusted PMP MAX(SPAS_A!U4,SPAS_B!U4,SPAS_C!U4,S through 17941 depth from each SAF tab PAS_D!U4,...,SPAS_Z!U4)

QA-DE-01-F07, Rev 1

CALCULATION Calculation No: CDQ0000002020000153 Rev 000 Page 18

Title:

Manual Computation of Grid Point PMP Depths Preparer SNH Checker JTS 7.5 Manual computation of grid point data was performed for varying watershed areas. These areas are typical of TVA project watershed areas and include areas down to 1-square-mile.

As discussed in Reference 2.3, Local event types are applicable only to areas less than 500-square-miles. As a result, no Local event areas above that limit were included in the calculations. The larger General and Tropical type events have the potential to include the entire model watershed. As discussed in Reference 2.4, the model is configured to include the Tennessee River main stem stopping downstream at the Wilson project. Areas listed in Reference 2.5 show total watershed areas above the Wilson and Kentucky projects of 30,750- and 40,200-square-miles, respectively. Therefore, an upper watershed limit of 40,000-square-miles was judged appropriate. The selected areas applied were 1-, 10-, 127-,

150- and 500-square mile areas for the Local type events and 1-, 10-, 127-, 150-m, 500-,

747-, 1000-, 7500-, 10000-, 20000- and 40000-square mile areas for the General and Tropical type events. The calculations for each selected area reside in separate Excel files included in Appendix C-1.

8.0 Results and Conclusions 8.1 The Excel files containing calculations and final grid point PMP depth results data for the five Local, eleven General and eleven Tropical selected areas are included in Appendix C. For reviewer convenience as an example, all sheets in the 7,500 square mile Tropical storm type event file were plotted to an Acrobat (*.pdf) file included as Appendix C-2.

8.2 Results data in the Appendix C files are produced using the calculations described in Reference 2.3 and are appropriate for use in subsequent calculations. Final grid point PMP depths in the Appendix C-1 Excel files are calculated in the last tab of the file, Final Manual Data. For reviewer convenience, all final grid point PMP depths for the five Local, eleven General and eleven Tropical areas were plotted to an Acrobat (*.pdf) file included as Appendix C-3.

QA-DE-01-F07, Rev 1

ELECTRONIC FILE ATTACHMENTS Document: CDQ0000002020000153 I Rev. 000 I Plant: GEN I

Subject:

Manual Computation of Grid Point PMP Depths The files listed below, which contain both input and output data, are stored in TVA FILEKEEPER.

FILEKEEPER Filename Attachment Name CDQ0000002020000153_NativeFiles.zip.txt (FILEKEEPER # KDQ0000002020000162 )

NEDP 2-1 40532 COC.docx NEDP 2-2 40709 COC 131572628.DOCX NEDP 2-3 40710 COC 131572630.DOCX NEDP 2-4 40533 COC 131571753.docx NEDP 2-6 40535 COC 131571758.docx Manual Grid Point Main.docx ManualCalculationTables.xlsx Equations.xmcd CDQ0000002020000153 Electronic File Attachments.docx CDQ0000002020000153_Appendix_A.pdf (FILEKEEPER # KDQ0000002020000161 )

CDQ0000002020000153_Appendix A -DAD and SAF Grid Point Data GIS Export Evaluation.docx Appendix_A-1_ArcGIS_DAD_DBF_Extraction_Check_Files.zip.txt Appendix_A-2_QGIS_DAD_DBF_Extraction_Check_Files.zip.txt Appendix_A-3_ArcGIS_SAF_DBF_Extraction_Check_Files.zip.txt Appendix_A-4_QGIS_SAF_DBF_Extraction_Check_Files.zip.txt Appendix_A-5_DAD_DBF_ExportCheck.xlsx.txt Appendix_A-6_DBF_ExportCheck.xlsx.txt DAD_SAF_ExportCheckCalculationTables.xlsx CDQ0000002020000153_Appendix_B.pdf (FILEKEEPER # KDQ0000002020000161 )

CDQ0000002020000153_Appendix B.docx Appendix B-1 SPAS DAD Data.zip.txt Appendix B-2 SPAS Grid Point Data.zip.txt CDQ0000002020000153_Appendix_C.pdf (FILEKEEPER # KDQ0000002020000161 )

CDQ0000002020000153_Appendix C.docx Appendix C-1 Manual Grid Point PMP Depth Computations.zip.txt Appendix C-2 7500 SqMi Example Manual PMP Depth Computations.pdf Appendix C-3 Final Grid Point PMP Depth Results.pdf Page 1

CALCULATION Calculation No: CDQ0000002020000153 Rev 0 Page A1

Title:

Appendix A - DAD and SAF Grid Point Data GIS Preparer SNH Export Evaluation Checker JTS 1.0 Purpose The purpose of this appendix is to document the extraction of the Storm Precipitation Analysis System (SPAS)

Depth-Area-Duration (DAD) and grid point Storm Adjustment Factors (SAF) data from Appendix H of the NRC approved Reference 2.3 source ArcGIS file geodatabase. Because the extraction of data from the source file geodatabase was performed in ArcGIS which is not NQA dedicated software, the extraction was also performed with an alternate method that utilized Quantum GIS (QGIS). The primary objective of this Appendix is to validate accurate extraction of data via ArcGIS by comparison with data extraction using QGIS. Extracted data were compared using Excel spreadsheets as a calculator. Spreadsheets were manually reviewed to ensure proper data comparison.

2.0 References The references in Section 2.0 of the parent calculation are applicable to this Appendix.

3.0 Assumptions The assumptions in Section 3.0 of the parent calculation are applicable to this Appendix.

4.0 Design Input Data Sec. Input Parameter Source Location Value/Description SPAS event DAD and grid point SPAS DAD and Grid Point Appendix H of data (developed in Reference 4.1 Reference 2.3 Data Reference 2.3 2.3 and included in the source ArcGIS file geodatabases) 5.0 Special Requirements/Limiting Conditions - None 6.0 Computations and Analysis 6.1 Data provided in Appendix H of Reference 2.3 includes two ArcGIS file geodatabases containing the DAD data for each of the 58 SPAS data sets and grid point storm adjustment factors for each SPAS event at each grid point. In order to perform manual computations within Microsoft Excel to determine PMP depths for defined grid points across the Tennessee Valley utilizing the data contained in Appendix H of Reference 2.3, extraction from the ArcGIS file geodatabases to a database file (*.dbf) is required.

Following export to a database file the input data included in the source ArcGIS file geodatabases can be opened and utilized within Microsoft Excel for the manual computations of PMP depths.

6.1.1 Within the PMP_Evaluation_Tool folder in Appendix H of Reference 2.3 the file geodatabase, DAD_Tables.gdb, nine tables were exported to a database file (*.dbf) via the ArcGIS software.

Three SPAS DAD tables within the geodatabase were exported for each of the three storm types by ArcGIS. The SPAS events selected to provide a representative sample for this analysis are detailed in Table 6.1 below. In ArcGIS the attribute table for each SPAS event was opened and the export data option selected. All records in the attribute table were exported as a *.dbf file and are included as Appendix A-1.

CALCULATION Calculation No: CDQ0000002020000153 Rev 0 Page A2

Title:

Appendix A - DAD and SAF Grid Point Data GIS Preparer SNH Export Evaluation Checker JTS The ArcGIS file geodatabase, Storm_Adj_Factors.gdb, within the PMP_Evaluation_Tool folder contained in Appendix H of Reference 2.3 contains the storm adjustment factors for each grid point across the Tennessee Valley. The same nine SPAS events detailed in Table 6.1 below were selected for export from the ArcGIS file geodatabase. In a similar process as the DAD table extraction, the nine grid point data files were opened within ArcGIS followed by opening of the attribute table and exporting as a *.dbf file. The exported database files are included as Appendix A-2.

Table 6.1 - DAD and Storm Adjustment Factor SPAS Event Exports Evaluated General Storm Type Tropical Storm Type Local Storm Type SPAS Event ID SPAS Event ID SPAS Event ID 1048_1 1182_1 1034_1 1208_1 1276_1 1210_1 1430_1 1317_1 1426_1 6.1.2 The process detailed in Section 6.1.1 above was performed again but in QGIS. Similar to ArcGIS the nine SPAS event DAD and SAF data sets were opened from their respective ArcGIS file geodatabase within QGIS. The individual data sets were selected within the Layers pane in QGIS and with a right mouse click the Save As option was selected. The DBF file output format from the Save As dialog was selected and the database files were saved and included as Appendices A-3 and A-4 for the DAD table and SAF datasets, respectively.

6.2 Following import into Excel by opening the exported .dbf files, a separate tab was created for each *.dbf file exported from ArcGIS and QGIS from the DAD_Tables.gdb geodatabase labeled as SPAS_****_*_DAD_##### where **** represents the SPAS event ID (e.g. 1430_1) and ##### represents ArcGIS or QGIS as corresponding to which software was used to export from the geodatabase. A new tab was created for each SPAS event labeled as SPAS_****_DAD_CHECK where **** represents the SPAS event ID in which the column headers were checked to match. The DAD data values extracted from QGIS were subtracted from the ArcGIS values to calculate the difference in DAD table values. A summary tab details the differences among all SPAS event DAD extractions analyzed. Tabs are used for data inputs, computations and final comparison summary. The following sections detail the sample calculations performed in Appendix A-5 to analyze differences in exported DAD data via ArcGIS and QGIS.

6.2.1 The first set of tabs in the spreadsheet are used for input of the *.dbf files as exported from the respective software. The tab setup is shown in Table 6.2.1. Note that ****_* represents the SPAS event ID and ##### represents the software utilized to export the DAD data.

Table 6.2.1 - "SPAS_****_*_DAD_#####" tabs Column/Cell Calculation Description Example Column headers from .dbf file exported via Columns A through P, row 1 In Cell B1, value = AREASQMI ArcGIS/QGIS to identify area, durations, etc.

Columns A through P, rows 2 Input data from .dbf file exported via In cell E5, value = 4.79 through 20 ArcGIS/QGIS

CALCULATION Calculation No: CDQ0000002020000153 Rev 0 Page A3

Title:

Appendix A - DAD and SAF Grid Point Data GIS Preparer SNH Export Evaluation Checker JTS 6.2.2 The next set of tabs in the spreadsheet are used for comparison of the values imported in the

  • .dbf files as exported from the ArcGIS and QGIS. The tab setup is shown in Table 6.2.2. Note that ****_* represents the SPAS event ID.

Table 6.2.2- "SPAS_****_DAD_CHECK" tabs Column/Cell Calculation Description Example Check to see if column headers match between In cell A1, value =

Columns A through 0, row 1 exported DAD tables from ArcGIS and QGIS by IF(SPAS_1430_1_DAD_ArGIS!B1=SPAS_1430 use of the Excel IF function _1_DAD_QGIS!A1,0,1)

In cell A3, value =

Columns A through O, rows 2 to Difference in exported DAD values calculated by SPAS_1430_1_DAD_ArGIS!B3-30 taking difference of ArcGIS and QGIS values SPAS_1430_1_DAD_QGIS!A3 6.2.3 The last tab in the spreadsheet is used to provide a summary of differences in the values imported in the *.dbf files as exported from the ArcGIS and QGIS. The tab setup is shown in Table 6.2.3.

Table 6.2.3 - "Summary" tab Column/Cell Calculation Description Example Cell B2 Label for columns C to P, row 2 In cell B2, value = Duration (hours)

Columns C to P, row 2 Column labels specifying storm duration In cell C2, value = 1 Cell B3 Label for columns C to P, row 3 In cell B3, value = Max D (inches)

Maximum difference between ArcGIS and QGIS In cell C3, value =

exported DAD values for each corresponding Columns C to P, row 3 MAX(SPAS_1430_DAD_CHECK:SPAS_1034_

storm duration calculated using the Excel MAX DAD_CHECK!A1:A30) function and a 3D reference to all CHECK sheets Cell B4 Label for columns C to P, row 4 In cell B4, value = Min D (inches)

Minimum difference between ArcGIS and QGIS In cell C4, value =

exported DAD values for each corresponding Columns C to P, row 4 MIN(SPAS_1430_DAD_CHECK:SPAS_1034_D storm duration calculated using the Excel MIN AD_CHECK!A1:A30) function and a 3D reference to all CHECK sheets Cell B5 Label for columns C to P, row 5 In cell B5, value = Min D (inches)

Average difference between ArcGIS and QGIS exported DAD values for each corresponding In cell C5, value =

Columns C to P, row 5 storm duration calculated using the Excel AVERAGE(SPAS_1430_DAD_CHECK:SPAS_1 AVERAGE function and a 3D reference to all 034_DAD_CHECK!A1:A30)

CHECK sheets 6.3 Following import into Excel by opening the exported *.dbf files a separate tab was created for each *.dbf file exported from ArcGIS and QGIS from the Storm_Adj_Factors.gdb geodatabase labeled as SPAS_****_*_SAF_##### where **** represents the SPAS event ID (e.g. 1430_1) and ##### represents ArcGIS or QGIS as corresponding to which software was used to export from the geodatabase. The count, Total Adjustment Factor and Transposability Flag values as exported from QGIS were subtracted from the values from ArcGIS to calculate a difference in exported values. A summary tab details the differences among all SPAS event SAF extractions analyzed. Tabs are used for data inputs, computations and final comparison summary. The following sections detail the calculations performed in Appendix A-6 to analyze differences in exported grid point data exported via ArcGIS and QGIS.

CALCULATION Calculation No: CDQ0000002020000153 Rev 0 Page A4

Title:

Appendix A - DAD and SAF Grid Point Data GIS Preparer SNH Export Evaluation Checker JTS 6.3.1 The first set of tabs in the spreadsheet are used for input of the *.dbf files as exported from respective software. The tab setup is shown in Table 6.3.1. Note that ****_* represents the SPAS event ID and ##### represents the software utilized to export the SAF data.

Table 6.3.1 - "SPAS_****_*_SAF_#####" tabs Column/Cell Calculation Description Example Column headers from .dbf file exported via Columns A through L, row 1 In cell B1, value = CNT ArcGIS/QGIS to identify area, durations, etc.

Columns A through L, rows 1 Input data from .dbf file exported via In cell D2, value = -86.525 through 17939 ArcGIS/QGIS 6.3.2 The next set of tabs in the spreadsheet are used for comparison of the values imported in the

  • .dbf files as exported from the ArcGIS and QGIS. The tab setup is shown in Table 6.3.2. Note that ****_* represents the SPAS event ID.

Table 6.3.2- "SPAS_****_SAF_CHECK" tabs Column/Cell Calculation Description Example Labels for columns A through C, rows 2 through Columns A through C, row 1 In cell A1, value = CNT 17939 In cell A2, value =

Difference in exported CNT values calculated by Column A, rows 2 to 17939 SPAS_1034_1_SAF_ArcGIS!B2-taking difference of ArcGIS and QGIS values SPAS_1034_1_SAF_QGIS!A2 In cell B2, value =

Difference in exported TAF values calculated by Column B, rows 2 to 17939 SPAS_1034_1_SAF_ArcGIS!K2-taking difference of ArcGIS and QGIS values SPAS_1034_1_SAF_QGIS!J2 In cell C2, value =

Difference in exported TRANS values calculated Column C, rows 2 to 17939 SPAS_1034_1_SAF_ArcGIS!L2-by taking difference of ArcGIS and QGIS values SPAS_1034_1_SAF_QGIS!K2 6.3.3 The last tab in the spreadsheet is used to provide a summary of differences in the values imported in the *.dbf files as exported from the ArcGIS and QGIS. The tab setup is shown in Table 6.3.3.

Table 6.3.3 - "Summary" tab Column/Cell Calculation Description Example Labels for attribute values in columns C through E, Columns C through E, row 2 In cell C2, value = CNT rows 3 through 5 Cell B3 Label for columns C to E, row 3 In cell B3, value = Max D Maximum difference between ArcGIS and QGIS In cell C3, value =

exported SAF values for each corresponding attribute Columns C to E, row 3 MAX(SPAS_1034_1_SAF_CHECK:SPAS_1430_1 calculated using the Excel MAX function and a 3D

_SAF_CHECK!$A$2:$A$17939) reference to all CHECK sheets Cell B4 Label for columns C to E, row 4 In cell B4, value = Min D Minimum difference between ArcGIS and QGIS In cell C4, value =

exported SAF values for each corresponding attribute Columns C to E, row 4 MIN(SPAS_1034_1_SAF_CHECK:SPAS_1430_1 calculated using the Excel MIN function and a 3D

_SAF_CHECK!$A$2:$A$17939) reference to all CHECK sheets Cell B5 Label for columns C to E, row 5 In cell B5, value = Average D Average difference between ArcGIS and QGIS In cell C3, value =

exported SAF values for each corresponding attribute Columns C to E, row 5 AVERAGE(SPAS_1034_1_SAF_CHECK:SPAS_14 calculated using the Excel AVERAGE function and a 30_1_SAF_CHECK!$A$2:$A$17939) 3D reference to all CHECK sheets

CALCULATION Calculation No: CDQ0000002020000153 Rev 0 Page A5

Title:

Appendix A - DAD and SAF Grid Point Data GIS Preparer SNH Export Evaluation Checker JTS 7.0 Summary of Results The export of DAD and SAF datasets for each of the nine SPAS events analyzed have been checked by parallel processing on the Quantum GIS platform. DAD PMP depths for all durations included within the SPAS DAD dataset differed by less than 10-14 inches. The total storm adjustment factors, transposability flag and feature counts at each of the 17,938 grid points in the Tennessee Valley watershed differed by less than 5x10-12 at any individual grid point. The DAD and SAF data sets exported by ArcGIS are suitable for use in the parent and subsequent calculations.

8.0 Conclusions Export of DAD and SAF datasets from ArcGIS file geodatabases performed in ArcGIS have been checked by Quantum GIS and any differences are insignificant. Calculations performed in the development of final PMP depths at each grid point are suitable for use in subsequent calculations and the parent calculation.

CDQ0000002020000153 Appendix B DAD and Grid Point Data Files Extracted by ArcGIS Used In Analysis Attached Files Description Appendix B-1 SPAS DAD Data.zip.txt SPAS Depth-Area-Duration datasets for the 58 SPAS Events Appendix B-2 SPAS Grid Point Data.zip.txt SPAS Grid Point datasets for the 58 SPAS Events

CDQ0000002020000153 Appendix C Manual Computations of Final Grid Point PMP Depth Results Attached Files Description Appendix C-1 Manual Grid Point PMP Depth Excel File Manual Computations of Final Grid Computations.zip.txt Point PMP Depths PDF of Computation for all Tropical SPAS Events Appendix C-2 7500 SqMi Example Manual PMP and Final Grid Point PMP Depths for 7,500 Square Depth Computations.pdf Mile Event Appendix C-3 Final Grid Point PMP Depth PDF of Manually Calculated Final Grid Point PMP Results.pdf Depths

Retrieved from "https://kanterella.com/w/index.php?title=CNL-21-072,_TVA_Nuclear_Calculation_Coversheet/_Ecm_Metadata_Update&oldid=3406114"