Work Logs

Work Logs are broken down within two divisions of McNair Center, the long-term deliverables of academic papers and short-term deliverables of general content. Individuals working within a division will be listed under the respective one. In case an individual works within both divisions, they will be listed in both locations.

Academic Papers

This division of the McNair Center pursues longer term projects, such as peer-reviewed academic papers.

Jake Silberman

Jake Silberman Work Logs (log page)

Will Cleland

Will Cleland Work Logs (log page)

Todd Rachowin

Todd Rachowin Work Logs (log page)

Amir Kazempour

Amir Kazempour Work Logs (log page)

Content

This division of the McNair Center focuses on shorter term projects, including blog posts, tweets, and issue briefs.

Dylan Dickens

2018-03-06:Troubleshot Key Terms program with Christy, continued to read articles.

2018-03-05: Tested the Key Terms program, found it not to be working. Troubleshot and alerted Christy.

2018-03-01: Started to read articles for key-terms testing.

2018-02-28: Adjusted some wiki pages, started testing the revamped tools.

2018-02-27: Drafted email with concerns to Ed, met with Ed to resolve concerns. Created action plan of testing the revamped tools and codifying a subset of known papers.

2018-02-26: Reviewed Christy's new documentation, prepared to meet with Ed.

2018-02-22: Tested RegEx-Excel Filter process, flagged some additional questions that need guidance from Ed. Met with Christy and worked to resolve coding issues.

2018-02-21: Finished RegEx-Excel Filter process, spoke with Ed about long-term goals of project.

2018-02-20: Continued working on the RegEx-Excel filter.

2018-02-19: Continued working on the RegEx-Excel filter.

2018-02-15: Started developing a RegEx and Excel filter for processing and cross-referencing sources.

2018-02-14: Identified the status of all codes. Drafted an email to Christy about retunring temporarily to help with the codes.

2018-02-13: Ran the KeyTerms and PDF Converter Python Codes.

2018-02-12: Finished troubleshooting crawler, reached out to Ed for guidance. Was redirected to testing Key Terms code.

2018-02-07: Troubleshot the crawler with Christy.

2018-02-06: Troubleshot the crawler with Christy.

2018-02-05: Reached out to Ed for guidance, was redirected to testing the scholar crawler.

2018-02-01: Continued PDF - BibTex filtering

2018-01-31: Started PDF - BibTex filtering process as per meetings with Christy and Lauren.

2018-01-30: Met with both Christy and Lauren.

2018-01-29: Reviewed the current state of PTLR project in order to prepare for meetings on Tuesday.

2018-01-26: Assisted with the McNair Center Event.

2018-01-25: Reached out to previous project owners to gather information for next steps. Was on standby to assist with the Lyceum Research Page

2018-01-24: Searched for tools to accomplish the strategies outlined in Patent Thicket Strategic Planning. Had a hard time locating anything, or getting a good grasp on where exactly the project is and what it needs. Gathered contact information for previous owners to make communications later this week. Also continued to prep the Lyceum Research Page for Ed.

2018-01-23: Finished Patent Thicket Strategic Planning and sent to Ed. Ed approved.

2018-01-22: Read Patent Thicket literature. Met with Ed to discuss broad strategy, began planning for next steps. Patent Thicket Strategic Planning

2018-01-18: Met with Ed to discuss Patent Thicket Project. Helped complete his research for the Amazon HQ2 Report.

2018-01-11: Finalized sourcing for Venture Capital Gap for Women

2018-01-10: Sourced all of Venture Capital Gap for Women, downloaded PDF's for about 3/4 of sources

2018-01-09: Found additional sources on the Venture Capital Gap for Women, as well as Fondren availability for a portion of the sources.

Marcela Interiano

Marcela Interiano Work Logs (log page)

Veeral Shah

Veeral Shah Work Logs (log page)

Ariel Sun

Ariel Sun Work Logs (log page)

Gunny Liu

Gunny Liu Work Logs (Work Log)

Ben Baldazo

Ben Baldazo Work Logs (Work Log)

contributing Projects

Crunchbase Data / Accelerator Seed List (Data) : Combined this data in a table discussed on Crunchbase Data

Houston Innovation District

Augusta Startup Ecosystem

Houston Entrepreneurship Ecosystem Project

Houston Entrepreneurship

