Computerized Compendium Of Standards
Contents
1. A as 3 lui Final Report Computerized Compendium Of Standards NSRP 0361 Submitted to Maritime Administration through Peterson Builders Inc December 18 1992 Project Director Howard M Bunch Principal Investigators Albert W Horsmon Jr Kurt W Hagemeister The Universitv of Michigan Transportation Research Institute Marine Svstems Division Ann Arbor Michigan 48109 2150 Eden Technical Report Documentation Page 1 Report No 2 Government Accession No 3 Recipient s Catalog No riga December 18 1992 Computerized Compendium of Standards 8 Performing Organization Report No 7 Author s The Marine Systems Division UMTRI 92 31 pte nearer The University of Michigan 11 Contract or Grant No P O 1009 0006 Transportation Research Institute 13 Type of Report and Period Covered 12 Sponsoring Agency Name and Address i Technical Peterson Builders Incorporated 2901 Baxter Road Ann Arbor Michigan 48109 101 Pennsylvania St P O Box 650 14 Sponsoring Agency Code Sturgeon Bay WI 54235 0650 The objective of this project was to develop a compendium of standards international national military and regulatory that have relevance to the U S shipbuilding and repair industry The intended benefits are to provide shipyards with a ready reference to standards that are of use to shipbuilding and to eliminate the development of new standards where acceptable standards exi2. STANDARD TITLE kkkkkkkkkk kkkkkkkkkkkkkkxkkkkkkk Green Bananas Guide to Storage and Transport First Edition ORIGINATION DATE kkkkkkkkkk Development and Evaluation of the OCD API Model Offshore Petroleum Operations on Cold Water Marine Mammals Effects of A Literature Review REGIONAL EXAMINATION CENTERS ADMININSTRATION POLICY FOR THE ISSUANCE OF MERCHANT MARINE LICENSES AND CERTIFICATES 1982 MSD CERTIFICATION 1982 COAST GUARD RETENTION OF 1983 COMMERCIAL VESSEL PLAN REVIEW CASE FILES REGULATIONS FOR VERY LARGE 46 CFR SUBCHAPTER T PASSENGER VESSELS 1983 PILOT TRANSFER ARRANGEMENTS 1991 DETERMINATION OF COLD WATER 1991 AREAS ISSUANCE OF LETTERS OF COMPLIANCE TO FOREIGN DOCUMENTED MOBILE OFFSHORE DRILLING UNITS OPERATION ON THE OUTER CONTINENTAL SHELF OF THE UNITED STATES 1988 Functions and Responsibilities of Warship Procurement and Design Authorities Issue 1 11 82 11 18 82 SEA 0743 TLC PRIVATE SECTOR DEPOT LEVEL AVAILABILITY PLANNING FOR NAVAL SURFACE SHIPS POLICIES PROCEDURES AND RESPONSIBILITIES FOR 08 01 83 05A4 JP NAVAL SEA SUPPORT CENTER ATLANTIC PORTSMOUTH VA AND NAVAL SEA SUPPORT CENTER PACIFIC SAN DIEGO CA MISSION AND FUNCTIONS OF Appendix C 16 Page No 1 REV NO kkk 12 04 92 JRGANIZ NAME KKKKKKK ABS SWBS KKK 074 074 074 074 074 074 074 074 074 074 095 095 100 100 100 100 100 1
3. AVAILABILITY PLANNING FOR NAVAL SURFACE SHIPS POLICIES PROCEDURES AND RESPONSIBILITIES FOR 08 01 83 05A4 JP NAVAL SEA SUPPORT CENTER ATLANTIC PORTSMOUTH VA AND NAVAL SEA SUPPORT CENTER PACIFIC SAN DIEGO CA MISSION AND FUNCTIONS OF 08 25 80 OP 35 FLEET INTRODUCTION PLAN FOR GUIDED MISSILE CRUISER TICONDEROGA CG 47 07 31 90 SPAWAR 003 211 GOVERNMENT FURNISHED EQUIPMENT GFE MANAGEMENT SYSTEM GMS 08 01 90 NIG 00 INFORMATION REQUIREMENTS FOR SEMIANNUAL REPORT TO THE CONGRESS 05 17 89 CHINFO SHIP NAMING CHRISTENINGS AND COMMISSIONINGS 10 22 54 SO 4 RSH MEMORANDUM OF AGREEMENT BETWEEN THE DEPARTMENT OF DEFENSE AND DEPARTMENT OF COMMERCE REVISION DATE kakkkk kkk 01 01 00 01 01 00 01 01 00 Page No 1 REV MOD SUBJECT ENGL ADDITIONAL STA REQ VER STANDARDS xix kkk KRKKKKKKKKK kk kk kk kk kk kk kk No Yes No Yes No Yes Q 3 E No Yes STANDARDS COMPENDIUM LISTING 12 04 92 Sort By Organization Long Version Page No 1 ORGANIZ SWBS STANDARD TITLE OF STANDARD ORIGIN REV REVISION REV MOD SUBJECT ENGL ADDITIONAL NUMBER TYP DATE NO DATE STA REQ VER STANDARDS kkkkkkkxk kkk kakkk amp kkkkkkke TEE EE AKEEF ZE EE AE EE EA kkk xkkkkkxk kk kkkk amp kkkk kk kkk xkkkkkkkkxk kk kek RAKKKKKKK K ABS 074 30 13 WELDING STRUCTURE CLASSIFICATION 5 3 JOINT WELDED WELD HEAT TREATMENTS ABS 074 30 35 RADIOGRAPHY BOILER AND PRESSURE VESSEL 4 3 RADIOGRAPHY PIPE CONNECTION ABS 074 30 37 TEST HYDROSTATIC TEST BO
4. PENDULUM TYPE MARINE SERVICE HEAVY DUTY HOOKS BOAT BALL POINT BERTH BOTTOM DUCK COTTON CLOTH CANVAS BIAS CUT REPAIR EQUIPMENT PLYWOOD BOAT AND PONTON PACKAGING BUOYS SEAPLANE MOORING INTERFERENCE LIMITS AIRBORNE LIFEBOAT GENERAL SPECIFICATION FOR AIRCRAFT EMERGENCY ESCAPE SYSTEM IDENTIFICATION OF SUPERSEDED BY MIL A 25165 OAR METAL SECTIONAL PAD EYES DECK SNUBBING FENDERS MARINE RUBBER FILLED BAG BOAT PADDLE REPAIR KIT ROLL PNEUMATIC FLOAT TOOL DUCK COTTON CLOTH REPAIR KIT INFLATABLE CRAFT FOR BLADDER TYPE OR NONBLADDER TYPE BOATS PACKAGING OF ANCHOR MARINE FLUKED KEDGE TYPE WELDED 100 LB Appendix A Page 1 ABS 01 ABS 02 ABS 03 ABS 04 ABS 05 ABS 06 ABS 07 ABS 08 ABS 09 ABS 10 ABS 11 ABS 12 ABS 13 ABS 14 ABS 15 ABS 16 ABS 17 ABS 18 ABS 19 ABS 20 ABYC AFNOR AMCA ANSI API ASTM BSI Bundesam Standards Compendium andar reanization rces in Data American Bureau of Shipping Rules for Building and Classing Steel Vessels Nondestructive Inspection of Hull Welds Approved Welding Electrodes Wire Flux amp Wire Gas Combinations Offshore Mobile Drilling Units Steel Barges for Offshore Service Bulk Carriers for Service on the Great Lakes River Rules 71 Inert Gas Installations on Vessels Carrving Oil in Bulk Certification of Cargo Containers Manual for Making Bronze Propeller Repairs Repair Welding Cladding amp Straightening of Tail Boilers Burning
5. retrieval from the Standards Compendium is available at moderate cost from UMTRI Requests should be made to the address and phone listed above Making Change Reguests Proposed changes can be made to the Compendium in writing using the form included at the end of this appendix Changes mav take the form of 1 Additions of new standards 2 Changes to one or more fields included in the current version of the Compendium 3 Deletions of standards in the Compendium 4 Changes to the Compendium program and data base structure This would include adding new data fields or different report formats for example All change requests will be reviewed by the Compendium program administrator The main criteria for acceptance will be usefulness to users availability of data and cost The originator will be notified in writing of the decision by the program administrator If a change of general benefit to users involves significantly higher cost than current funding allows the change will be discussed at an SP 6 meeting Appendix C 15 12 04 92 SWBS ORGANIZ NAME kkkk xkkkkkxkx ISO 000 API 000 API 000 CGNVIC 000 CGNVIC 000 CGNVIC 000 CGNVIC 000 CGNVIC 000 CGNVIC 000 CGNVIC 000 DEF 000 DOD 000 DOD STANDARDS COMPENDIUM LISTING STANDARD NO KKKKKKKKKKKK 799 PUBL 441 PUBL 430 14 82 9 82 13 83 11 83 4 91 L 91 3 88 NES 20 NAVSEA 4710 NAVSEA 5450 Short Version By SWBS
6. special request from UMTRI After developing the PC data base file it was necessary to begin importing standards The first major block of data was from the original Compendium However since it was not in a format directly readable by Alpha Four the data base had to be converted into a form that Alpha Four could understand This was done using an optical character reader which could read text into a structured format that a data base program such as Alpha Four can recognize as a data base Once this was done the next major task was to begin adding new standards to the data base The third task was to research existing information sources to find new standards not already in the Compendium In particular an index to international and military shipbuilding related standards needed to be greatly expanded in the new data base Due to the volume of standards being sought the only way to l This task was performed by Frank Darvalics in San Diego CA 5 Computerized Compendium of Standards efficientlv assimilate them into the Standards Compendium was to reference an electronic standards source For this reason the Information Handling Service IHS CD ROM data base was used as a major reference source This is described in the next section of the report In addition the Code of Federal Regulations and miscellaneous other standards sources not available in electronic format were entered manuallv The final task was to produce th
7. 00 000 000 000 000 kkkkk kkk ISO API API CGNVIC CGNVIC CGNVIC CGNVIC CGNVIC CGNVIC CGNVIC DEF S DOD DOD DOD DOD DOD DOD DOD STANDARD NUMBER TTT 799 PUBL 441 PUBL 430 14 82 9 82 13 83 il 83 4 91 7 91 3 88 NES 20 NAVSEA 4710 NAVSEA 5450 OPNAV 4760 1 SPAWAR 4860 SECNAV 7700 SECNAV 5031 SECNAV 5740 STANDARDS COMPENDIUM LISTING Sort By SWBS Long Version TITLE OF STANDARD STD ORIGIN REV TYP DATE NO kakkkkikikkkkkkakkkkkkkkkkkkkkikkkkkkkkkkkkkkkkikkkkkkikkkkik kkk kkk kK kkk kkk Green Bananas Guide to Storage and Transport First Edition Development and Evaluation of the OCD API Model Offshore Petroleum Operations on Cold Water Marine Mammals Effects of A Literature Review REGIONAL EXAMINATION CENTERS ADMININSTRATION POLICY 1982 FOR THE ISSUANCE OF MERCHANT MARINE LICENSES AND CERTIFICATES MSD CERTIFICATION 1982 COAST GUARD RETENTION OF COMMERCIAL VESSEL PLAN REVIEW 1983 CASE FILES REGULATIONS FOR VERY LARGE 46 CFR SUBCHAPTER T 1983 PASSENGER VESSELS PILOT TRANSFER ARRANGEMENTS 1991 DETERMINATION OF COLD WATER AREAS 1991 ISSUANCE OF LETTERS OF COMPLIANCE TO FOREIGN DOCUMENTED 1988 MOBILE OFFSHORE DRILLING UNITS OPERATION ON THE OUTER CONTINENTAL SHELF OF THE UNITED STATES Functions and Responsibilities of Warship Procurement and Design Authorities Issue 1 11 82 11 18 82 SEA 0743 TLC PRIVATE SECTOR DEPOT LEVEL
8. 00 100 STANDARDS COMPENDIUM LISTING Page No Short Version By Organization STANDARD STANDARD ORIGINATION NO TITLE DATE kkkkkkkkkkxkxk kkkkkkkkkkkkkkkkkkkkkkkkkkkkxxkxk kkkxkkkkxkxkk 30 13 WELDING STRUCTURE CLASSIFICATION JOINT WELDED WELD HEAT TREATMENTS 30 35 RADIOGRAPHY BOILER AND PRESSURE VESSEL RADIOGRAPHY PIPE CONNECTION 30 37 TEST HYDROSTATIC TEST BOILER 30 39 METAL FILLER TEST WELD TEST WELD NONDESTRUCTIVE 30 49 WELDER QUALIFICATIONS 44 17 RIVET BOILER BOILER RIVET 44 19 FORGING MACHINERY STEEL FOR TEST STEEL FORGING 44 23 CASTING STEEL FOR MACHINERY BOILER AND PRESSURE VESSEL TEST CASTING STEEL CASTING REPAIR 44 25 CASTINGS NODULAR IRON FOR MACHINERY TEST IRON CASTING 44 27 CASTINGS GRAY IRON FOR MACHINERY TEST GRAY IRON CASTINGS ogee cyt TRIALS ELECTRICAL EQUIPMENT 41 83 TEST AUTOMATIC CONTROL SYSTEM TRIALS AUTOMATIC CONTROL SYSTEM 3 MATERIALS SCANTLINGS STRUCTURAL SECTION 43 1 STEEL HULL TESTS AND INSPECTIONS STEEL HULL PLATE THICKNESS TOLERANCES 43 3 STEEL HULL STEEL HULL TREATMENT OF SURFACE DEFECTS 43 5 STEEL HULL HIGHER STRENGTH 43 6 STEEL FOR LOW TEMPERATURE REQUIREMENTS 43 7 CASTING HULL STEEL TEST HULL STEEL CASTING 43 9 FORGING HULL STEEL TEST FORGING HULL STEEL Appendix C 17 REV NO xxx 12 04 92 SWBS ORGAN wkk k 000 000 000 000 000 000 000 000 000 000 000 000 0
9. Crude Oil amp Slops in Main amp Auxiliary Boilers Steel Floating Drydocks Underwater Inspection in Lieu of Drydocking Survey Construction of Shipboard Elevators Certification of Construction amp Survey of Cargo Gear on Merchant Vessels Certification of Self Unloading Cargo Gear on Great Lakes Vessels Single Point Moorings Aluminum Vessels Classification of Nuclear Ships Submersible Vessels American Boat and Yacht Council Incorporated Association Francais de Normalisation France Air Moving and Conditioning Association Incorporated American National Standards Institute American Petroleum Institute American Society for Testing and Materials British Standards Institute German Standards Appendix B 1 CGNVIC U S Coast Guard Navigation and Vessel Inspection Circular DEF S DIN DOD DOL EPA FCI British Defense Standards Deutsches Institute fur Normung Germany Department of Defense Department of Labor Environmental Protection Agency Fluid Controls Institute Incorporated FED SPEC Federal Specification GL HEI HI IEC IEEE IES IMCO IPCEA ISO JIC JIS MARAD MASS MASSD MIL MSS NBS NEMA NFPA NNI OCMIF PCC SAA SCA SNAME SOLAS SSPC TEMA Germanisher Lloyd Heat Exchange Institute Hydraulic Institute International Electrotechnical Commission Institute of Electrical and Electronics Engineers Incorporated Illuminating Engineering Society Intergovernmental Maritime C
10. E THIS QUERY command in the Query Menu If the query is needed again in the future it can be retrieved easily at the Control Center Appendix C 10 Using Indexes To use an established index simplv activate one of them For example to find all standards created by the American Boat and Yacht Council in the short version the user would activate the Organization ORGAN Index With the main data base active the user can choose an index other than the current index as long as he she in the dBASE IV Control Center Press F2 Data select ORGANIZE and highlight ACTIVATE INDEX FILE dBASE IV will then present a list of the available indexes which can be selected bv simplv highlighting and entering Creating a new index mav be desirable if the user needs to view the records using another field as the main sort An example of this would be to create an index sorted in order of the Subject category To do this select ORGANIZE from the dBASE IV Control Center and choose CREATE AN INDEX dBASE IV will then ask for the filename under which the index file is to be saved There are complete instructions on how to do this in the dBASE IV Manual Using dBASE IV Chapter 5 Browsing Through Recor From the dBASE IV Control Center begin browsing through records by using the F2 Data command dBASE IV starts at the beginning of the database by default and shows multiple records at once This is called the Browse mode and will display each record o
11. ILER ABS 074 30 39 METAL FILLER TEST WELD TEST WELD 4 3 NONDESTRUCTIVE ABS 074 30 49 WELDER QUALIFICATIONS 4 ABS 074 44 17 RIVET BOILER BOILER RIVET ABS 074 44 19 FORGING MACHINERY STEEL FOR TEST 5 STEEL FORGING ABS 074 44 23 CASTING STEEL FOR MACHINERY BOILER AND 5 3 O PRESSURE VESSEL TEST CASTING STEEL E CASTING REPAIR GR ABS 074 44 25 CASTINGS NODULAR IRON FOR MACHINERY 5 3 a TEST IRON CASTING L ABS 074 44 27 CASTINGS GRAY IRON FOR MACHINERY TEST 5 3 GRAY IRON CASTINGS ABS 095 35 161 TRIALS ELECTRICAL EQUIPMENT 5 ABS 095 41 83 TEST AUTOMATIC CONTROL SYSTEM TRIALS 4 AUTOMATIC CONTROL SYSTEM ABS 100 3 MATERIALS SCANTLINGS STRUCTURAL 5 3 SECTION ABS 100 43 1 STEEL HULL TESTS AND INSPECTIONS 4 3 STEEL HULL PLATE THICKNESS TOLERANCES ABS 100 43 3 STEEL HULL STEEL HULL TREATMENT OF 5 3 SURFACE DEFECTS ABS 100 43 5 STEEL HULL HIGHER STRENGTH 5 ABS 100 43 6 STEEL FOR LOW TEMPERATURE REQUIREMENTS 5 ABS 100 43 7 CASTING HULL STEEL TEST HULL STEEL 4 3 CASTING ABS 100 43 9 FORGING HULL STEEL TEST FORGING HULL 5 3 STEEL ABS 100 6 HULL GIRDER STRENGTH CALCULATION DECK 5 3 STRENGTH ARRANGEMENT HATCH ABS 100 E STRENGTH HULL GIRDER TANKER TANKER 2 3 GHANGE REQUEST FORM Standards Compendium Database ACTION REQUESTED Japo _ oereme cHance __ pRoGRAam cHance DATE REQUEST MADE STANDARD ORGANIZATION STANDARD NUMBER S DESCRIPTION QF GHANGE SIGNATURE OF ORIGINATOR T
12. ITLE OF ORIGINATOR REVIEWED BY ACTION DATE UPDATED DATE COPY SENT TO ORIGINATOR Appendix C 20
13. TRODUCTION Overview The Standards Compendium Data base has been developed to provide an up to date reference list of all existing marine related standards The data base is intended as a resource to the shipbuilding ship design and maritime industries for standards that have been developed bv various organizations to aid in boat and ship construction Users will be able to locate standards of interest using a DOS PC and the data disks provided by UMTRI currently the organization responsible for developing and maintaining the data base The Standards Compendium will be updated periodically to reflect changes in the current body of marine standards as well as to enhance the system based on user input The data base contains basic descriptive information of each standard organization number title along with current revision and administrative data There will be sufficient information on each standard so that a user can determine if it is suitable for a given purpose A user should then be able to determine whether it is necessary to reference a detailed standard All major standards generating organizations have been included both U S and international See Appendix B for a list of the organizations included in the Compendium In developing the Standards Compendium data base the 1979 National Shipbuilding Standards Program data base was used as a starting point with these standards being updated and new ones added The basic data base str
14. This program will be included on the disk each user receives and can be run using the following command at the DOS prompt B gt PKUNZIP COMPEND ZIP CNCOMPENDX In this example the user has the Compendium disk in the B drive on some computers this will be the A drive and is extracting the data base files from the Compend Zip file into the COMPEND directory on the computer s C hard drive The user can name the directory by some other name if desired The Compendium data base can be put in any directory or subdirectory desired However it would be a good idea to put the files in an easy to find location Once the PKUNZIP command has been successfully completed all of the Appendix C 6 necessarv data base files will be on the User s hard drive readv to access with the data base program There will need to be at least eight megabytes of free memory space on the computer hard drive in order to load the Compendium data base and its supporting files If there is insufficient memory options for obtaining more space include deleting obsolete files to create more space finding another computer with enough free memory or obtaining a larger hard drive Using Different Data base Programs The Standards Compendium was developed using the Alpha Four data base software program However the Compendium is supplied in dBASE IV The Alpha Four version is available upon request from UMTRI The data base files can be accessed with other data base prog
15. d as aspects of the other parts were developed The first task was to examine the 1979 Compendium and decide which parts if any of it were to be saved It was quickly decided that all of the data would be retained at least until it was found to be outdated if that happened at all Thus all twelve data fields for all 2 580 records were retained This was felt to be the most conservative approach to use and would eliminate any chance of deleting potentially valuable data The second task was to develop a new data base format using PC based software which would incorporate the fields from the old Compendium add any new fields that could be useful and be relatively easy to use for shipyard personnel The resulting data base has 12 fields in a rearranged format which is easier to read in hard copy form A sub task here was to select a PC data base software package with which to develop the new format The main criteria used in this selection were ease of use and learning flexibility in performing searches creating reports etc and the ability to import and export data in other data base software formats This last point is important due to the diversity of data base programs being used across the industry As a result the Alpha Four program was selected for data base development However the Compendium is shipped as a dBase IVO data base at the request of the SP 6 Panel as more commonly in use at shipyards It is available in Alpha Four on
16. e As a result a subscription to the Information Handling Services IHS standards was purchased IHS provides a data base subscription service in a CD ROM format for many data bases including standards The data bases are updated on a regular basis to reflect additions changes or deletions to standards across a wide spectrum of domestic and foreign standards organizations The Project Team concluded it was the most complete and easily accessible standards resource available The IHS data is sent out to subscribers in the form of a CD ROM disk with accompanying software once each quarter Using a computer searches for standards can be carried out included organizations using select criteria specified by the user In most cases the search results can be saved to a file or printed for further reference An example of a search result is in Appendix A Search criteria were developed that would ensure that most if not all of the marine related standards were extracted for organizations included on the IHS disks This task was made easier due to IHS use of subject indexes and keywords which helped to eliminate duplicate and non marine standards A final list of organizations included in the Compendium is included in the Appendix One final limitation of the IHS disks is that the American Bureau of Shipping standards are not coded to an acceptable level of detail The original compendium has a much more complete listing for ABS and these were
17. e Compendium in a format that is easilv usable bv shipvard personnel and transferable to personal computers anvwhere in as efficient a manner as possible This involved creating an easy to follow User s Manual which explained precisely how to install the Compendium how to locate information easily and where to call in case help is required In addition report formats were developed that would enable hard copies of searches to be printed quickly Finally a method of compressing the Compendium data base files into an easily shipped form was required due to the volume of data involved The PKZIP software program was selected for this task As a result eight high density floppy disks worth of data was compressed onto one disk for shipping to users With one command described in the User s Manual all of the files are loaded onto the user s computer in their original size Computerized Compendium of Standards V INFORMATION HANDLING SERVICES As explained earlier in the report a need was identified at the beginning of the project to find and capture large amounts of standards information electronically This was deemed the only way to efficiently import to the data base file the thousands of new standards necessary to make the Compendium a truly useful tool for industry users Although this added to the technical complexity of the project the resource savings in data entry hours justified the extra programming and computer problem solving tim
18. e been revised and some standards have been deleted Since the original compendium was not revised it has become outdated and incomplete 2 The cumbersome form of a hard copy listing makes finding a given standard difficult With the availability of powerful personal computers and highly flexible data base software search times can be greatly reduced with more thorough results 3 There was no ongoing maintenance requirement defined that provided for input from users into the data base content or periodic updates based on evolving industry standards Therefore in addition to updating the listing of standards to reflect all of the changes since 1979 a major goal of this project was to develop a format for the compendium which would be easily distributed to users flexible in manipulating information and searching and easily maintainable Also due to the increased need to reference international standards the Compendium needed to be broadened to include some of the major foreign standards bodies The main objective of this project was to arrange all existing standards applicable to U S shipbuilding and ship repair into an easily usable computerized data base that can be updated efficiently on a regular basis Computerized Compendium of Standards IV TECHNICAL APPROACH The approach used to complete the project consisted of four main tasks These tasks were not necessarily sequential in completion and actually had to be refine
19. er these fields will encompass most of the useful information for each standard in the Standards Compendium data base Appendix C 4 N n Mili r Most references to militarv standards in the data base were taken from the Information Handling Services IHS standards disks However due to program limitations it was onlv possible to extract basic fields such as title standard number and organization Future revisions of the data base will correct this problem so that other fields such as revision number and revision date can be extracted easily All military standards are coded in the Compendium under the organization DOD The were 2 601 new military standards obtained for this Compendium Most of these standards are primary first level standards There are a great many more standards referenced by these first level standards For example a fuel oil service system standard may refer to a standard for copper nickel piping among many others The reference standards are not included in the Compendium in most cases For government applications these references are available through the Naval Sea Systems Command NAVSEA Where to Call With Questions Problems If you are having any problems with the Compendium or have questions about any aspect of using it call the University of Michigan Transportation Research Institute UMTRI at 313 764 5308 FAX 313 936 1081 Or you can write to University of Michigan Transportation Research Ins
20. he appropriate command at the DOS prompt or if you are in the Windows environment double click on the program icon under non Windows Applications At the Control Center the data base the queries and the reports are available by command There are two ways to look at the Main data base file You can use the Query command at the Control Center or you can use the ORGANIZE command when editing data We recommend using the QUERY command Both methods are described below earchin Data There are a variety of ways to search the data base depending on what information is being sought and how often the query will be required dBASE IV is very flexible in letting users define queries using either very broad criteria or narrow search parameters This section gives a general description of how to set up queries as well as examples of some common queries that will be used with the Standards Compendium Each of the popular data base software programs has very flexible command structures for creating queries Most programs allow a search for key words or character strings from one or more data fields concurrently Also it is usually possible to link different search criteria using logical operators such as AND or GREATER THAN Appendix C 8 For example a querv can be set up in dBASE IV to find all ABS standards pertaining to boilers with a standard number greater than 25 Remember the expression field has to be enclosed in quotes This would invo
21. herebv presented 1 In order to make the Compendium an ongoing usable tool it will need to be maintained so that it reflects updated standards and references new standards sources and archiving of obsolete standards Also users will need support and specialized services such as custom searches and ready access to hard copies of standards RECOMMENDATION Approve funding for continued maintenance and development of the Compendium This also includes renewed subscriptions to IHS data 2 In an effort to continually build the data base smaller standards generating organizations that do not fall into the IHS data bases and other standards directories should be researched and added RECOMMENDATION Approved funding per item 1 This should be included in a maintenance effort 3 Military standards should be extended to include 2nd tier standards for those standards referenced by the major lst tier standards This would improve the usefulness of the data base even more especially for military users RECOMMENDATION Should maintenance projects be approved work with IHS or the Navy to develop a method of extracting 2nd tier standards Computerized Compendium of Standards VIII REFERENCES 1 A Compendium of Shipbuilding Standards NSRP 1979 by Corporate Tech Planning for Bath Iron Works 2 Information Handling Services Denver Colorado CD ROM subscription service 1991 1992 3 Codeof Federal Regulations U S Government
22. ill be filled in a future revision of the data base The following are names and descriptions of each of the data fields in the Standards Compendium FIELD DESCRIPTION ORGAN Standards organization that originated the Appendix C 3 standard see the listing in the Appendix of organizations included SWBS Navy ship work breakdown structure applicable to the standard see the listing in the Appendix of this manual STD_NO Standard number as assigned by issuing organization TITLE Descriptive title of the standard ORIGDATE Date the standard was originally issued REV_NO Revision number REV_DATE Date the standard revision was issued SUBJECT Major work breakdown structure category MOD_REQD Code indicating whether a revision is due or not Yes or No STD_TYPE Code for the type of standard The standard establishes definitions or classifications The standard is used primarily in design The standard is used primarily in production operations The standard is used primarily in test and or inspection activities 5 The standard defines limits or boundaries specifications on the characteristics of materials items systems or services A U N Fi ENGLISH Code that indicates whether an English version of the standard is available Yes or No ADDTL_STD Other standards relating to the current standard Note It is expected that not all of the above fields will be pertinent to every standard Also some data will not be available Howev
23. inting describes the available report formats and briefly explains how to design reports using dBASE IV Hardware Requirements dBASE IV or any of the common data base software packages functions well with either dot matrix or laser printers The software provides a menu of printers from which a user can select one that is compatible with his her printer Either letter size or wide computer paper can be used to print listings of standards Several of the report formats provided with the Compendium are designed to fit on letter size paper A desirable feature for printers is the ability to use compressed mode This is helpful when printing large listings of standards so that more information can be fit onto a page Report Formats Available In the dBASE IV version shipped to Compendium users there are four report formats available to choose from These were the listings assumed to be the most useful for the majority of users Any of the four formats can be used to print a list of standards of any length Below are descriptions of each 1 Organization order short version This report lists the standards in alphabetical order of the originating organization Within each organization the standards are in ascending numerical order The fields included are the ones expected to be of the most interest Organization Standard Number Standard Title Origination Date and Revision Number 2 Organization order long version This report
24. ions This can not be not only time consuming but may result in either not finding a standard or developing a new standard where a suitable one may already exist As a result Panel SP 6 of the Ship Production Committee of SNAME has identified the need for an up to date computerized compendium of standards pertinent to shipbuilding and ship repair The development of the Computerized Compendium of Standards was contracted for under SP 6 Project P 67 The purpose of this report is to describe the final Compendium data base and the process used in its development Section III describes the previous standards compendium project some of its limitations new requirements for a standards compendium based on industry need and the goals of this project Section IV explains the four main tasks of this project The first task was to examine the previous standards compendium and decide how much of it to use as a Starting point Second a new data base structure was developed and incorporated into a data base on a personal computer Third new sources for marine standards were researched and a new method to incorporate them into the computer data base was developed Finally data copies of the Compendium and User s Manual were produced to make transfer of the data base to the industry as efficient as possible Section V describes the Information Handling Service IHS CD ROM based standards library and how it was used to gather much of the updated standa
25. lists standards in the same order and logic as the above report except that all data fields are included In order to print this report a wide carriage printer and paper are required Appendix C 12 3 SWBS order short version This report lists the standards in ascending SWBS order with organization being the secondarv sort The fields included are ORGANIZATION STANDARD NUMBER STANDARD TITLE ORIGINATION DATE AND REVISION NUMBER 4 SWBS order long version This report lists standards in ascending SWBS order with organization being the secondary sort All data fields are included in this report Again a wide carriage printer is required in order to fit all of the columns onto one page When ready to print dBASE IV displays a list of report formats to choose from under the Control Center Report Menu command How to Print a Report Printing a report is straightforward using one of the predefined formats in dBASE IV Basically this tells the program which fields to print in what order on the page and in which locations Also the format tells the program what to print on the top and bottom of the page in the way of heading and summary information The dBASE IV commands to use in printing are simple once a report has been created to print from a query main data base Suppose a search is run that results in a list of 150 records It is necessary to tell dBASE IV to begin printing All 150 records will be printed using the format ch
26. lve setting up three search criteria as follows RITERIA FIELD OPERATOR EXPRESSION 1 ORGAN ABS 2 STD_NO gt 25 3 TITLE BOILER In the above is a dBASE IV operator which tells the program to search for any occurrence of the word boiler in the specified field Another simple commonly used type of search is to find all records with the same entry in the primary index For example if the current query is By Organization within dBASE IV the Find command can be used to jump to the first SNAME record for example The user can then page through the records The searches that Compendium users will probably employ most of the time are 1 Search for a specific standard number possibly within a given organization 2 Search for standards with a specific SWBS possibly within a given organization 3 Search for all standards related to one or several key words or expressions for example all standards related to Halon Systems Using Queries To use established queries simply activate one of them For example to find all standards issued by the American Boat and Yacht Council in the short version you would activate the Organization Order short version ORGSHORT Query Appendix C 9 Creating a new querv is desirable if vou want to view the records using a field other than the established ones as the main sort To create a querv sorted in order of the ASTM subcommittee responsibilitv select QUERX from the dBASE IV C
27. n one line It will still be possible to see other data fields within the record by scrolling to the right until the desired field comes onto the screen To look at a single record at a time press the F2 Data button this will put you in the Edit mode To go back to Browse mode multiple records at a time press the F2 button again Using the Tab key causes the cursor to move one field at a time To scroll forward 17 records use the Page Down key using the Page Up key results in a backward scroll of 17 records Exporting Data from the Data base If necessary records can be exported to another file in a selected data base software format This is done in dBASE IV using the TOOLS EXPORT DATA command There is a lot of flexibility in determining which fields and records are selected for export One advantage to doing this is the ability to manipulate some of the data in another file without altering the structure of the original data base Appendix C 11 IV PRINTING REPORTS Printing reports can be done in several different wavs The Compendium has been sent out with report formats alreadv set up To print enter the Report menu and select the desired report format Another wav is to design a custom report using the software This is of course much more time consuming However it does afford a lot more flexibilitv in tailoring a report to specific needs This section of the manual provides printer and hardware requirements necessary for pr
28. onsultive Organization Insulated Power Cable Engineers Association International Organization for Standardization Joint Industrial Council Japenese Industrial Standards Maritime Administration MARAD Standard Specification MARAD Standard Specification Diesel Military Specification Manufacturers Standardization Society of the Valve amp Fittings Industry National Bureau of Standards National Electrical Manufacturers Association National Fire Protection Association Netherlands Normalisatie Instituut Oil Companies International Marine Forum Panama Canal Company Standards Association of Australia Suez Canal Authority Society of Naval Architects and Marine Engineers Safety of Life at Sea Steel Structures Painting Council Tubular Exchanger Manufacturers Association Appendix B 2 UL Underwriters Laboratories Incorporated USCG United States Coast Guard USDA United States Department of Agriculture USN United States Navy USPHS United States Public Health Service Appendix B 3 STANDARDS COMPENDIUM DATA BASE USER S MANUAL Table of Contents E Jotredue Heger 2 II How to Access the Data base Disk ssseeesssnzensenssnnenezossnnezznennnnenonnnnes 5 III Using the Data base to Locate Information esssesssesseeerereseeesesssssssseree 1 IV Pinions ROpOrt Sika ei ikeriettiszii like te peti tebg said 11 Ve MA NISA LINE ki e a A 14 Appendix C l STANDARDS COMPENDIUM DATA BASE USER S MANUAL I IN
29. ontrol Center There are complete instructions on how to do this in the dBASE IV Manual Using dBASE IV Chapter 6 Queries Available The data base can be displaved on the screen sorted bv anv field desired Each sort of the data base is called a querv A querv is called up from the Control Center The main data base file is exactly the same no matter which querv is chosen The records will simplv be displaved in a different order Within the querv file there are primarv indexes and secondarv indexes The primarv index is the field used to sort the records on the screen The secondarv index es is the field to sort bv within the primarv index field For example within the Organization primarv index field one mav want to sort all entries bv Standard Number the secondarv index field The Compendium has been shipped with four Queries available these were the ones that are considered most useful Querv Tvpe dBASE IV Name 1 By Organization Order short version ORGSHORT 2 By Organization Order long version ORGANLND 3 By SWBS Order short version SWBSSHRT 4 By SWBS Order long version SWBSLAND If there are other queries that would be useful the Query Create command can be used to set up and save a new query Saving Queries and Query Results Frequently accessed queries should be saved under a file name for use in the future Queries can also be saved as a new mini data base In dBASE IV this can be done using the LAYOUT SAV
30. osen Creating a Custom Report Printing does not have to be done using one of the predefined report formats The software will allow users to design a report form This usually takes a little effort but may be worth it depending on which fields are most useful as well as what is the best order to print in In dBASE IV the basic command to use in setting up a new report is Reports and then Create Modify a Report After the report has been set up in the Layout Save This Report a file name will be needed to store the report in a report description and which data fields need to be printed in the report The further details of how to create a custom report are beyond the scope of this manual However the software user s manual will provide detailed Appendix C 13 instructions on all the commands Bevond this it will take some working with the software to become proficient at setting up a report Examples of Reports Following the administrative section are example pages of the different report formats available Appendix C 14 V ADMINISTRATIVE How in Revi ies of the Data The Standards Compendium can be obtained through a written request to the Universitv of Michigan Transportation Research Institute UMTRI Marine Division 2901 Baxter Rd Ann Arbor Michigan 48109 2150 or via a phone call to the NSRP Documentation Center at the same address at 313 763 2465 Custom Services Available Custom searches and information
31. printing office October 1990 parts 1 588 8 10 DODISS 92 03 Document Number MIL O 39A MIL M 69A 1 MIL L 221C MIL F 243E 2 MIL C 486B CANC NOTICE 1 MIL G 613C 1 MIL F 902J 2 MIL M 1158B 3 MIL A 2673 MIL B 2680 MIL G 2697A 2 MIL S 2734B 1 MIL G 2767C 1 MIL F 2807A CANC NOTICE 1 MIL G 2860E MIL H 2946 CANC NOTICE 1 MIL A 3339C VALID NOTICE 1 MIL W 345 9D MIL H 3496D MIL B 3715B MIL R 3768B CANC NOTICE 1 MIL B 5006 CANC NOTICE 1 MIL I 5284A MIL I 6142 CANC NOTICE 1 MIL O 8626A CANC NOTICE 1 MIL P 11064C CANC NOTICE 1 MIL F 11435A CANC NOTICE 1 MIL B 12203B CANC NOTICE 1 MIL R 12500A CANC NOTICE 1 MIL P 12581B CANC NOTICE 1 MIL A 13480A CANC NOTICE 1 Information Handling Services FSN2000 TXT Page 1 St Title LIP FP P EP DG mp ppm PP u pp PN Se Se OARS MATS CARGO LADDERS JACOB S FURNITURE SHIPBOARD STEEL GENERAL SPECIFICATION FOR CHAIRS SHIPBOARD STEEL USE AA C 275 GRAPNELS MARINE TRIP WIRE AND CRASH TRUCK FURNITURE SHIPBOARD ALUMINUM GENERAL SPECIFICATION FOR MIRRORS GLASS SHIPBOARD USE ANCHOR STEEL NAVY TYPE OR STOCKED BUOYS ANCHOR SPAR GLASSES PORTLIGHT CIRCULAR HEAT TREATED STRAP BERTH MATTRESS RETAINING GUARDS RAT SHIP FENDER MARINE COIR ROPE GLASSES SIGHT FLAT CLEAR BOROSILICATE HOISTS AMMUNITION AUTOMATIC DREDGER TYPE AND POWER EQUIPMENT ANCHORS SEA LIFE RAFT WIPERS WINDOW ELECTRIC
32. project was sponsored bv the Maritime Administration MARAD of the United States Department of Transportation DOT Peterson Builders Incorporated PBI was the prime contractor Universitv of Michigan Transportation Research Institute UMTRI worked under a Subcontract purchase order 1009 0006 Under the SPC Panel SP 6 proposal the technical objective of this project was to develop a compendium of standards international national militarv and regulatorv that have relevance to the U S shipbuilding and repair industrv The intended benefits were to provide shipvards with a readv reference to standards that are of use to shipbuilding and to eliminate the development of new standards where acceptable standards exist The project was performed at the UMTRI bv Albert W Horsmon Jr and Kurt W Hagemeister assisted bv student Sean Callan Howard M Bunch was project director Computerized Compendium of Standards II INTRODUCTION Standards are kev elements in the efficient design construction and repair of ships and vessels in all shipyards As a result there is a continuous need by many designers engineers managers and other people associated with marine work to reference standards from a wide range of regulatory bodies government agencies technical societies and private industry groups Traditional methods of locating standards center around referencing many documents and books of standards issued by diverse individual organizat
33. rams if saved in the correct file format In either case it will be possible to directly read the files with your data base program without any file conversion programs Problems with Accessing the Compendium Data base Upon successful loading of the Compendium onto the computer it can be accessed simply by loading the data base software program into memory and choosing MAIN DBF as the active data base file If MAIN is not available as a choice it may be necessary to change the default directory currently set up in the data base software to CNCOMPEND or whichever directory path the data files were moved to The default directory is the location where the software program automatically looks to find files to load This directory can be named whatever one wants Most users choose an easy to remember name where they want all their data bases to reside Appendix C 7 III USING THE COMPENDIUM TO LOCATE INFORMATION This manual uses the dBASE IV command language to describe search methods Most data base software programs use similar if not identical commands The title of the command may be different but usually the function is the same This section of the manual will describe the basic steps for locating the available information Experienced data base software users will be able to use more advanced techniques tailored to their individual needs Assuming that the data base program is loaded onto the computer hard drive call it up using t
34. rds information finally incorporated into the Compendium section VI summarizes the final results of the project including some size parameters of the final data base which information is included which information is not included uses for the data base and details of some of the major standards types included i e military ABS Coast Guard international Computerized Compendium of Standards Section VII presents some conclusions of the project with corresponding recommendations of actions to be taken in the future Finallv the References and Appendix contain supporting information for this report including a User s Manual Computerized Compendium of Standards II PROBLEM DEFINITION The most recent development of a standards compendium was completed in September 1979 under an NSRP Project titled A Compendium of Shipbuilding Standards NSRP 0088 compiled bv Corporate Tech Planning for Bath Iron Works under a MARAD contract The resultant data base was in the form of a hard copy paper listing of 2 580 entries from mainly domestic regulatory agencies At that time the data base was issued to the marine industry only as hard copy as a reference guide with no provision for ongoing maintenance The limitations of the 1979 project relative to today s needs were recognized by SP 6 in approving this project These limitations are 1 Since 1979 many new standards have been developed many existing standards hav
35. retained in the current Compendium In addition both Coast Guard Navigation and Vessel Inspection Circulars NVICs and marine related cites from the Code of Federal Regulations CFRs had to be obtained directly CFR cites were manually entered at the CFR section level Computerized Compendium of Standards VI FINAL RESULTS The final Compendium data base contains 10 379 standards from 50 different organizations This represents a 300 percent increase in size from the 1979 Compendium With the expansion in militarv standards Coast Guard regulations and foreign standards such as JIS DIN and BSB the Compendium offers a much more complete reference source for shipvard personnel Everv standard record entrv contains the organization acronvm standard number descriptive title and SWBS Ship Work Breakdown Structure number Thus with the flexibility of the data base software searches can be run to find standards meeting a variety of criteria defined by the user This is a significant improvement from the original Compendium project The User s Manual with a more detailed description of the compendium and how to access it is attached to this report as Appendix C 3 JIS is Japanese Industrial Standards DIN is Deutsches Institute fur Normung Germany and BSI is British Standards Institute Computerized Compendium of Standards VII CONCLUSIONS AND RECOMMENDATIONS The following conclusions with corresponding recommendations are
36. st 17 Key Words 18 Distribution Statement Standards Standardization Shipbuilding Indexes Computerized Indexes 19 Security Ciassif of this report 20 Security Ciassif of this page 21 No of Pages 22 Price Unclassified Unclassified 36 i COMPUTERIZED COMPENDIUM OF STANDARDS TABLE OF CONTENTS Report Documentation EA di iet 1 Table OF CONC MS tikek a li L FOWO WE l A a te EE 2 TE Problem Feta ebe EE 4 IV Technical ett 5 V Information Handling Service IHS sssssseeeseoseenzzonenneznnenzontanss 7 Wis Final Results si sies intesa inibiti 8 VII Conclusions and Recommendations ss sssseessorenenzonnenzeonenzennnnnza 9 VU EN 10 Appendixes A Example of IHS File Output sisi sccsssssssseisstsivscosaetesnsstactesceaess A 1 B List of Compendium Organizations sssenenesnennenzznnnenzn B 1 C Compendium User s Manual sssssssssnsennnnnnezzznnnnnnnots C 1 E AMMOUUCTION ika n a E C 2 II How to Access the Data Base Disk cceseesssoeeees C 6 III Using the Data Base to Locate Information C 8 IV Printing Reports ikseb iii esibit C 12 Vic A dM ger C 15 Computerized Compendium of Standards I FOREWORD This report is a product of a program directed bv the National Shipbuilding Research Program NSRP and the Ship Production Committee SPC of the Society of Naval Architects and Marine Engineers SNAME This particular research
37. titute Marine Systems Division 2901 Baxter Rd Ann Arbor MI 48109 2150 Attn Standards Compendium Appendix C 5 I HOW TO ACCESS THE DATA BASE FILE General The data base will arrive on one 3 5 disk in dBASE IV format The first necessarv task will be to make a backup copv of the database This will protect valuable data in case of hard drive or floppv disk damage Use the DOS DISKCOPY command with this format DISKCOPY A A To copy using a one drive system with the same type of disk or DISKCOPY A B To copy using a two drive system from the 5 25 disk to a 3 5 disk Note It is important to number each of the copy disks if you receive more than one disk the same as the originals This will help ensure that the disks are read onto the hard drive in the correct order ncompressing the Files Loading on Hard Driv The Compendium will be sent to users in a compressed file format so that the data base and all associated files can fit on one data disk The data base files have been compressed using the PKZIP EXE program into one file called COMPEND ZIP In order to load the Compendium files onto the hard drive and restore them to normal size it will be necessary to use the PKUNZIP command After making a backup copy of the Compendium disk use the copy to load the database to the hard drive in your computer It will be necessary to use the PKUNZIP command to uncompress extract the files and load them onto the hard drive
38. ucture was kept intact and some new fields were added The Compendium was developed using PC based data base software Alpha Four and dBASE IV versions are available Contents of the Users Manual This User s Manual contains information to help new users of the Compendium install the data base on their computers learn how to find information quickly print out reports and locate help should problems arise The manual is divided into 6 main sections Appendix C 2 I Introduction II How to Access The Data base Disk III Using the Data base to Locate Information IV Printing Reports V Administrative VI Appendix Hardw f Reguiremen The following are recommended hardware and software requirements for the Standards Compendium IBM PC compatible at least a 286 640K RAM with 1 megabyte or more Hard drive with at least 8 megabytes free 5 25 or 3 5 inch high density disk drive Major data base software program such as dBASE IV Paradox Alpha Four etc Dot matrix or laser printer if printing is desired Note that the Compendium can be shipped in different floppy disk sizes and data base formats depending on each user s requirements Data Included in the Data base In general the data in the Compendium has been obtained from the most recent versions of the standards available Not all data field information is available for each standard These fields were left blank although there is a possibility they w
Download Pdf Manuals
Related Search