Name
|
Filename
|
Last Update
|
Bubble Chart
|
|
06/14/2019 |
Notes:
|
New: Save and Load templates for common field selections. |
Requirements:
|
A dataset is open with year fields. |
|
Clean Derwent Assignees
|
|
05/22/2017 |
Notes:
|
Change Derwent codes into their most common assignee name unless they are a) -N or -R codes or b) -I codes in a record with a non -I code. |
Requirements:
|
VPv7.1 minimum;
Derwent WPI data with "Patent Assignee Codes" and "Patent Assignees (long)" fields |
|
Close All Views
|
|
07/18/2013 |
Notes:
|
Closes all active views in your dataset - only the Summary sheet will remain. |
Requirements:
|
|
|
Color Cross-Correlation Matrix
|
|
07/18/2013 |
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. |
Concatenate Fields
|
|
09/16/2019 |
Notes:
|
Concatenate two fields in a record into a new field. The second field can have multiple values per record. |
Requirements:
|
|
|
Copy Sheets
|
|
07/18/2013 |
Notes:
|
Attempt to re-create the lists and matrices from one dataset to another. ONLY works with default named lists. |
Requirements:
|
Two datasets are open. The "original" and the target. Only works on lists and matrices. Maps and other sheets will be ignored. |
|
Count Matrix Rows with Multiple Column Values
|
|
10/13/2014 |
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
|
|
06/05/2017 |
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:
|
VPv10
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 Espace patent links
|
|
05/22/2017 |
Notes:
|
Create a field with links to Espace abstracts based on the Patent Number field |
Requirements:
|
VPv7.1 minimum;
File has a clean (no extra spaces) patent number field. |
Usage:
|
This script demonstrates creating and running a thesaurus from within a script. The links could potentially be to anything with a consistent URL. |
Create Full Coverage Group
|
|
06/05/2017 |
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 Image
|
|
12/18/2018 |
Requirements:
|
|
|
Export List Terms and Groups to Excel
|
|
08/27/2019 |
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/04/2016 |
Notes:
|
Export an open matrix matrix to tab-delimited, Unicode text file |
Requirements:
|
Matrix is open. |
|
Export Title List
|
|
07/18/2013 |
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
|
|
05/22/2017 |
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
https://gephi.org/ |
|
Field to Classification
|
|
07/18/2013 |
Notes:
|
Create a Record Classification from a field of terms. |
Requirements:
|
|
|
Get Earliest Year
|
|
05/22/2017 |
Notes:
|
Takes a multi-valued year field (e.g. Priority Years) and creates a new field with only the earliest year for each record. |
Requirements:
|
VPv7.1 minimum;
There is a clean year field |
|
Get Latest Year
|
|
05/22/2017 |
Notes:
|
Takes a multi-valued year field (e.g. Patent Family Publication Years) and creates a new field with only the most recent year for each record. |
Requirements:
|
There is a clean year field |
|
Make Earliest Date
|
|
07/18/2013 |
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
|
|
08/21/2019 |
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 Row Cross Product
|
|
08/21/2019 |
Notes:
|
Export to Excel a cross product of column items by row |
Requirements:
|
A matrix must be open. |
Usage:
|
Use with matrix of records (rows) by keywords or classification (columns) to asses the centrality of each record. Records with many, common terms will have a higher cross-product than records with a few, infrequent terms. |
Matrix Row Sum
|
|
05/22/2017 |
Notes:
|
Export to Excel a count of number of column items per row |
Requirements:
|
A matrix must be open. |
Usage:
|
Similar to MatrixColumnSum but avoids Excel's limits on columns. Can be used to examine the dispersion of vocabulary by calculating the number of organizations or journals (columns) per term (row). |
Open File in Browser Sheet
|
|
06/05/2017 |
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. |
|
Pivot Tool
|
|
08/23/2019 |
Requirements:
|
VantagePoint version 12 |
|
Plot Fields
|
|
05/22/2017 |
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
|
|
08/27/2019 |
Requirements:
|
|
|
Scatter Plot
|
|
11/25/2019 |
Requirements:
|
VPv12 |
|
Statistics
|
|
09/25/2019 |
Notes:
|
Profile the items in a selected field with statistics from a second, numeric field. |
Requirements:
|
|
|
Super Profile
|
|
03/19/2019 |
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
|
|
03/28/2016 |
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. |
|