Changes

2017/11/2 2:30-5:30pm 02 met with Ed; loaded tables for bo, firm, fund into vcdb2 latitude and longitude

2017/10/27 3pm-5pm come up with next steps for matching firms to funds - for geocoding branch offices

2017/10/26 2:30-4:30pm update VC Database Rebuild wiki; identify key for bocore table; verify that fundbasecore table was correctly cleaned after being being rebuilt by Ed

2017/10/24 2:30-5:30pm met with Ed to discuss firmbase and branch office tables; find key for firmbasecore table; remove undisclosed firms

2017/10/12 2:30-5:30pm peer edit and put Shelby's blog post into Wordpress; see what needs to be done on VC project; continue literature review for matching models

2017/10/11 3pm-5pm finished loading tables (firmbase and branchoffice)

2017/10/6 3pm-5:30pm load data using SQL code into tables, which is on [[Retrieving US VC Data From SDC]]

2017/9/29 3pm-5:45pm completed pulling/normalizing data, still need to load data using SQL code into tables, which is on [[Retrieving US VC Data From SDC]]

2017/9/28 2:30-6pm met with Ed, worked on pulling firm and branch office data from SDC

2017/9/22 3pm-5pm join portcos and funds; and begin literature review of matching games/venture capital (located in "Matching Entreps to VC's project folder" on E drive."

2017/9/21 2:30-5:30pm work with Ed on research project

2017/9/19 2:30-5:30pm continue to work on joining portcoexits and roundlinejoiner tables in vcdb2, in MatchingEntrepsToVC folder under project management

2017/9/15 3pm-5pm work on joining portcoexits and roundlinejoiner; create txt file called "Notes on Matching Funds to portcos" in the "Matching Entreps to VC's project folder" on E drive.

2017/9/14 2:30pm-5:30pm build table roundlinejoinerapprop (appropriate the funds between funds; work on joining portcoexits and roundlinejoiner)

2017/9/12 2:30pm-5:30pm 27 rebuild portcoexits and work on apportioning amounts in roundlinejoiner

2017/9/7 3-5pm-5pm work with Ed to familiarize with SQL script for VC project/vcdb2 database

2017/9/7 2:30-5:30pm receive project from Ed; reacquaint with wiki, RDP, etc.