Start-Up Guide (Issue Brief)

Houston Accelerators and Incubators (Report)

Cofounding in Exchange for Equity

Start-Ups of Houston (Map)

worklog

2017-11-21: Worked with Ed to set up all of the ground work to begin joining tables for the purpose stated in yesterday's work log. Should be able to finish it upon returning next week, but until then, notes are all held within "Z:\bulk\crunchbase\AccFunding.psql" with the important parts under the header of "From Ed on 21st of Nov. To finish on Nov 27" 2017-11-20: Attempting to link 3 tables from psql crunchbasebulk to find accelerators that have invested in companies. Likely found success with the table "Acc_Funded_Cos" but the investor column is dirty, thus trying to do it cleaner with the aforementioned 3 table link

• This is all noted in "Z:\bulk\crunchbase\AccFunding.psql" and the code for "Acc_Funded_Cos" is emphasized

2017-09-25: Followed Talk:Ben Baldazo (Work Log) to create documentation infrastructure for Augusta Startup Ecosystem

Shoeb Mohammed

Shoeb Mohammed Work Logs Work Log page

James Chen

James Chen Work Logs (log page)

Albert Nabiullin

Albert Nabiullin Work Logs (log page)

Carlin Cherry

Carlin Cherry Work Logs (log page)

Julia Wang

Julia Wang Work Logs (log page)

12/4-12/8 finalizing University Patents report

• 12/4 9-12 edits, sent to Ed, confirming catering for party
• 12/5 9-12 final edits, sent to Ed
• 12/6 1-4 making City Agglomeration graphics
• 12/7 1-3 wrapping up everything

11/27-12/1

• 11/27 10-12 edits, sent to Ed
• 11/29 10-12 catering order for lunch party, wiki page organization
• 11/30 2:30-4:30 edits
• 12/1 10-12 met with Ed, edits

11/20-11/22

• 11/20 10-12 edits
• 11/21 10-12 met with Ed, edits
• 11/22 10-12 met with Ed, edits

11/13-11/17 deadline 11/16 final draft

• 11/13 10-12 redoing reg table
• 11/14 10-12 edits
• 11/15 10-12:30 edits
• 11/16 2:30-4 met with Ed, edits
• 11/17 10-12 edits

11/6-11/10 deadline 11/16 final draft

• 11/6 10-12 4th draft
• 11/8 10-12 met with Ed, editing
• 11/9 2:30-5:30 redoing graphs, restructuring introduction
• 11/10 10-12, 3-4:30 redoing charts, rewriting body

10/30-11/3 deadline 11/16 final draft

• 10/30 10-12 revisions
• 10/31 10-12 revisions
• 11/1 10-12 revisions, new data for basic funding
• 11/2 10-12 revisions

10/23-10/27

• 10/23 10-12 editing University Patents
• 10/24 10-12 reran regressions, fixed problem with Cornell!
• 10/25 10-12 sent 2nd draft to Anne
• 10/26 2:30-4:30 revisions
• 10/27 10-12 sent 3rd draft

10/16-10/20

• 10/16 10-12 pulled Houston patent addresses
• 10/17 10-12 pulled Houston patent addresses
• 10/18 10-12 edited University Patents
• 10/19 2:30-4:30 edited University Patents, tabled patent database reorganization until it is cleaned by Oliver/Shelby/Ed
• 10/20 10-12 edited University Patents

10/11-10/13

• 10/11 10-12 pulling Houston patents
• 10/12 10-12 University patents, sent draft to Anne

10/2-10/6

• 10/2 10-12 work on University Patents draft, close to sending
• 10/3 10-12 Distracted by Augusta project, Reorganizing patent database
• 10/4 10-12 Reorganizing whole patent database by city, state, pulling Crunchbase data for Augusta
• 10/5 2:15-2:45 Augusta patents
• 10/6 10-12 Reorganizing patents, figure out misspellings

9/25-9/29 finish draft

• 9/25 10-12 remaking charts
• 9/26 10-12 data pull for Augusta University
• 9/27 10-12 data pull for Augusta University
• 9/29 10-12 reran log regressions

9/18-9/22/2017

• 9/18 10-12 cleaning data
• 9/19 10-12 cleaning data
• 9/20 10-12 created time-series data set
• 9/21 2:30-4 reran regressions
• 9/22 10-12, 2-3 remade charts

