Cover Image

Not for Sale

View/Hide Left Panel
Click for next page ( 13

The National Academies | 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 12
Chapter 3: The Tool 13 3.2.6 Evaluation Criteria Groups The weights entered in the tables above are used to assess the operator's priorities within a sin- gle evaluation criteria group (i.e., security objectives, non-security effects, 33 CFR compliance, locations, or threat type). The weights provided below will be used to adjust weights between evaluation criteria groups according to the priorities for your operation. After each description, enter the number from 0 to 5 (see definitions below) that best indicates the relative importance of the evaluation criteria group. 0 = not important 3 = moderate importance 1 = low importance 4 = moderate to high importance 2 = low to moderate importance 5 = high importance Importance Evaluation Criteria Groups (0 5) Security Objectives Non-Security Effects 33 CFR Compliance Locations Threat Type When the information in Worksheet 1 is completed, the tool calculates the value of each GSM in accordance with the user-set weighting factors. These will appear in Worksheet 2, Valuations. 3.3 Worksheet 2, Valuations Figure 3 shows a view of Worksheet 2, Valuations. This worksheet is used to sort GSMs based on valuations in utils. These valuations are calculated from the weights given by the user to dif- ferent evaluation criteria (entered in Worksheet 1, Evaluation Weights), and from the applica- bility rankings of GSMs (entered in Worksheet 4, Applicability Ranks). Step 2 (see Figure 1) requires the following: Sort area A11 to P112 by Columns G through O (refer to the box below for instructions on sorting in Excel). This will provide the first prioritizations of GSMs. In Column P, enter the order of sorted rows for comparison with subsequent sorts. Record (in a separate file or on paper) the GSM numbers (from Column A) that are of great- est interest to you for further analysis. Any edits made in this worksheet will not be copied to other worksheets. Changes in cell content should be made in Worksheet 3 (Characterization) to change content in Columns A through E, and Worksheets 1 (Evaluation Weights) and 4 (Applicability Ranks) to change the utils shown in Columns G through O.

OCR for page 12
14 Part I: Guide for Evaluating Security Measures for the U.S. Ferry System A B C D E F G H I J K L M N O P 1 VALUATION ("UTILS") OF GSM BY DIFFERENT EVALUATION CRITERIA INSTRUCTIONS: For Sorting Only (DO NOT Enter New Data on this Page!) 2 Sort area A11 to P112 by Columns G through O. In Column P, you can enter the order 3 of sorted rows for comparison to subsequent sorts. Develop a "Further Evaluation" list EXPLANATION OF COLUMNS BELOW on paper, by recording the GSM #s (Column A) that are of greatest interest to you for "Utils" are calculated from the weights given by the user to different evaluation criteria (entered on 4 further analysis. Sheet 1 "Evaluation Weights"), and from the applicability ranks of GSMs (entered on Sheet 4 To enter new data: "Applicability Ranks"). 5 Use Sheet 1 to change Evaluation Weights. 6 Use Sheet 3 to change GSM Characterization (Columns C to E). 7 Use Sheet 4 to change Applicability Ranks. GROUPED EVALUATION CRITERIA VALUATION IN UTILS 8 GSM CHARACTERIZATION Threat Type Non- 33 CFR Threat Act of Your GSM General Security Security Security Compli- Security Type EID Force WMD TOTAL GSM 9 # Method Category Measures (GSMs) Options and Variations of GSMs Objective Effects ance Locations Total Only Only Only (All Criteria) List # 10 1 Fencing / Retractable Ramp/ Wedge, Manual or automatic raising and lowering; Barriers Vehicle in-ground mounted some products rated as high as DOS Deterrents K12/ L3. 14.6 -1.8 4.5 5.3 8.9 3.7 2.7 2.5 31.6 11 2 Fencing / Retractable Bollards, Hydraulic, electro-hydraulic, or manual Barriers Vehicle retractable retraction into ground. Some products Deterrents (steel or concrete) rated as high as DOS K12/ L3 depending 13.4 0.9 4.5 6.4 8.9 3.7 2.7 2.5 34.2 on installation. 12 3 Fencing / Retractable Ramp/ wedge, Manual or automatic operation. Chain Barriers Vehicle surface mounted reinforcements increase anti-ram Deterrents capability, but substantially lower anti-ram 13.4 0.9 4.5 5.3 8.9 3.7 2.7 2.5 33 ratings than in-ground mounted ramps (listed separately). 13 4 Fencing / Retractable Booms and Crash Manual, automatic, or portable. Range Barriers Vehicle Beams from minimal anti-ram capability to DOS Deterrents (sliding or swing K4/L2 or higher. 13.4 0.9 4.5 5.3 8.9 3.7 2.7 2.5 33 gates) 14 5 Fencing / Retractable Traffic controllers Spring-mounted to allow safe one-way Barriers Vehicle ("tire teeth") travel, or retractable (with access control) Deterrents to allow two-way travel. Wrong-way 13.4 0.9 4.5 4.0 8.9 3.7 2.7 2.5 32 penetration distance can be reduced with low speed conditions. 15 6 Fencing / Fixed Vehicle Bollards, Variable anti-ram capability. Some Barriers Deterrent, fixed/stationary products rated as high as DOS K12/ L3 Pedestrian (concrete or steel) depending on installation. 13.4 6.2 4.5 8.6 8.9 3.7 2.7 2.5 42 Access 16 Figure 3. View of Worksheet 2, Valuations. How to Sort in Excel Highlight the area to be sorted. To do this on Worksheet 2, start with the cursor in Cell A11, hold the "shift" key down while moving the mouse to Cell P11. While still holding the shift key down, press "down page," or "end" followed by down arrow. The entire contents from Cells A11 to P112 should be highlighted. Release the shift key and click on "Data" at the top of the screen, then click on "sort" in the drop- down box. Click on the down arrow to show the drop box under "Sort By," select "Column O" to sort on the "Total Utils" or other columns to sort by a particular evaluation criteria group. Select "Descending" to the right of the drop-box and then click "OK" at the bottom of the "Sort" box. The highlighted area will be re- ordered with the GSMs with the highest number of utils at the top of the page.