474
edits
Changes
Jump to navigation
Jump to search
10/11 3pm-5pm finished loading tables ===Fall 2017===<onlyinclude>[[Meghana Gaur]] [[Work Logs]] [[Meghana Gaur (firmbase and branchofficeWork Log)|(log page)]]
10/6 3pm2017-12-51:30pm load worked with ed to build tables with firm/portco data on distance and fund/portco data using SQL code into tables, which is on [[Retrieving US VC Data From SDC]]performance
9/29 3pm2017-511-16:45pm completed pulling/normalizing datafinished calculating great circle distances between firms, still need to load data using SQL code into tablesportco's, which is on [[Retrieving US VC Data From SDC]]and branch offices (look at roundlinewithgcd table)
9/28 22017-11-14:30-6pm met with Ed, worked on pulling getting all roundline tables down to the firm level, instead of fund; running into small problems with calculating gcd between firms and branch office data from SDCportco's (will discuss with Ed)
9/22 3pm2017-5pm join portcos and funds11-14: worked on joining ipo information to roundline; and begin literature review of matching games/venture capital aggregated ipo information to the fund level (located in "Matching Entreps to VC's project folder" on E drive."rather than fund)
9/21 22017-11-09:30reloaded 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-5:30pm work with Ed run), wrote code for fundtofirms and portcotofirms, but this code will be re-run once the firm codes are correctly loaded; working on research projectjoining portcoexitmaster to roundlinejoinerlean
9/19 2:302017-11-508:30pm continue to work on joining portcoexits loaded roundlinewithgcd table (calculating gcd between portcos and roundlinejoiner tables in vcdb2funds), created GCD example with notes in MatchingEntrepsToVC datawork folder under project managementin MatchingEntrepsToVCs, worked on building portcostofirms
9/15 3pm2017-5pm 11-07: loaded portcocoords table, joined portcocoords to roundlinejoinerlean, calculate gcd distance between funds and portco's, work on joining portcoexits and roundlinejoiner; create txt file called "Notes on Matching Funds funds to portcos" in the "Matching Entreps to VC's project folder" on E drive.firms
9/14 2:30pm2017-11-503:30pm build loaded table roundlinejoinerapprop (appropriate the /sql script for firms office locations into vcdb2 with latitude and longitude coordinates; joined coordinates to all clean base tables for firms, funds between funds; work on joining portcoexits , branch offices, joined co and roundlinejoiner)fund coordinates to roundlinejoinerlean in new table: roundlinecoords
9/12 2:30pm2017-11-502:30pm rebuild portcoexits met with Ed; loaded tables/sql script for branch office and fund office locations into vcdb2 with latitude and work on apportioning amounts in roundlinejoinerlongitude coordinates
9/7 32017-5pm10-5pm work 27: come up with Ed next steps for matching firms to familiarize with SQL script funds - for VC project/vcdb2 databasegeocoding branch offices
9/7 2:302017-10-526:30pm receive project from update VC Database Rebuild wiki; identify key for bocore table; verify that fundbasecore table was correctly cleaned after being being rebuilt by Ed; reacquaint with wiki, RDP, etc.
4/12 4pm2017-610-24:30pm finish weekly roundupmet with Ed to discuss firmbase and branch office tables; find key for firmbasecore table; remove undisclosed firmsfrom both firmbasecore and bocore
4/11 4pm2017-610-12:30pm start weekly rounduppeer edit and put Shelby's blog post into Wordpress; see what needs to be done on VC project; continue literature review for matching models
4/3 4p2017-6pm finish weekly roundup10-11: finished loading tables (firmbase and branchoffice)
4/2 12pm2017-4pm start weekly roundup10-6: load data using SQL code into tables, which is on [[Retrieving US VC Data From SDC]]
32017-09-29: completed pulling/30 finish weekly roundupnormalizing data, still need to load data using SQL code into tables, which is on [[Retrieving US VC Data From SDC]]
3/2017-09-28 continue working : met with Ed, worked on weekly rounduppulling firm and branch office data from SDC
32017-09-22: join portcos and funds; and begin literature review of matching games/27 Finish venture capital (located in "Matching Entreps to VC's project page for weekly rounudp, create wiki form for all legislation wiki pages with Ramee, begin weekly roundupfolder" on E drive."
3/2017-09-21 4pm-6pm Create : work with Ed on research project page on wiki for weekly roundup, finish weekly roundup
3/20 122017-4pm Create Weekly Roundup09-19: continue to work on joining portcoexits and roundlinejoiner tables in vcdb2, in MatchingEntrepsToVC folder under project management
3/9/17 4pm2017-6pm finish weekly roundup post09-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.
3/7/17 4pm2017-6pm continue weekly roundup post09-14: build table roundlinejoinerapprop (appropriate the funds between funds; work on joining portcoexits and roundlinejoiner)
3/6/17 2pm2017-4pm start weekly roundup post09-27: rebuild portcoexits and work on apportioning amounts in roundlinejoiner
3/32017-09-07: work with Ed to familiarize with SQL script for VC project/17 4pm-6pm finish weekly roundup postvcdb2 database
2/28/17 4:002017-09-605:00pm continue weekly roundup blog postreceive project from Ed; reacquaint with wiki, RDP, etc.</onlyinclude>
2/27/17 2:00pm - 4:00pm start weekly roundup post===Spring 2017===
2/23/17 4:002017-04-612:00pm finish weekly roundup blog post
2/21/17 4:002017-04-611:00pm continue start weekly roundup blog post
2/20/17 2:002017-04-403:00pm Start finish weekly roundup blog post
2/16/17 4:00pm2017-04-602:00pm Publish start weekly roundup blog post
2/14/17 4:00pm2017-03-630:00pm continue finish weekly roundup blog post
2/13/17 2:002017-03-428:00pm Start continue working on weekly roundup blog post
2/2/17 1:002017-03-327:00pm Finish project page for weekly rounudp, create wiki form for all legislation wiki pages with Ramee, begin weekly roundup blog post
2/1/17 1:002017-03-321:00pm Work Create project page on wiki for weekly roundup, finish weekly roundup blog post
1/30/17 1:002017-03-420:00pm Work on weekly roundup blog postCreate Weekly Roundup
1/26/17 4:002017-03-609:00pm Finish on finish weekly roundup blog post
1/24/17 4:002017-03-607:00pm Work on continue weekly roundup blog post
1/23/17 2:002017-03-406:00pm Work on start weekly roundup blog post
11/29 work on Accelerator project; add content for Weekly Roundup2017-03-03: finish weekly roundup post
11/18 publish 2017-02-28: continue weekly roundupblog post
11/17 2:302017-02-427:00pm finish content for Weekly start weekly roundup; edit Tay's blog post
11/16 10:00am2017-02-1223:00pm work on content for Weekly finish weekly roundupblog post
11/15 2:302017-02-621:00pm continue weekly roundup 11/18; work on FTC merger/non-merger acquisitions actions spreadsheetblog post
11/10 3:002017-02-520:00pm put Start weekly roundups into wordpressroundup blog post
11/9 10:002017-02-1216:00am finish Publish weekly roundup contentblog post
11/8 3:302017-02-614:00pm work on continue weekly roundup entrepreneurship blog post
11/4 3:002017-02-513:00pm finalize Start weekly roundup; edit ACA postsblog post
11/3 3:302017-02-502:30pm SQL training; Edit Finish weekly roundup blog post
11/2 10:00am2017-02-1201:00pm finish Weekly Work on weekly roundup blog post
11/1 3:002017-01-630:00pm edit Avesh's Work on weekly roundup blog post; draft weekly round-up post
10/27 12:00pm2017-01-426:00pm edit Eliza's Finish on weekly roundup blog post, work on weekly round-up, and attend SQL training with Ed
10/26 10:002017-01-1224:00am finish editing ACA articles, submit Tay for peer editingWork on weekly roundup blog post
10/25 2:302017-01-423:30pm draft first Work on weekly round-up roundup blog post
10/24 5:00-6:00pm meet with Avesh, Anne, and Ed to discuss weekly roundup blog post===Fall 2016===
10/21 3:002017-11-329:45pm Attend blogger's meetingwork on Accelerator project; add content for Weekly Roundup
10/21 2:302017-11-418:00pm incorporate Anne's edits to ACA articles; add information to education innovation summarypublish weekly roundup
10/19 3:002017-11-617:00pm finish dividing two ACA articlescontent for Weekly roundup; help edit wiki pages for small business development ecosystem; work on education innovation summaryTay's blog post
10/18 2:302017-11-516:30pm find tweets, re-write descriptions work on content for small business resourcesWeekly roundup
102017-11-15:weekly roundup 11/18; work on FTC merger/14 3:00non-5:00pm finish ACA articlemerger acquisitions actions spreadsheet
10/12 10:002017-11-1209:00am work on trimming down ACA blog postfinish weekly roundup content
10/2017-11 2:30-508:30pm Continue editing ACA blog post, incorporating Anne's commentswork on weekly roundup entrepreneurship
10/10 2:302017-11-504:30pm Work on finalize roundup; edit ACA blog post, adding sourcesposts
10/7 3:002017-11-603:00pm work on carried interest research, find tweets, edit ACA articleSQL training; Edit weekly roundup post
10/6 2:302017-11-502:30pm Add information on resources wiki pages for SBDE projectfinish Weekly roundup post
10/5/16 102017-11-01:00amedit Avesh's blog post; draft weekly round-12:00pm Research info on organizations for SBDE projectup post
9/28/16 2017-10:00am-127:00pm Work edit Eliza's blog post, work on govtrack bill table on Innovation Policy Pageweekly round-up, and attend SQL training with Ed
9/27/16 2:302017-10-526:30 upload finish editing ACA to wiki; talk to Ed/Anne about new project (VC carried interest; bill analysis on 6 innovation bills)articles, submit Tay for peer editing
9/23/16 32017-10-25:00draft first weekly round-5:00 finish ACA; send over to Anneup post
9/22/16 2:302017-10-524:30 work on ACA health care articlemeet with Avesh, Anne, and Ed to discuss weekly roundup blog post
9/21/16 2017-10:00-1221:00 Look for more material/data for health care article, specifically related Attend blogger's meeting. Incorporate Anne's edits to election 2016ACA articles; find a tweetadd information to education innovation summary
9/20/16 2:302017-10-519:30 Finish editing health care article (include sources), re-share with Annefinish dividing two ACA articles; look into possible articles on women in help edit wiki pages for small businessdevelopment ecosystem; look over Dylan's ACA and entrepreneurship articlework on education innovation summary
9/15/16 22017-10-18:30find tweets, re-5:30 Work on editing health care document (incorporating edits from Ann); look up women in entrepreneurship research topicswrite descriptions for small business resources
9/14/16 2017-10:00am-1214: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.finish ACA article
9/2017-10-13/16 2:30pm-5:30pm Finish up editing old ACA article (share with Anne), work on finding tweet material, edit ACApost, and look into education/candidates article, submit two tweets for twitter channelinnovation blog post
9/09/16 3:00pm2017-10-512:00pm Set up work on trimming down ACA 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-510-11:30-pm Twitter meeting with Continue editing ACA blog post, incorporating 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)comments
92017-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/07data 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 10candidates article, submit two tweets for twitter channel 2017-09-09:00amSet 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-1208: 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:00pm Reviewed blog posts, searched possible blog topics, looked up articles for twitter. Will try to resolve issues with RDP on Wednesday. 2017-09-06: Set up bio page, work logs, looked at blog posts
9/06/16 2:30-4:30pm Set up bio page, work logs, looked at blog posts
Meghana Gaur (Work Log) (view source)
Revision as of 18:37, 1 December 2017
, 18:37, 1 December 2017no edit summary
2017-11-10/13 2:30-5:30pm work on finding tweet material, edit ACA post, and look put weekly roundups into education/innovation blog postwordpress
[[Category:Work Log]]
