Changes

2016. 04.13 (Wed) 42017-12-1:00 - added new content worked with ed to pagebuild tables with firm/portco data on distance and fund/portco data on performance

2016. 04. 13 2017-11-16: finished calculating great circle distances between firms, portco's, and branch offices (Wedlook at roundlinewithgcd table) 1:00 - Look at article from Jason on health care premiums, tidied up page

2016. 04. 2017-11 (Mon) 3-14:00- worked on ACA pagegetting all roundline tables down to the firm level, should be ready to go go over instead of fund; running into small problems with calculating gcd between firms and portco's (will discuss with edEd)

2016. 04. 2017-11. (Mon) 1-14:00 - tidy up page so ed can review it worked on Wednesday2016. 04. 08. joining ipo information to roundline; aggregated ipo information to the fund level (Frirather than fund) 1:00 - add sample sizes, sources, and sources to surveys, record bibtex entries in file, meet with Jason

2016. 04. 06. (Wed) 42017-11-09:00reloaded firm coords and also fund coords - talked to edre-building roundlinewithgcd (code is written, went over articlesbut fund coords weren't correctly loaded, surveysso this code will be re-run), uploaded papers 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 serverroundlinejoinerlean

2016. 04. 06. 2017-11-08: loaded roundlinewithgcd table (Wedcalculating gcd between portcos and funds) 1:00 - talk to ed, work created GCD example with notes in datawork folder in MatchingEntrepsToVCs, worked on ACA pagebuilding portcostofirms

2016. 04. 04. (Mon) 42017-11-07:00 -edited pageloaded portcocoords table, joined portcocoords to roundlinejoinerlean, calculate gcd distance between funds and portco's, looked for articleswork on joining funds to firms

2016. 04. 04 (Mon) 12017-11-03:00 - Look loaded table/sql script for relevant articles on ACA firms office locations into vcdb2 with latitude and small businesslongitude coordinates; talk joined coordinates to EDall clean base tables for firms, funds, branch offices, joined co and fund coordinates to roundlinejoinerlean in new table: roundlinecoords

2016. 03. 30 (Wed) 42017-11-02:00 - Edited writing on ACA Page, looked met with Ed; loaded tables/sql script for academic paper pertaining to ACA using google scholarbranch office and fund office locations into vcdb2 with latitude and longitude coordinates

2016. 03. 30 (Wed) 12017-10-27:00 come up with next steps for matching firms to funds - Edit writing on ACA Page, look for academic paper pertaining to ACA using google scholargeocoding branch offices

2016. 03. 28 (Mon) 42017-10-26:00 - Edited writing on ACA Page, looked update VC Database Rebuild wiki; identify key for academic paper pertaining to ACA using google scholarbocore table; verify that fundbasecore table was correctly cleaned after being being rebuilt by Ed

2016. 03. 28 (Mon) 12017-10-24:00 - Edit writing on ACA Page, look met with Ed to discuss firmbase and branch office tables; find key for academic paper pertaining to ACA using google scholarfirmbasecore table; remove undisclosed firmsfrom both firmbasecore and bocore

2016.03.25. (Fri) 42017-10-12:00 - Looked peer edit and put Shelby's blog post into Wordpress; see what needs to be done on VC project; continue literature review for scholarly/academic paper pertaining to ACAmatching models

2016.03.25. 2017-10-11: finished loading tables (Frifirmbase and branchoffice) 1:00 - Looked for scholarly/academic paper pertaining to ACA

2016.03.23. (Wed) 42017-10-6:00 - Edited ACA Pageload data using SQL code into tables, which is on [[Retrieving US VC Data From SDC]]

2016.03.23. (Wed) 12017-09-29:00 - Edit ACA Pagecompleted pulling/normalizing data, still need to load data using SQL code into tables, which is on [[Retrieving US VC Data From SDC]]

2016.03.16 (Wed) 42017-09-28:00 - Almost completed ACA pagemet with Ed, worked on pulling firm and branch office data from SDC

2016.03.16 2017-09-22: join portcos and funds; and begin literature review of matching games/venture capital (Wed) 1:00 - Continued located in "Matching Entreps to finalize ACA PageVC's project folder" on E drive."

2016. 03. 14 (Mon) 42017-09-21:00 - Edited ACA page; met work with Ed; found article for McNair Center twitteron research project

2016.03.14 (Mon) 12017-09-19:00- Work continue to work on editing Affordable Care Act pagejoining portcoexits and roundlinejoiner tables in vcdb2, in MatchingEntrepsToVC folder under project management

2016.03.11 (Fri) 42017-09-15:00 - Connected work on joining portcoexits and roundlinejoiner; create txt file called "Notes on Matching Funds to portcos" in the "Matching Entreps to server, created a small business wiki page with Jason, uploaded health care and small businesses page, edited page with JasonVC's project folder" on E drive.

2016.03.11. 2017-09-14: build table roundlinejoinerapprop (Friappropriate the funds between funds; work on joining portcoexits and roundlinejoiner) 1:00 - Connect to server, finalize policy brief, contribute to Jason/Pedro

2016.03.2017-09 (Wed) 6-27:00 - Finished policy paper rebuild portcoexits and work on small businesses and health careapportioning amounts in roundlinejoiner

2016.03.2017-09. (Wed) 2-07:00 - Finish Policy paper on small businesses and health carework with Ed to familiarize with SQL script for VC project/vcdb2 database

2016.032017-09-05: receive project from Ed; reacquaint with wiki, RDP, etc.07 (Mon) 5:00 - Worked on policy paper on small businesses and health care</onlyinclude>

2016.02.24 (Wed) 42017-04-12:30 - Created Health Policy Wiki page; decided direction of project w/ Pedro, Carlin, and Jason (Status update scheduled for Monday after Spring Break)finish weekly roundup

2016.02.24 (Wed) 22017-04-11:00- Work on health care summary; join Issac, Pedro's projectstart weekly roundup

2016.02.22 (Mon) 52017-04-03:00 - Found information on how health care law affects small businesses, alternate routes that small businesses can take to avoid increased health costs in the marketfinish weekly roundup

2016.02.22 (Mon) 2017-04-2:00 - Find information/start writing an article on how health care regulations affect small businessesweekly roundup

2016.02.19 (Fri) 52017-03-30:00 - Wrote in depth summary of STRONG Patents Act, also worked on the Innovation Act, PATENT Act, TROL Act, and Demand Letter Transparency Act pagesfinish weekly roundup

2016.02.19 (Fri) 22017-03-28:00 - Write summary continue working on STRONG Patents Act and other Patent Reform Actsweekly roundup

2016.02.15 (Mon)2017-03-27: 4:00 - Planned/organized presentation and speech Finish project page for weekly rounudp, create wiki form for Ed all legislation wiki pages with Julia, Jackie, CarlinRamee, and Albertbegin weekly roundup

2016.02.15 (Mon): 22017-03-21:00 - Plan/organize presentation and speech Create project page on wiki for Ed with Julia, Jackie, Carlinweekly roundup, and Albertfinish weekly roundup

2016.02.12. (Fri): 52017-03-20:00 - Added regulations to excel sheet, researched candidates' stances on Carried Interest, brainstormed with Ed and Albert on speech ideasCreate Weekly Roundup

2016.02.12. (Fri): 2:00 2017- Work on excel sheet03- finding where candidates stand on specific regulations that affect small business (specifically EPA/energy)09: finish weekly roundup post

2016.02.10 (Wed): 42017-03-07:00 - Added content to regulations page for Ed's speech, created work log page, wrote key talking points on EPA'S proposal for expanding Clean Waters Actcontinue 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 (WedVC carried interest; bill analysis on 6 innovation bills) 2017-09-23: finish ACA; send over to Anne 2017-09-22: 2work on ACA health care article 2017-09-21:00 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 regulations page 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 Edtwitter 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 Speech edits to health care/innovation) 2017-09-07: Reviewed blog posts, searched possible blog topics, looked up articles for Baker Institute Presidential Campaign Eventtwitter. Will try to resolve issues with RDP on Wednesday. 2017-09-06: Set up bio page, work logs, looked at blog posts [[Category:Work Log]]