STN Express logo

Creating a CAS Registry Number and Role Interactive Spreadsheet

Use the CAS Registry Number® and Role Report Wizard to obtain an overview of the relationship of the compounds in your answer set and the types of studies for those compounds.  You can analyze CAS Roles for:

You may launch the CAS Registry Number and Role Report from the Results tab of the Select Discover! Wizard Window, from the Discover button, or from an L-number hyperlink.

To create a spreadsheet from CAS Registry Numbers and CAS Roles:  

  1. Conduct a search in the CA/CAplus database or CAS REGISTRYSM.

  2. Select the Create CAS RN & Role Report wizard and the L-number for the answer set.

  3. Select All RNs and the answers to be used. Click Chart.

The CAS Registry Numbers from the selected documents and the associated roles are tabulated in a Microsoft Excel interactive spreadsheet.  Click 3-D Column on the bottom of the sheet to view the data as a 3-D column.

To create a report from Hit CAS Registry Numbers and CAS Roles

  1. Conduct a search in the CA/CAplus or CAS REGISTRY database.  

  2. Select the CAS RN & Role Report wizard and the L-number for the answer set.

  3. Select Hit RNs and the answers to be used. Click Chart.  

To display answers from a CAS RN & Role Report: 

  1. To display STN records associated with a specific cell, double-click the cell.  To display records associated with multiple cells, select the cell(s) and click Display Records  from the toolbar. To display STN records from the 3-D column view, double-click a column.

  2. Choose your display options.  Click Display.  Selected answers are displayed in both your online session and in a separate window.

To change the default sort order for the CAS RN & Role Report:

There are three possible "Initial Sort Orders" which can be selected from the CAS RN & Role Report toolbar within Excel.  The options are:

  1. None (default value)

  2. Alphabetic

  3. Frequency

If you change the "Initial Sort Order", the new value is remembered the next time you run the CAS RN & Role Report.

Copyright © 2017 American Chemical Society. All Rights Reserved.