Jake Silberman (Work Log)
Summer 2016
06/01/2016 15:52 - Introduction/Wiki building
06/02/2016 14:22 - Project refinement & reorganization
06/03/2016 13:30 - Public wiki page development
06/06/2016 13:51 - Further public wiki development
06/07/2016 13:22 - Carried interest debate wiki page writing
06/08/2016 14:54 - Finishing Carried interest debate wiki page, beginning research on history of leveraged buyouts for wiki/blog post
06/09/2016 15:53 - Transfer of wiki pages from private to public
06/10/2016 15:42 - Finished Carried Interest Blog Post
06/13/2016 15:09 - Working on LBO data to match it with patent data
06/14/2016 15:22 - More work on LBO data
06/15/2016 15:20 - Finished work on LBO Data
06/16/2016 15:12 - Beginning of research for LBO academic paper, looking at other scholarly papers
06/20/2016 15:38 - Finding more scholarly papers and writing litreviews, then examining potential variables for the LBO paper
07/15/2016 11:00 - Creating research plan page, updating work log, finalizing hazard models, see Leveraged Buyout Innovation (Academic Paper) for general summary of work since 06/16/2016
07/18/2016 15:00 - Pulling extra SDC data on LBO's, adjusting work on project to Brian's specs
07/19/2016 12:01 - Repulling SDC data with new variables, normalizing SDC data, then matching SDC data and private to private LBO data from the original LBO data to the working set in order to get more LBO matches.
07/20/2016 14:00 - Joining new LBO deals in the 5000s to working data set
07/26/2016 15:52 - finished incorporating 5000s lbo deals into data set, now beginning reorganization of scripts and past work to make it simpler/easier to follow and execute
07/27/2016 11:25 - Reorganizing scripts and helping Ed/James Brander with Winner's Curse.
07/28/2016 12:00 - Cleaning LBO SQL scripts
07/29/2016 13:45 - Cleaning LBO SQL scripts and helping Ed/James Brander a bit more with Winner's Curse
08/01/2016 13:57 - Examining corporate governance databases to solidify measures for Winner's Curse
=Fall 2016
09/06/2016 13:00 - Getting reacquainted with the LBO Project
09/08/2016 13:10 - Continuing research into data for Winner's Curse
09/15/2016 15:04 - Finding variables/data sources for Winner's Curse
Spring 2017
02/13/2017 10:30 - Locating variables for Venture Capital (Data) in SDC
02/15/2017 10:08 - Trying to locate several more variables for Venture Capital (Data) in SDC, then begin work to make data sets in SQL
02/17/2017 12:18 - Running SDC pulls for Company Level, Main Round, and Round on One Line (if Main Round finishes up).
02/20/2017 10:22 - Normalizing Main Round, organizing data in folders
02/22/2017 10:00 - Pulling Round on One Line (and normalizing, as long as it doesn't crash), and creating database in SQL to import them into
03/06/2017 11:12 - Beginning work for Venture Capital Data Issue Brief
03/08/2017 11:42 - Did first SDC Pull for VC Data and began cleaning data/making graphs
03/22/2017 11:15 - Redid SDC Pulls with final variables, wrote research plan
03/27/2017 10:00 - Normalizing SDC data, cleaning data/making graphs, work in E:\McNair\Projects\VentureCapitalData\VCData Pull 2 Normalized
04/05/2017 11:30 - Normalized and loaded SDC pulls into 'vcdata' database
04/19/2017 11:20 - Completed SEL deal, investment, rounds, and IPO tables. Code found in E:\McNair\Projects\VentureCapitalData\SQL Scripts and tables in 'vcdata' database
04/25/2017 14:55 - Worked on adding extra IPO data to old IPO table, seemed that there were no new IPOs in the data. Final tables so far found in 'vcdata' database. Names of final tables so far are sel3, investments3, rounds2, and ipo2. Merger and acquistion data in table MA.
