Cover Image

Not for Sale

View/Hide Left Panel
Click for next page ( 20

The National Academies of Sciences, Engineering, and Medicine
500 Fifth St. N.W. | Washington, D.C. 20001

Copyright © National Academy of Sciences. All rights reserved.
Terms of Use and Privacy Statement

Below are the first 10 and last 10 pages of uncorrected machine-read text (when available) of this chapter, followed by the top 30 algorithmically extracted key phrases from the chapter as a whole.
Intended to provide our own search engines and external engines with highly rich, chapter-representative searchable text on the opening pages of each chapter. Because it is UNCORRECTED material, please consider the following text as a useful but insufficient proxy for the authoritative book pages.

Do not use for reproduction, copying, pasting, or reading; exclusively for search engines.

OCR for page 19
20 Part I: Guide for Evaluating Security Measures for the U.S. Ferry System 3.8 References Worksheet This worksheet provides full references for Column G of Worksheet 3, Characterization, and Column O of Worksheet 5, Costs. Wherever possible, Internet sites are provided. The sites pro- vided do not always display cost information, but they provide e-mail and telephone contact information through which costs estimates can be obtained. 3.9 Hidden Calculations Worksheet 3.9.1 Overview of Hidden Calculations The Hidden Calculations worksheet does not need to be viewed by the user. It uses entries in Worksheets 1 and 4 to calculate valuations (utils) and entries in Worksheet 3 to label the viewed GSMs. Valuations calculated in the Hidden Calculations worksheet are copied to Worksheet 2, Valuations. More advanced users may benefit from viewing additional breakdowns shown in the Hidden Calculations worksheet. While valuations in Worksheet 2 are shown only for grouped evaluation criteria, valuations may be viewed for each individual evaluation criterion in the Hidden Calculations worksheet. Columns A through O of the Hidden Calculations worksheet show the same information that is displayed in Worksheet 2, Valuations. Columns farther to the right (i.e., Columns Q through BK) show the utils (or weight-adjusted rank) of each GSM for each evaluation criterion within each of the evaluation groups. If you sort data in the Hidden Calculations worksheet, the data must be returned to the original order prior to using Worksheets 2 and 6. Alternatively, the Hidden Calculations worksheet can be copied to another worksheet name for sorting. As previously described, utils are calculated from the weights given by the user to different evaluation criteria (entered in Worksheet 1, Evaluation Weights) and to the relative applicability ranks (entered in Worksheet 4, Applicability Ranks). A more detailed description of the Excel equations used to calculate these weight-adjusted ranks (i.e., utils) in the Hidden Calculations worksheet is provided below. Most users are not likely to need this level of detail. Columns Q through T of the Hidden Calculations worksheet show GSM characterization infor- mation from Worksheet 3, Characterization, to provide easy reference when analyzing the valua- tions for GSMs in Columns V through BK. For discussion of weight-adjusted ranks (i.e., utils) in Columns V through BK, the following terms are used: Rank refers to the numbers entered in Worksheet 4, Applicability Ranks. These numbers indi- cate the relative applicability of each GSM to each evaluation criterion. The maximum accept- able applicability rank is 3. Specific Criteria refers to the specific evaluation criteria described in Worksheet 1, Evaluation Weights. For example, in the Security Objective group, the specific criteria are to deter, detect, deny, and mitigate, as described in Rows 9 through 12 of Worksheet 1, Evaluation Weights. Weight refers to the numbers entered in Worksheet 1, Evaluation Weights. These numbers indicate the relative weight given to different evaluation criteria. The maximum weight is five. There are two types of weights: group weights and specific weights (described below). Group Weight refers to the five weights entered in Rows 75 to 79 of Worksheet 1, Evaluation Weights, for the criteria groups of security objectives, non-security effects, 33 CFR Compli- ance, Security Locations, and Threat Type. Sub-Group Weight refers to the average weight of each of the three sub-groups within the Threat Type group. These sub-groups are Delivery of Explosive/Incendiary, Act of Force, and Deliver WMD.