Meghana Gaur (Work Log)

10/25 2:30-4:30pm update VC Database Rebuild wiki; identify key for bocore table; come up with next steps for matching firms to funds

10/24 2:30-5:30pm met with Ed to discuss firmbase and branch office tables; find key for firmbasecore table; remove undisclosed firms from both firmbasecore and bocore

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

10/11 3pm-5pm finished loading tables (firmbase and branchoffice)

10/6 3pm-5:30pm load data using SQL code into tables, which is on Retrieving US VC Data From SDC

9/29 3pm-5:45pm completed pulling/normalizing data, still need to load data using SQL code into tables, which is on Retrieving US VC Data From SDC

9/28 2:30-6pm met with Ed, worked on pulling firm and branch office data from SDC

9/22 3pm-5pm 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."

9/21 2:30-5:30pm work with Ed on research project

9/19 2:30-5:30pm continue to work on joining portcoexits and roundlinejoiner tables in vcdb2, in MatchingEntrepsToVC folder under project management

9/15 3pm-5pm 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.

9/14 2:30pm-5:30pm build table roundlinejoinerapprop (appropriate the funds between funds; work on joining portcoexits and roundlinejoiner)

9/12 2:30pm-5:30pm rebuild portcoexits and work on apportioning amounts in roundlinejoiner

9/7 3-5pm-5pm work with Ed to familiarize with SQL script for VC project/vcdb2 database

9/7 2:30-5:30pm receive project from Ed; reacquaint with wiki, RDP, etc.

4/12 4pm-6:30pm finish weekly roundup

4/11 4pm-6:30pm start weekly roundup

4/3 4p-6pm finish weekly roundup

4/2 12pm-4pm start weekly roundup

3/30 finish weekly roundup

3/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

3/21 4pm-6pm Create project page on wiki for weekly roundup, finish weekly roundup

3/20 12-4pm Create Weekly Roundup

3/9/17 4pm-6pm finish weekly roundup post

3/7/17 4pm-6pm continue weekly roundup post

3/6/17 2pm-4pm start weekly roundup post

3/3/17 4pm-6pm finish weekly roundup post

2/28/17 4:00-6:00pm continue weekly roundup blog post

2/27/17 2:00pm - 4:00pm start weekly roundup post

2/23/17 4:00-6:00pm finish weekly roundup blog post

2/21/17 4:00-6:00pm continue weekly roundup blog post

2/20/17 2:00-4:00pm Start weekly roundup blog post

2/16/17 4:00pm-6:00pm Publish weekly roundup blog post

2/14/17 4:00pm-6:00pm continue weekly roundup blog post

2/13/17 2:00-4:00pm Start weekly roundup blog post

2/2/17 1:00-3:00pm Finish weekly roundup blog post

2/1/17 1:00-3:00pm Work on weekly roundup blog post

1/30/17 1:00-4:00pm Work on weekly roundup blog post

1/26/17 4:00-6:00pm Finish on weekly roundup blog post

1/24/17 4:00-6:00pm Work on weekly roundup blog post

1/23/17 2:00-4:00pm Work on weekly roundup blog post

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

11/16 10:00am-12:00pm work on content for Weekly roundup

11/15 2:30-6:00pm weekly roundup 11/18; work on FTC merger/non-merger acquisitions actions spreadsheet

11/10 3:00-5:00pm put weekly roundups into wordpress

11/9 10:00-12:00am finish weekly roundup content

11/8 3:30-6:00pm work on weekly roundup entrepreneurship

11/4 3:00-5:00pm finalize roundup; edit ACA posts

11/3 3:30-5:30pm SQL training; Edit weekly roundup post

11/2 10:00am-12:00pm finish Weekly roundup post

11/1 3:00-6:00pm edit Avesh's blog post; draft weekly round-up post

10/27 12:00pm-4:00pm edit Eliza's 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

10/25 2:30-4:30pm draft first weekly round-up post

10/24 5:00-6:00pm meet with Avesh, Anne, and Ed to discuss weekly roundup blog post

10/21 3:00-3:45pm Attend blogger's meeting

10/21 2:30-4:00pm 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

10/18 2:30-5:30pm find tweets, re-write descriptions for small business resources

10/14 3:00-5:00pm finish ACA article

10/13 2:30-5:30pm 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

10/11 2:30-5:30pm Continue editing ACA blog post, incorporating Anne's comments

10/10 2:30-5:30pm Work on ACA blog post, adding sources

10/7 3:00-6:00pm 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

10/5/16 10:00am-12:00pm Research info on organizations for SBDE project

9/28/16 10:00am-1:00pm 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)

9/23/16 3:00-5:00 finish ACA; send over to Anne

9/22/16 2:30-5:30 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

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

9/15/16 2:30-5:30 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.

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

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

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)

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.

9/06/16 2:30-4:30pm Set up bio page, work logs, looked at blog posts