Home

User`s Manual - CNA Corporation

1. 20002 Authorized for US Navy construction EE EE O za NONAME J sva SSN 20078 Authorized for US Navy construction lo 8H42003 esns o mU e wp deu CONSTITUTION us aaa erase UA Active neommission nn E 3 WT ess 43 PUEBLO USS AGER2 agen VER oe Ae incomenision 7 AGER 2 E 2 44 DOLPHIN dues asst faces fost72 poten commission are y Worksheet Tabs Figure 2 View of the remaining fields Homeport Program Type DANFS Link INVR Link 1 Status AE I0 IN O EN EEN E app a2 Za E E gt o A SS SS O A o o n p AA pps hp Ai eo tamos ooo y o ssews SS IA 00088 a E EA Aan o p HEI 25 ES EA EX 29 30 ET E EJ EA 38 38 KI at d CONSTITUTION es iir M P E A A E ox CONSTITUTION OL 03401447941 112011744 amt onna a an 43 PUEBLO uss lag ho Ll Location Namp a PRK fox FS34qAKLdd aadd DOLPHIN i SANDIEGO CA o aamataana SINAI LI MATA AITANA tre Figure 3 NVR ship web page for USS John C Stennis CVN 74 o osoft Internet Explore 181 x File Edit View Favorites Tools Help a Back gt O A A Asearch GjFavortes meda Zb S c4 5 Address E http jww nvr navy millnvrships details CVN74 htm v oo Links e IAdobe Y X 2f y Search web 53 gt mal
2. 3 f 3 Y 24 9 USN Naval Reserve Force Active lA o F 2 0 USN Stand down TTT 1 n USN Inactive Ta 4 amp USN See pr 72 13 USNIMSC Disposed A o P 190 sl EU UON 1 SES sia REE io lo A Lplwe 1 Tga Tang ina wm EE AA 22 Total er RB Zi RL R2 51 9 X 209 251 Lo TT 20 21 22 23 I4 AEN DataTableOriginal DataTableCopy PivotTable The AutoFilter feature of Excel 36 Excel s AutoFilter offers still another way to rapidly query the data base Unfortunately Excel disables AutoFilter when a worksheet is protected Because we have protected DataTableOriginal we have included the sheet DataTableCopy in the workbook Make sure you create a copy of the original one Figure 22 is a view of DataTableCopy that shows the drop down menu path to toggle the AutoFilter off and on In this view the AutoFilter is on as indicated by the check mark Further indication of the AutoFilter being on is given by the gray drop down boxes in each of the field name cells in row 1 of the spreadsheet Now we ll present an example to show how the AutoFilter works Let s identify all the aircraft carriers in the database First we draw down the filter options for the Type field and select the Custom option as shown in figure 23 The Custom Autofilter in which one can enter filtering criteria appea
3. HOME DoD NAVSHIPSO NAVSEA Shipbuilding Support Office E Norfolk Naval Shipyard Detachment EA 3751 Island Avenue Third Floor Philadelphia PA 19153 3297 PHILADELPHIA 215 365 5767 Shipbu ng Support Office 210 909 0508 FA 10 Figure 5 NVR status groups N V R NAVAL VESSEL REGISTER This information resides on a DOD interest computer Important conditions restrictions and disclaimers apply a Ship Status Groups Authorized Under Construction Active Naval Reserve Force Active Stand Down Special Miscellaneous MARAD Custody Military Sealift Command Naval Fleet Auxiliary Force Military Sealift Command Cargo Fast Sealift Support Specialized Military Sealift Command Contract Operated Military Sealift Command Ready Reserve Force Military Sealift Command Special Mission Support All Hulls 11 Figure 6 List of units in Active status category N V R This information resides on a DOD interest computer Important conditions restrictions and disclaimers apply NAVAL VESSEL REGISTER Ships Both Coasts Active Class Name UIC Homeport CONSTITUTION 01024 AGER 2 PUEBLO 20256 AGF 3 LA SALLE 07172 AGF 11 CORONADO 07194 AGSS 555 DOLPHIN 05072 OE 1 CAMDEN 05833 OE 1 SEATTLE 05848 OE 1 DETROIT 20120 ARS 50 SAFEGUARD 21245 RS 50 GRASP 21467 NORFOLK V LITTLE CREEK RS 50 SALVOR 21468 PEARL HARBOR HI RS 50 GRAPPLE 21441 NOR
4. Ele Edit View Insert Format Tools Data Window Help Acrobat 1281 xl Ia eE az ESTA LEE l8 ED Name a SS Red ii a 23195 Authorized for US Maut construction wezeo iakk i 23196 Authorized for US Maut construction weno KES 23197 Authorized for US Navy construction OoOo 22005 KES 23198 Authorized for US Mawgconstruction OoOo wed iset 23161 Authorized for US Navy construction 9132002 A 8 TRUXTUN Cid DDGi3 23165 Authorized for US Maut construction LL crac sTERETT 1 1 1 23166 Authorized for US Nawy construction aooe ippast Ax ee poa 55684 sn3200 open 55685 AAA EE 55687 Authorized for US construction a 00655688 ewe ues o 1 construction 19 NEvHAMPSHRE HC is e 20 NEvMEXECO amp 1 1 1 jssuzs ssu 23183 Authorized for US 842003 ew ar noname Teeween ssw________ 20002 Authorized for US Na REN 842003 een i 22 NONAME ssu s SSN 1 20073 Authorized for US Navy construction 8m420030 een i zz Ssh TI woo seum T A KH Da
5. Unit Identification Ship Name Previous Names Ship Name Prefix Unit Identification Code UIC Hull Number Class Ship Type Location Fleet Homeport Berth Status Force Type Status Date Status Changed Force MARAD Type History Builder Award Date Keel Date Launch Date Delivery Date Commission Date Years from Commission to Decommission Stricken Date Age since launch Age since delivery Decommission Date Physical Characteristics Overall Length Extreme Beam Maximum Navigational Draft Light Displacement Dead Weight Waterline Length Waterline Beam Draft Limit Full Displacement Hull Material Propulsion Propulsion Type Accommodations Officers Enlisted Number of Propellers Custody Design Agent Custodian Planning Yard Information currency Date of Last Change to Information a We have incorporated the fields in italics in the Integrated Ship Database Figure 4 NVR SHIPS web page NAVAL VESSEL REGISTER This information resides on a DoD interest computer Important conditions restrictions and disclaimers apply Fleet Size Ship Hull Classification Symbols Ship Names Homeports of Active and NRFA 5 Status of S ship Custodian Assignments Planning Yard Hull Assignments Planning Yard Nuclear Reactor Plant Nuclear Eacility Assignments Ships Donated a Museum and Memorial NVR RELATED LINKS COMMENTS FAO s DOD DISCLAIMER SERVICE CRAFT
6. in service contract operated Sealift Program Maritime Administration The NVR organizes ships under MARAD custody primarily in terms of the National Defense Reserve Fleet and the Ready Reserve Force National Defense Reserve Fleet The NDRF under the custody of MARAD is an inactive reserve source of basic Merchant design type ships that could be activated within 20 120 days to meet the shipping requirements of the United States during national emergencies These merchant vessels are available for use in both military and non military emergencies such as commercial shipping crises Naval auxiliaries are maintained at the fleet by MARAD on a retention basis for the Navy e Non Retention Ships in this category are no longer militarily or non militarily useful assets and are scheduled for scrapping or they can be donated to individual US states for use as artifi cial fishing reefs e Retention Ships in this category are militarily useful assets which are titled to either MARAD or to the Navy Ready Reserve Force The RRF was created on 14 February 1977 spe cifically to enhance the readiness of sealift to respond rapidly in any contingency The RRF a quick response subset of the NDRF is a select group of ships within the NDRF which are relatively modern highly militarily useful ships rigorously maintained to meet Coast Guard and American Bureau of Shipping standards They are crewed by Maritime
7. E my Yahoo Fj Games SY Personals BB Movies Music Sign In N V R NAVAL VESSEL REGISTER This information resides on a DOD interest computer Important conditions restrictions and disclaimers apply USS JOHN C STENNIS CVN 74 MULTI PURPOSE AIRCRAFT CARRIER NUCLEAR PROPULSION UK 21847 Class CVN 68 Fleet Pacific Homeport BREMERTON WA Berth Maintenance Category Force Battle Force MARAD Type Builder NEWPORT NEWS NEWPT Delivery Date 11 09 1995 Award Date 06 30 1988 Age since delivery 93 years Keel Date 03 13 1991 Commission Date 12 09 1995 Launch Date 11 13 1993 Decommission Date Age since launch 11 3 years Years from Commission to Decommission Stricken Date Overall Length 1092 ft Waterline Length 1040 ft Extreme Beam 252ft Waterline Beam 134 ft Maximum Navigational Draft 42ft Draft Limit 41ft Light Displacement 78453 tons Eull Displacement 103300 tons Dead Weight 24847 tons Hull Material Steel hull steel superstructure Number of Propellers 4 Propulsion Type Steam Turbines Nuclear Accommodations Officers 200 Custodian US NAVY Ships Program Manager 312 Planning Yard Norfolk NSY Norfolk VA Nuclear Planning Yard To learn more about this type of ship visit Newport News Shipbuilding and Drydock Co Newport News VA Table 1 Type of information Fields from NVR data NVR fields
8. Naval Reserve Force Active Stricken Stand Down Disposed Maritime Administration MARAD National Defense Reserve Fleet Non Retention Retention Ready Reserve Force MARAD Custody Title XI Military Sealift Command Naval Fleet Auxiliary Force Cargo Fast Sealift Support Specialized Contract Operated Undergoing Conversion Ready Reserve Force Special Mission Support Prepositioning Force Maritime Prepositioning Ship Si fab intemet Z 42 Our structure We distilled our organizing structure out of the various schemes we found It is similar to all of them but not identical to any of them Figure 27 summarizes our approach Figure 27 Status organization for Integrated Ship Database pivot table NVR MSC amp MARAD Ship Inventory Data Level 1 USN MSC MARAD Level 2 Authorized NFAF Program NDRF Active Under Construction Spec Msn Program r RRE Retention i Active PREPO Program F 1 Custody Non retention i i NRF A Sealift Program 1 Disposal by Inactive reserve MARAD Sale Inactive Lease Disposal by Loan or Grant MARAD te Exchange Stricken gt Disposal by Disp sal _ E EE gt Title Transfer F
9. one ship Proteus EX AS 19 is not included in the NVR database 23 This page intentionally left blank Querying the database PivotTable For rapid querying of the database and counting of the records within it we built PivotTable It uses four fields from the database Ship Name Status Type and Force We grouped the status titles similar to the way described in our discussion above on the structure of the database Figure 14 shows the opening view of the pivot table Ship Name Status and Type are in columns B C and D respectively The grouped field in column A which we named Status Category combines the Status groups for MSC and MARAD Due to the volume of USN records we were unable to gather them into a single group Thus we grouped these records by phase of the life cycle and anno tated each group with USN as a prefix Figure 14 shows the count of each group in column M Hiding and unhiding data One of the very nice features of a pivot table is that data can be ana lyzed easily if you simply double click the mouse on the text cells found beneath the title fields highlighted in grey Double clicking a cell at one level will unhide the cells at the next level down For example double clicking on the MSC cell under Status Category will reveal groupings by various titles in the Status field as shown in figure 15 You can see the sub total of records for each Status title in column M in addition t
10. 2000 joos 8 TRUXTUN O Authorized for US Navy construction 3H3i2000 DDGs 3 9 STEHETT O 23166 Authorized for US Navy construction 83 2007 Gg Oo T 1 DEWEY 23162 Authorized for US Navy construction SH3202 oos 2 NoName O 23164 Authorized for US Navy construeti n 9H32002 DDGS 3 Noname 55684 Authorized for US Navy construction 8 3 2007 joos O 4 NONAME O o DD 103 55685 Authorized for US Navy construction sg Gg sid Hs NONAME O ees 006 nho ors Nag conetucton SE AE E NA 6 NONAME gt 55687 Authorized for US Navy construction mao pon JJ U jim NONAME gt Authorized for US Navy construction 3H3i200 a O T O 16 NEW YORK __ Authorized for US Navy construction noo Jeor o o ooo o eg 8 NEV HAMPSHIRE EE EE gt E 20 NEW MERICO f SsNz 3 SSN 23183_ Authorized for US Navy construction LE Is 2 NONAME sna lss
11. VASHINGTON i Active in commission eg JOHN C STENNIS Cy 21847 Active in commission eget gt JEUNES HARRY S TRUMAN Lu em Ta Det neommission rone Ice RONALD REAGAN uss Cvu7z6 Jeww 22178 Active in commission ll eves ev 0334 Donated as a Museum and Memorial 8129 2003 Cya Donated as a Museum and Memorial 8454974 Donated as a Museum and Memorial 412711981 78 79 80 8t 83 84 J 85 86 363 420 421 Le Appendix Organization by ship status In this appendix we discuss the organizational structure by ship status in the PivotTable sheet in Integrated Ship Database First we dis cuss our overall organization and how we derived it from the NVR s presentation on ship status Then we present our organizing struc ture We show the specific NVR status definitions within each status category Overall organization NVR s method We based our method of organization on the NVR s structure in figure 26 The first level of organization distinguishes between Navy MSC and MARAD custody The organizing principle for the next level of organization varies within each group The principle for Navy ships is generally based on the cradle to grave life cycle of a ship In addition commissioned vessels in the Active fleet are distinguished from those in the Naval Reserve Fleet Active The structure for MSC ships revolves around its four business programs the Nav
12. by Defense Reutilization and Marketing Service DRMS for scrapping Disposed of by scrapping cannibalization Disposed of sold for scrapping Disposed of by scrapping dismantling Disposed of by submarine recycling Disposed of by recycling Disposed of resold by Defense Reutilization and Marketing Service DRMS for scrapping Disposed of sold by Defense Reutilization and Marketing Service DRMS for reuse conversion Foreign transfer 47 48 Disposed of through the Security Assistance Program SAP trans ferred cash sale ex US fleet hull foreign military sale case number assigned Disposed of through the Security Assistance Program SAP trans Jerred Foreign Assistance Act FAA Section 516 Southern Region Amendment Disposed of built in US for foreign government not SAP Disposed of hull transferred to foreign government not SAP Disposed of through the Security Assistance Program SAP trans ferred grant aid ex US fleet hull Disposed of through the Security Assistance Program SAP trans ferred Foreign Assistance Act FAA Section 519 Southern Region Amendment Disposed of through the Security Assistance Program SAP trans ferred Foreign Assistance Act FAA Section 517 Southern Region Amendment Disposed of through the Security Assistance Program SAP trans ferred grant aid continental US constructed for SAP Disposed of
13. have placed an unprotected copy of the database in DataTableCopy we chose not to do this in order to keep the file as small as possible Structure of the database The fields Figure 1 displays the opening view of the database in the Excel appli cation This view shows some of the fields and a small portion of the records The worksheet tabs at the bottom of the sheet control the access to and display of the three worksheets of the file DataTableOrig inal DataTableCopy and PivotTable In figure 2 the remaining fields from MSC Link through Date Last Updated are shown You will notice that the left most fields Ship Name Prefix and Hull No remain in view even when you move the sheet to view the fields on the right The colored portions of DataTableOriginal distinguish the records of the various ship status categories in the NVR We ll describe these cat egories later But first let s look at the field structure in more detail From the Naval Vessel Register We initially defined the fields for our database after reviewing the NVR web site for ships The NVR web site contains a separate page of detailed data for each ship as shown for USS John C Stennis CVN 74 in figure 3 Table 1 is a list of the fields in the NVR ship pages Downloading the data Unfortunately not all of these data can be easily retrieved from the web site for import into a database application The Status of Ships dis play offers one way to eas
14. table just click on its tab For example double clicking on cell M7 of the opening view see figure 14 will generate the query sheet shown in figure 20 for the 17 ships under construction for the USN Unhiding the SASDT Force information The breakout by SASDT Ship Battle Force category in the pivot table is in columns E through L In the opening view of the pivot table these columns are hidden Unhiding them will result in the display in figure 21 33 VE Figure 20 Query sheet generated from the pivot table El Di a ShipName PrefizHullNo NYRLink Tspe UIC Status Date Status MClass N Force MSC Link 2 BAINBRIDGE FARRAGUT FORREST SHERMAN GEORGE H W BUSH GRIDLEY HAWAII KIDD LEWIS AND CLARK MAKIN ISLAND MESA VERDE NEW ORLEANS NO NAME NORTH CAROLINA SAN ANTONIO DDG 96 DDG 99 DDG 101 SSN 776 DDG 100 23153 Under construction in US bi 23150 Under construction in US bi Na Na 23149 Under construction in US by Na 23170 Under construction in US bi H tructio 23151 Under construction in US bi 23159 Under construction in US b 23152 Under construction in US b 23181 Under construction in US b 23171 Under construction in US b 32421 Under construction in US b 23168 i Under construction in US b 23193 Under construction in US b 23180 Under construction in US bi N Na Na Nav Naw N N Na Na Na unassigned to fleet unassigne
15. through the Security Assistance Program SAP trans ferred Military Assistance Service Funded ex US fleet hull e Experimental target Disposed of in support of Fleet training exercise Disposed of hull stricken for use in test and research work e Transfer to other government non government agencies Disposed of by transfer to other Government Agencies States Schools Sea Scouts etc e Donation Historic Memorial Donated as a Museum and Memorial Dedicated as a Memorial Donated as a Memorial e Miscellaneous Disposed of by abandoning burning scuttling or sinking Disposed of destroyed by enemy action with the Japanese in World War II Disposed of by return to owner Disposed of by navy title transfer Disposed of hull stricken disposition unknown data shown is stricken Disposed of sold by Defense Reutilization and Marketing Service DRMS for reuse and conversion to a power barge Other One ship the ntegrity AGOS 24 was not categorized into another USN status group because of its peculiar and unique status title The NVR does not have a status category Level 2 named Other We added it to accommodate this exception Hull number assigned authorized to be built but never awarded authorization cancelled Military Sealift Command The Military Sealift Command organizes itself around four business programs We quote the NVR descriptions for these pro
16. 04 AC eau Wee 0 Y 9 s 4 a ra 4 TT 1 EES 4 anes i Done lap Internet 21 Figure 13 NVR homeport page for ships in Yokosuka Japan S YOKOSUKA JAPAN Microsoft Internet Explorer la xl File Edit View Favorites Tools Help a SBak gt Gi search Favorites Zhuedes lt 4 Ey 5 al 5 Address El http Jwww nwr navy mil nvrships s hp YO htm e Go Links 2 LMdobe YY 2 Y search web 53 gt mai O my Yahoo IF Games BI Personals Y Movies Music Sign in N V R dd NAVAL VESSEL REGISTER This information resides on a DOD interest computer Important conditions restrictions and disclaimers apply Homeport YOKOSUKA JAPAN Select a Hull Class Hull Name CG 47 CG 49 VINCENNES CG 47 CG 62 CHANCELLORSVILLE CG 47 CG 63 COWPENS CV 63 CV 63 KITTY HAWK DD 963 DD_985 CUSHING DDG 51 DDG_54 CURTIS VILBUR DDG 51 DDG 56 JOHN S MCCAIN FFG 7 FFG 48 VANDEGRIFT FFG 7 FFG 51 GARY LCC 19 ICC 19 BLUE RIDGE RELATED LINKS DOD DISCLAIMER SHIPS SERVICE CRAFT HOME DoD Related Links Disclaimer i Ships k Service Craft Home b il e EOD fg internet The records database composition and NVR status The database contains a total of 2 510 records As mentioned above we grouped the records by ship status and used colors to set them apart generally according to the NVR s ship status groups listed
17. Administration MARAD personnel in an increased 53 54 state of readiness that would permit their activation within four five ten and twenty days The NVR defines other status groups for MARAD in figure 26 as fol lows MARAD Custody Ships or service craft maintained and laid up at MARAD facilities on a temporary basis when the Navy cannot accom modate the assets at its inactive fleet facilities During this lay up period the Navy pays rent to MARAD for the pier space Title XI Ships or service craft acquired by MARAD following default on MARAD guaranteed mortgages The specific status descriptions in the NVR for ships under MARAD custody include the following Special MARAD titled ship listed here as part of the U S Navy Ship Battle Forces Sealift Program RRF Special Miscellaneous MARAD Titled RRF Prepositioning Program Special Miscellaneous MARAD Titled RRF Sealift Program Military Sealift Command MSC MARAD custody NDRF Military Sealift Command MSC MARAD custody RRF Sea lift Program Disposed of ships under MARAD custody We noted that many of status titles in the USN MSC Disposed status category involved sale or transfer of some kind to MARAD In all cases the NVR lists MARITIME ADMINISTRATION NATIONAL DEFENSE RESERVE FLEET as Custodian As a result we moved them from the Disposed status group to the MARAD group We did retain the NVR s de
18. As mentioned above the Class field with ship class from the NVR contains hyperlinks to the type and class information in the CHINFO Navy Fact File Figure 8 shows the page from the Fact Filefor aircraft carriers Note Links on a Fact File page can take you to the web pages of individual ships Figure 9 shows the page for USS Abraham Lincoln CVN 72 which was accessed through the link shown at the bottom of the Fact File page for carriers The links in the Forcefield connect to the respective definitions in the NVR for the entries MSC Link accesses the pages for individual ships in the MSC Ship Inventory The page for USS Arctic I AOE 8 is shown in figure 10 e The links in the field MARAD NDRF Program Type Status con nect to the individual ship pages in the PMARS database An example the page for Neosho is shown in figure 11 DANFS Link connects users to the appropriate page for a ship name in the NHC Dictionary of American Naval Fighting Ships database The DANFS page for USS Kitty Hawk CV 63 is shown in figure 12 Since several ships may have the same name at different points in time you may have to search through the web page to find the specific ship of interest The links in the Homeport field take you to the NVR pages that list all ships with the same homeport as the ship of the record Figure 13 shows the list of ships homeported in Yokosuka Japan 15 Figure 7 Fields with hyperlinks Wm Eer H
19. CIS D0012061 A2 Final December 2005 The Integrated Ship Database A Rapid Access Database of Naval Ship Information A User s Manual Gregory Suess e Lynette McClain CNA 4825 Mark Center Drive e Alexandria Virginia 22311 1850 Approved for distribution Praman Mg Maureen A Wigge Director Operational Policy Team Operations Evaluation Group This document represents the best opinion of CNA at the time of issue It does not necessarily represent the opinion of the Department of the Navy Distribution limited to DOD agencies Specific authority N00014 00 D 0700 For copies of this document call CNA Document Control and Distribution Section at 703 824 2123 Copyright 2005 The CNA Corporation December 2005 Contents Introduction The Integrated Ship Database file File structure s 4 a dn RR o RR RR Rs Data access and protection Structure of the database The fields From From Fields the Naval Vessel Register the other data sources with hyperlinks s sag tae WANG The records database composition and NVR status Querying the database 0004 PivotTable Hidin g and unhiding data Query sheets with a double click Unhiding the SASDT Force information The AutoFilter feature of Excel Appendix Organization by ship sta
20. DRF Program Type Homeport gao nl i Status HVR Link ee CONSTITUTION Oidironsides Did ronsides DOLPHIN CGS ESA oo cco E AA a xx RN PA BEF Tanker E hom Fm NEN RN EM xU e JR HU ON mi lama sve ge eo mopa loo lo law been PP AT 2057 CAPE ISLAND TARO e Seed Long Beach CA I4 4 pi DataTableOriginal Figure 8 Portion of Navy Fact File page for aircraft carriers 3 Navy Fact File Aircraft Carriers Microsoft Internet Explorer Cl xj File Edit View Favorites Tools Help Back gt O A A Asearch xFavortes Ameda Er SM a Address http www chinfo navy mil navpalibjfactfile ships ship cv html v 6o Links gt Adobe YY 2 z search web 2 Gmail Eh my Yahoo Ej Games SP Personals Bl Movies Music sw The United States Navy United States Navy Aircraft Carriers CV CVN El Video of USS Dwight D Eisenhower CVN 69 underway in the Atlantic This video is more than 22 MB LII silent Description Aircraft carriers provide a wide range of possible response for the National Command Authority The Carrier Mission To provide a credible sustainable independent forward presence and conventional deterrence in peacetime To operate as the cornerstone of joint allied maritime expeditionary forces in times of crisis and To operate and support aircraft attacks on enemies prote
21. FOLK VA LITTIE CREEK AS 39 EMORY S LAND 20635 LA MADDALENA ITALY AS 39 FRANK CABLE 20865 GUAM MARIANA ISLANDS CG 47 VINCENNES 21295 YOKOSUKA JAPAN CG 47 THOMAS S GATES 21344 PASCAGOULA MS CG 47 BUNKER HILL 21345 SAN DIEGO CA CG 47 MOBILE BAY 21346 CG 47 ANTIETAM 21387 CG 47 LEYTE GULF 21388 CG 47 S N JACINTO 21389 CG 47 LAKE CHAMPLAIN 21428 12 Other NVR data were relatively easy to enter manually These fields included the Prefix to the ship name e g USS USNS MV SS Previ ous Names for the ship and the specific battle or support Force to which a ship is assigned Still other data specifically the various dates related to ship history status change and data currency took more time to enter We decided to include these data because of their considerable value for historical research and analysis We added the Type field although it has information that can be found in the Hull Number field Having a separate field for ship type facilitates sorting and counting in the pivot table From the other data sources CHINFO Navy Fact File The database does not contain specific information from the Navy Fact File Instead there are hyperlinks to the Fact Filein the Class field MSC Ship Inventory The field MSC Link contains the ship s name as presented in the MSC Ship Inventory database MARAD Property Management amp Archive Record System The information from MARAD is in column K in the field na
22. IAL READI NESS AND LOGISTICS FLEET READINESS DIVISION N430H Mr Alex Ballesteros N430G Mr Clifton Gray DEPUTY CHIEF OF NAVAL OPERATIONS FOR RESOURCES REQUIREMENTS AND ASSESSMENTS PROGRAMMING DIVISION N80N Mr Andrew Seamans CNA N801L2 Ms Jacquelline Williams ASSESSMENTS DIVISION N81B Mr Arthur Barber N816 Mr Chris Duquette CNA NAVSEASYSCOM NAVSHIPSO NVR Mr Ray Parzych Mr Dave Powell CHINFO Mr Alan Goldstein MSC Mr Frank Randall MARAD Mr Peter Wagner CNA FIELD REPRESENTATIVES COMUSJFCOM J004EG Mr Floyd Kennedy J02EG Dr Edward Cavin JCOA LL Dr Lawrence Lewis JCOA LL Ms Elizabeth Young USCENTCOM CCJS JOAR Mr Thomas Neuberger USPACOM JO1SA Dr Valerie Scruggs USFLTFORCOM N4 N7 Mr Lawrence Lynn N8 Mrs Catherine Lea NS Dr David Perin COMPACFLT N3CNA Dr Brian McCue COMSECONDFLT Dr William Startin COMTHIRDFLT JOOCNA Dr Gregory Cox COMFIFTHFLT COMUSNAVCENT N3 Mr Alarik Fritz N5 Ms Jessica Stewart COMSIXTHFLT COMUSNAVEUR NEPO Mr John Bentrup NEPRS Mr Jed Snyder COMSEVENTHFLT NOIA Dr James North 67 68 TACTRAGRUPAC N3 Dr Kevin Kirk FLTASWCOM Dr Kim Malmin NWDC Nancy Nugent COMOPTEVFOR 00T4 Mr Paul Symborski STRATEGIC STUDIES GROUP Mr James Wylie 70 This page intentionally left blank ISO 19031000 SII CNA
23. Sealift Command MSC Prepositioning Program OOOO YO IA Grand Total mah DataTableOriqinal DataTableCopy XPivotTable Lal 13 az ya v v Figure 16 View with Status and Type fields under USN Under construction Status Category opened Ed Microsoft Excel Integrated Ship Database Sep05 xls File Edit Yiew Insert Format Tools Data Window Help Acrobat 2H s x 8 uid 2 Count of Ship Name mg Fi 5 Status Categor y Status y Type y Ship Mame y amp USN Authorized O maa PEA a Under construction in US by Navy unassigned to fleet SSN Under construction in US by Navy unassigned to fleet Total 16 USN Naval Reserve Force Active o 2 Lo d 17 USN Stand down mp USN Active In commission In service 8 USMSuicken 20 USNIMSC Disposed o tO p21 juswOme O 1 gg mse 000 0 O JI MARAD O a EA E EI 14141 M PivotTable 28 the numbers of ships under construction by type To view the specific list of ships by name double click on each of the cells designating type This will produce the view in figure 17 There is another way to hide and unhide the details in a pivot table i e by using drop down menus For example if you select the gray cell Status Category and right click the option menu in figure 18 will appear By flying the cursor over Group and Outline you will see Hide Detail Show Detail Group and Ungroup options Selecti
24. a Systems Command Washington DC 20362 General Characteristics Nimitz Class Builder Newport News Shipbuilding Co Newport News Va Power Plant Two nuclear reactors four shafts Length overall 1 092 feet 332 85 meters Flight Deck Width 252 feet 76 8 meters Beam 134 feet 40 84 meters Displacement Approx 97 000 tons 87 996 9 metric tons full load Speed 30 knots 34 5 miles per hour Aircraft 85 Cost about 4 5 billion each Ships USS Nimitz CVN 68 San Diego Calif USS Dwight D Eisenhower CVN 69 Norfolk Va USS Carl Vinson CVN 70 Bremerton Wash USS Theodore Roosevelt CVN 71 Norfolk Va USS Abraham Lincoln CVN 72 Everett Wash y E Done PF 6 Internet 17 Figure 9 Web page for USS Abraham Lincoln A USS Abraham Lincoln CYN 72 Microsoft Internet Explorer E 181x File Edit View Favorites Tools Help Ea Bak gt Dl d Search Favorites ieda 04 Ey SH 3 Address http www cvn72 navy mil sl Go Links 2 Adobe YY 2 sese web J Gi CIMail EI Wo Yahoo W Games Personals Bi Movies Music RS EA a T LE te xw t nag Battle Group P a 4 lt a Nano a nia The Command 5 4 Ng Pa ak aY a E ai x SC The Ship Statistics ca PABA fixo E i A 2 m Public Affairs History Crew Support Namesake Photo Gallery Mission Accessibility Carrier Qualifications What
25. age in North Carolina where the Wright brothers made the world s first airplane flight 17 December 1903 D CVA 63 dp 60 000 1 1 047 6 b 129 4 ea 252 s 35k cpl 4 582 a Ter mis cl Kitty Hawk The second Kitty Hawk CV amp 65 was laid down by the New York Ship Building Corp Camden N J 27 December 1956 and launched 21 May 1960 sponsored by Mrs Neil H McElroy and commissioned 21 April 1961 at Philadelphia Naval Shipyard Captain William F Bringle in command Following shakedown in the Western Atlantic Kitty Hawk departed Norfolk 11 August 1961 After a brief stop at Rio de Janeiro where she embarked the Secretary of the Brazilian Navy for a demonstration of exercises at sea with five Brazilian destroyers the attack carrier rounded Cape Horn 1 October She steamed into Valparaiso Bay 13 October and then sailed 2 days later for Peru arriving Callao 20 October where she entertained the President of Peru t San Diego Admiral George W Anderson Chief of Naval Operations landed on her deck 18 November to witness antisubmarine demonstrations by Wilson and Blueback a Terrier Missile demonstration by Topeka and air demonstrations by Kitty Hawk Kitty Hawk entered San Francisco Naval Shipyard 23 November 1961 for alterations Following operations out of San Diego she sailed from San Francisco 13 September 1962 Kitty Hawk joined the 7th Fleet 7 October 1962 relieving Midway as flagship an og yg ys m A taco XIT
26. al Fleet Auxiliary Force Program the Special Mission Program the Prepositioning Force Program and the Sealift Program The organization for MARAD ships is based on the structure of the NDRF in terms of RRF Custody Retention and Non Reten tion programs discussed in 6 NVR also defined its ship status organization as shown in the list in figure 5 That list includes ten Navy life cycle groups four groups related to MSC business programs and one group for MSC contract operated ships one group for ships in MARAD custody and one Spe cial Miscellaneous group that consists of an assortment of MARAD and MSC ships 41 Figure 26 Status of Ships organization from the NVR E Status of Ships Microsoft Internet Explorer C10 xl File Edit View Favorites Tools Help Adobe Y f I search web to Qmai HBBak gt A searh Favorites meda lt 4 Er 5 Bel 5 Address ja http www nvr navy mil nvrships STATUS HTM y Go FS Status of Ships Each ship listed in the NVR has been categorized into a specific status grouping These status groups identify where a particular ship is in its life cycle and the date it attained that status Select a specific group for the definition of the status category or select Ship Status Summaries for listings of ships assigned a particular status Definitions US Havy Ships Authorized Inactive Under Construction Leased Active Loan
27. bat DB el Abee ANH Mao DD Arial 0 B 7z UlE BE ez EE nA N55 4 4 B E D Count of Ship Name USN Authorized Authorized for US Navy construction AKE NO NAME AKE Total DDG DEWEY NO NAME SAMPSON STERETT TRUXTUN UNG Total LPD NEW YORK PO Total SSN NEW HAMPSHIRE NEW MEXICO NO NAME SSN Total Authorized for US Navy construction Total USN Under construction Under construction in US by Navy unassigned to fleet AKE LEWIS AND CLARK NO NAME SACAGAWEA AKE Total CYN GEORGE H W BUSH CYN Total DDG BAINBRIDGE FARRAGUT FORREST SHERMAN GRIDLEY KIDD DOG Total MAKIN ISLAND LHD Total LPD GREEN BAY MESA YERDE NEW ORLEANS SAN ANTONIO LPD Total SSN HAWAII NORTH CAROLINA TEXAS SSN Total Under construction in US by Navy unassigned to fleet Total USN Active In commission In service O Grand Total as 5 1 7 1 1 1 A Y EN l A 1 E A II EN 1 Y 24 m ki Active in commission M lid A KH DataTableOrigmal DataTableCopy PivotTable EN 32 Query sheets with a double click The pivot table has yet another feature for rapidly querying the database By double clicking on any cell in column M you can produce a query report on a new separate worksheet for those units being counted in that cell Excel will automatically name and number the query sheet To return to the pivot
28. ble Pivot table showing SASDT Ship Battle Force unhiddetb iaa Ee paesi us View of DataTableCopy with Autofilter tosoled On a ioa adora ecd end eir d d era ag od Autofilter drop down menu showing Custom Autofilter option selected Custom filter set to find aircraft carriers Portion of database filtered for aircraft carriers Status of Ships organization from the NVR Status organization for Integrated Ship Database prottable att al dd List of tables Table 1 Table 2 Fields from NVR data Database composition 63 Distribution list OPNAV DEPUTY CHIEF OF NAVAL OPERATIONS FOR INFORMATION PLANS AND SECURITY N3N5B RADM Doug Crowder INFORMATION PLANS AND SECURITY DIVISION N3IPS RDML Harry Harris N3IPSB CAPT Joe Harriss PLANS AND FORCE MANAGEMENT BRANCH N3OP CAPT Marty Simon N3OP4 CDR Russ Haas N3OPNHC Mr Mike McDaniel AUGMENTATION BRANCH N3AUG CAPT Kathy Isgrig ANTI TERRORISM FORCE PROTECTION BRANCH N3AT CAPT Tim Sprague NAVY OPERATIONS CENTER N3NOC CAPT Vince Drouillard N3NOCS8 LT Joe Zummo 3 copies N3NOG38 Mr David Hinckley OCEAN SYSTEMS amp NUCLEAR MATTERS N3ON CAPT Rick Kitchens SPECIAL PROJECTS DIVISION DEEP BLUE DBL3 Dr Jeff Chilton CNA STRATEGY AND POLICY DIVISION N5SPCNA Mr Peter Swartz 65 66 INTERNATIONAL SECURITY STRATEGY BRANCH N5ISCNA Mr Pat Roth DEPUTY CHIEF OF NAVAL OPERATIONS FOR MATER
29. ct friendly forces and engage in sustained independent operations in war Features The aircraft carrier continues to be the centerpiece of the forces necessary for forward presence Whenever there has been a crisis the first question has been Where are the carriers Carriers support and operate aircraft that engage in attacks on airborne afloat and ashore targets that threaten free use of the sea and engage in sustained onerations in einnort of ather forres Aircraft carriers are deployed worldwide in support of U S interests and commitments They can respond to global crises in ways ranging from peacetime presence to full scale war Together with their on board air wings the carriers have vital roles across the full spectrum of conflict The Mmitz class carriers eight operational and two under construction are the largest warships in the world USS Nimitz CVN 68 was the first to undergo its initial refueling during a 33 month Refueling Complex Overhaul at Newport News Shipbuilding in Newport News Va in 1998 The next generation of carrier CVN 21 the hull number will be CVN 78 is programmed to start construction in 2007 and is slated to be placed in commission in 2014 to replace USS Enterprise CVN 65 which will be over its 50 year mark CVN 79 is programmed to begin construction in 2012 and to be placed in commission in 2018 replacing USS John F Kennedy CV 67 in her 50th year Point of Contact Public Affairs Office Naval Se
30. d repossessed by the Navy contract terminated to be resold e Donation Historic Memorial Stricken on donation hold as a museum and memorial Stricken retained by Navy as museum Stricken available for donation as a museum and or memorial Stricken on 08 20 1994 moved from donation hold status to dis posal as an experimental ship and then returned to donation hold status again e Experimental Target Stricken to be disposed of in support of Fleet training exercise e Transfer to other government agencies etc 5 The lists of Level 3 status descriptions for Stricken and Disposal are quite long We grouped them as shown here as an aid to understanding Stricken to be disposed of by transfer to government agencies activ ities foreign countries not SAP MARAD Sea Scouts etc e Retain Stricken to be disposed of retain as logistics support asset Stricken to be disposed of retain as submarine moored training ship Other Stricken Stricken to be disposed of type of disposal not known Disposed Navy assets must first be stricken from the Naval Vessel Register before they can be disposed of Once stricken their disposi tion can be by several methods Scrapping Transfer to MARAD For eign Transfer Experimental Target Donation Historic Memorial Transfer to Other Government Non Government Agencies and Navy Sale e Scrapping Recycling Disposed of sold
31. d to fleet unassigned to fleet unassigned to fleet unassigned to fleet unassigned to fleet unassigned to fleet unassigned to fleet unassigned to fleet y unassigned to fleet unassigned to fleet unassigned to fleet 31611938 316119938 3 6 1998 DDG 51 DDG 51 DDG 51 12612001 CYN 68 0 LPD f 31611998 9 30 1998 31611998 10 18 2001 4119 2002 2115 2000 1142511998 7612002 9 30 1998 1211711996 DDG 51 SSN 774 DDG 51 AKE1 LHD 1 LPD t LPD t AKE1 SSN 774 LPD 1 unassigned GREEN BAY LPD 20 LPD Under cons n in US by Navy unassigned to fleet 5151200 USNS Lewis And Clark Sheet GE Figure 21 Pivot table showing SASDT Ship Battle Force unhidden Ed Microsoft Excel Integrated Ship Database Sep05 xls Oj xl File Edit View Insert Format Tools Data Window Help Acrobat OSHA 6RY BAS e addi A Aims E Arial mio B I UE 3 M32 s See Ea 3 CountofShipName SASDT For v Force x Ea Ship Battle Forces Local Defense and Misc Support Forces 5 Status Categor v Status Type Ship Mai Battle Force Strategic Force Support Force Mobilization Cat A Strategic Sealift amp usiliary Mobilization Cat B blank 6 USN Authorized Zeie ee AA 7 USN Under construction _____________ AP ff 8 USN ActiveIncommission Inservice ad td amp JW
32. e identify and characterize the fields and records contained within it We briefly describe the data in each field and summarize the make up of the 2 510 records in the database We also amplify on the information available in the fields through hyperlinks to the NVR CHINFO MSC NHC and MARAD on line databases In the next section we discuss how to use the standard database oper ations of Excel to query the database Specifically we consider the associated pivot table worksheet and Excel s autofilter function To illustrate we provide snapshots as examples of these functions The Integrated Ship Database file File structure This CNA Interactive Software product consists of two pieces 1 this documentation and 2 a Microsoft Excel workbook Integrated Ship Database_Sep05 xls yA In this section we describe the basic structure of the file as well as access to and protection of the data The Excel workbook consists of three worksheets The sheet named DataTableOriginal contains the fields and records of the Integrated Ship Database The second sheet named DataTableCopy is a blank sheet we inserted that enables you to use all of Excel s analysis features while protecting the data in DataTableOriginal The third sheet called Pivot Table can be used for rapid analysis and querying of the database Data access and protection We have protected the data in the file by making it a password pro tected read only file That
33. etention as a mobilization asset or for pending disposal Inactive Out of Commission in reserve Inactive out of service in reserve Inactive reinstated in the Naval Vessel Register in reserve out of Commission Leased A ship or service craft that has been inactivated and leased to a foreign government for a specified period of time with title retained by the US Navy Leased not SAP SAP loaned or leased SAP grant aid Loan A ship or service craft owned by the US Navy and loaned to contractors or scientific institutions Loaned not SAP loan was renewed on date shown in Status Date Loaned not SAP loan was effective renewed on date shown in Status Date Loaned indefinitely and carried in the Ship Donation Program as a Museum and Memorial 45 46 Stricken A ship or service craft formally removed from the Naval Vessel Register by SECNAV on recommendation of CNO A legal preliminary to disposal e Scrapping Recycling Stricken to be disposed of by submarine recycling Stricken to be disposed of by scrapping Stricken to be disposed of by recycling Navy Sale Stricken to be disposed of by the Security Assistance Program SAP for cash sale Stricken sold but Contractor defaulted repossessed by the Navy contract terminated Stricken to be disposed of by Navy sale Stricken sold but Contractor defaulte
34. g fields Figure 3 NVR ship web page for USS John C Stennis CVN 74 Figure 4 NVR SHIPS web page Figure 5 NVR status groups oco ot gne eoe ten os Figure 6 List of units in Active status category Figure 7 Fields with hyperlinks Figure 8 Portion of Navy Fact File page for amcraft Carriers eee SAS AS NA Figure 9 Web page for USS Abraham Lincoln Figure 10 MSC Ship Inventory page for USNS Arctic Figure 11 MARAD PMARS page for Neosho Figure 12 DANFS page for USS Kitty Hawk CV 63 Figure 13 NVR homeport page for ships in Yokosuka Japala e y ito yg Figure 14 Opening view of pivot table Figure 15 Example of an ungrouped view at the Stats level aunar ae xd e PAA 10 11 12 16 17 18 19 20 21 22 26 27 61 62 Figure 16 Figure 17 Figure 18 Figure 19 Figure 20 Figure 21 Figure 22 Figure 23 Figure 24 Figure 25 Figure 26 Figure 27 View with Status and Type fields under USN Under construction Status Category View with Status Type and Ship Name fields opened under USN Under construction Hide Detail and Show Detail control of pivot tables displays erg Ee At ek ere 99 A a WG ee Completely open Status Category Status Type and Ship Name fields Query sheet generated from the pivot ta
35. go Project Office The Dry Cargo Project Office handles all Department of Defense cargo requirements that cannot be accom modated by regularly scheduled ocean liner service Nearly all peace time DOD cargo is shipped via U S flagged contracted or government owned ships During a military contingency additional vessels may be chartered to expand sealift capabilities to meet addi tional demand MSC s dry cargo ships carry engineering and con struction equipment military vehicles helicopters ammunition and supplies Surge Project Office The Surge Project Office manages strategic sealift ships that can be activated from reduced operating status to support the U S military in exercises contingencies and war Ready Reserve Force ships are owned and maintained by the U S Department of Transportation s Maritime Administration at strategic locations around the U S coasts near Army loading ports Normally kept in four five 10 or 20 day reduced operating status the 59 militarily useful ships come under MSC control when activated Ships may be 9 Inthe absence of a description of MSC s Sealift program in the NVR we used this description from the MSC web site activated for humanitarian operations military exercises and contin gencies and for war Military Sealift Command MSC Sealift Program Military Sealift Command MSC Cargo Fast Sealift Ships FSS Sealift Program Military Sealift Command MSC
36. grams and present the associated Level 3 status titles in italics Naval Fleet Auxiliary Force The NFAF provides direct support for Navy combatant ships allowing them to remain at sea for extended periods of time These ships perform underway replenishment services for Navy battle groups and deliver food fuel spare parts and ammunition Some NFAF ships provide ocean towing and salvage services NFAF ships are crewed by civil service mariners and each ship carries Navy departments ranging in size from four to forty five people Civilian crews operate the ships and perform underway replenish ment and provide other logistics services to the fleet Military person nel provide communications support coordinate supply operations 49 50 and conduct military helicopter operations In addition to logistics operations the NFAF has two hospital ships USNS Mercy AH 19 and USNS Comfort AH 20 designed to provide emergency on site medi cal care for our US forces in a war or contingency These two ships are maintained in an Reduced Operating Status ROS but can be fully operational crewed and ready for deployment within five days with 1 200 active duty medical personnel and 70 civil service mariners Military Sealift Command MSC Naval Fleet Auxiliary Force Reactivated and assigned to the Military Sealift Command MSC Naval Fleet Auxiliary Force Special Mission Program Ships of this type are both U S govern me
37. i to MARAD Other Level 3 Detailed NVR MSC Detailed NVR Status Detailed NVR MSC Status MARAD Status a The Level 2 structure under USN is actually used in PivotTable The Level 2 structures under MSC and MARAD are not explicit in PivotTable but are notional This is the reason for their lighter appearance Our structure comprises three levels at least conceptually The top level distinguishes records by custodian Navy MSC or MARAD The lowest level is the detailed status description in the source database For the records from the NVR we used the specific NVR status For the MSC records not in the NVR we assigned one of the NVR status descriptions based on program descriptions in the MSC Ship Inventory 43 U S Navy 44 system For MARAD ships not in the NVR we assigned the status MARAD NDRE Not in NVR The MARAD NDRF Program Type Status field elaborates further on these records The middle level is less straightforward The Level 2 structure under USN is the life cycle structure We use these states explicitly in the Status Category grouping in Pivot Table The Level 2 structures under MSC and MARAD do not explicit appear in PivotTable They are conceptually reasonable however in that they underlie the detailed status descriptions in the NVR and are consistent with the several higher level depictions of NVR status cate gories In the following sections we present NVR defini
38. ily extract data for several fields To get to the Status of Ships display use the link on the SHIPS page ofthe NVR site figure 4 Each status group title in Status of Ships figure 5 links to a page like the one shown in figure 6 with information from the following fields Ship Class Hull No Ship Name Unit Identification Code UIC and Homeport Transferring these data to Excel involved a simple cut and paste followed by text to column parsing into distinct fields Figure 1 Opening view of the database Ed Microsoft Excel Integrated Ship Database_Sep05 xls BI File Edit View Insert Format Tools Data Window Help Acrobat 81 xl jn ualSmav reeso ceres 8 EH 10 a I ig 906 g Fields Ee cr Ee Tupe Date Status Class sp Changed NFF Link NONGME tp ib 84 Authorized or US Navy construction eee Noa na ARES fake 23195 Authorized for US Navy construction 4 Noname O kes Jae 2 6 Authorized for US Nau constuction o e a R 1 L 3 5 NONAME gt faer KE 28187 AuthoedforUSNawconsmuc on lt f maws fakes 6 Noname gt 23198 Authorized for US Navy construeti n mezos JAKE JO 7 SAMPSON O 23161 Authorized forUS Navy construction f 8 3
39. in figure 5 Table 2 summarizes the composition of the database by these status groups 3 All but 96 of the records came from the NVR Of those 96 records 86 came from MARAD s PMARS database and 10 came from the MSC Ship Inventory 22 For a more in depth breakout please refer to the PivotTable work sheet in the Excel file There you will be able to see the composition by the specific status descriptions in the NVR We also refer you to the appendix for a detailed discussion of ship status categorization Table 2 Database composition Category No of records U S Navy Ships 1 933 Authorized 23 Under Construction 17 Active 244 Naval Reserve Force Active 23 Stand down 1 Inactive In reserve 20 Inactive Leased loan or grant 14 Inactive To be disposed of 8 Stricken 72 Disposed 1 510 Other 1 Military Sealift Command 117 Naval Fleet Auxiliary Force 35 Special Mission Support 24 Prepositioning Program 30 Sealift Program 28 Maritime Administration 460 RRF Prepositioning Program 5 RRF Sealift Program 54 NDRF Retention for mobilization 49 NDRF Non retention 141 NDRF Custody for Navy 1 12 Disposed by MARAD 210 TOTAL 2 510 a Includes disposal of ships that spent a portion of their lifetime under custody of MSC b Integrity AGOS 24 Hull number assigned authorized to be built but never awarded authorization cancelled c Of the 12 ships in the NDRF under MARAD custody for the Navy
40. ioning and Sealift ships The MSC Ship Inventory web site does distinguish between these two programs As a matter of informa tion and convenience we have appended the program name in brack ets to the NVR status description 8 We found some ships in the MSC Ship Inventory that were not in the NVR We added them to the database for completeness For these ships we chose the descriptive status title shown here 51 52 sealift requirements in peace contingency and war with quality efficient cost effective assets and centralized management Sealift is divided into three separate project offices Tanker Project Office Dry Cargo Project Office and the Surge Project Office Tanker Project Office MSC s Tanker Project Office works closely with the Defense Energy Support Center to transport petroleum products to DoD storage and distribution facilities around the world The gov ernment owned tankers and one of the long term chartered ships are capable of conducting underway replenishment with Navy fleet oilers to provide additional logistics support to the fleet in time of need In addition to the primary mission of providing transportation of fuel for the DESC MSC s chartered tankers perform unique missions such as refueling the National Science Foundation s McMurdo Sta tion in Antarctica as well as fuel for the Thule Air Base in Greenland MSC also operates a shallow draft shuttle tanker between Korea and Japan Dry Car
41. is you must open it as read only you cannot use the password option to obtain access We hold the pass word in order to maintain the integrity of the original source file and to control updating and modification of the data The read only file attribute will allow you to manipulate the data but you won t be able to save the file under its original name To save your working version you must rename the file 1 The data in the database is current as of September 2005 Our intention is to update the database quarterly In the meantime the hyperlinks in the database can be used to access data currently available online To access the data simply open the Excel file Select Read Only when asked for a password The file will open displaying the top most records of the database in the DataTableOriginal worksheet As we mentioned DataTableOriginalis password protected If you only want to search the data use the hyperlinks and explore the database with PivotTable you won t need to take any further steps However Microsoft Excel restricts the sorting and filtering features in a protected worksheet If you wish to sort and filter the database you ll need to copy the data from DataTableOriginal into DataTable Copy Protecting the data in this way not only gives us control over the data but also maintains the original data as a reference in any file that you might modify for your purposes 2 Although we could
42. lale MIN DataTableOriginal DataTableCopy PivotTable lal El e o 2 Si g v 4 DN e 2 a E zl No o lz y nla sin amp e rm Ka 7 1 0 12 K l 30 Figure 18 Hide Detail and Show Detail control of pivot table display Ed Microsoft Excel Integrated Ship Database_Sep05 xls NG File Edit View Insert Format Tools Data Window Help Acrobat Do gR v mme A zip E gt Arial DONANTE E 9 4 gt AS Status Category Eg er Gf aay SSS ES SS Ses 1 E i Grand Total 5 JStatusCategoy wilStanis Tue ShipName v Ce USN Authorized px s z 7 USN Under construction m D f 8 USN Active In commission H Format Report 0 9 USR Naval Reserve Force 4 pivotChart E 10 USN Stand down 1 11 USN Inactive Hide EA 12 USN Stricken _ EA 13 USNIMSC Disposed 3 us P8510 ARNET Wizard SRA t5 msc f Refresh Data LE 16 MARAD _ L o 7 Grand Total Select EK T mol Group and Outline gt Hide Detail Formulas b Show Detail Order D Group EZ Ungroup H 4 E H DataTableorigi 3 Field Settings Draw Te 5 Autosha _ Table Options FG Show Pages e Ready 31 Figure 19 Completely open Status Category Status Type and Ship Name fields Ed Microsoft Excel Integrated Ship Database Sep05 xls File Edit Yiew Insert Format Tools Data Window Help Acro
43. ld be even more useful if it were available in such form To facilitate rapid access to other sources of ship data on the Internet we inserted hyperlinks to the U S Navy Chief of Information CHINFO United States Navy Fact File 2 the Military Sealift Com mand MSC Ship Inventory web site 3 the Naval Historical Center NHO Dictionary of American Naval Fighting Shibs DANFS 4 and the U S Department of Transportation Maritime Administration MARAD Property Management amp Archive Record System PMARS 5 In addition we have drawn on National Defense Reserve Fleet NDRF ship inventory that is available on MARAD s web site 6 We hope that this database will be useful to decision makers staff officers and watch standers in Navy and MSC operations centers as well as to naval operations analysts We especially hope that new ana lysts both now and in the future will find the database particularly useful as they learn how naval vessels are identified and classified and where to find information about ships It is to these analysts that we dedicate this product Organization of the paper This memorandum describes the Microsoft Excel ship database work book which contains the database and an associated pivot table The pivot table summarizes the content of the database and serves as a mechanism for quick automated queries of the database After a brief introduction to the database we describe its structure W
44. med MARAD NDRF Program Type Status The information in the field in the program type and status description is as presented in the monthly NDRF inventory report 6 We did not include the data for the numerous other ships in the PMARS data that are not in the 2 This field reports the Battle Forces Category used in the Ships and Air craft Data Supplemental Table SASDT of the Navy s budget reporting system One major grouping Ship Battle Forces comprises Battle Forces Mobilization Forces Category A Assets Strategic Forces and Support Forces The second major grouping Local Defense and Miscellaneous Support Forces includes Strategic Sealift Forces Auxiliary Ships and Mobilization Force Cat egory B Assets 13 14 NDRY specifically those in the Disposed category of USN and MSC ships NHC Dictionary of American Naval Fighting Ships The field DANFS Link contains the name of the ship as it appears in the DANFS The ship history information is accessed through hyper links Fields with hyperlinks In figure 7 we show the fields in the database that contain the hyper links To activate a link simply click once on the hypertext in a cell defined by the particular ship record and link destination of interest The fields with hyperlinks include the following The Hull No field contains the links to the NVR pages for indi vidual ships For example figure 3 is the NVR page for USS John C Stennis
45. n System Property Management amp Archive Record System Petroleum oil amp lubricants Prepositioned prepositioning Roll on Roll off Reduced operating status Ready Reserve Force Security Assistance Program Ships and Aircraft Supplemental Data Tables Suisan Bay Reserve Fleet Secretary of the Navy Special Mission Ship Unit Identification Code References 1 2 3 4 5 6 NVR Naval Vessel Register The Official Inventory of US Naval Ships and Service Craft Naval Sea Systems Command NAVSEA Shipbuilding Support Office NAVSHIPSO Sep 2005 http www nvr navy mil United States Navy Fact File U S Navy Chief of Information Sep 2005 http www navy mil navydata fact asp MSC Ship Inventory Military Sealift Command Sep 2005 http www msc navy mil inventory Dictionary of American Naval Fighting Ships Naval Historical Center Sep 2005 http www history navy mil danfs PMARS Property Management E Archive Record System U S Department of Transportation Maritime Administration Sep 2005 http www pmars imsg com National Defense Reserve Fleet Inventory For the month ending August 31 2005 U S Department of Transportation Mari time Administration Sep 2005 http www marad dot gov Offices Ship Current Inventory pdf 59 This page intentionally left blank List of figures Figure 1 Opening view of the database Figure 2 View of the remainin
46. ng Show Detail will unhide the next lower level of the pivot table for all Status Category cells Figure 19 displays the uppermost portion of a pivot table with these fields open 4 Warning With this approach you will see a Hide command on the menu when you right click If you select it you will remove that variable from the pivot table There is no Unhide command to reinsert it You ll have to use the pivot table controls to reinsert If you don t know how to do this either consider it a learning opportunity or find some one who can help you Alternatively you can close the file without saving and reopen it to restore it to the original condition 29 Figure 17 View with Status Type and Ship Name fields opened under USN Under construc tion i E4 Microsoft Excel Integrated Ship Database Sep05 xls O xi SI File Edit View Insert Format Tools Data Window Help Acrobat lel xi DRAR BBS eA A Al D Aral 70 BLU FESSH 8 7 8 Type Under construction in US by Navy unassigned to fleet LEWIS 4ND CLARK NO NAME SACAGAWEA YN GEORGE H W BUSH CYN Total BAINBRIDGE FARRAGUT FORREST SHERMAN GRIDLEY KIDD DDG Total HD MAKIN ISLAND HD Total Oj A m 4 o pi GREEN BAY MESA VERDE NEW ORLEANS SAM ANTONIO FD Total SSN HAWAII NORTH CAROLINA TEXAS 31 Under construction in US by Navy unassigned to fleet Total 35 USN Inactive 36 USN Stricken 41 Grand Total M
47. nt owned and chartered vessels and are operated by civil service mariners or mariners employed by companies under contract to MSC Military and civilian scientists and technicians carry out unique missions on various types of ships SMSs provide highly specialized support services for their customers and often work in some of the most remote areas in the world Some of SMSs missions are oceanographic surveys missile tracking coastal surveys cable laying and repair submarine escort deep submergence rescue support and other Navy operations Military Sealift Command MSC Special Mission Support Prepositioning Program The Military Sealift Command MSC has operational control of MSC chartered commercial ships and MARAD Ready Reserve Force RRF ships stationed at Diego Garcia and Guam Saipan for the support of U S Army Air Force and Navy Requirements Army Prepositioning Afloat APA Currently there are 12 Army PREPO ships deployed to USCINCPAC AOR as part of the Afloat Preposition ing Force APF These ships carry Army War Reserve Stocks No 3 AWR 3 cargo and consist of seven RO ROs carrying Army unit equipment One Auxiliary Crane Ship ACS three LASH ships car rying ammunition rations and other non ammunition cargo and 6 SMS Special Mission Ship one Flo Flo Semisubmersible ship which carries Army port support equipment AWR 3 ships carry a US Army Brigade Afloat along with Combat Service Su
48. o the rolled up total of 117 records at the top of the open section Double clicking a second time in the same location will re hide the cells just unhidden Figure 16 has a view of the Status and Type fields unhidden under the Status Category USN Under Construction In this view you can see 25 Figure 14 Opening view of pivot table Ed Microsoft Excel Integrated Ship Database Sep05 xls mfe x File Edit Yiew Insert Format Tools Data Window Help Acrobat i81 x KT TS AE WH EES E fe 21 a DI Arial 10 B T UE Hs 96 y e 48 A A Grand Total KS ee 7 USN Under construction ll mj 8 USI Active IncommissionfInservice OY 9 USN Naval Reserve Force Active 10 USN Stand down USN Inactive e USN Strieken l7 A _ _ USN Other Cd i MARAD Y e AR Grand Tata Y so an HA EH DataTableOriginal f DataTableCopy PivotTable la EM 26 L6 Figure 15 Example of an ungrouped view at the Status level Grand Total 5 Bona TMNT f USMUnderconsetion A HI 8 US Active In commission In service et 9 USN NavalReserveForce Active pto USN Stand down O S LI USN Inactive HI METE EI am EN wu ooo Iy SUS E a aa iar Sea Command ASE Neva Fe Rain Fase EEE Reactivated and assigned to the Military Sealift Command MSC Naval Fleet Auxiliary Foree Y Military Sealift Command MSC Special Mission Support A Military
49. pport and Humanitarian Assistance cargo Eventu ally constructed or converted Large Medium Speed RO ROs LMSR will replace the RRF ships supporting the APA program US Air Force USAF Sponsored PREPO Ships Two PREPO ships one LASH and one breakbulk carry USAF munitions US Navy USN Sponsored PREPO Ships One heavy lift breakbulk ship carries a 500 bed combat tactical zone US Navy fleet hospital This cargo is stored in ISO units within controlled temperature humidity limits Defense Fuel Supply Center DFSC There are three PREPO tankers car rying petroleum POL products for use by service components as part of the prepositioned war reserve program of the DFSC Two of these tankers are equipped with Offshore Petroleum Discharge System OPDS and are capable of in stream discharge of POL The third PREPO tanker is the USNS Henry J Kaiser T AO 187 and is capable of console operations with additional manning and rig acti vation Military Sealift Command MSC in service contract operated Prepositioning Program 7 Special chartered by MSC listed here as part of the U S Navy Ship Battle Forces Prepositioning Program Military Sealift Command MSC Prepositioning Program S Sealift Program The mission of the Sealift Program is to provide ocean transportation to the Department of Defense by meeting its 7 The status title in the NVR does not indicate the specific MSC program for Preposit
50. rized for US Navy construction o 92002 ppas 17 3109 55685 Authorized for US Nawy construction Oo f3200o2 poa5 Iopem ooa 55686 Authorized for US Navy construction sn32000 poast 16 NONAME fpoaw Jopoa s5687 iAuthorized forUs Nawy construction 1 3200 NONAME JL fooaw ooa Je Authorized forUSMawyconstructi n o o 9mx202 pos enz ro AwhenzedforUSNawconsruction e mnoec2 enr 19 NEWHAMPSHIRE ssu772 SSN 2382 Authorized for US Mavy construction s8ne2003 SITS 20 mewmexco 1 ssuzs ssN 23983 AuthorzedforUSNawconstucion o Z 8nuo03 ssuz 3 momame o ssuzo ssu 20002 jAuthorized for US Navy construction 842000 iSSN774 NONAME 1 O O Leave ssu 20079 Authorized for US Mavy construction Z o Z o o ammos issuzz L NONAME 1 O Z o ssruzez een 20080 _ Authorized for US Mavy construction Z o o amos isaya 24 Noname OY ssuze ssm 20034 Authorized for US Navy construction SSN 774 Figure 23 Autofilter drop down menu showing Custom Autofilter option selected El Microsoft Excel Integrated Ship Database_Sep05 xls E B lel x
51. rs It is shown in figure 24 Here we ve entered begins with and CV to select all records for aircraft carriers Figure 25 shows a partial list of the records selected Le Figure 22 View of DataTableCopy with Autofilter toggled on El Microsoft Excel Integrated Ship Database Sep05 xls E laj x In Edt wew Insert Format Tools Data Window Help Acrobat la x DBS el A B is lla a 41 2L 48 75 Tan Filter Wd Y AutoFilter u n MEC 3 Advanced Filter Ship Narr Y Refresh Data 23194 AP v qp Authorized for US Navy construction meizo0o3 Leg 23195 Authorized for US Mavy construction 2222222 arc 23196 Authorized for US Nau construction OOo emos AKE li 23197 Authorized for US Nawy construction o iio2005 JEE 23198 Authorized for US Nawy construction 22005 iAKE 23160 Authorized for US Navy construction 132002 DDG5 23165 Authorized forUSNavyconstruction YO 392000 is 23166 Authorized for US Nawy construction OoOo aooe SHG 23162 Authorized for US Nawy construction 39200 SGC 23163 fAuthorzed forUS Nawy construction 1 OOo aaoo TG 23164 Authorized for US Nawy construction 1 OOo aaoo STG 55684 Autho
52. s New T What s New ONLINE This is an official Navy web site Everything on this site has been approved by the PAO Privacy Policy Freedom of Information Act Last Updated Marc t This page best viewed at 1024x768 dpi Problems E mail the Webmaster 4D Internet Figure 10 MSC Ship Inventory page for USNS Arctic e Ship Inventory USNS ARCTIC T AOE 8 Fast Combat Support Ship USNS Arctic is one of Military Sealift Command s four Fast Combat Support Ships and is part of the 37 ships in the Naval Fleet 754 feet 107 feet 38 feet 48 500 long tons 25 knots Click on image at left for larger picture Return to ship inventory main page Glossary of Terms Military Sealift Command ATTN Public Affairs 914 Charles Morris Ct SE Washington Navy Yard DC 20398 5540 General Information 1 888 SEALIFT Marine Employment Opportunities 1 877 JOBS MSC Email webmaster msc navy mil 19 Figure 11 MARAD PMARS page for Neosho 20 Home Ships Artifacts PMARS MARAD Other Custody CARDS Disposal CARDS Front of Card 1 Back of Card 1 No Image Basic Ship Data History Data Current Status Data Artifact Data Basic Ship Data ACTIVE SHIP Ship Name Other Names Year Built Sister Ship s Neosho NN Official No Marad Hull No Class Gross Tonnage Net Tonnage CargoCapacity MastHeight Length Beam Summer Draft Summer Displacement Summer Deadweight Summer Immersion Ligh
53. scriptions of these ships which include Disposed of by MARAD sale Disposed of by MARAD exchange Disposed of by Navy title transfer to the Maritime Administration Disposed of by transfer to Maritime Administration NDRF for mobilization The flow diagram under MARAD Level 2 in figure 27 depicts the rela tionship of these disposal categories as suggested by 5 and 6 55 This page intentionally left blank Glossary BRF CHINFO CIS CNO DANFS DESC DFSC DRMS FAA FSS GSA ISO JRRF LASH LMSR Area of responsibility Army Prepositioning Afloat Afloat Prepositioning Force Beaumont Reserve Fleet Chief of Information CNA Interactive Software Chief of Naval Operations Dictionary of American Naval Fighting Ships Defense Energy Support Center Defense Fuel Supply Center Defense Reutilization and Marketing Service Foreign Assistance Act Fast Sealift Ship General Services Administration International Organization for Standardization James River Reserve Fleet Lighter Aboard Ship Large Medium Speed RO RO Maritime Administration 57 MSC NDRF NFAF NFF NHC NREA NVR OPDS PMARS POL PREPO RO RO ROS RRF SAP SASDT SBRF SECNAV SMS UIC 58 Military Sealift Command National Defense Reserve Fleet Naval Fleet Auxiliary Force Navy Fact File Naval Historical Center Naval Reserve Force Active Naval Vessel Register Offshore Petroleum Distributio
54. taTableOriginal PivotTable 6 Figure 24 Custom filter set to find aircraft carriers E3 Microsoft Excel Integrated Ship Database Sep05 xls 18 x 6 File Edit View Insert Format Tools Data Window Help Acrobat Dec lam BBS o o Qz 1303 Mam E fueren fica me zm 23194 Authorized for US Nawy construetion O mew Le xu JAKES CAKE 23095 Authorized for US Navy construction PAAR L amp urhorisad kar IS Mam eanctriction 12742004 TAKE E Custom AutoFilter i wi2005 AKE 1242005 AKEs Show rows where Type begins with y cv y and Use to represent any single character EM NEW YORK a LPD Use to represent any series of characters 12H0 2002 E 19 NEvHAMPSHRE ssuzz L ae E T 8n4m2003 Figure 25 Portion of database filtered for aircraft carriers El Microsoft Excel Integrated Ship Database_Sep05 xls 0 xi File Edit view Insert Format Tools Data Window Help Acrobat j OsH ea SRY pe r rw salam D Sens dame Ship Hame A RR a ESE jcvuz cvw 2300 Under construction in US by Navy unassigned to fleet waerzo JH Damon us ness ov CCT HA rors exis EEUU NT EN E NN PA ENTERPRISE NIMITZ eves DWIGHT D EISENHOWER A o o E CARL VINSON aY a THEODORE ROOSEVELT em oer ative in commission sis STE ABRAHAM LINCOLN cv Jas Activelincommission Tei cvwes 5 EYN CN GEORGE
55. tions for the status groups in Level 2 and the detailed status descriptions in Level 3 The Level 2 definitions from NVR for USN ships are quoted below The Level 3 specific descriptions in the database are italicized in the bulleted lists under each Level 2 group Authorized Funding has been approved by Act of Congress for new construction or conversion Authorized for US Navy construction Under Construction A contract has been awarded to a builder for new construction or conversion Under construction in US by Navy unassigned to fleet Active A ship or service craft that has been formally accepted by the Navy that is either in service or in commission Active in commission Active in service Naval Reserve Force Active Ships of this category are still commissioned ships They have a reduced or skeletonized crew of active duty personnel assigned to provide training of assigned reservists for limited operations and maintenance Under mobilization reservists assigned to a particular ship will be activated complementing the active duty personnel Naval Reserve Force Active Stand Down Start of the inactivation cycle These hulls are not counted in either the active or inactive fleet counts In Commission in Reserve Stand Down commencement of inac tivation availability Inactive A ship or service craft that has been taken out of commission or out of service for r
56. tus Overall organization hok E E Re OK E Ros NVR s method Our structure aoa e U S Navy Military Se alift Command lr Maritime Administration Glossary References List of figures CO 09 OU Ot gu 14 22 25 25 25 33 33 36 41 41 41 43 49 53 57 59 61 11 List of tables Distribution list Introduction Analytical and information support for Navy decision makers and staff action officers demands easy quick access to reliable informa tion about ships In this CNA Interactive Software CIS product we offer a relatively quick and easy to learn way to find information on naval ships future current and past from authoritative sources on the Internet We present the data in a simple database titled the nte grated Ship Database The database resides in a Microsoft Excel work book Our fundamental data source is the on line Naval Vessel Register NVR The Official Inventory of US Naval Ships and Craft 1 The NVR contains a wealth of information on ships and service craft over the course of a vessel s life cycle Although the on line information is quite useful it is not available in the standard database format of fields and records Therefore it is of only limited use to researchers and others who must search sort query and count We believe the information cou
57. tweight Draft Lightweight Displacement Lightweight Immersion Ship yard Information Ship Yard Ship Yard City Ship Yard State MARAD Design Military Design Specific Type General Type Classification Society Classification ID Historical Data Entry Entry Date Region FleetSite 20 030 7946 SOUTHATLANTIC A Acquisition ACQ Date Method 20 030 946 Reimbursable Customer Ge Previous Owner Remarks AAA VA EA KENNEN Disposition Disposition Date Method New Owner eme UJ a JN qM Remarks o CUSTIS Withdrawal Date A ALII Entry Entry Date Region FleetSite 0082 9922 SOUTHATLANTIC JRF James River VA Acquisition ACQ Date Method Cost 200 82 9922 Reimbursable Customer Previous Owner Remarks EA A I W CONS Ship Event Event Date Event Name Event Document 2000 292005 Departure 7 Event Remarks Figure 12 DANFS page for USS Kitty Hawk CV 63 File Edit View Favorites Tools Help EI Back gt Qo S A Qsearch iFavortes meda A D S R 2 Address http www history navy mil dants k4 kitty hawk ii htm Go Links Adobe Y EZ search web LJ CI Mail my Yahoo Fe Games Personals fi Movies Fb Music sen Return to DANES Index ly y Retum to Naval Historical Center home of American Naval Fighting Ships DEPARTMENT OF THE NAVY NAVAL HISTORICAL CENTER 805 KIDDER BREESE SE WASHINGTON NAVY YARD WASHINGTON DC 20374 5060 Kitty Hawk small vill

User`s Manual - CNA Corporation

Contents

Download Pdf Manuals

Related Search

Related Contents