Matching VentureOne (Data)

McNair Project

Matching VentureOne (Data)
Project Information
Project Title
Start Date
Deadline
Primary Billing
Notes
Has project status
Copyright © 2016 edegan.com. All Rights Reserved.

Data

1. Get the source file for the LBOs

E:\McNair\Projects\Venture One Data\Venture Data 1.xlsx Original data source

1. Clean it up

E:\McNair\Software\Scripts\Matcher\Input\Venture Data 1.txt extraneous symbols and words removed

1. Match it against itself

E:\McNair\Projects\Venture One Data\Cleaned and Matched Data.xlsx

1. Get the patent data
   1. Draw the distinct assignees
   2. Match them against themselves
2. Load the LBO data into a dbase