474
edits
Changes
Jump to navigation
Jump to search
10/24 2:30-5:30pm met with Ed to discuss firmbase and branch office tables; find key for firmbase table; remove undisclosed firms===Fall 2017===from both tables<onlyinclude>[[Meghana Gaur]] [[Work Logs]] [[Meghana Gaur (Work Log)|(log page)]]
10/2017-12 2:30-51:30pm peer edit worked with ed to build tables with firm/portco data on distance and put Shelby's blog post into Wordpress; see what needs to be done fund/portco data on VC projectperformance
10/2017-11 3pm-5pm 16: finished loading tables calculating great circle distances between firms, portco's, and branch offices (firmbase and branchofficelook at roundlinewithgcd table)
10/6 3pm2017-511-14:30pm load data using SQL code into worked on getting all roundline tablesdown to the firm level, which is on [[Retrieving US VC Data From SDC]]instead of fund; running into small problems with calculating gcd between firms and portco's (will discuss with Ed)
9/29 3pm2017-511-14:45pm completed pulling/normalizing data, still need worked on joining ipo information to roundline; aggregated ipo information to load data using SQL code into tables, which is on [[Retrieving US VC Data From SDC]]the fund level (rather than fund)
9/28 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-6pm met with Edrun), wrote code for fundtofirms and portcotofirms, worked but this code will be re-run once the firm codes are correctly loaded; working on pulling firm and branch office data from SDCjoining portcoexitmaster to roundlinejoinerlean
9/22 3pm2017-5pm join 11-08: loaded roundlinewithgcd table (calculating gcd between portcos and funds; and begin literature review of matching games/venture capital (located ), created GCD example with notes in "Matching Entreps to VC's project datawork folder" in MatchingEntrepsToVCs, worked on E drive."building portcostofirms
9/21 2:302017-11-507:30pm loaded portcocoords table, joined portcocoords to roundlinejoinerlean, calculate gcd distance between funds and portco's, work with Ed on research projectjoining funds to firms
9/19 2:302017-11-503:30pm continue loaded table/sql script for firms office locations into vcdb2 with latitude and longitude coordinates; joined coordinates to work on joining portcoexits and roundlinejoiner all clean base tables in vcdb2for firms, funds, branch offices, joined co and fund coordinates to roundlinejoinerlean in MatchingEntrepsToVC folder under project managementnew table: roundlinecoords
92017-11-02: met with Ed; loaded tables/15 3pm-5pm work on joining portcoexits sql script for branch office and fund office locations into vcdb2 with latitude and roundlinejoiner; create txt file called "Notes on Matching Funds to portcos" in the "Matching Entreps to VC's project folder" on E drive.longitude coordinates
9/14 2:30pm2017-10-527:30pm build table roundlinejoinerapprop (appropriate the come up with next steps for matching firms to funds between funds; work on joining portcoexits and roundlinejoiner)- for geocoding branch offices
9/12 2:30pm2017-10-526:30pm rebuild portcoexits and work on apportioning amounts in roundlinejoinerupdate VC Database Rebuild wiki; identify key for bocore table; verify that fundbasecore table was correctly cleaned after being being rebuilt by Ed
9/7 32017-5pm10-5pm work 24: met with Ed to familiarize with SQL script discuss firmbase and branch office tables; find key for VC project/vcdb2 databasefirmbasecore table; remove undisclosed firmsfrom both firmbasecore and bocore
9/7 2:302017-10-512:30pm receive peer edit and put Shelby's blog post into Wordpress; see what needs to be done on VC project from Ed; reacquaint with wiki, RDP, etc.continue literature review for matching models
4/12 4pm2017-610-11:30pm finish weekly roundupfinished loading tables (firmbase and branchoffice)
4/11 4pm2017-10-6:30pm start weekly roundupload data using SQL code into tables, which is on [[Retrieving US VC Data From SDC]]
42017-09-29: completed pulling/3 4p-6pm finish weekly roundupnormalizing data, still need to load data using SQL code into tables, which is on [[Retrieving US VC Data From SDC]]
4/2 12pm2017-4pm start weekly roundup09-28: met with Ed, worked on pulling firm and branch office data from SDC
32017-09-22: join portcos and funds; and begin literature review of matching games/30 finish weekly roundupventure capital (located in "Matching Entreps to VC's project folder" on E drive."
3/28 continue working 2017-09-21: work with Ed on weekly roundupresearch project
3/27 Finish 2017-09-19: continue to work on joining portcoexits and roundlinejoiner tables in vcdb2, in MatchingEntrepsToVC folder under project page for weekly rounudp, create wiki form for all legislation wiki pages with Ramee, begin weekly roundupmanagement
3/21 4pm2017-6pm Create 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 page folder" on wiki for weekly roundup, finish weekly roundupE drive.
3/20 122017-4pm Create Weekly Roundup09-14: build table roundlinejoinerapprop (appropriate the funds between funds; work on joining portcoexits and roundlinejoiner)
3/9/17 4pm2017-6pm finish weekly roundup post09-27: rebuild portcoexits and work on apportioning amounts in roundlinejoiner
3/72017-09-07: work with Ed to familiarize with SQL script for VC project/17 4pm-6pm continue weekly roundup postvcdb2 database
3/62017-09-05: receive project from Ed; reacquaint with wiki, RDP, etc.</17 2pm-4pm start weekly roundup postonlyinclude>
3/3/17 4pm-6pm finish weekly roundup post===Spring 2017===
2/28/17 4:002017-04-612:00pm continue finish weekly roundup blog post
2/27/17 2:00pm 2017-04- 411:00pm start weekly roundup post
2/23/17 4:002017-04-603:00pm finish weekly roundup blog post
2/21/17 4:002017-04-602:00pm continue start weekly roundup blog post
2/20/17 2:002017-03-430:00pm Start finish weekly roundup blog post
2/16/17 4:00pm2017-03-628:00pm Publish continue working on weekly roundup blog post
2/14/17 4:00pm2017-03-627:00pm continue Finish project page for weekly rounudp, create wiki form for all legislation wiki pages with Ramee, begin weekly roundup blog post
2/13/17 2:002017-03-421:00pm Start Create project page on wiki for weekly roundup, finish weekly roundup blog post
2/2/17 1:002017-03-320:00pm Finish weekly roundup blog postCreate Weekly Roundup
2/1/17 1:002017-03-309:00pm Work on finish weekly roundup blog post
1/30/17 1:002017-03-407:00pm Work on continue weekly roundup blog post
1/26/17 4:002017-03-606:00pm Finish on start weekly roundup blog post
1/24/17 4:002017-03-603:00pm Work on finish weekly roundup blog post
1/23/17 2:002017-02-428:00pm Work on continue weekly roundup blog post
11/29 work on Accelerator project; add content for Weekly Roundup2017-02-27: start weekly roundup post
11/18 publish 2017-02-23: finish weekly roundupblog post
11/17 2:302017-02-421:00pm finish content for Weekly continue weekly roundup; edit Tay's blog post
11/16 10:00am2017-02-1220:00pm work on content for Weekly Start weekly roundupblog post
11/15 2:302017-02-616:00pm Publish weekly roundup 11/18; work on FTC merger/non-merger acquisitions actions spreadsheetblog post
11/10 3:002017-02-514:00pm put continue weekly roundups into wordpressroundup blog post
11/9 10:002017-02-1213:00am finish Start weekly roundup contentblog post
11/8 3:302017-02-602:00pm work on Finish weekly roundup entrepreneurship blog post
11/4 3:002017-02-501:00pm finalize Work on weekly roundup; edit ACA postsblog post
11/3 3:2017-01-30-5:30pm SQL training; Edit Work on weekly roundup blog post
11/2 10:00am2017-01-1226:00pm finish Weekly Finish on weekly roundup blog post
11/1 3:002017-01-624:00pm edit Avesh's Work on weekly roundup blog post; draft weekly round-up post
10/27 12:00pm2017-01-423:00pm edit Eliza's Work on weekly roundup blog post, work on weekly round-up, and attend SQL training with Ed
10/26 10:00-12:00am finish editing ACA articles, submit Tay for peer editing===Fall 2016===
10/25 2:302017-11-429:30pm draft first weekly round-up postwork on Accelerator project; add content for Weekly Roundup
10/24 5:002017-11-618:00pm meet with Avesh, Anne, and Ed to discuss publish weekly roundup blog post
10/21 3:002017-11-317:45pm Attend bloggerfinish content for Weekly roundup; edit Tay's meetingblog post
10/21 2:302017-11-416:00pm incorporate Anne's edits to ACA articles; add information to education innovation summarywork on content for Weekly roundup
10/19 3:002017-11-615:00pm finish dividing two ACA articles; help edit wiki pages for small business development ecosystemweekly roundup 11/18; work on education innovation summaryFTC merger/non-merger acquisitions actions spreadsheet
10/14 3:002017-11-509:00pm finish ACA articleweekly roundup content
10/13 2:302017-11-508:30pm work on finding tweet material, edit ACA post, and look into education/innovation blog postweekly roundup entrepreneurship
10/12 10:002017-11-1204:00am work on trimming down finalize roundup; edit ACA blog postposts
10/2017-11 2:30-503:30pm Continue editing ACA blog SQL training; Edit weekly roundup post, incorporating Anne's comments
10/10 2:302017-11-502:30pm Work on ACA blog finish Weekly roundup post, adding sources
10/7 3:002017-11-601:00pm work on carried interest research, find tweets, edit ACA articleAvesh's blog post; draft weekly round-up post
9/28/16 2017-10-25:00amdraft first weekly round-1:00pm Work on govtrack bill table on Innovation Policy Pageup post
9/27/16 2:302017-10-524:30 upload ACA meet with Avesh, Anne, and Ed to wiki; talk to Ed/Anne about new project (VC carried interest; bill analysis on 6 innovation bills)discuss weekly roundup blog post
9/23/16 3:002017-10-521:00 finish Attend blogger's meeting. Incorporate Anne's edits to ACAarticles; send over add information to Anneeducation innovation summary
9/22/16 2:302017-10-519:30 finish dividing two ACA articles; help edit wiki pages for small business development ecosystem; work on ACA health care articleeducation innovation summary
9/21/16 2017-10-18:00find tweets, re-12:00 Look for more material/data write descriptions for health care article, specifically related to election 2016; find a tweetsmall business resources
9/20/16 2:302017-10-514: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 finish ACA and entrepreneurship article
9/15/16 2:302017-10-513:30 Work work on editing health care document (incorporating edits from Ann); finding tweet material, edit ACA post, and look up women in entrepreneurship research topicsinto education/innovation blog post
9/14/16 2017-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.work on trimming down ACA blog post
9/13/16 2:30pm2017-10-511:30pm Finish up Continue editing old ACA article (share with blog post, incorporating Anne), work on ACA/candidates article, submit two tweets for twitter channel's comments
9/09/16 3:00pm2017-10-510:00pm Set up Work on ACA blog post in google docs (on health care and small businesses, and health care and the election) to share with Anne and Dylanadding sources
9/08/16 300pm2017-510-07:30-pm Twitter meeting with Anne, Albert, Carlin, Rameework on carried interest research, and Avesh; Resolve RDP issue; figure out new project planfind tweets, look at new developments with health care and small business (look at Dylan's edits to health care/innovation)edit ACA article
92017-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: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:00amTwitter 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-1207: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/18 2:30-5:30pm find tweets, re-write descriptions for small business resourcesput weekly roundups into wordpress
2017-10/6 2:30-527:30pm Add information edit Eliza's blog post, work on resources wiki pages for SBDE projectweekly round-up, and attend SQL training with Ed
2017-10/5/16 10:00am-1226:00pm Research info on organizations finish editing ACA articles, submit Tay for SBDE projectpeer editing
[[Category:Work Log]]
