Changes

===Fall 2017===-12-1: worked with ed to build tables with firm/portco data on distance and fund/portco data on performance<onlyinclude>2017-11-16: finished calculating great circle distances between firms, portco's, and branch offices (look at roundlinewithgcd table) 2017-11-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) 2017-11-14: worked on joining ipo information to roundline; aggregated ipo information to the fund level (rather than fund)  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 joining portcoexitmaster to roundlinejoinerlean 2017-11-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-07: loaded portcocoords table, joined portcocoords to roundlinejoinerlean, calculate gcd distance between funds and portco's, work on joining funds to firms

2017/-11/-03 : loaded table/sql script for firms office locations into vcdb2 with latitude and longitude coordinates; worked on joined roundononelinecoordinates to all clean base tables for firms, funds, branch offices, joined co and fund coordinates to roundlinejoinerlean in new table: roundlinecoords

2017/-11/-02 : met with Ed; loaded tables/sql script for branch office and fund office locations into vcdb2 with latitude and longitude coordinates

2017/-10/-27 : come up with next steps for matching firms to funds - for geocoding branch offices

2017/-10/-26 : update 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 : met with Ed to discuss firmbase and branch office tables; find key for firmbasecore table; remove undisclosed firms

2017/-10/-12 : peer edit and put Shelby's blog post into Wordpress; see what needs to be done on VC project; continue literature review for matching models

2017/-10/-11 : finished loading tables (firmbase and branchoffice)

2017/-10/-6 : load data using SQL code into tables, which is on [[Retrieving US VC Data From SDC]]

2017/9/-09-29 : completed pulling/normalizing data, still need to load data using SQL code into tables, which is on [[Retrieving US VC Data From SDC]]

2017/9/-09-28 : met with Ed, worked on pulling firm and branch office data from SDC