9/11-9/15/2017 Deadline: 9/15 - convert data to time-series, new charts

• 9/11 10-12 Converting to time-series
• 9/12 10-12 Check accuracy, converting to time-series, talked to Jeemin about next project
• 9/13 10-12 Fix R&D data, previous SQL code
• 9/14 2:30pm-4pm, 10:30pm-12am Fix R&D data
• 9/15 10-12, 2-3 join data

9/5-9/8/2017 Putting together University Patents report

• 9/5 10-12 Looked at report, created artifacts, cleaned University Patents folder
• 9/6 10-12 Spoke with Ed about project organization
• 9/7 2:30-4:30 Writing report
• 9/8 10-12 Making data into time series: gyear, make tables and charts

Ramee Saleh

Ramee Saleh Work Logs (log page)

Tay Jacobe

Taylor Jacobe Work Logs (log page)

2017-12-01: Finished up the California post, ready to publish.

2017-11-30: Finished and published the Augusta post. Worked on California post in Wordpress, adding a bit more content suggested by Ed.

2017-11-29: Cleaned up Augusta findings post and cleaned out spam comments on Wordpress; there were almost 2000 spam comments within the last 3 weeks, which is concerning. Maybe there is a reason it has increased so quickly?

2017-11-17: Worked on Augusta Findings post.

2017-11-16: Finished first draft of California post, California Growth (Blog Post). Continued looking into a "Future of Communication" post and what that would look like. Anne also suggested I write a post about Augusta Findings (Blog Post), so I began that!

2017-11-15: Peer edited Yunnie and Dianna's blog post drafts. Anne suggested another post: McNair projects>Agglomeration>PeterHarrison. Research growth of high-tech high-growth enterprises in California from 1986-2016. Use file of maps. Started working on the post.

2017-11-10: Spent the morning cleaning out the spam comments on the blog. More than 1000 of them! Kept investigating Blockchain; I think I've determined that it might not be worth doing a post about because there are already a lot of sources that have published pieces that explain blockchain in simple terms. Continued looking for future blog post ideas: new social media (https://www.techworld.com/social-media/bumble-founder-whitney-wolfe-herd-talks-harvey-weinstein-linkedin-future-of-social-network-3666350/), 3D printing, security in a time of increasing automation and digitalization, the future of communication (smartphones, etc.: what's next?)

2017-11-09: Reorganized work log. Continued researching blockchain and began a draft of a post that will explain the concept in simpler terms and discuss potential impacts of this new technology! Created graphs for the Fund of Funds post. Finished the post and put everything into wordpress.

2017-11-08: Compiled a list of cities in Greater Cincinnati to use for data for blog post. Tried to educate myself on blockchain to eventually write a post about it

2017-11-01: Tried to gather research to improve the VC FOF post. Edited and redrafted. Investigated other potential blog posts.

2017-10-26: Worked on Fund of Funds in VC Blog post

2017-10-25: Looked over summary and edited. Started working on a blog post on the role of fund of funds in venture capital by direction of Anne and Ed

2017-10-23: Worked on a summary document for the Houston Innovation District project, verbal summaries of data analysis

2017-10-19: Worked on Houston Innovation District more. All work is documented on the wiki page

2017-10-18: Working on Houston Innovation District project. Figuring out what we've done and what needs to be done. McNair center servers went down, while I was working, so I lost a decent amount of work that I had been doing to summarize what we had and had to start over when it was rebooted. Cleaned up the wiki page and summarized where we are so far: what data we have & where it is, what data we are currently collecting, and what data we still want/need. Began working on collecting information about tax codes, incentives for development offered in Houston.

2017-10-11: Worked on prep for Houston Innovation District project

2017-10-06: Added more slides and edited. Updated wiki page with info.

2017-10-05: Spent quite a while trying to figure out source data for patent data in slides for Augusta, then worked on cleaning up and adding to Augusta slides that were unfinished/not great, created cybersecurity slide

2017-10-04: Continued working on Augusta project

2017-09-27: Worked on data analysis and research for Augusta Project, looked into Augusta business news (there isn't very much of it!)

2017-09-21: Continued preparation for Augusta Startup Ecosystem and Houston Innovation District Projects

2017-09-20: Preliminary preparations for Augusta and Houston Projects

Archive

This is the work log for archived members.