Support: Tips for Using BizInt Smart Charts

Using Reference Rows™ Alpha

Reference Rows Alpha #3 is a single program that can be used to build Reference Rows from combined charts created by both BizInt Smart Charts for Drug Pipelines and BizInt Smart Charts for Patents. This release can be used to:

  • set up your rules for generating Reference Rows
  • generate Reference Rows
  • review and change the selected cells in a Reference Row
  • sort Reference Rows based on selected values
  • export a report with Reference Rows to HTML

We recommend that you create and customize your report in Version 3.4 and run the Generate Common Drug Name or the Identify Common Patent Family tool before working with the report in Reference Rows Alpha #3.

Using the Reference Rows Alpha

  1. Save your Smart Charts file in Version 3.4 and then open it in the Reference Rows Alpha. You may run the Generate Common Drug Name or the Identify Common Patent Family tool on the chart after opening it in the alpha.
  2. Press the "RefRows" button on the toolbar, or select "Create Reference Rows" from the "Reference Rows" menu.
  3. Modify rules by pressing the Rules button. The Default Rule is used to select cells when no specific column rule is applicable, or in case of ties. The most important part of the Default Rule is the ranking of databases within the chart. The initial order is based on the order the databases were listed when you created the combined chart.
  4. Double click a column name (or choose Reference Row Rules from the right mouse menu in that column) to bring up the Cell Selection Rule panel for that column. The "Based on" drop down menu is not active at this time. You can also get to this panel by choosing "Reference Row Rule" from the right mouse button in a column.
  5. Check marks on the upper right corner of a cell means that cell will appear in the reference row.
  6. To change the selected cell for a reference row, select the cell you want, hold down the right mouse button, and choose "Select this cell" from the menu. Note that there is no way to "unselect" a cell in this version.
  7. After you have created Reference Rows, you can change your rules and the Reference Row selections will be re-created. If you change the database order in the Row Scoring rule, the rows will be reordered within each Reference Row.
  8. You can sort the chart and the Reference Rows will be sorted based on the selected value for each row.
  9. To export the reference row report, press the "Export" button and provide the .htm file name. Export options are not yet available for the Reference Rows HTML export.