Difference between revisions of "Meghana Gaur (Work Log)"

From edegan.com
Jump to navigation Jump to search
 
(8 intermediate revisions by 2 users not shown)
Line 1: Line 1:
 +
===Fall 2017===
 +
<onlyinclude>
 
[[Meghana Gaur]] [[Work Logs]] [[Meghana Gaur (Work Log)|(log page)]]
 
[[Meghana Gaur]] [[Work Logs]] [[Meghana Gaur (Work Log)|(log page)]]
  
===Fall 2017===
+
2017-12-1: worked with ed to build tables with firm/portco data on distance and fund/portco data on performance
<onlyinclude>
+
 
 +
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-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-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/27 come up with next steps for matching firms to funds - for geocoding branch offices
+
2017-10-27: come up with next steps for matching firms to funds - for geocoding branch offices
  
2017/10/26 update VC Database Rebuild wiki; identify key for bocore table; verify that fundbasecore table was correctly cleaned after being being rebuilt by Ed  
+
2017-10-26: update VC Database Rebuild wiki; identify key for bocore table; verify that fundbasecore table was correctly cleaned after being being rebuilt by Ed  
  
2017/10/24 met with Ed to discuss firmbase and branch office tables; find key for firmbasecore table; remove undisclosed firms
+
2017-10-24: met with Ed to discuss firmbase and branch office tables; find key for firmbasecore table; remove undisclosed firms
 
from both firmbasecore and bocore
 
from both firmbasecore and bocore
  
2017/10/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
+
2017-10-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
  
2017/10/11 finished loading tables (firmbase and branchoffice)
+
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-10-6: load data using SQL code into tables, which is on [[Retrieving US VC Data From SDC]]
  
2017/9/29 completed pulling/normalizing data, still need to load data using SQL code into tables, which is on [[Retrieving US VC Data From SDC]]
+
2017-09-29: completed pulling/normalizing data, still need to load data using SQL code into tables, which is on [[Retrieving US VC Data From SDC]]
  
2017/9/28 met with Ed, worked on pulling firm and branch office data from SDC
+
2017-09-28: met with Ed, worked on pulling firm and branch office data from SDC
  
