Changes

42017-12-1: worked with ed to build tables with firm/portco data on distance and fund/11 4pm-6pm start weekly roundupportco data on performance

4/3 4p2017-6pm finish weekly roundup11-16: finished calculating great circle distances between firms, portco's, and branch offices (look at roundlinewithgcd table)

4/2 12pm2017-4pm start weekly roundup11-14: worked on getting all roundline tables down to the firm level, instead of fund; running into small problems with calculating gcd between firms and portco's (will discuss with Ed)

3/28 continue 2017-11-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 weekly roundupjoining portcoexitmaster to roundlinejoinerlean

3/27 Finish project page for weekly rounudp2017-11-08: loaded roundlinewithgcd table (calculating gcd between portcos and funds), create wiki form for all legislation wiki pages created GCD example with Rameenotes in datawork folder in MatchingEntrepsToVCs, begin weekly roundupworked on building portcostofirms

3/21 4pm2017-6pm Create project page 11-07: loaded portcocoords table, joined portcocoords to roundlinejoinerlean, calculate gcd distance between funds and portco's, work on wiki for weekly roundup, finish weekly roundupjoining funds to firms

32017-11-03: loaded table/20 12-4pm Create Weekly Roundupsql 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: roundlinecoords

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

3/7/17 4pm2017-6pm continue weekly roundup post10-27: come up with next steps for matching firms to funds - for geocoding branch offices

3/6/17 2pm2017-4pm start weekly roundup post10-26: update VC Database Rebuild wiki; identify key for bocore table; verify that fundbasecore table was correctly cleaned after being being rebuilt by Ed

3/3/17 4pm2017-6pm finish weekly roundup post10-24: met with Ed to discuss firmbase and branch office tables; find key for firmbasecore table; remove undisclosed firmsfrom both firmbasecore and bocore

2/28/17 4:002017-10-612:00pm continue weekly roundup peer edit and put Shelby's blog postinto Wordpress; see what needs to be done on VC project; continue literature review for matching models

2/27/17 2:00pm 2017-10- 411:00pm start weekly roundup postfinished loading tables (firmbase and branchoffice)

2/23/17 4:002017-10-6:00pm finish weekly roundup blog postload data using SQL code into tables, which is on [[Retrieving US VC Data From SDC]]

2/21/17 4:002017-09-629:00pm continue weekly roundup blog postcompleted pulling/normalizing data, still need to load data using SQL code into tables, which is on [[Retrieving US VC Data From SDC]]

2/20/17 2:002017-09-428:00pm Start weekly roundup blog postmet with Ed, worked on pulling firm and branch office data from SDC

