Changes

Jump to navigation Jump to search
3,683 bytes added ,  18:37, 1 December 2017
no edit summary
3/21 4pm-6pm Create project ===Fall 2017===<onlyinclude>[[Meghana Gaur]] [[Work Logs]] [[Meghana Gaur (Work Log)|(log page on wiki for weekly roundup, finish weekly roundup)]]
3/20 2017-12-4pm Create Weekly Roundup1: worked with ed to build tables with firm/portco data on distance and fund/portco data on performance
3/9/17 4pm2017-6pm finish weekly roundup post11-16: finished calculating great circle distances between firms, portco's, and branch offices (look at roundlinewithgcd table)
3/7/17 4pm2017-6pm continue weekly roundup post11-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)
3/6/17 2pm2017-4pm start weekly roundup post11-14: worked on joining ipo information to roundline; aggregated ipo information to the fund level (rather than fund)
3/3/17 4pm2017-6pm finish weekly roundup post11-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
2/28/17 4:002017-11-608:00pm continue weekly roundup blog postloaded roundlinewithgcd table (calculating gcd between portcos and funds), created GCD example with notes in datawork folder in MatchingEntrepsToVCs, worked on building portcostofirms
2/27/17 2:00pm 2017-11- 407:00pm start weekly roundup postloaded portcocoords table, joined portcocoords to roundlinejoinerlean, calculate gcd distance between funds and portco's, work on joining funds to firms
2/232017-11-03: loaded table/17 4:00-6sql script for firms 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:00pm finish weekly roundup blog postroundlinecoords
2/21/17 4:002017-11-602:00pm continue weekly roundup blog postmet with Ed; loaded tables/sql script for branch office and fund office locations into vcdb2 with latitude and longitude coordinates
2/20/17 22017-10-27:00come up with next steps for matching firms to funds -4:00pm Start weekly roundup blog postfor geocoding branch offices
2/16/17 4:00pm2017-10-626:00pm Publish weekly roundup blog postupdate VC Database Rebuild wiki; identify key for bocore table; verify that fundbasecore table was correctly cleaned after being being rebuilt by Ed
2/14/17 4:00pm2017-10-624:00pm continue weekly roundup blog postmet with Ed to discuss firmbase and branch office tables; find key for firmbasecore table; remove undisclosed firmsfrom both firmbasecore and bocore
2/13/17 2:002017-10-412:00pm Start weekly roundup peer edit and put Shelby's blog postinto Wordpress; see what needs to be done on VC project; continue literature review for matching models
2/2/17 1:002017-10-311:00pm Finish weekly roundup blog postfinished loading tables (firmbase and branchoffice)
2/1/17 1:002017-10-36:00pm Work load data using SQL code into tables, which is on weekly roundup blog post[[Retrieving US VC Data From SDC]]
1/30/17 1:002017-09-429:00pm Work completed pulling/normalizing data, still need to load data using SQL code into tables, which is on weekly roundup blog post[[Retrieving US VC Data From SDC]]
1/26/17 4:002017-09-628:00pm Finish met with Ed, worked on weekly roundup blog postpulling firm and branch office data from SDC
1/24/17 4:002017-09-622:00pm Work join portcos and funds; and begin literature review of matching games/venture capital (located in "Matching Entreps to VC's project folder" on weekly roundup blog postE drive."
1/23/17 2:002017-09-421:00pm Work work with Ed on weekly roundup blog postresearch project
11/29 2017-09-19: continue to work on Accelerator joining portcoexits and roundlinejoiner tables in vcdb2, in MatchingEntrepsToVC folder under project; add content for Weekly Roundupmanagement
11/18 publish weekly roundup2017-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.
11/17 2:302017-09-414:00pm finish content for Weekly roundupbuild table roundlinejoinerapprop (appropriate the funds between funds; edit Tay's blog postwork on joining portcoexits and roundlinejoiner)
11/16 10:00am2017-09-1227:00pm rebuild portcoexits and work on content for Weekly roundupapportioning amounts in roundlinejoiner
11/15 2:302017-09-607:00pm weekly roundup 11/18; work on FTC mergerwith Ed to familiarize with SQL script for VC project/non-merger acquisitions actions spreadsheetvcdb2 database
11/10 3:002017-09-505:00pm put weekly roundups into wordpressreceive project from Ed; reacquaint with wiki, RDP, etc.</onlyinclude>
11/9 10:00-12:00am finish weekly roundup content===Spring 2017===
11/8 3:302017-04-612:00pm work on finish weekly roundup entrepreneurship
2017-04-11/4 3:00-5:00pm finalize start weekly roundup; edit ACA posts
11/3 3:302017-04-503:30pm SQL training; Edit finish weekly roundup post
11/2 10:00am2017-04-1202:00pm finish Weekly start weekly roundup post
11/1 3:002017-03-630:00pm edit Avesh's blog post; draft finish weekly round-up postroundup
10/27 12:00pm2017-03-428:00pm edit Eliza's blog post, work continue working on weekly round-up, and attend SQL training with Ed roundup
10/26 10:002017-03-1227:00am finish editing ACA articlesFinish project page for weekly rounudp, submit Tay create wiki form for peer editingall legislation wiki pages with Ramee, begin weekly roundup
10/25 2:302017-03-421:30pm draft first Create project page on wiki for weekly roundup, finish weekly round-up postroundup
10/24 5:002017-03-620:00pm meet with Avesh, Anne, and Ed to discuss weekly roundup blog postCreate Weekly Roundup
10/21 3:002017-03-309:45pm Attend blogger's meetingfinish weekly roundup post
10/21 2:302017-03-407:00pm incorporate Anne's edits to ACA articles; add information to education innovation summarycontinue weekly roundup post
10/19 3:002017-03-606:00pm finish dividing two ACA articles; help edit wiki pages for small business development ecosystem; work on education innovation summarystart weekly roundup post
10/18 2:302017-03-503:30pm find tweets, re-write descriptions for small business resourcesfinish weekly roundup post
10/14 3:002017-02-528:00pm finish ACA articlecontinue weekly roundup blog post
10/13 2:302017-02-527:30pm work on finding tweet material, edit ACA post, and look into education/innovation blog start weekly roundup post
10/12 10:002017-02-1223:00am work on trimming down ACA finish weekly roundup blog post
10/11 2:302017-02-521:30pm Continue editing ACA continue weekly roundup blog post, incorporating Anne's comments
10/10 2:302017-02-520:30pm Work on ACA Start weekly roundup blog post, adding sources
10/7 3:002017-02-616:00pm work on carried interest research, find tweets, edit ACA articlePublish weekly roundup blog post
10/6 2:302017-02-514:30pm Add information on resources wiki pages for SBDE projectcontinue weekly roundup blog post
10/5/16 10:00am2017-02-1213:00pm Research info on organizations for SBDE projectStart weekly roundup blog post
9/28/16 10:00am2017-02-102:00pm Work on govtrack bill table on Innovation Policy PageFinish weekly roundup blog post
9/27/16 2:302017-02-501:30 upload ACA to wiki; talk to Ed/Anne about new project (VC carried interest; bill analysis Work on 6 innovation bills)weekly roundup blog post
9/23/16 3:002017-01-530:00 finish ACA; send over to AnneWork on weekly roundup blog post
9/22/16 2:302017-01-526:30 work Finish on ACA health care articleweekly roundup blog post
9/21/16 10:002017-01-1224:00 Look for more material/data for health care article, specifically related to election 2016; find a tweetWork on weekly roundup blog post
9/20/16 2:302017-01-523:30 Finish editing health care article (include sources), re-share with Anne; look into possible articles Work on women in small business; look over Dylan's ACA and entrepreneurship articleweekly roundup blog post
9/15/16 2:30-5:30 Work on editing health care document (incorporating edits from Ann); look up women in entrepreneurship research topics===Fall 2016===
9/14/16 10:00am2017-11-1229:00am Research viable subjects for health care innovation, role of health care regulation in 2016 election work on Accelerator project; add content for articles. Submit two twitter articles. Review Accenture health articles.Weekly Roundup
9/13/16 2:30pm2017-11-518:30pm Finish up editing old ACA article (share with Anne), work on ACA/candidates article, submit two tweets for twitter channelpublish weekly roundup
9/09/16 3:00pm2017-11-517:00pm Set up finish content for Weekly roundup; edit Tay's 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/2017-11-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)work on content for Weekly roundup
92017-11-15:weekly roundup 11/0718; work on FTC merger/16 10:00amnon-12:00pm Reviewed blog posts, searched possible blog topics, looked up articles for twitter. Will try to resolve issues with RDP on Wednesday.merger acquisitions actions spreadsheet
92017-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:30Set 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-408: 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: Reviewed blog posts, searched possible blog topics, looked up articles for twitter. Will try to resolve issues with RDP on Wednesday. 2017-09-06:30pm Set up bio page, work logs, looked at blog posts [[Category:InternalWork Log]]
474

edits

Navigation menu