474
edits
Changes
Jump to navigation
Jump to search
10/6 3pm-5:30pm load data using SQL code into tables, which is on ===Fall 2017===<onlyinclude>[[Retrieving US VC Data From SDCMeghana Gaur]] [[Work Logs]] [[Meghana Gaur (Work Log)|(log page)]]
9/29 3pm2017-12-51:45pm completed pullingworked with ed to build tables with firm/normalizing portco data, still need to load on distance and fund/portco data using SQL code into tables, which is on [[Retrieving US VC Data From SDC]]performance
9/28 22017-11-16:30-6pm met with Edfinished calculating great circle distances between firms, portco's, worked on pulling firm and branch office data from SDCoffices (look at roundlinewithgcd table)
9/22 3pm2017-5pm join portcos and funds11-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 begin literature review of matching games/venture capital (located in "Matching Entreps to VCportco's project folder" on E drive."(will discuss with Ed)
9/21 2:302017-11-514:30pm work with Ed worked on research projectjoining ipo information to roundline; aggregated ipo information to the fund level (rather than fund)
9/19 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-run), wrote code for fundtofirms and portcotofirms, but this code will be re-5:30pm continue to work run once the firm codes are correctly loaded; working on joining portcoexits and roundlinejoiner tables in vcdb2, in MatchingEntrepsToVC folder under project managementportcoexitmaster to roundlinejoinerlean
9/15 3pm2017-5pm work on joining portcoexits 11-08: loaded roundlinewithgcd table (calculating gcd between portcos and roundlinejoiner; create txt file called "Notes on Matching Funds to portcos" funds), created GCD example with notes in the "Matching Entreps to VC's project datawork folder" in MatchingEntrepsToVCs, worked on E drive.building portcostofirms
9/14 2:30pm2017-11-507:30pm build loaded portcocoords table roundlinejoinerapprop (appropriate the funds , joined portcocoords to roundlinejoinerlean, calculate gcd distance between funds; and portco's, work on joining portcoexits and roundlinejoiner)funds to firms
9/12 2:30pm2017-11-503:30pm rebuild portcoexits loaded table/sql script for firms office locations into vcdb2 with latitude and work on apportioning amounts longitude coordinates; joined coordinates to all clean base tables for firms, funds, branch offices, joined co and fund coordinates to roundlinejoinerlean in roundlinejoinernew table: roundlinecoords
9/7 32017-5pm11-5pm work 02: met with Ed to familiarize with SQL ; loaded tables/sql script for VC project/branch office and fund office locations into vcdb2 databasewith latitude and longitude coordinates
9/7 2:302017-10-527:30pm receive project from Ed; reacquaint come up with wiki, RDP, etc.next steps for matching firms to funds - for geocoding branch offices
4/12 4pm2017-610-26:30pm finish weekly roundupupdate VC Database Rebuild wiki; identify key for bocore table; verify that fundbasecore table was correctly cleaned after being being rebuilt by Ed
4/11 4pm2017-610-24:30pm start weekly roundupmet with Ed to discuss firmbase and branch office tables; find key for firmbasecore table; remove undisclosed firmsfrom both firmbasecore and bocore
4/3 4p2017-6pm finish weekly roundup10-12: peer 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/2 12pm2017-4pm start weekly roundup10-11: finished loading tables (firmbase and branchoffice)
3/30 finish weekly roundup2017-10-6: load data using SQL code into tables, which is on [[Retrieving US VC Data From SDC]]
32017-09-29: completed pulling/28 continue working normalizing data, still need to load data using SQL code into tables, which is on weekly roundup[[Retrieving US VC Data From SDC]]
3/27 Finish project page for weekly rounudp, create wiki form for all legislation wiki pages 2017-09-28: met with RameeEd, begin weekly roundupworked on pulling firm and branch office data from SDC
32017-09-22: join portcos and funds; and begin literature review of matching games/21 4pm-6pm Create venture capital (located in "Matching Entreps to VC's project page folder" on wiki for weekly roundup, finish weekly roundupE drive."
3/20 122017-4pm Create Weekly Roundup09-21: work with Ed on research project
3/9/17 4pm2017-6pm finish weekly roundup post09-19: continue to work on joining portcoexits and roundlinejoiner tables in vcdb2, in MatchingEntrepsToVC folder under project management
3/7/17 4pm2017-6pm continue 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/6/17 2pm2017-4pm start weekly roundup post09-14: build table roundlinejoinerapprop (appropriate the funds between funds; work on joining portcoexits and roundlinejoiner)
3/3/17 4pm2017-6pm finish weekly roundup post09-27: rebuild portcoexits and work on apportioning amounts in roundlinejoiner
2/28/17 4:002017-09-607:00pm continue weekly roundup blog postwork with Ed to familiarize with SQL script for VC project/vcdb2 database
2/27/17 2:00pm 2017-09- 405:00pm start weekly roundup postreceive project from Ed; reacquaint with wiki, RDP, etc.</onlyinclude>
2/23/17 4:00-6:00pm finish weekly roundup blog post===Spring 2017===
2/21/17 4:002017-04-612:00pm continue finish weekly roundup blog post
2/20/17 2:002017-04-411:00pm Start start weekly roundup blog post
2/16/17 4:00pm2017-04-603:00pm Publish finish weekly roundup blog post
2/14/17 4:00pm2017-04-602:00pm continue start weekly roundup blog post
2/13/17 2:002017-03-430:00pm Start finish weekly roundup blog post
2/2/17 1:002017-03-328:00pm Finish continue working on weekly roundup blog post
2/1/17 1:002017-03-327:00pm Work on Finish project page for weekly rounudp, create wiki form for all legislation wiki pages with Ramee, begin weekly roundup blog post
1/30/17 1:002017-03-421:00pm Work Create project page on wiki for weekly roundup, finish weekly roundup blog post
1/26/17 4:002017-03-620:00pm Finish on weekly roundup blog postCreate Weekly Roundup
1/24/17 4:002017-03-609:00pm Work on finish weekly roundup blog post
1/23/17 2:002017-03-407:00pm Work on continue weekly roundup blog post
11/29 work on Accelerator project; add content for Weekly Roundup2017-03-06: start weekly roundup post
11/18 publish 2017-03-03: finish weekly rounduppost
11/17 2:302017-02-428:00pm finish content for Weekly continue weekly roundup; edit Tay's blog post
11/16 10:00am2017-02-1227:00pm work on content for Weekly start weekly rounduppost
11/15 2:302017-02-623:00pm finish weekly roundup 11/18; work on FTC merger/non-merger acquisitions actions spreadsheetblog post
11/10 3:002017-02-521:00pm put continue weekly roundups into wordpressroundup blog post
11/9 10:002017-02-1220:00am finish Start weekly roundup contentblog post
11/8 3:302017-02-616:00pm work on Publish weekly roundup entrepreneurship blog post
11/4 3:002017-02-514:00pm finalize continue weekly roundup; edit ACA postsblog post
11/3 3:302017-02-513:30pm SQL training; Edit Start weekly roundup blog post
11/2 10:00am2017-02-1202:00pm finish Weekly Finish weekly roundup blog post
11/1 3:002017-02-601:00pm edit Avesh's Work on weekly roundup blog post; draft weekly round-up post
10/27 12:00pm2017-01-430:00pm edit Eliza's Work on weekly roundup blog post, work on weekly round-up, and attend SQL training with Ed
10/2017-01-26 10:00-12:00am finish editing ACA articles, submit Tay for peer editingFinish on weekly roundup blog post
10/25 2:302017-01-424:30pm draft first Work on weekly round-up roundup blog post
10/24 5:002017-01-623:00pm meet with Avesh, Anne, and Ed to discuss Work on weekly roundup blog post
10/21 3:00-3:45pm Attend blogger's meeting===Fall 2016===
10/21 2:302017-11-429:00pm incorporate Anne's edits to ACA articleswork on Accelerator project; add information to education innovation summarycontent for Weekly Roundup
10/19 3:002017-11-618:00pm finish dividing two ACA articles; help edit wiki pages for small business development ecosystem; work on education innovation summarypublish weekly roundup
10/18 2:302017-11-517:30pm find tweets, re-write descriptions finish content for small business resourcesWeekly roundup; edit Tay's blog post
10/14 3:002017-11-516:00pm finish ACA articlework on content for Weekly roundup
10/13 2:302017-11-515:30pm weekly roundup 11/18; work on finding tweet material, edit ACA post, and look into educationFTC merger/innovation blog postnon-merger acquisitions actions spreadsheet
10/2017-11 2:30-509:30pm Continue editing ACA blog post, incorporating Anne's commentsfinish weekly roundup content
10/10 2:302017-11-508:30pm Work work on ACA blog post, adding sourcesweekly roundup entrepreneurship
10/7 3:002017-11-604:00pm work on carried interest research, find tweets, finalize roundup; edit ACA articleposts
10/6 2:302017-11-503:30pm Add information on resources wiki pages for SBDE projectSQL training; Edit weekly roundup post
10/5/16 10:00am2017-11-1202:00pm Research info on organizations for SBDE projectfinish Weekly roundup post
9/28/16 102017-11-01:00amedit Avesh's blog post; draft weekly round-1:00pm Work on govtrack bill table on Innovation Policy Pageup post
9/2017-10-27/16 2:30edit Eliza's blog post, work on weekly round-5:30 upload ACA to wiki; talk to up, and attend SQL training with Ed/Anne about new project (VC carried interest; bill analysis on 6 innovation bills)
9/23/16 3:002017-10-526:00 finish editing ACA; send over to Annearticles, submit Tay for peer editing
9/22/16 22017-10-25:30draft first weekly round-5:30 work on ACA health care articleup post
9/21/16 2017-10:00-1224:00 Look for more material/data for health care articlemeet with Avesh, Anne, specifically related and Ed to election 2016; find a tweetdiscuss weekly roundup blog post
9/20/16 2:302017-10-521:30 Finish editing health care article (include sources), re-share with Attend blogger's meeting. Incorporate Anne; look into possible articles on women in small business; look over Dylan's edits to ACA and entrepreneurship articlearticles; add information to education innovation summary
9/15/16 2:302017-10-519:30 Work finish dividing two ACA articles; help edit wiki pages for small business development ecosystem; work on editing health care document (incorporating edits from Ann); look up women in entrepreneurship research topicseducation innovation summary
9/14/16 2017-10:00am-1218:00am Research viable subjects for health care innovationfind tweets, role of health care regulation in 2016 election re-write descriptions for articles. Submit two twitter articles. Review Accenture health articles.small business resources
9/13/16 2:30pm2017-10-514:30pm Finish up editing old ACA article (share with Anne), work on finish ACA/candidates article, submit two tweets for twitter channel
9/09/16 3:00pm2017-10-513:00pm Set up blog work on finding tweet material, edit ACA post in google docs (on health care and small businesses, and health care and the election) to share with Anne and Dylanlook into education/innovation blog post
9/08/16 300pm2017-510-12: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 trimming down ACA blog post
92017-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/07Anne 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 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-1209-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 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/12 10:00-12:00am work on trimming down ACA blog postput weekly roundups into wordpress
[[Category:Work Log]]
