474
edits
Changes
Jump to navigation
Jump to search
10/27 3pm-5pm come up with next steps for matching firms to funds - for geocoding branch offices===Fall 2017===<onlyinclude>[[Meghana Gaur]] [[Work Logs]] [[Meghana Gaur (Work Log)|(log page)]]
10/26 2:302017-12-41:30pm update VC Database Rebuild wiki; identify key for bocore table; verify that fundbasecore table was correctly cleaned after being being rebuilt by Ed worked with ed to build tables with firm/portco data on distance and fund/portco data on performance
102017-09-29: completed pulling/11 3pm-5pm finished loading normalizing data, still need to load data using SQL code into tables (firmbase and branchoffice), which is on [[Retrieving US VC Data From SDC]]
10/6 3pm2017-509-28:30pm load data using SQL code into tablesmet with Ed, which is worked on [[Retrieving US VC Data From pulling firm and branch office data from SDC]]
9/29 3pm2017-09-522:45pm completed pullingjoin portcos and funds; and begin literature review of matching games/normalizing data, still need venture capital (located in "Matching Entreps to load data using SQL code into tables, which is VC's project folder" on [[Retrieving US VC Data From SDC]]E drive."
9/28 22017-09-21:30-6pm met work with Ed, worked on pulling firm and branch office data from SDCresearch project
9/22 3pm2017-5pm join portcos 09-19: continue to work on joining portcoexits and funds; and begin literature review of matching games/venture capital (located roundlinejoiner tables in vcdb2, in "Matching Entreps to VC's MatchingEntrepsToVC folder under project folder" on E drive."management
9/21 2:302017-09-515:30pm work with Ed on research joining portcoexits and roundlinejoiner; create txt file called "Notes on Matching Funds to portcos" in the "Matching Entreps to VC's projectfolder" on E drive.
9/19 2:302017-09-514:30pm continue to build table roundlinejoinerapprop (appropriate the funds between funds; work on joining portcoexits and roundlinejoiner tables in vcdb2, in MatchingEntrepsToVC folder under project management)
9/15 3pm2017-5pm work on joining 09-27: rebuild portcoexits and roundlinejoiner; create txt file called "Notes work on Matching Funds to portcos" apportioning amounts in the "Matching Entreps to VC's project folder" on E drive.roundlinejoiner
9/14 2:30pm2017-09-507:30pm build table roundlinejoinerapprop (appropriate the funds between funds; work on joining portcoexits and roundlinejoiner)with Ed to familiarize with SQL script for VC project/vcdb2 database
9/12 2:30pm2017-09-505:30pm rebuild portcoexits and work on apportioning amounts in roundlinejoinerreceive project from Ed; reacquaint with wiki, RDP, etc.</onlyinclude>
9/7 3-5pm-5pm work with Ed to familiarize with SQL script for VC project/vcdb2 database===Spring 2017===
9/7 2:302017-04-512:30pm receive project from Ed; reacquaint with wiki, RDP, etc.finish weekly roundup
4/12 4pm2017-604-11:30pm finish start weekly roundup
4/11 4pm2017-604-03:30pm start finish weekly roundup
4/3 4p2017-6pm finish 04-02: start weekly roundup
4/2 12pm2017-4pm start 03-30: finish weekly roundup
3/30 finish 2017-03-28: continue working on weekly roundup
3/28 continue working on 2017-03-27: Finish project page for weekly rounudp, create wiki form for all legislation wiki pages with Ramee, begin weekly roundup
3/27 Finish 2017-03-21: Create project page on wiki for weekly rounudp, create wiki form for all legislation wiki pages with Rameeroundup, begin finish weekly roundup
3/21 4pm2017-6pm 03-20: Create project page on wiki for weekly roundup, finish weekly roundupWeekly Roundup
3/20 122017-4pm Create Weekly Roundup03-09: finish weekly roundup post
3/9/17 4pm2017-6pm finish 03-07: continue weekly roundup post
3/7/17 4pm2017-6pm continue 03-06: start weekly roundup post
3/6/17 2pm2017-4pm start 03-03: finish weekly roundup post
3/3/17 4pm2017-6pm finish 02-28: continue weekly roundup blog post
2/28/17 4:002017-02-627:00pm continue start weekly roundup blog post
2/27/17 2:00pm 2017-02- 423:00pm start finish weekly roundup blog post
2/23/17 4:002017-02-621:00pm finish continue weekly roundup blog post
2/21/17 4:002017-02-620:00pm continue Start weekly roundup blog post
2/20/17 2:002017-02-416:00pm Start Publish weekly roundup blog post
2/16/17 4:00pm2017-02-614:00pm Publish continue weekly roundup blog post
2/14/17 4:00pm2017-02-613:00pm continue Start weekly roundup blog post
2/13/17 2:002017-02-402:00pm Start Finish weekly roundup blog post
2/2/17 1:002017-02-301:00pm Finish Work on weekly roundup blog post
2/1/17 1:002017-01-330:00pm Work on weekly roundup blog post
1/30/17 1:002017-01-426:00pm Work Finish on weekly roundup blog post
1/26/17 4:002017-01-624:00pm Finish Work on weekly roundup blog post
1/24/17 4:002017-01-623:00pm Work on weekly roundup blog post
1/23/17 2:00-4:00pm Work on weekly roundup blog post===Fall 2016===
10/5/16 10:00am2017-09-1228:00pm Research info Work on govtrack bill table on organizations for SBDE projectInnovation Policy Page
9/28/16 10:00am2017-09-127:00pm Work on govtrack upload ACA to wiki; talk to Ed/Anne about new project (VC carried interest; bill table analysis on Innovation Policy Page6 innovation bills)
9/27/16 2:302017-09-523:30 upload finish ACA to wiki; talk send over to Ed/Anne about new project (VC carried interest; bill analysis on 6 innovation bills)
9/23/16 3:002017-09-522:00 finish work on ACA; send over to Annehealth care article
9/22/16 2:302017-09-521:30 work on ACA Look for more material/data for health care article, specifically related to election 2016; find a tweet
9/21/16 10:002017-09-1220:00 Look for more material/data for Finish editing health care article(include sources), specifically related to election 2016re-share with Anne; find a tweetlook into possible articles on women in small business; look over Dylan's ACA and entrepreneurship article
9/20/16 2:302017-09-515:30 Finish Work on editing health care article document (include sourcesincorporating edits from Ann), re-share with Anne; look into possible articles on up women in small business; look over Dylan's ACA and entrepreneurship articleresearch topics
9/15/16 2:302017-09-514:30 Work on editing Research viable subjects for health care document (incorporating edits from Ann); look up women innovation, role of health care regulation in entrepreneurship research topics2016 election for articles. Submit two twitter articles. Review Accenture health articles.
9/14/16 10:00am2017-09-1213:00am Research viable subjects for health care innovationFinish up editing old ACA article (share with Anne), work on ACA/candidates article, role of health care regulation in 2016 election submit two tweets for articles. Submit two twitter articles. Review Accenture health articles.channel
9/13/16 2:30pm2017-09-509:30pm Finish Set up editing old ACA article blog post in google docs (on health care and small businesses, and health care and the election) to share with Anne), work on ACA/candidates article, submit two tweets for twitter channeland Dylan
9/08/16 300pm2017-509-07:30-pm Twitter meeting with AnneReviewed blog posts, Albertsearched possible blog topics, Carlin, Ramee, and Avesh; Resolve looked up articles for twitter. Will try to resolve issues with 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)on Wednesday.
9/07/16 10:00am2017-09-1206:00pm Reviewed blog postsSet up bio page, searched possible blog topicswork logs, looked up articles for twitter. Will try to resolve issues with RDP on Wednesday.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-16: finished calculating great circle distances between firms, portco's, and branch offices (look at roundlinewithgcd table) 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 (will discuss with Ed) 2017-11-14: worked on joining ipo information to roundline; aggregated ipo information to the fund level (rather than fund) 2017-11-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 2017-11-08: loaded roundlinewithgcd table (calculating gcd between portcos and funds), created GCD example with notes in datawork folder in MatchingEntrepsToVCs, worked on building portcostofirms 2017-11-07: loaded portcocoords table, joined portcocoords to roundlinejoinerlean, calculate gcd distance between funds and portco's, work on joining funds to firms 2017-11-03: loaded table/sql 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: roundlinecoords 2017-11-02: met with Ed; loaded tables/sql script for branch office and fund office locations into vcdb2 with latitude and longitude coordinates 2017-10/24 2-27: come up with next steps for matching firms to funds - for geocoding branch offices 2017-10-26:30update VC Database Rebuild wiki; identify key for bocore table; verify that fundbasecore table was correctly cleaned after being being rebuilt by Ed 2017-510-24:30pm met with Ed to discuss firmbase and branch office tables; find key for firmbasecore table; remove undisclosed firms
from both firmbasecore and bocore
2017-10/-12 2:30-5:30pm 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 2017-10-11: finished loading tables (firmbase and branchoffice) 2017-10-6: load data using SQL code into tables, which is on [[Retrieving US VC Data From SDC]]
2017-11/-29 : work on Accelerator project; add content for Weekly Roundup
2017-11/-18 : publish weekly roundup
2017-11/-17 2:30-4:00pm finish content for Weekly roundup; edit Tay's blog post
2017-11/-16 10:00am-12:00pm work on content for Weekly roundup
2017-11/-15 2:30-6:00pm weekly roundup 11/18; work on FTC merger/non-merger acquisitions actions spreadsheet
2017-11/-10 3:00-5:00pm put weekly roundups into wordpress
2017-11/9 10:00-1209:00am finish weekly roundup content
2017-11/8 3:30-608:00pm work on weekly roundup entrepreneurship
2017-11/4 3:00-504:00pm finalize roundup; edit ACA posts
2017-11/3 3:30-503:30pm SQL training; Edit weekly roundup post
2017-11/2 10:00am-1202:00pm finish Weekly roundup post
2017-11/1 3:00-601:00pm edit Avesh's blog post; draft weekly round-up post
2017-10/-27 12:00pm-4:00pm edit Eliza's blog post, work on weekly round-up, and attend SQL training with Ed
2017-10/-26 10:00-12:00am finish editing ACA articles, submit Tay for peer editing
2017-10/-25 2:30-4:30pm draft first weekly round-up post
2017-10/-24 5:00-6:00pm meet with Avesh, Anne, and Ed to discuss weekly roundup blog post
2017-10/-21 3:00-3:45pm Attend blogger's meeting. Incorporate Anne's edits to ACA articles; add information to education innovation summary
2017-10/21 2:30-419:00pm incorporate Anne's edits to finish dividing two ACA articles; add information to help edit wiki pages for small business development ecosystem; work on education innovation summary
2017-10/19 3-18:00find tweets, re-6:00pm finish dividing two ACA articles; help edit wiki pages write descriptions for small business development ecosystem; work on education innovation summaryresources
2017-10/18 2:30-514:30pm find tweets, re-write descriptions for small business resourcesfinish ACA article
2017-10/14 3:00-513:00pm finish work on finding tweet material, edit ACA articlepost, and look into education/innovation blog post
2017-10/13 2:30-512:30pm work on finding tweet material, edit trimming down ACA post, and look into education/innovation blog post
2017-10/12 10:00-1211:00am work on trimming down Continue editing ACA blog post, incorporating Anne's comments
2017-10/11 2:30-510:30pm Continue editing Work on ACA blog post, incorporating Anne's commentsadding sources
2017-10/10 2:30-507:30pm Work work on carried interest research, find tweets, edit ACA blog post, adding sourcesarticle
2017-10/7 3:00-606:00pm work Add information on carried interest research, find tweets, edit ACA articleresources wiki pages for SBDE project
2017-10/6 2:30-505:30pm Add information Research info on resources wiki pages organizations for SBDE project
2017-9/09/16 3:00pm-508:00pm Set up blog post in google docs (on 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 businesses, and business (look at Dylan's edits to health care and the election/innovation) to share with Anne and Dylan
[[Category:Work Log]]