2/16/17 4:00pm2017-09-622:00pm Publish weekly roundup blog postjoin portcos and funds; and begin literature review of matching games/venture capital (located in "Matching Entreps to VC's project folder" on E drive."

2/14/17 4:00pm2017-09-621:00pm continue weekly roundup blog postwork with Ed on research project

2/13/17 2:002017-09-419:00pm Start weekly roundup blog postcontinue to work on joining portcoexits and roundlinejoiner tables in vcdb2, in MatchingEntrepsToVC folder under project management

2/2/17 1:002017-09-315:00pm Finish weekly roundup blog 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/1/17 1:002017-09-314:00pm Work build table roundlinejoinerapprop (appropriate the funds between funds; work on weekly roundup blog postjoining portcoexits and roundlinejoiner)

1/30/17 1:002017-09-427:00pm Work rebuild portcoexits and work on weekly roundup blog postapportioning amounts in roundlinejoiner

1/26/17 4:002017-09-607:00pm Finish on weekly roundup blog postwork with Ed to familiarize with SQL script for VC project/vcdb2 database

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

2017-04-11/18 publish : start weekly roundup

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

11/16 10:00am2017-04-1202:00pm work on content for Weekly start weekly roundup

11/15 2:2017-03-30-6:00pm finish weekly roundup 11/18; work on FTC merger/non-merger acquisitions actions spreadsheet

11/10 3:002017-03-528:00pm put continue working on weekly roundups into wordpressroundup

11/9 10:002017-03-1227:00am finish Finish project page for weekly rounudp, create wiki form for all legislation wiki pages with Ramee, begin weekly roundup content

11/8 3:302017-03-621:00pm work Create project page on wiki for weekly roundup, finish weekly roundup entrepreneurship

11/4 3:002017-03-520:00pm finalize roundup; edit ACA postsCreate Weekly Roundup

11/3 3:302017-03-509:30pm SQL training; Edit finish weekly roundup post

11/2 10:00am2017-03-1207:00pm finish Weekly continue weekly roundup post

11/1 3:002017-03-606:00pm edit Avesh's blog post; draft start weekly round-up roundup post

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

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

10/25 2:302017-02-427:30pm draft first start weekly round-up roundup post

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

10/2017-02-21 3:00-3:45pm Attend blogger's meetingcontinue weekly roundup blog post

10/21 2:302017-02-420:00pm incorporate Anne's edits to ACA articles; add information to education innovation summaryStart weekly roundup blog post

10/19 3:002017-02-616:00pm finish dividing two ACA articles; help edit wiki pages for small business development ecosystem; work on education innovation summaryPublish weekly roundup blog post

10/18 2:302017-02-514:30pm find tweets, re-write descriptions for small business resourcescontinue weekly roundup blog post

10/14 3:002017-02-513:00pm finish ACA articleStart weekly roundup blog post

10/13 2:302017-02-502:30pm work on finding tweet material, edit ACA post, and look into education/innovation Finish weekly roundup blog post

10/12 10:002017-02-1201:00am work Work on trimming down ACA weekly roundup blog post

10/11 2:2017-01-30-5:30pm Continue editing ACA Work on weekly roundup blog post, incorporating Anne's comments

10/10 2:302017-01-526:30pm Work Finish on ACA weekly roundup blog post, adding sources

10/7 3:002017-01-624:00pm work Work on carried interest research, find tweets, edit ACA articleweekly roundup blog post

10/6 2:302017-01-523:30pm Add information Work on resources wiki pages for SBDE projectweekly roundup blog post

9/28/16 10:00am2017-11-129:00pm Work on govtrack bill table work on Innovation Policy PageAccelerator project; add content for Weekly Roundup

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

9/23/16 3:002017-11-517:00 finish ACAcontent for Weekly roundup; send over to Anneedit Tay's blog post

9/22/2017-11-16 2:30-5:30 work on ACA health care articlecontent for Weekly roundup

9/21/16 10:002017-11-1215:00 Look for more materialweekly roundup 11/data for health care article, specifically related to election 201618; find a tweetwork on FTC merger/non-merger acquisitions actions spreadsheet

9/20/16 2:302017-11-510:30 Finish editing health care article (include sources), re-share with Anne; look put weekly roundups into possible articles on women in small business; look over Dylan's ACA and entrepreneurship articlewordpress

9/15/16 2:302017-11-509:30 Work on editing health care document (incorporating edits from Ann); look up women in entrepreneurship research topicsfinish weekly roundup content

9/14/16 10:00am2017-11-1208: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.work on weekly roundup entrepreneurship

9/13/16 2:30pm2017-11-504:30pm Finish up editing old ACA article (share with Anne), work on finalize roundup; edit ACA/candidates article, submit two tweets for twitter channelposts

9/09/16 3:00pm2017-11-503:00pm Set up blog SQL training; Edit weekly roundup post in google docs (on health care and small businesses, and health care and the election) to share with Anne and Dylan

9/08/16 300pm2017-511-02: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 Weekly roundup post

92017-11-01: edit Avesh's blog post; draft weekly round-up post 2017-10-27: edit Eliza's blog post, work on weekly round-up, and attend SQL training with Ed  2017-10-26: finish editing ACA articles, submit Tay for peer editing 2017-10-25: draft first weekly round-up post 2017-10-24: meet with Avesh, Anne, and Ed to discuss weekly roundup blog post 2017-10-21: Attend blogger's meeting. Incorporate Anne's edits to ACA articles; add information to education innovation summary 2017-10-19: finish dividing two ACA articles; help edit wiki pages for small business development ecosystem; work on education innovation summary 2017-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/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:Set 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-08:00amTwitter 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-1207: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