2017/9/-09-22 : join portcos and funds; and begin literature review of matching games/venture capital (located in "Matching Entreps to VC's project folder" on E drive."

2017/9/-09-21 : work with Ed on research project

2017/9/-09-19 : continue to work on joining portcoexits and roundlinejoiner tables in vcdb2, in MatchingEntrepsToVC folder under project management

2017/9/-09-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.

2017/9/-09-14 : build table roundlinejoinerapprop (appropriate the funds between funds; work on joining portcoexits and roundlinejoiner)

2017/9/-09-27 : rebuild portcoexits and work on apportioning amounts in roundlinejoiner

2017/9/7 -09-07: work with Ed to familiarize with SQL script for VC project/vcdb2 database 2017/9/5 receive project from Ed; reacquaint with wiki, RDP, etc.

4/2017-04-12 4pm-6:30pm finish weekly roundup

4/2017-04-11 4pm-6:30pm start weekly roundup

4/3 4p2017-6pm 04-03: finish weekly roundup

4/2 12pm2017-4pm 04-02: start weekly roundup

3/2017-03-30 : finish weekly roundup

3/2017-03-28 : continue working on weekly roundup

3/2017-03-27 : Finish project page for weekly rounudp, create wiki form for all legislation wiki pages with Ramee, begin weekly roundup

3/2017-03-21 4pm-6pm : Create project page on wiki for weekly roundup, finish weekly roundup

3/2017-03-20 12-4pm : Create Weekly Roundup

3/9/17 4pm2017-6pm 03-09: finish weekly roundup post

3/7/17 4pm2017-6pm 03-07: continue weekly roundup post

3/6/17 2pm2017-4pm 03-06: start weekly roundup post

3/3/17 4pm2017-6pm 03-03: finish weekly roundup post

2/2017-02-28/17 4:00-6:00pm continue weekly roundup blog post

2/2017-02-27/17 2:00pm - 4:00pm start weekly roundup post

2/2017-02-23/17 4:00-6:00pm finish weekly roundup blog post

2/2017-02-21/17 4:00-6:00pm continue weekly roundup blog post

2/2017-02-20/17 2:00-4:00pm Start weekly roundup blog post

2/2017-02-16/17 4:00pm-6:00pm Publish weekly roundup blog post

2/2017-02-14/17 4:00pm-6:00pm continue weekly roundup blog post

2/2017-02-13/17 2:00-4:00pm Start weekly roundup blog post

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

2/1/17 1:002017-02-301:00pm Work on weekly roundup blog post

1/2017-01-30/17 1:00-4:00pm Work on weekly roundup blog post

1/2017-01-26/17 4:00-6:00pm Finish on weekly roundup blog post

1/2017-01-24/17 4:00-6:00pm Work on weekly roundup blog post

1/2017-01-23/17 2:00-4:00pm Work on weekly roundup blog post

2017-11/-29 : work on Accelerator project; add content for Weekly Roundup 11/18 publish weekly roundup

2017-11/17 2:30-418:00pm finish content for Weekly publish weekly roundup; edit Tay's blog post

2017-11/16 10:00am-1217:00pm work on finish content for Weekly roundup; edit Tay's blog post

2017-11/15 2:30-616:00pm weekly roundup 11/18; work on FTC merger/non-merger acquisitions actions spreadsheetcontent for Weekly roundup

2017-11/10 3:00-515:00pm put weekly roundups into wordpressroundup 11/18; work on FTC merger/non-merger acquisitions actions spreadsheet

2017-11/9 -10:00-12:00am finish put weekly roundup contentroundups into wordpress

2017-11/8 3:30-609:00pm work on finish weekly roundup entrepreneurship content

2017-11/4 3:00-508:00pm finalize work on weekly roundup; edit ACA postsentrepreneurship

2017-11/3 3:30-504:30pm SQL trainingfinalize roundup; Edit weekly roundup postedit ACA posts

2017-11/2 10:00am-1203:00pm finish Weekly SQL training; Edit weekly roundup post

2017-11/1 3:00-602:00pm edit Avesh's blog post; draft weekly round-up finish Weekly roundup post

10/27 12:00pm2017-11-401:00pm edit ElizaAvesh's blog post, work on ; draft weekly round-up, and attend SQL training with Ed post

2017-10/26 10-27:00edit Eliza's blog post, work on weekly round-12:00am finish editing ACA articlesup, submit Tay for peer editingand attend SQL training with Ed

2017-10/25 2:30-426:30pm draft first weekly round-up postfinish editing ACA articles, submit Tay for peer editing

2017-10/24 5:00-625:00pm meet with Avesh, Anne, and Ed to discuss draft first weekly roundup blog round-up post

2017-10/21 3:00-324:45pm Attend blogger's meetingmeet with Avesh, Anne, and Ed to discuss weekly roundup blog post

2017-10/-21 2:30-4:00pm incorporate Attend blogger's meeting. Incorporate Anne's edits to ACA articles; add information to education innovation summary

2017-10/-19 3:00-6:00pm finish dividing two ACA articles; help edit wiki pages for small business development ecosystem; work on education innovation summary

2017-10/-18 2:30-5:30pm find tweets, re-write descriptions for small business resources

2017-10/-14 3:00-5:00pm finish ACA article

2017-10/-13 2:30-5:30pm work on finding tweet material, edit ACA post, and look into education/innovation blog post

2017-10/12 10:00-12:00am work on trimming down ACA blog post

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

2017-10/-10 2:30-5:30pm Work on ACA blog post, adding sources

2017-10/7 3:00-607:00pm work on carried interest research, find tweets, edit ACA article

2017-10/6 2:30-506:30pm Add information on resources wiki pages for SBDE project

2017-10/5/16 10:00am-1205:00pm Research info on organizations for SBDE project

9/2017-09-28/16 10:00am-1:00pm Work on govtrack bill table on Innovation Policy Page

9/2017-09-27/16 2:30-5:30 upload ACA to wiki; talk to Ed/Anne about new project (VC carried interest; bill analysis on 6 innovation bills)

9/2017-09-23/16 3:00-5:00 finish ACA; send over to Anne

9/2017-09-22/16 2:30-5:30 work on ACA health care article

9/2017-09-21/16 10:00-12:00 Look for more material/data for health care article, specifically related to election 2016; find a tweet

9/2017-09-20/16 2:30-5: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 article

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

9/2017-09-14/16 10:00am-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.

9/2017-09-13/16 2:30pm-5:30pm Finish up editing old ACA article (share with Anne), work on ACA/candidates article, submit two tweets for twitter channel

2017-9/09/16 3:00pm-509:00pm 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

9/2017-09-08/16 300pm-5: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)

9/2017-09-07/16 10:00am-12:00pm Reviewed blog posts, searched possible blog topics, looked up articles for twitter. Will try to resolve issues with RDP on Wednesday.

9/2017-09-06/16 2:30-4:30pm Set up bio page, work logs, looked at blog posts