Changes

2/1/17 1:00-3:00pm ===Fall 2017===<onlyinclude>[[Meghana Gaur]] [[Work on weekly roundup blog postLogs]] [[Meghana Gaur (Work Log)|(log page)]]

2017-12-1: worked with ed to build tables with firm/30portco data on distance and fund/17 1:00-4:00pm Work portco data on weekly roundup blog postperformance

1/26/17 4:002017-11-616:00pm Finish on weekly roundup blog postfinished calculating great circle distances between firms, portco's, and branch offices (look at roundlinewithgcd table)

1/24/17 4:002017-11-614:00pm Work worked on weekly roundup blog postgetting 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)

1/23/17 2:002017-11-414:00pm Work worked on weekly roundup blog postjoining ipo information to roundline; aggregated ipo information to the fund level (rather than fund)

2017-11/29 work -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 Accelerator project; add content for Weekly Roundupjoining portcoexitmaster to roundlinejoinerlean

2017-11/18 publish weekly roundup-08: loaded roundlinewithgcd table (calculating gcd between portcos and funds), created GCD example with notes in datawork folder in MatchingEntrepsToVCs, worked on building portcostofirms

2017-11/17 2:30-407:00pm finish content for Weekly roundup; edit Tayloaded portcocoords table, joined portcocoords to roundlinejoinerlean, calculate gcd distance between funds and portco's blog post, work on joining funds to firms

2017-11/16 10:00am-1203:00pm work on content loaded table/sql script for Weekly roundupfirms 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

2017-11/15 2:30-602:00pm weekly roundup 11/18met with Ed; work on FTC mergerloaded tables/non-merger acquisitions actions spreadsheetsql script for branch office and fund office locations into vcdb2 with latitude and longitude coordinates

11/2017-10 3-27:00come up with next steps for matching firms to funds -5:00pm put weekly roundups into wordpressfor geocoding branch offices

11/9 2017-10:00-1226:00am finish weekly roundup contentupdate VC Database Rebuild wiki; identify key for bocore table; verify that fundbasecore table was correctly cleaned after being being rebuilt by Ed

11/8 3:302017-10-624:00pm work on weekly roundup entrepreneurship met with Ed to discuss firmbase and branch office tables; find key for firmbasecore table; remove undisclosed firmsfrom both firmbasecore and bocore

11/4 3:002017-10-512:00pm finalize rounduppeer edit and put Shelby's blog post into Wordpress; edit ACA postssee what needs to be done on VC project; continue literature review for matching models

2017-10-11/3 3:30-5:30pm SQL training; Edit weekly roundup postfinished loading tables (firmbase and branchoffice)

11/2 2017-10:00am-126:00pm finish Weekly roundup postload data using SQL code into tables, which is on [[Retrieving US VC Data From SDC]]

11/1 3:002017-09-629:00pm edit Avesh's blog post; draft weekly round-up postcompleted pulling/normalizing data, still need to load data using SQL code into tables, which is on [[Retrieving US VC Data From SDC]]

10/27 12:00pm2017-09-428:00pm edit Eliza's blog postmet with Ed, work worked on weekly round-up, pulling firm and attend SQL training with Ed branch office data from SDC

10/26 10:002017-09-1222:00am finish editing ACA articles, submit Tay for peer editingjoin portcos and funds; and begin literature review of matching games/venture capital (located in "Matching Entreps to VC's project folder" on E drive."

10/25 2:302017-09-421:30pm draft first weekly round-up postwork with Ed on research project

10/24 5:002017-09-619:00pm meet with Aveshcontinue to work on joining portcoexits and roundlinejoiner tables in vcdb2, Anne, and Ed to discuss weekly roundup blog postin MatchingEntrepsToVC folder under project management

10/21 3:002017-09-315:45pm Attend bloggerwork on joining portcoexits and roundlinejoiner; create txt file called "Notes on Matching Funds to portcos" in the "Matching Entreps to VC's meetingproject folder" on E drive.

10/21 2:302017-09-414:00pm incorporate Anne's edits to ACA articlesbuild table roundlinejoinerapprop (appropriate the funds between funds; add information to education innovation summarywork on joining portcoexits and roundlinejoiner)

10/19 3:002017-09-627:00pm finish dividing two ACA articles; help edit wiki pages for small business development ecosystem; rebuild portcoexits and work on education innovation summaryapportioning amounts in roundlinejoiner

10/18 2:302017-09-507:30pm find tweets, re-write descriptions work with Ed to familiarize with SQL script for small business resourcesVC project/vcdb2 database

10/14 3:002017-09-505:00pm finish ACA articlereceive project from Ed; reacquaint with wiki, RDP, etc.</onlyinclude>

10/12 10:002017-04-12:00am work on trimming down ACA blog postfinish weekly roundup

10/2017-04-11 2:30-5:30pm Continue editing ACA blog post, incorporating Anne's commentsstart weekly roundup

10/10 2:302017-04-503:30pm Work on ACA blog post, adding sourcesfinish weekly roundup

10/7 3:002017-04-602:00pm work on carried interest research, find tweets, edit ACA articlestart weekly roundup

10/6 2:2017-03-30-5:30pm Add information on resources wiki pages for SBDE projectfinish weekly roundup

10/5/16 10:00am2017-03-1228:00pm Research info continue working on organizations for SBDE projectweekly roundup

9/28/16 10:00am2017-03-127:00pm Work on govtrack bill table on Innovation Policy PageFinish project page for weekly rounudp, create wiki form for all legislation wiki pages with Ramee, begin weekly roundup

9/27/16 2:302017-03-521:30 upload ACA to wiki; talk to Ed/Anne about new Create project (VC carried interest; bill analysis page on 6 innovation bills)wiki for weekly roundup, finish weekly roundup

9/23/16 3:002017-03-520:00 finish ACA; send over to AnneCreate Weekly Roundup

9/22/16 2:302017-03-509:30 work on ACA health care articlefinish weekly roundup post

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

9/20/16 2:302017-03-506: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 post

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

9/14/16 10:00am2017-02-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 weekly roundup blog post

9/13/16 2:30pm2017-02-527:30pm Finish up editing old ACA article (share with Anne), work on ACA/candidates article, submit two tweets for twitter channelstart weekly roundup post

9/09/16 3:00pm2017-02-523:00pm Set up finish weekly roundup blog 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-502-21: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)continue weekly roundup blog post

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

92017-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/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 2candidates 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]]