2017/9/22 join portcos and funds; and begin literature review of matching games/venture capital (located in "Matching Entreps to VC's project folder" on E drive."
+
2017-09-22: join portcos and funds; and begin literature review of matching games/venture capital (located in "Matching Entreps to VC's project folder" on E drive."
  
2017/9/21 work with Ed on research project
+
2017-09-21: work with Ed on research project
  
2017/9/19 continue to work on joining portcoexits and roundlinejoiner tables in vcdb2, in MatchingEntrepsToVC folder under project management
+
2017-09-19: continue to work on joining portcoexits and roundlinejoiner tables in vcdb2, in MatchingEntrepsToVC folder under project management
  
2017/9/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.
+
2017-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.
  
2017/9/14 build table roundlinejoinerapprop (appropriate the funds between funds; work on joining portcoexits and roundlinejoiner)
+
2017-09-14: build table roundlinejoinerapprop (appropriate the funds between funds; work on joining portcoexits and roundlinejoiner)
  
2017/9/27 rebuild portcoexits and work on apportioning amounts in roundlinejoiner
+
2017-09-27: rebuild portcoexits and work on apportioning amounts in roundlinejoiner
  
2017/9/7 work with Ed to familiarize with SQL script for VC project/vcdb2 database
+
2017-09-07: work with Ed to familiarize with SQL script for VC project/vcdb2 database
 
 
2017/9/5 receive project from Ed; reacquaint with wiki, RDP, etc.
 
  
 +
2017-09-05: receive project from Ed; reacquaint with wiki, RDP, etc.
 
</onlyinclude>
 
</onlyinclude>
  
 
===Spring 2017===
 
===Spring 2017===
  
4/12 4pm-6:30pm finish weekly roundup
+
2017-04-12: finish weekly roundup
  
4/11 4pm-6:30pm start weekly roundup
+
2017-04-11: start weekly roundup
  
4/3 4p-6pm finish weekly roundup
+
2017-04-03: finish weekly roundup
  
4/2 12pm-4pm start weekly roundup
+
2017-04-02: start weekly roundup
  
3/30 finish weekly roundup
+
2017-03-30: finish weekly roundup
  
3/28 continue working on weekly roundup
+
2017-03-28: continue working on weekly roundup
  
3/27 Finish project page for weekly rounudp, create wiki form for all legislation wiki pages with Ramee, begin weekly roundup
+
2017-03-27: Finish project page for weekly rounudp, create wiki form for all legislation wiki pages with Ramee, begin weekly roundup
  
3/21 4pm-6pm Create project page on wiki for weekly roundup, finish weekly roundup
+
2017-03-21: Create project page on wiki for weekly roundup, finish weekly roundup
  
3/20 12-4pm Create Weekly Roundup
+
2017-03-20: Create Weekly Roundup
  
3/9/17 4pm-6pm finish weekly roundup post
+
2017-03-09: finish weekly roundup post
  
3/7/17 4pm-6pm continue weekly roundup post
+
2017-03-07: continue weekly roundup post
  
3/6/17 2pm-4pm start weekly roundup post
+
2017-03-06: start weekly roundup post
  
3/3/17 4pm-6pm finish weekly roundup post
+
2017-03-03: finish weekly roundup post
  
2/28/17 4:00-6:00pm continue weekly roundup blog post
+
2017-02-28: continue weekly roundup blog post
  
2/27/17 2:00pm - 4:00pm start weekly roundup post
+
2017-02-27: start weekly roundup post
  
2/23/17 4:00-6:00pm finish weekly roundup blog post
+
2017-02-23: finish weekly roundup blog post
  
2/21/17 4:00-6:00pm continue weekly roundup blog post
+
2017-02-21: continue weekly roundup blog post
  
2/20/17 2:00-4:00pm Start weekly roundup blog post
+
2017-02-20: Start weekly roundup blog post
  
2/16/17 4:00pm-6:00pm Publish weekly roundup blog post
+
2017-02-16: Publish weekly roundup blog post
  
2/14/17 4:00pm-6:00pm continue weekly roundup blog post
+
2017-02-14: continue weekly roundup blog post
  
2/13/17 2:00-4:00pm Start weekly roundup blog post
+
2017-02-13: Start weekly roundup blog post
  
2/2/17 1:00-3:00pm Finish weekly roundup blog post
+
2017-02-02: Finish weekly roundup blog post
  
2/1/17 1:00-3:00pm Work on weekly roundup blog post
+
2017-02-01: Work on weekly roundup blog post
  
1/30/17 1:00-4:00pm Work on weekly roundup blog post
+
2017-01-30: Work on weekly roundup blog post
  
1/26/17 4:00-6:00pm Finish on weekly roundup blog post
+
2017-01-26: Finish on weekly roundup blog post
  
1/24/17 4:00-6:00pm Work on weekly roundup blog post
+
2017-01-24: Work on weekly roundup blog post
  
1/23/17 2:00-4:00pm Work on weekly roundup blog post
+
2017-01-23: Work on weekly roundup blog post
  
 
===Fall 2016===
 
===Fall 2016===
  
11/29 work on Accelerator project; add content for Weekly Roundup
+
2017-11-29: work on Accelerator project; add content for Weekly Roundup
 
 
11/18 publish weekly roundup
 
  
11/17 2:30-4:00pm finish content for Weekly roundup; edit Tay's blog post
+
2017-11-18: publish weekly roundup
  
11/16 10:00am-12:00pm work on content for Weekly roundup
+
2017-11-17: finish content for Weekly roundup; edit Tay's blog post
  
11/15 2:30-6:00pm weekly roundup 11/18; work on FTC merger/non-merger acquisitions actions spreadsheet
+
2017-11-16: work on content for Weekly roundup
  
11/10 3:00-5:00pm put weekly roundups into wordpress
+
2017-11-15:weekly roundup 11/18; work on FTC merger/non-merger acquisitions actions spreadsheet
  
11/9 10:00-12:00am finish weekly roundup content
+
2017-11-10: put weekly roundups into wordpress
  
11/8 3:30-6:00pm work on weekly roundup entrepreneurship
+
2017-11-09: finish weekly roundup content
  
11/4 3:00-5:00pm finalize roundup; edit ACA posts
+
2017-11-08: work on weekly roundup entrepreneurship
  
11/3 3:30-5:30pm SQL training; Edit weekly roundup post
+
2017-11-04: finalize roundup; edit ACA posts
  
11/2 10:00am-12:00pm finish Weekly roundup post
+
2017-11-03: SQL training; Edit weekly roundup post
  
11/1 3:00-6:00pm edit Avesh's blog post; draft weekly round-up post
+
2017-11-02: finish Weekly roundup post
  
10/27 12:00pm-4:00pm edit Eliza's blog post, work on weekly round-up, and attend SQL training with Ed
+
2017-11-01: edit Avesh's blog post; draft weekly round-up post
  
10/26 10:00-12:00am finish editing ACA articles, submit Tay for peer editing
+
2017-10-27: edit Eliza's blog post, work on weekly round-up, and attend SQL training with Ed
  
10/25 2:30-4:30pm draft first weekly round-up post
+
2017-10-26: finish editing ACA articles, submit Tay for peer editing
  
10/24 5:00-6:00pm meet with Avesh, Anne, and Ed to discuss weekly roundup blog post
+
2017-10-25: draft first weekly round-up post
  
10/21 3:00-3:45pm Attend blogger's meeting
+
2017-10-24: meet with Avesh, Anne, and Ed to discuss weekly roundup blog post
  
10/21 2:30-4:00pm incorporate Anne's edits to ACA articles; add information to education innovation summary
+
2017-10-21: Attend blogger's meeting. Incorporate Anne's edits to ACA articles; add information to education innovation summary
  
10/19 3:00-6:00pm finish dividing two ACA articles; help edit wiki pages for small business development ecosystem; work on 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
  
10/18 2:30-5:30pm find tweets, re-write descriptions for small business resources
+
2017-10-18: find tweets, re-write descriptions for small business resources
  
10/14 3:00-5:00pm finish ACA article
+
2017-10-14: finish ACA article
  
10/13 2:30-5:30pm work on finding tweet material, edit ACA post, and look into education/innovation blog post
+
2017-10-13: work on finding tweet material, edit ACA post, and look into education/innovation blog post
  
10/12 10:00-12:00am work on trimming down ACA blog post
+
2017-10-12: work on trimming down ACA blog post
  
10/11 2:30-5:30pm Continue editing ACA blog post, incorporating Anne's comments
+
2017-10-11: Continue editing ACA blog post, incorporating Anne's comments
  
10/10 2:30-5:30pm Work on ACA blog post, adding sources
+
2017-10-10: Work on ACA blog post, adding sources
  
10/7 3:00-6:00pm work on carried interest research, find tweets, edit ACA article
+
2017-10-07: work on carried interest research, find tweets, edit ACA article
  
10/6 2:30-5:30pm Add information on resources wiki pages for SBDE project
+
2017-10-06: Add information on resources wiki pages for SBDE project
  
10/5/16 10:00am-12:00pm Research info on organizations for SBDE project
+
2017-10-05: Research info on organizations for SBDE project
  
9/28/16 10:00am-1:00pm Work on govtrack bill table on Innovation Policy Page
+
2017-09-28: Work on govtrack bill table on Innovation Policy Page
  
9/27/16 2:30-5:30 upload ACA to wiki; talk to Ed/Anne about new project (VC carried interest; bill analysis on 6 innovation bills)
+
2017-09-27: upload ACA to wiki; talk to Ed/Anne about new project (VC carried interest; bill analysis on 6 innovation bills)
  
9/23/16 3:00-5:00 finish ACA;  send over to Anne
+
2017-09-23: finish ACA;  send over to Anne
  
9/22/16 2:30-5:30 work on ACA health care article
+
2017-09-22: work on ACA health care article
  
9/21/16 10:00-12:00 Look for more material/data for health care article, specifically related to election 2016; find a tweet
+
2017-09-21: Look for more material/data for health care article, specifically related to election 2016; find a tweet
  
9/20/16 2:30-5: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 ACA and entrepreneurship article
+
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
  
9/15/16 2:30-5:30 Work on editing health care document (incorporating edits from Ann); look up women in entrepreneurship research topics
+
2017-09-15: Work on editing health care document (incorporating edits from Ann); look up women in entrepreneurship research topics
  
9/14/16 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.
+
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.
  
9/13/16 2:30pm-5:30pm Finish up editing old ACA article (share with Anne), work on ACA/candidates article, submit two tweets for twitter channel
+
2017-09-13: Finish up editing old ACA article (share with Anne), work on ACA/candidates article, submit two tweets for twitter channel
  
9/09/16 3:00pm-5:00pm 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-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
  
9/08/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)
+
2017-09-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)
  
