Changes

9/19 2:302017-12-51:30pm continue worked with ed to work build tables with firm/portco data on joining portcoexits distance and roundlinejoiner tables in vcdb2 and begin literature review of matching games involving venture capital, in MatchingEntrepsToVC folder under project managementfund/portco data on performance

9/15 3pm2017-5pm work on joining portcoexits and roundlinejoiner; create txt file called "Notes on Matching Funds to portcos" in the "Matching Entreps to VC11-16: finished calculating great circle distances between firms, portco's project folder" on E drive., and branch offices (look at roundlinewithgcd table)

9/2017-11-14 2:30pm-5:30pm build table roundlinejoinerapprop (appropriate worked on getting all roundline tables down to the funds firm level, instead of fund; running into small problems with calculating gcd between funds; work on joining portcoexits firms and roundlinejoinerportco's (will discuss with Ed)

9/12 2:30pm2017-11-514:30pm rebuild portcoexits and work worked on apportioning amounts in roundlinejoinerjoining ipo information to roundline; aggregated ipo information to the fund level (rather than fund)

9/7 32017-5pm11-5pm work with Ed 09: reloaded firm coords and also fund coords - re-building roundlinewithgcd (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 firm codes are correctly loaded; working on joining portcoexitmaster to familiarize with SQL script for VC project/vcdb2 databaseroundlinejoinerlean

9/7 2:302017-11-508:30pm receive project from Ed; reacquaint loaded roundlinewithgcd table (calculating gcd between portcos and funds), created GCD example with wiki, RDPnotes in datawork folder in MatchingEntrepsToVCs, etc.worked on building portcostofirms

4/12 4pm2017-611-07:30pm finish weekly rounduploaded portcocoords table, joined portcocoords to roundlinejoinerlean, calculate gcd distance between funds and portco's, work on joining funds to firms

4/2017-11 4pm-603: loaded table/sql script for firms office locations into vcdb2 with latitude and longitude coordinates; joined coordinates to all clean base tables for firms, funds, branch offices, joined co and fund coordinates to roundlinejoinerlean in new table:30pm start weekly rounduproundlinecoords

42017-11-02: met with Ed; loaded tables/3 4p-6pm finish weekly roundupsql script for branch office and fund office locations into vcdb2 with latitude and longitude coordinates

4/2 12pm2017-4pm start weekly roundup10-27: come up with next steps for matching firms to funds - for geocoding branch offices

3/27 Finish 2017-10-12: peer edit and put Shelby's blog post into Wordpress; see what needs to be done on VC project page ; continue literature review for weekly rounudp, create wiki form for all legislation wiki pages with Ramee, begin weekly roundupmatching models

3/21 4pm2017-6pm Create project page on wiki for weekly roundup, finish weekly roundup10-11: finished loading tables (firmbase and branchoffice)

3/20 122017-4pm Create Weekly Roundup10-6: load data using SQL code into tables, which is on [[Retrieving US VC Data From SDC]]

3/92017-09-29: completed pulling/17 4pm-6pm finish weekly roundup postnormalizing data, still need to load data using SQL code into tables, which is on [[Retrieving US VC Data From SDC]]

3/7/17 4pm2017-6pm continue weekly roundup post09-28: met with Ed, worked on pulling firm and branch office data from SDC

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

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

2/28/17 4:002017-09-619:00pm continue weekly roundup blog postto work on joining portcoexits and roundlinejoiner tables in vcdb2, in MatchingEntrepsToVC folder under project management

2/27/17 2:00pm 2017-09- 415:00pm start weekly roundup postwork 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/23/17 4:002017-09-614:00pm finish weekly roundup blog postbuild table roundlinejoinerapprop (appropriate the funds between funds; work on joining portcoexits and roundlinejoiner)

2/21/17 4:002017-09-627:00pm continue weekly roundup blog postrebuild portcoexits and work on apportioning amounts in roundlinejoiner

2/20/17 2:002017-09-407:00pm Start weekly roundup blog postwork with Ed to familiarize with SQL script for VC project/vcdb2 database

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

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

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

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

1/30/17 1:002017-04-402:00pm Work on start weekly roundup blog post

1/26/17 4:002017-03-630:00pm Finish on finish weekly roundup blog post

1/24/17 4:002017-03-628:00pm Work continue working on weekly roundup blog post

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

11/29 work 2017-03-21: Create project page on Accelerator project; add content wiki for Weekly Roundupweekly roundup, finish weekly roundup

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

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

11/15 2:302017-03-606:00pm start weekly roundup 11/18; work on FTC merger/non-merger acquisitions actions spreadsheetpost

11/10 3:002017-03-503:00pm put finish weekly roundups into wordpressroundup post

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

11/8 3:302017-02-627:00pm work on start weekly roundup entrepreneurship post

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

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

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

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

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

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

10/25 2:302017-02-402:30pm draft first Finish weekly round-up roundup blog post

10/24 5:002017-02-601:00pm meet with Avesh, Anne, and Ed to discuss Work on weekly roundup blog post

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

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

10/19 3:002017-01-624:00pm finish dividing two ACA articles; help edit wiki pages for small business development ecosystem; work Work on education innovation summaryweekly roundup blog post

10/18 2:302017-01-523:30pm find tweets, re-write descriptions for small business resourcesWork on weekly roundup blog post

10/13 2:302017-11-529:30pm work on finding tweet material, edit ACA post, and look into education/innovation blog postAccelerator project; add content for Weekly Roundup

10/12 10:002017-11-1218:00am work on trimming down ACA blog postpublish weekly roundup

10/2017-11 2:30-517:30pm Continue editing ACA finish content for Weekly roundup; edit Tay's blog post, incorporating Anne's comments

10/10 2:302017-11-516:30pm Work work on ACA blog post, adding sourcescontent for Weekly roundup

10/7 3:002017-11-615:00pm weekly roundup 11/18; work on carried interest research, find tweets, edit ACA articleFTC merger/non-merger acquisitions actions spreadsheet

2017-11-10/6 2:30-5:30pm Add information on resources wiki pages for SBDE projectput weekly roundups into wordpress

10/5/16 10:00am2017-11-1209:00pm Research info on organizations for SBDE projectfinish weekly roundup content

9/28/16 10:00am2017-11-108:00pm Work on govtrack bill table work on Innovation Policy Pageweekly roundup entrepreneurship

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

9/23/16 3:002017-11-503:00 finish ACASQL training; send over to AnneEdit weekly roundup post

9/22/16 2:302017-11-502:30 work on ACA health care articlefinish Weekly roundup post

9/21/16 10:002017-11-1201:00 Look for more material/data for health care article, specifically related to election 2016edit Avesh's blog post; find a tweetdraft weekly round-up post

9/20/16 2:302017-10-527:30 Finish editing health care article (include sources)edit Eliza's blog post, rework on weekly round-share up, and attend SQL training with Anne; look into possible articles on women in small business; look over Dylan's ACA and entrepreneurship articleEd

9/15/16 2:302017-10-526:30 Work on finish editing ACA articles, submit Tay for peer editing health care document (incorporating edits from Ann); look up women in entrepreneurship research topics

9/14/16 2017-10-25:00amdraft first weekly round-12:00am 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.up post

9/13/16 2:30pm2017-10-524:30pm Finish up editing old ACA article (share meet with Avesh, Anne), work on ACA/candidates article, submit two tweets for twitter channeland Ed to discuss weekly roundup blog post

9/09/16 3:00pm2017-10-521:00pm Set up blog post in google docs (on health care and small businesses, and health care and the election) Attend blogger's meeting. Incorporate Anne's edits to share with Anne and DylanACA articles; add information to education innovation summary

9/08/16 300pm2017-510-19:30-pm Twitter meeting with Anne, Albert, Carlin, Ramee, and Avesh; Resolve RDP issuefinish dividing two ACA articles; figure out new project plan, look at new developments with health care and help edit wiki pages for small business (look at Dylan's edits to health care/development ecosystem; work on education innovation)summary

92017-10-18: find tweets, re-write descriptions for small business resources 2017-10-14: finish ACA article 2017-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/16 10Anne 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/candidates 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-09-1208: 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