Changes

#*Get the source file for the LBOs

#*Clean it up:<code>E:\McNair\Projects\LBO\LBO_cleaned_data.xlsx </code> Names of LBO's/deal numbers with extraneous symbols and words removed

#*Match it against itself:<code>E:\McNair\Software\Scripts\Matcher\Output\LBO_cleaned_data.txt-LBO_cleaned_data.txt.matched </code> Original matched data:<code>E:\McNair\Projects\LBO\LBO_cleaned_data_duplicates_removed</code>#*Get the patent data##**Draw the distinct assignees:<code>Z:\allpatentsprocessed\DistinctAssignees2</code>##**Match them against themselves::<code>Z:\allpatentsprocessed\DistinctAssignees2matched</code>#*Load the LBO data into a dbase

#*match the LBO data to the patent data

#*all data under allpatentsprocessed database

##**Join patent data to assignee data, creating firstjoin_cleaned **again, just look inside database

##**join firstjoin_cleaned to matchassignees data, creating secondjoin_cleaned

##**join secondjoin_cleaned to lbopatentmatch data, creating thirdjoin_cleaned. This final step matches the LBO data with the patent data, creating a list of LBO's and their patents

*<code>Z:\allpatentsprocessed\LBO Patent Data Joined</code>