Changes

2016.04.22 (Fri) 32017-12-1:00 - mostly complete blog post; upload worked with ed to server! (under health care in projects)build tables with firm/portco data on distance and fund/portco data on performance

2016. 04.22 2017-11-16: finished calculating great circle distances between firms, portco's, and branch offices (Frilook at roundlinewithgcd table) 1:00 - work on blog post, upload everything to server

2016.04.20 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 (Wedwill discuss with Ed) 4:00 - compiled literature review, begin blog post

2016. 04.20 2017-11-14: worked on joining ipo information to roundline; aggregated ipo information to the fund level (Wedrather than fund) 1:00 - wrap up ACA page

2016. 04.15 2017-11-09: reloaded firm coords and also fund coords - re-building roundlinewithgcd (Fricode is written, but fund coords weren't correctly loaded, so this code will be re-run) 3:30 , wrote code for fundtofirms and portcotofirms, but this code will be re- added new content run once the firm codes are correctly loaded; working on joining portcoexitmaster to pageroundlinejoinerlean

2016. 04. 15 2017-11-08: loaded roundlinewithgcd table (Fricalculating gcd between portcos and funds) 1:30 - Look at article from Jason , created GCD example with notes in datawork folder in MatchingEntrepsToVCs, worked on health care premiums, tidied up pagebuilding portcostofirms

2016. 04. 2017-11 (Mon) 3-07:00- worked loaded portcocoords table, joined portcocoords to roundlinejoinerlean, calculate gcd distance between funds and portco's, work on ACA page, should be ready joining funds to go go over with edfirms

2016. 04. 2017-11. (Mon) 1:00 - tidy up page so ed can review it on Wednesday2016. 04. 08. (Fri) 103:00 - add sample sizesloaded table/sql script for firms office locations into vcdb2 with latitude and longitude coordinates; joined coordinates to all clean base tables for firms, funds, sourcesbranch offices, joined co and sources fund coordinates to surveys, record bibtex entries roundlinejoinerlean in file, meet with Jasonnew table: roundlinecoords

2016. 04. 06. (Wed) 42017-11-02:00- talked to ed, went over articles, surveys, uploaded papers to servermet with Ed; loaded tables/sql script for branch office and fund office locations into vcdb2 with latitude and longitude coordinates

2016. 04. 06. (Wed) 12017-10-27:00 come up with next steps for matching firms to funds - talk to ed, work on ACA pagefor geocoding branch offices

2016. 04. 04. (Mon) 42017-10-26:00 -edited page, looked update VC Database Rebuild wiki; identify key for articlesbocore table; verify that fundbasecore table was correctly cleaned after being being rebuilt by Ed

2016. 04. 04 (Mon) 12017-10-24:00 - Look met with Ed to discuss firmbase and branch office tables; find key for relevant articles on ACA firmbasecore table; remove undisclosed firmsfrom both firmbasecore and small business; talk to EDbocore

2016. 03. 30 (Wed) 42017-10-12:00 - Edited writing peer edit and put Shelby's blog post into Wordpress; see what needs to be done on ACA Page, looked VC project; continue literature review for academic paper pertaining to ACA using google scholarmatching models

2016. 03. 30 2017-10-11: finished loading tables (Wedfirmbase and branchoffice) 1:00 - Edit writing on ACA Page, look for academic paper pertaining to ACA using google scholar

2016. 03. 28 (Mon) 42017-10-6:00 - Edited writing load data using SQL code into tables, which is on ACA Page, looked for academic paper pertaining to ACA using google scholar[[Retrieving US VC Data From SDC]]

2016. 03. 28 (Mon) 12017-09-29:00 - Edit writing on ACA Pagecompleted pulling/normalizing data, look for academic paper pertaining still need to ACA load data using google scholarSQL code into tables, which is on [[Retrieving US VC Data From SDC]]

2016.03.25. (Fri) 42017-09-28:00 - Looked for scholarly/academic paper pertaining to ACAmet with Ed, worked on pulling firm and branch office data from SDC

2016.03.25. (Fri) 12017-09-22:00 - Looked for scholarlyjoin portcos and funds; and begin literature review of matching games/academic paper pertaining venture capital (located in "Matching Entreps to ACAVC's project folder" on E drive."

2016.03.23. (Wed) 42017-09-21:00 - Edited ACA Pagework with Ed on research project

2016.03.23. (Wed) 12017-09-19:00 - Edit ACA Pagecontinue to work on joining portcoexits and roundlinejoiner tables in vcdb2, in MatchingEntrepsToVC folder under project management

2016.032017-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.16 (Wed) 4:00 - Almost completed ACA page

2016.03.16 2017-09-14: build table roundlinejoinerapprop (Wedappropriate the funds between funds; work on joining portcoexits and roundlinejoiner) 1:00 - Continued to finalize ACA Page

2016. 03. 14 (Mon) 42017-09-27:00 - Edited ACA page; met with Ed; found article for McNair Center twitterrebuild portcoexits and work on apportioning amounts in roundlinejoiner

2016.03.14 (Mon) 12017-09-07:00- Work on editing Affordable Care Act pagework with Ed to familiarize with SQL script for VC project/vcdb2 database

2016.03.11 (Fri) 42017-09-05:00 - Connected to server, created a small business receive project from Ed; reacquaint with wiki page with Jason, uploaded health care and small businesses pageRDP, edited page with Jasonetc.</onlyinclude>

2016.03.09 (Wed) 62017-04-12:00 - Finished policy paper on small businesses and health carefinish weekly roundup

2016.03.09. (Wed) 22017-04-11:00 - Finish Policy paper on small businesses and health carestart weekly roundup

2016.2017-04-03.07 (Mon) 5:00 - Worked on policy paper on small businesses and health carefinish weekly roundup

2016.03.07 (Mon) 22017-04-02:00 - Write policy paper on small businesses and health carestart weekly roundup

2016.02.24 (Wed) 42017-03-30: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-03-28:00- Work continue working on health care summary; join Issac, Pedro's projectweekly roundup

2016.02.22 (Mon) 52017-03-27:00 - Found information on how health care law affects small businessesFinish project page for weekly rounudp, create wiki form for all legislation wiki pages with Ramee, alternate routes that small businesses can take to avoid increased health costs in the marketbegin weekly roundup

2016.02.22 (Mon) 22017-03-21:00 - Find information/start writing an article Create project page on how health care regulations affect small businesseswiki for weekly roundup, finish weekly roundup

2016.02.19 (Fri) 52017-03-20:00 - Wrote in depth summary of STRONG Patents Act, also worked on the Innovation Act, PATENT Act, TROL Act, and Demand Letter Transparency Act pagesCreate Weekly Roundup

2016.02.19 (Fri) 22017-03-09:00 - Write summary on STRONG Patents Act and other Patent Reform Actsfinish weekly roundup post

2016.02.15 (Mon): 42017-03-07:00 - Planned/organized presentation and speech for Ed with Julia, Jackie, Carlin, and Albertcontinue weekly roundup post

2016.02.15 (Mon): 22017-03-06:00 - Plan/organize presentation and speech for Ed with Julia, Jackie, Carlin, and Albertstart weekly roundup post

2016.02.12. (Fri): 52017-03-03:00 - Added regulations to excel sheet, researched candidates' stances on Carried Interest, brainstormed with Ed and Albert on speech ideasfinish weekly roundup post

2016.2017-02.12. (Fri)-28: 2:00 - Work on excel sheet- finding where candidates stand on specific regulations that affect small business (specifically EPA/energy)continue weekly roundup blog post

2016.2017-02.10 (Wed): 4-27: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 Actstart 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: 2finish ACA; send over to Anne 2017-09-22:00 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 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]]