Changes

11/15 2:302017-12-61:00pm weekly roundup 11worked with ed to build tables with firm/18; work portco data on FTC mergerdistance and fund/non-merger acquisitions actions spreadsheetportco data on performance

2017-11/10 3:00-516:00pm put weekly roundups into wordpressfinished calculating great circle distances between firms, portco's, and branch offices (look at roundlinewithgcd table)

2017-11/9 10:00-1214:00am finish weekly roundup content 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)

2017-11/8 3:30-614:00pm work worked on weekly roundup entrepreneurship joining ipo information to roundline; aggregated ipo information to the fund level (rather than fund)

2017-11/4 3-09:00reloaded 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-5:00pm finalize rounduprun), wrote code for fundtofirms and portcotofirms, but this code will be re-run once the firm codes are correctly loaded; edit ACA postsworking on joining portcoexitmaster to roundlinejoinerlean

2017-11/3 3:30-508:30pm SQL training; Edit weekly roundup postloaded roundlinewithgcd table (calculating gcd between portcos and funds), created GCD example with notes in datawork folder in MatchingEntrepsToVCs, worked on building portcostofirms

2017-11/2 10:00am-1207:00pm finish Weekly roundup postloaded portcocoords table, joined portcocoords to roundlinejoinerlean, calculate gcd distance between funds and portco's, work on joining funds to firms

2017-11/1 3:00-603:00pm edit Avesh's blog postloaded table/sql script for firms office locations into vcdb2 with latitude and longitude coordinates; draft weekly round-up postjoined coordinates to all clean base tables for firms, funds, branch offices, joined co and fund coordinates to roundlinejoinerlean in new table: roundlinecoords

10/27 12:00pm2017-11-402:00pm edit Eliza's blog post, work on weekly round-up, met with Ed; loaded tables/sql script for branch office and attend SQL training fund office locations into vcdb2 with Ed latitude and longitude coordinates

2017-10/26 10-27:00come up with next steps for matching firms to funds -12:00am finish editing ACA articles, submit Tay for peer editinggeocoding branch offices

2017-10/25 2:30-426:30pm draft first weekly round-up postupdate 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 5:00-6:00pm meet met with Avesh, Anne, and Ed to discuss weekly roundup blog postfirmbase and branch office tables; find key for firmbasecore table; remove undisclosed firmsfrom both firmbasecore and bocore

2017-10/21 3:00-312:45pm Attend bloggerpeer edit and put Shelby's meetingblog post into Wordpress; see what needs to be done on VC project; continue literature review for matching models

2017-10/21 2:30-411:00pm incorporate Anne's edits to ACA articles; add information to education innovation summaryfinished loading tables (firmbase and branchoffice)

2017-10/19 3:00-6:00pm finish dividing two ACA articles; help edit wiki pages for small business development ecosystem; work load data using SQL code into tables, which is on education innovation summary[[Retrieving US VC Data From SDC]]

10/18 2:302017-09-529:30pm find tweetscompleted pulling/normalizing data, re-write descriptions for small business resourcesstill need to load data using SQL code into tables, which is on [[Retrieving US VC Data From SDC]]

10/14 3:002017-09-528:00pm finish ACA articlemet with Ed, worked on pulling firm and branch office data from SDC

10/13 2:302017-09-522:30pm work on finding tweet material, edit ACA post, join portcos and funds; and look into educationbegin literature review of matching games/innovation blog postventure capital (located in "Matching Entreps to VC's project folder" on E drive."

10/12 10:002017-09-1221:00am work with Ed on trimming down ACA blog postresearch project

10/11 2:302017-09-519:30pm Continue editing ACA blog postcontinue to work on joining portcoexits and roundlinejoiner tables in vcdb2, incorporating Anne's commentsin MatchingEntrepsToVC folder under project management

10/10 2:302017-09-515:30pm Work 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 ACA blog post, adding sourcesE drive.

10/7 3:002017-09-614:00pm build table roundlinejoinerapprop (appropriate the funds between funds; work on carried interest research, find tweets, edit ACA articlejoining portcoexits and roundlinejoiner)

10/6 2:302017-09-527:30pm Add information rebuild portcoexits and work on resources wiki pages for SBDE projectapportioning amounts in roundlinejoiner

10/5/16 10:00am2017-09-1207:00pm Research info on organizations work with Ed to familiarize with SQL script for SBDE VC project/vcdb2 database

9/28/16 10:00am2017-09-105:00pm Work on govtrack bill table on Innovation Policy Pagereceive project from Ed; reacquaint with wiki, RDP, etc.</onlyinclude>

9/23/16 3:002017-04-512:00 finish ACA; send over to Anneweekly roundup

9/22/16 2:302017-04-511:30 work on ACA health care articlestart weekly roundup

9/21/16 10:002017-04-1203:00 Look for more material/data for health care article, specifically related to election 2016; find a tweetfinish weekly roundup

9/20/16 2:302017-04-502:30 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 articlestart weekly roundup

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

9/14/16 10:00am2017-03-1228: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.continue working on weekly roundup

9/13/16 2:30pm2017-03-527:30pm Finish up editing old ACA article (share project page for weekly rounudp, create wiki form for all legislation wiki pages with Anne)Ramee, work on ACA/candidates article, submit two tweets for twitter channelbegin weekly roundup

9/09/16 3:00pm2017-03-521:00pm Set up blog post in google docs (Create project page on health care and small businesseswiki for weekly roundup, and health care and the election) to share with Anne and Dylanfinish weekly roundup

9/08/16 300pm2017-503-20: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)Create Weekly Roundup

9/07/16 10:00am2017-03-1209:00pm Reviewed blog posts, searched possible blog topics, looked up articles for twitter. Will try to resolve issues with RDP on Wednesday.finish weekly roundup post

92017-03-07: continue weekly roundup post 2017-03-06: start weekly roundup post 2017-03-03: finish weekly roundup post 2017-02-28: continue weekly roundup blog post 2017-02-27: start weekly roundup post 2017-02-23: finish weekly roundup blog post 2017-02-21: continue weekly roundup blog post 2017-02-20: Start weekly roundup blog post 2017-02-16: Publish weekly roundup blog post 2017-02-14: continue weekly roundup blog post 2017-02-13: Start weekly roundup blog post 2017-02-02: Finish weekly roundup blog post 2017-02-01: Work on weekly roundup blog post 2017-01-30: Work on weekly roundup blog post 2017-01-26: Finish on weekly roundup blog post 2017-01-24: Work on weekly roundup blog post 2017-01-23: Work on weekly roundup blog post ===Fall 2016=== 2017-11-29: work on Accelerator project; add content for Weekly Roundup 2017-11-18: publish weekly roundup 2017-11-17: finish content for Weekly roundup; edit Tay's blog post 2017-11-16: work on content for Weekly roundup 2017-11-15:weekly roundup 11/18; work on FTC merger/non-merger acquisitions actions spreadsheet 2017-11-10: put weekly roundups into wordpress 2017-11-09: finish weekly roundup content 2017-11-08: work on weekly roundup entrepreneurship  2017-11-04: finalize roundup; edit ACA posts 2017-11-03: SQL training; Edit weekly roundup post 2017-11-02: finish Weekly roundup post 2017-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/16 2data 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: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: 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:30Reviewed blog posts, searched possible blog topics, looked up articles for twitter. Will try to resolve issues with RDP on Wednesday. 2017-09-406:30pm Set up bio page, work logs, looked at blog posts [[Category:InternalWork Log]]