Import Filters  Scripts  Thesauri

Total Records: 33 Last Updated
Name Filename Last Update
Bubble Chart
Notes: New: Save and Load templates for common field selections.
Requirements: A dataset is open with year fields.
Butterfly Chart
Clean Messy Affiliations
Close All Views
Notes: Closes all active views in your dataset - only the Summary sheet will remain.
Color Cross-Correlation Matrix
Notes: Color code cross-correlation matrix based on whether there are shared records or not.
Requirements: A cross-correlation matrix is open.
Usage: Just because cells in a cross-correlation matrix have a positve number does not mean that the terms actually appear together on any records. This script will color in all the cells with actual records.
Company Activity Gantt Chart
Notes: Create a Gantt chart of company's active years. Can plot 2 year fields (priority and publication)
Requirements: A saved dataset is open with organization and Data Type: Year fields.
Usage: Quickly compare the range of active years across multiple organizations.
Compound Field Filler
Notes: Look for empty country items in an assignee/inventor compound field. Fill with value from neighboring, matching rows.
Create Full Coverage Group
Notes: Creates a group that includes as many records as possible from as few terms as possible.
Requirements: VPv10 Will prompt for a field if list is not already open.
Usage: User chooses to add terms to the group from the top (most frequent) or bottom (least frequent). Script then does a second pass trying to remove terms but keep full coverage. Script can attempt to make multiple, non-overlapping groups of terms.
Export List Terms and Groups to Excel
Notes: Send a List with Groups to Excel as a two column list of Terms & Groups
Requirements: A list with groups exists
Export Matrix to Text
Notes: Export an open matrix matrix to tab-delimited, Unicode text file
Requirements: Matrix is open.
Export Title List
Notes: Export to MS Word a formatted list of titles in each group from the selected field.
Requirements: A title field exists and groups exist in the selected descriptor field.
Usage: When there are too many records to read in a fancy printed list, export just the titles. This is specifically intended for exporting factor groups since the titles are sorted by the number of grouped terms they include. If you allow titles to be exported to multiple groups, titles will be prefaced with an asterisk after they have appeared in another group. You also have the option to list titles not affiliated with any groups at the end of the document if you want the document to include every title in the dataset.
Export To Gephi
Notes: VP to Gephi.pdf file included with step by step guide for use, will appear in the Macros\Resource folder.
Requirements: VantagePoint version 10. Latest version of Gephi is installed
Field to Classification
Notes: Create a Record Classification from a field of terms.
Make Earliest Date
Notes: Go through a list of dates. Put the first one for each record into a new field.
Requirements: Dates are expected to be in YYYY-MM-DD or YYYYMMDD format. A field with years or other non-date information will cause errors.
Usage: Use to create a field with, for example, the earliest priority date from a patent family record.
Matrix Column Cross Product
Notes: Export to Excel a cross product of row items by column
Requirements: A matrix must be open.
Usage: Use with a cross-correlation matrix to evaluate the total "connectedness" of each column, for example, in a cross-correlation of organizations by subject terms Note: Script is limited to Excel's maximum of 256 columns.
Matrix Viewer
Notes: View a node-edge representation of a matrix in a browser sheet.
Requirements: Requires VPv2020 A matrix must be open.
Usage: Similar to VantagePoint's other maps, this script displays terms as nodes and shared records or correlations (depending on matrix type) as lines between them. If the matrix has different fields in its rows and columns, they will be represented with different color nodes. Different layouts can be selected from the drop-down at the top of the sheet. Additional usage instructions can be found at the bottom of the sheet. Warning: In force-directed (animated) layout, map will continuously update and use processor power unless paused, even if you switch to another sheet.
Multiple Donut Chart
Notes: Create a multi-donut chart from a second field with a maximum of 7 categories.
Open File in Browser Sheet
Notes: Get a file name from user then attempt to open the file in a new browser sheet
Requirements: VPv10 File is html or other format that can be rendered by internal browser.
Plot Classification
Notes: Plot a classification field (CPC, IPC, or Derwent) in one of three multi-level layouts: Circle Pack, Treemap, or Sunburst
Requirements: Classification field should have "Classification" metatag.
Plot Emergence Indicators
Plot Fields
Notes: Requres VantagePoint v10. Create a Rank by # of records plot for each field in the datset.
Requirements: Requires VPv10 Dataset is open
Usage: Makes a series of small plots in a browser sheet. This is an example of using ChartDirector, a graphing package, and browser sheets to display information. Note: All charts are temporary PNG files in \VantagePoint\TempData\ directory. For more information on ChartDirector and to acquire a developer's licence, please visit the ChartDirector website.
Refine NLP
Super Profile
Notes: Create a profile table of a group of items in a field.
Requirements: Requires v11 or newer The file "SuperProfileForm.html" is in your \Macros\Resource\ directory.
Usage: This script opens a form where you "build" your profile. The first column will always be the items from the group you selected. In subsequent columns, you will first pick an analysis type for the column, then pick a field as the basis for the column, and finally specify how many items for each cell in the column. When finished adding columns, click submit.
VP Macros for users with Internet Explorer 8
Notes: WARNING - This will overwrite macros with older macros that are compatible with version 8 of Internet Explorer. Do not download or install these files unless recommended by your support representative.
Requirements: VantagePoint version 9 or 9.5. Do not install with version 10.
World Map
Notes: Make a browser sheet with a clickable country map(s) with values corresponding to a country field.