Jake Silberman (Work Log)

Jake Silberman Work Logs (log page)

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.