9/07/16 10:00am-12:00pm Reviewed blog posts, searched possible blog topics, looked up articles for twitter. Will try to resolve issues with RDP on Wednesday.
+
2017-09-07: Reviewed blog posts, searched possible blog topics, looked up articles for twitter. Will try to resolve issues with RDP on Wednesday.
  
9/06/16 2:30-4:30pm Set up bio page, work logs, looked at blog posts
+
2017-09-06: Set up bio page, work logs, looked at blog posts
  
 
[[Category:Work Log]]
 
[[Category:Work Log]]

Latest revision as of 18:37, 1 December 2017

Fall 2017

Meghana Gaur Work Logs (log page)

2017-12-1: worked with ed to build tables with firm/portco data on distance and fund/portco data on performance

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-27: come up with next steps for matching firms to funds - for geocoding branch offices

2017-10-26: update VC Database Rebuild wiki; identify key for bocore table; verify that fundbasecore table was correctly cleaned after being being rebuilt by Ed

2017-10-24: 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: 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-09-29: completed pulling/normalizing data, still need to load data using SQL code into tables, which is on Retrieving US VC Data From SDC

2017-09-28: met with Ed, worked on pulling firm and branch office data from SDC

2017-09-22: join portcos and funds; and begin literature review of matching games/venture capital (located in "Matching Entreps to VC's project folder" on E drive."

2017-09-21: work with Ed on research project

2017-09-19: continue to work on joining portcoexits and roundlinejoiner tables in vcdb2, in MatchingEntrepsToVC folder under project management

2017-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.

2017-09-14: build table roundlinejoinerapprop (appropriate the funds between funds; work on joining portcoexits and roundlinejoiner)

2017-09-27: rebuild portcoexits and work on apportioning amounts in roundlinejoiner

2017-09-07: work with Ed to familiarize with SQL script for VC project/vcdb2 database

2017-09-05: receive project from Ed; reacquaint with wiki, RDP, etc.


Spring 2017

2017-04-12: finish weekly roundup

2017-04-11: start weekly roundup

2017-04-03: finish weekly roundup

2017-04-02: start weekly roundup

2017-03-30: finish weekly roundup

2017-03-28: continue working on weekly roundup

2017-03-27: Finish project page for weekly rounudp, create wiki form for all legislation wiki pages with Ramee, begin weekly roundup

2017-03-21: Create project page on wiki for weekly roundup, finish weekly roundup

2017-03-20: Create Weekly Roundup

2017-03-09: finish weekly roundup post

2017-03-07: continue weekly roundup post

2017-03-06: start weekly roundup post

2017-03-03: finish weekly roundup post

2017-02-28: continue weekly roundup blog post

2017-02-27: start weekly roundup post

2017-02-23: finish weekly roundup blog post

2017-02-21: continue weekly roundup blog post

2017-02-20: Start weekly roundup blog post

2017-02-16: Publish weekly roundup blog post

2017-02-14: continue weekly roundup blog post

2017-02-13: Start weekly roundup blog post

2017-02-02: Finish weekly roundup blog post

2017-02-01: Work on weekly roundup blog post

2017-01-30: Work on weekly roundup blog post

2017-01-26: Finish on weekly roundup blog post

2017-01-24: Work on weekly roundup blog post

2017-01-23: Work on weekly roundup blog post

Fall 2016

2017-11-29: work on Accelerator project; add content for Weekly Roundup

2017-11-18: publish weekly roundup

2017-11-17: finish content for Weekly roundup; edit Tay's blog post

2017-11-16: work on content for Weekly roundup

2017-11-15:weekly roundup 11/18; work on FTC merger/non-merger acquisitions actions spreadsheet

2017-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/candidates 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: 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: Set up bio page, work logs, looked at blog posts