Changes

92017-12-1: worked with ed to build tables with firm/22 3pm-5pm join portcos portco data on distance and funds; and begin literature review of matching gamesfund/venture capital (located in "Matching Entreps to VC's project folder" portco data on E drive."performance

9/21 2:302017-11-516:30pm work with Ed on research projectfinished calculating great circle distances between firms, portco's, and branch offices (look at roundlinewithgcd table)

9/19 2:302017-11-514:30pm continue to work worked on joining portcoexits and roundlinejoiner getting all roundline tables in vcdb2down to the firm level, in MatchingEntrepsToVC folder under project managementinstead of fund; running into small problems with calculating gcd between firms and portco's (will discuss with Ed)

9/15 3pm2017-5pm work 11-14: worked on joining portcoexits and roundlinejoineripo information to roundline; create txt file called "Notes on Matching Funds aggregated ipo information to portcos" in the "Matching Entreps to VC's project folder" on E drive.fund level (rather than fund)

9/14 22017-11-09:30pmreloaded firm coords and also fund coords - re-5:30pm build table roundlinejoinerapprop building roundlinewithgcd (appropriate code is written, but fund coords weren't correctly loaded, so this code will be re-run), wrote code for fundtofirms and portcotofirms, but this code will be re-run once the funds between fundsfirm codes are correctly loaded; work working on joining portcoexits and roundlinejoiner)portcoexitmaster to roundlinejoinerlean

9/12 2:30pm2017-11-508:30pm rebuild portcoexits loaded roundlinewithgcd table (calculating gcd between portcos and work funds), created GCD example with notes in datawork folder in MatchingEntrepsToVCs, worked on apportioning amounts in roundlinejoinerbuilding portcostofirms

9/7 32017-5pm11-5pm 07: loaded portcocoords table, joined portcocoords to roundlinejoinerlean, calculate gcd distance between funds and portco's, work with Ed on joining funds to familiarize with SQL script for VC project/vcdb2 databasefirms

9/7 2:302017-11-503:30pm receive project from Edloaded table/sql script for firms office locations into vcdb2 with latitude and longitude coordinates; reacquaint with wikijoined coordinates to all clean base tables for firms, funds, RDPbranch offices, etc.joined co and fund coordinates to roundlinejoinerlean in new table: roundlinecoords

4/12 4pm2017-11-602:30pm finish weekly roundupmet with Ed; loaded tables/sql script for branch office and fund office locations into vcdb2 with latitude and longitude coordinates

4/11 4pm2017-610-27:30pm start weekly roundupcome up with next steps for matching firms to funds - for geocoding branch offices

4/3 4p2017-6pm finish weekly roundup10-26: update VC Database Rebuild wiki; identify key for bocore table; verify that fundbasecore table was correctly cleaned after being being rebuilt by Ed

4/2 12pm2017-4pm start weekly roundup10-24: met with Ed to discuss firmbase and branch office tables; find key for firmbasecore table; remove undisclosed firmsfrom both firmbasecore and bocore

3/27 Finish project page for weekly rounudp2017-10-6: load data using SQL code into tables, create wiki form for all legislation wiki pages with Ramee, begin weekly roundupwhich is on [[Retrieving US VC Data From SDC]]

32017-09-29: completed pulling/21 4pm-6pm Create project page normalizing data, still need to load data using SQL code into tables, which is on wiki for weekly roundup, finish weekly roundup[[Retrieving US VC Data From SDC]]

3/20 122017-4pm Create Weekly Roundup09-28: met with Ed, worked on pulling firm and branch office data from SDC

3/92017-09-22: join portcos and funds; and begin literature review of matching games/17 4pm-6pm finish weekly roundup postventure capital (located in "Matching Entreps to VC's project folder" on E drive."

3/7/17 4pm2017-6pm continue weekly roundup post09-21: work with Ed on research project

3/6/17 2pm2017-4pm start weekly roundup post09-19: continue to work on joining portcoexits and roundlinejoiner tables in vcdb2, in MatchingEntrepsToVC folder under project management

3/3/17 4pm2017-6pm finish weekly roundup post09-15: 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.

2/28/17 4:002017-09-614:00pm continue weekly roundup blog postbuild table roundlinejoinerapprop (appropriate the funds between funds; work on joining portcoexits and roundlinejoiner)

2/2017-09-27/17 2:00pm - 4:00pm start weekly roundup postrebuild portcoexits and work on apportioning amounts in roundlinejoiner

2/23/17 4:002017-09-607:00pm finish weekly roundup blog postwork with Ed to familiarize with SQL script for VC project/vcdb2 database

2/21/17 4:002017-09-605:00pm continue weekly roundup blog postreceive project from Ed; reacquaint with wiki, RDP, etc.</onlyinclude>

2/16/17 4:00pm2017-04-612:00pm Publish finish weekly roundup blog post

2/14/17 4:00pm2017-04-611:00pm continue start weekly roundup blog post

2/13/17 2:002017-04-403:00pm Start finish weekly roundup blog post

2/2/17 1:002017-04-302:00pm Finish start weekly roundup blog post

2/1/17 1:002017-03-330:00pm Work on finish weekly roundup blog post

1/30/17 1:002017-03-428:00pm Work continue working on weekly roundup blog post

1/26/17 4:002017-03-627:00pm Finish on project page for weekly rounudp, create wiki form for all legislation wiki pages with Ramee, begin weekly roundup blog post

1/24/17 4:002017-03-621:00pm Work Create project page on wiki for weekly roundup, finish weekly roundup blog post

1/23/17 2:002017-03-420:00pm Work on weekly roundup blog postCreate Weekly Roundup

11/18 publish 2017-03-07: continue weekly rounduppost

11/17 2:302017-03-406:00pm finish content for Weekly start weekly roundup; edit Tay's blog post

11/16 10:00am2017-03-1203:00pm work on content for Weekly finish weekly rounduppost

11/15 2:302017-02-628:00pm continue weekly roundup 11/18; work on FTC merger/non-merger acquisitions actions spreadsheetblog post

11/10 3:002017-02-527:00pm put start weekly roundups into wordpressroundup post

11/9 10:002017-02-1223:00am finish weekly roundup contentblog post

11/8 3:302017-02-621:00pm work on continue weekly roundup entrepreneurship blog post

11/4 3:002017-02-520:00pm finalize Start weekly roundup; edit ACA postsblog post

11/3 3:302017-02-516:30pm SQL training; Edit Publish weekly roundup blog post

11/2 10:00am2017-02-1214:00pm finish Weekly continue weekly roundup blog post

11/1 3:002017-02-613:00pm edit Avesh's Start weekly roundup blog post; draft weekly round-up post

10/27 12:00pm2017-02-402:00pm edit Eliza's Finish weekly roundup blog post, work on weekly round-up, and attend SQL training with Ed

10/26 10:002017-02-1201:00am finish editing ACA articles, submit Tay for peer editingWork on weekly roundup blog post

10/25 2:2017-01-30-4:30pm draft first Work on weekly round-up roundup blog post

10/24 5:002017-01-626:00pm meet with Avesh, Anne, and Ed to discuss Finish on weekly roundup blog post

10/21 3:002017-01-324:45pm Attend blogger's meetingWork on weekly roundup blog post

10/21 2:302017-01-423:00pm incorporate Anne's edits to ACA articles; add information to education innovation summaryWork on weekly roundup blog post

10/18 2:302017-11-529:30pm find tweets, re-write descriptions work on Accelerator project; add content for small business resourcesWeekly Roundup

10/14 3:002017-11-518:00pm finish ACA articlepublish weekly roundup

10/13 2:302017-11-517:30pm work on finding tweet material, finish content for Weekly roundup; edit ACA post, and look into education/innovation Tay's blog post

10/12 10:002017-11-1216:00am work on trimming down ACA blog postcontent for Weekly roundup

10/2017-11 2-15:30weekly roundup 11/18; work on FTC merger/non-5:30pm Continue editing ACA blog post, incorporating Anne's commentsmerger acquisitions actions spreadsheet

2017-11-10/10 2:30-5:30pm Work on ACA blog post, adding sourcesput weekly roundups into wordpress

10/7 3:002017-11-609:00pm work on carried interest research, find tweets, edit ACA articlefinish weekly roundup content

10/6 2:302017-11-508:30pm Add information work on resources wiki pages for SBDE projectweekly roundup entrepreneurship

10/5/16 10:00am2017-11-1204:00pm Research info on organizations for SBDE projectfinalize roundup; edit ACA posts

9/28/16 10:00am2017-11-103:00pm Work on govtrack bill table on Innovation Policy PageSQL training; Edit weekly roundup post

9/27/16 2:302017-11-502:30 upload ACA to wiki; talk to Ed/Anne about new project (VC carried interest; bill analysis on 6 innovation bills)finish Weekly roundup post

9/23/16 3:002017-11-501:00 finish ACAedit Avesh's blog post; send over to Annedraft weekly round-up post

9/22/16 2:302017-10-527:30 edit Eliza's blog post, work on ACA health care articleweekly round-up, and attend SQL training with Ed

9/21/16 2017-10:00-1226:00 Look finish editing ACA articles, submit Tay for more material/data for health care article, specifically related to election 2016; find a tweetpeer editing

9/20/16 2:302017-10-525:30 Finish editing health care article (include sources), redraft first weekly round-share with Anne; look into possible articles on women in small business; look over Dylan's ACA and entrepreneurship articleup post

9/15/16 2:302017-10-524:30 Work on editing health care document (incorporating edits from Ann); look up women in entrepreneurship research topicsmeet with Avesh, Anne, and Ed to discuss weekly roundup blog post

9/14/16 2017-10:00am-1221:00am Research viable subjects for health care innovation, role of health care regulation in 2016 election for articlesAttend blogger's meeting. Submit two twitter Incorporate Anne's edits to ACA articles. Review Accenture health articles.; add information to education innovation summary

9/13/16 2:30pm2017-10-519:30pm Finish up editing old finish dividing two ACA article (share with Anne), articles; help edit wiki pages for small business development ecosystem; work on ACA/candidates article, submit two tweets for twitter channeleducation innovation summary

9/09/16 32017-10-18:00pmfind tweets, re-5:00pm Set up blog post in google docs (on health care and write descriptions for small businesses, and health care and the election) to share with Anne and Dylanbusiness resources

9/08/16 300pm2017-510-14:30-pm Twitter meeting with Anne, Albert, Carlin, Ramee, and Avesh; Resolve RDP issue; figure out new project plan, look at new developments with health care and small business (look at Dylan's edits to health care/innovation)finish ACA article

92017-10-13: work on finding tweet material, edit ACA post, and look into education/innovation blog post 2017-10-12: work on trimming down ACA blog post 2017-10-11: Continue editing ACA blog post, incorporating Anne's comments 2017-10-10: Work on ACA blog post, adding sources 2017-10-07: work on carried interest research, find tweets, edit ACA article 2017-10-06: Add information on resources wiki pages for SBDE project 2017-10-05: Research info on organizations for SBDE project 2017-09-28: Work on govtrack bill table on Innovation Policy Page 2017-09-27: upload ACA to wiki; talk to Ed/Anne about new project (VC carried interest; bill analysis on 6 innovation bills) 2017-09-23: finish ACA; send over to Anne 2017-09-22: work on ACA health care article 2017-09-21: Look for more material/data for health care article, specifically related to election 2016; find a tweet 2017-09-20: Finish editing health care article (include sources), re-share with Anne; look into possible articles on women in small business; look over Dylan's ACA and entrepreneurship article 2017-09-15: Work on editing health care document (incorporating edits from Ann); look up women in entrepreneurship research topics 2017-09-14: Research viable subjects for health care innovation, role of health care regulation in 2016 election for articles. Submit two twitter articles. Review Accenture health articles. 2017-09-13: Finish up editing old ACA article (share with Anne), work on ACA/16 10candidates article, submit two tweets for twitter channel 2017-09-09:00amSet up blog post in google docs (on health care and small businesses, and health care and the election) to share with Anne and Dylan 2017-1209-08: Twitter meeting with Anne, Albert, Carlin, Ramee, and Avesh; Resolve RDP issue; figure out new project plan, look at new developments with health care and small business (look at Dylan's edits to health care/innovation) 2017-09-07:00pm Reviewed blog posts, searched possible blog topics, looked up articles for twitter. Will try to resolve issues with RDP on Wednesday. 2017-09-06: Set up bio page, work logs, looked at blog posts