Import Filters  Scripts  Thesauri

Total Records: 30 Last Updated
Name Filename Last Update
Butterfly Chart
 
12/20/2022
Requirements:
 
Calculate Date Difference
 
12/15/2022
Requirements:
 
Clean Messy Affiliations
 
08/24/2021
Requirements:
 
Close All Views
 
08/25/2021
Notes: Closes all active views in your dataset - only the Summary sheet will remain.
Requirements:
 
Color Cross-Correlation Matrix
 
08/25/2021
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.
Compound Field Filler
 
12/15/2022
Notes: Look for empty country items in an assignee/inventor compound field. Fill with value from neighboring, matching rows.
Requirements:
 
Concatenate Fields
 
12/15/2022
Notes: Concatenate two fields in a record into a new field. The second field can have multiple values per record.
Requirements:
 
Count Matrix Rows with Multiple Column Values
 
12/29/2022
Notes: Given a matrix, count the number of row items that co-occur with more than one column item. Results returned in a popup.
Requirements: A co-occurrence matrix is open with more than one column
Usage: Using cleaned lists, quickly count the number of authors that appear with multiple organizations or patents with multiple assignees.
Count-Frequency Plots
 
12/15/2022
Notes: Create a Count-Frequency plot for each field in the dataset. Attempts to fit a 2nd order polynomial to the log of the distribution.
Requirements: VPv14 Dataset is open
Usage: Intended as a seed for bibliometric exploration of distributions in NLP, keyword, classification, and other fields. see Zhiqiang Bi, Christos Faloutsos and Flip Korn, "The DGX Distribution for Mining Massive, Skewed Data", KDD 2001, San Francisco, CA, August 2001
Create Concept Grid
 
01/26/2023
Requirements:
 
Create Full Coverage Group
 
09/19/2022
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.
Create Sankey Chart
 
03/01/2023
Requirements:
 
Create VizLinkĀ® Chart
 
12/15/2022
Requirements: VantagePoint v14
 
Export List Terms and Groups to Excel
 
08/25/2021
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
 
08/25/2021
Notes: Export an open matrix matrix to tab-delimited, Unicode text file
Requirements: Matrix is open.
 
Export Title List
 
12/15/2022
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
 
12/15/2022
Notes: VP to Gephi.pdf file included with step by step guide for use, will appear in the Macros\Resource folder.
Requirements: VantagePoint version 14. Latest version of Gephi is installed https://gephi.org/
 
Field to Classification
 
08/25/2021
Notes: Create a Record Classification from a field of terms.
Requirements:
 
Make Earliest Date
 
08/25/2021
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.
Make Word Cloud from List Selection
 
12/15/2022
Notes: Makes a Word Cloud of the selected list items.
Requirements:
 
Matrix Column Cross Product
 
08/25/2021
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 Column Sum
 
08/25/2021
Notes: Export to Excel a count of number of row items per column
Requirements: A matrix must be open.
Usage: From a matrix of classifications (rows) by organizations (columns), find the number of unique and total classifications applied to each organizations' records. Note: Script is limited to Excel's maximum of 256 columns.
Matrix Viewer
 
12/15/2022
Notes: View a node-edge representation of a matrix in a browser sheet.
Requirements: Requires VPv15 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.
Pivot Tool
 
11/17/2022
Requirements: VantagePoint v14
 
Plot Emergence Indicators
 
01/26/2023
Requirements:
 
Plot Fields
 
12/29/2022
Notes: Create a Rank by # of records plot for each field in the dataset. Estimate power law coefficients.
Requirements: Requires VantagePoint v15.1. Dataset is open
Usage: Makes a series of small plots in a browser sheet, displayed in a sortable table.
Rebuild Dataset
 
12/15/2022
Requirements: A dataset is open.
Usage: Export all fields to a generic XML format then re-import everything. Used to reset all raw records and fields in datasets that may have corrupted fields.
Record Similarity Plot
 
01/31/2023
Requirements:
 
Scatter Plot
 
02/21/2023
Requirements: VPv14
 
Terms By Year
 
02/15/2023
Notes: Create new field with groups showing which terms appeared in which year (first, last, or all). Offers option to export results to an Excel table.
Requirements: Requires VPv15.1 There is a cleaned year field with at least two items.
Usage: This handy script groups terms by the year they appeared. Grouping by first year is a good way to find who or what only appeared in the dataset recently and what has been around for a while. Grouping by last year can show you which terms have depreciated and are no longer in use. In addition, if you export the Excel report, you can get a total of how many grouped terms appeared in each year. This can be used as an indicator of the maturity of the set (see the "maturity" section of the Analysis Guide).