Ben Baldazo (Work Log)

Fall 2017

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

Spring 2017

• 4/24/2017 9:30am-11:30am

• 4/19/2017 2:00 - 4:00pm

• 4/17/2017 2:00pm - 4:00pm

• 4/12/2017 3:00pm - 5:30pm

• 4/10/2017 2:00pm - 5:30pm
  • Created some of the missing cohort files for the accelerator project
  • Created PotentialAccelerators.txt in 'E:\McNair\Projects\Accelerators\Crunchbase Snapshot'
    • Used Organizations.csv from crunchbase and matched on "accel" "startup" and "mentor" asking that "accel" and at least one of the other two be included in the description of the organization

• 4/05/2017 2:00pm - 6:00pm
  • Finished code to create a percentage of VC backed marker per accelerators
  • Looked over duplicates from VC data matched to Cohort Data

• 4/03/2017 2:00pm - 4:00pm
  • Worked with duplicates in Matches between Accelerator Cohorts and All VC data for Accelerators project. Notated what the duplicates mean
  • helped teach SQL

• 3/29/2017 2:00pm-5:15pm
  • Filtered websites for Accelerator project using regex code

• 3/22/2017 2:00pm - 5:30pm
  • Began Join tables in "accelerator" database in order to find "PercentVC" amount per accelerator

• 3/20/2017 2:00pm - 5:40pm
  • Taught PSQL and went over future expectations for Houston Entrepreneurship page

• 3/8/2017 2:00pm-5:30pm
  • Ran matches between VC Data and PortCos for the Accelerator Project

• 3/6/2017 2:00pm-3:00pm
  • Cleaned data from VC Data and PortCos

• 3/3/2017 1:00pm-4:00pm
  • Refined data in E:\McNair\Projects\Accelerators\VC_Data_Repeated_Down.txt

• 3/1/2017 2:00pm-5:00pm
  • Worked with the Accelerators project

• 2/27/2017 3:30-5:30
  • Cleaned and reuploaded data to Start-Up Guide (Issue Brief)
  • Worked on editing Houston Issue Brief

• 2/22/2017 2:00pm-5:00pm
  • Taught SDC and normalizer. Updated Normalizer Documentation

• 2/20/2017 2:00pm-5:30pm
  • Report on Houston Issue Brief
  • Cleaning Start-Up Guide (Issue Brief)

• 2/17/2017 3:00pm-5:00pm

• 2/15/2017 2:00pm-3:30pm
  • Report on Houston Issue Brief
  • Graphics for this in "E:\McNair\Projects\Houston\AccRank (IB)\AccRankGraphics.xlsx"

• 2/13/2017 2:00pm-5:30pm
  • Report on Houston Issue Brief

• 2/08/2017 2:00pm-4:00pm
  • Report on Houston Issue Brief

• 2/06/2017 2:00pm-4:00pm
  • Report on Houston Issue Brief

• 2/03/2017 1:00pm-5:00pm
  • 1st and Future

• 2/01/2017 2:00pm-5:30pm
  • Report on Houston Issue Brief

Fall 2016

• 12/02/2016 2:00pm-4:00pm
  • Accelerator Seed List (Data)

• 11/29/2016 1:00pm-5:00pm
  • Accelerator Seed List (Data)

• 11/28/2016 2:00pm-5:00pm
  • Start-Up Guide (Issue Brief)

• 11/22/2016 2:00pm-5:30pm
  • VC Policy Report

• 11/21/2016 3:00pm-5:45pm
  • VC Policy Report

• 11/18/2016 2:00pm-5:00pm
  • VC Policy Report
  • Began matching tables against VC funding

• 11/15/2016 1:00pm-5:20pm
  • VC Policy Report
  • Began putting portfolio information tables onto specific accelerator pages ex: TechStars

• 11/14/2016 2:00pm-5:20pm
  • Money In, Money Out

• 11/11/2016 2:00pm-5:00pm
  • Created tables in PSQL for Accelerator Issue Brief

• 11/8/2016 1:00pm-5:00pm
  • Filtered tables of multiples

• 11/7/2016 3:30pm-5:30pm
  • Began matching tables within PSQL to generate complete VC Data-sheets for portfolios

• 11/4/2016 1pm-5pm
  • Began importing and refining matcher data in PSQL for Accelerator Issue Brief

• 11/1/2016 1pm-5pm
  • Imported and worked tables in Houston Database for Accelerator Issue Brief

• 10/31/2016 2pm-3:30pm
  • Structured steps for PSQL tables
  • PSQL notes in Z:\Houston\HoustonSQLNotes.txt

• 10/28/2016 2pm-3:30pm
  • Redid IPO Pull for more information
  • Began psql to match tables and complete info for accelerator data

• 10/25/2016 1pm-5:00pm
  • Finished Acquisition information
  • Created short term plan for future of Houston Accelerators (issue brief)
  • Guided people to not go into wrong door for an event

• 10/24/2016 2pm-4:50pm
  • Finished IPO information
  • Ran into difficulty with M&A pull from SDC

• 10/21/2016 2pm-4:30pm
  • Pulled IPO information
  • Began running IPO numbers for Houston Accelerators (issue brief)
  • Power went out at 4:30 so I left

• 10/18/2016 1pm-3:30pm and 5:30pm-7pm
  • Finished VC% per accelerator for Houston Accelerators (issue brief)
  • Came back in the evening for McNair wide meeting

• 10/17/2016 2pm-5pm
  • Repulled portfolio lists and began updating VC % per accelerator for Houston Accelerators (issue brief)

Time Sheet

Late start filling out work logs during school year

Summer 2016

• 08/01/2016
  • Called in to grade Organic Chem Tests (-1 hour on time sheet)
  • Created A timeline of first, last investments and founding date for companies in Houston
  • Left documentation for either future self or future owner of the Houston Entrepreneurship page

• 07/29/2016
  • Created timelines representing the Houston area in terms of entrepreneurial growth
    • Base files in 'E:\McNair\Projects\Houston\Startup Source Files\Venture'
    • Charts in separate sheets in 'E:\McNair\Projects\Houston\Acc Rank IB\Charts.xlsx'
  • Put more detail into documentation

• 07/28/2016
  • Went back and documented sql tables in Z:\Bulk\Houston\HoustonSQLNotes.txt
  • Put more detail into documenting the research process
  • Created tables for Accelerator Issue Brief in 'E:\McNair\Projects\Houston\Acc Rank IB\Charts.xlsx'

• 07/26/2016 and 07/27/2016
  • Finished Acquisitions, IPO and Firm name data in [Accelerators Google Sheet]
  • Cleaned up and looked at stats of Benchmarkers vs. HTC and TMCx (which have the most data points of Houston companies)
  • Began looking for more ways to condemn the HTC (though this one may be promising)
    • Just kidding, but the HTC is seeming to do better than expected until now

• 07/25/2016
  • Began working with acquisitions data in SDC
  • ran into a lot of bugs
  • Planned out the next unbiased ranking

• 07/22/2016
  • Presented unbiased VC funding table to Ed (Sheet 4 from [Accelerators Google Sheet])
  • Added some benchmarks
  • Began adding IPOs and Acquisitions data
  • Began looking at relationships between Acc and VC's
  • Tomorrow need to look into: difference between Total Invested and IPO/Aquired amount
  • Tomorrow need to look into: In which accelerators do mentors have skin in the game

• 07/21/2016
  • Matched VC to portfolios of accelerators
  • Used VC info to look at accelerator performance
  • Realized that in the books HTC doesn't look as bad as we thought
  • Tried to come up with better industry averages (in the process)
  • [Accelerators Google Sheet]

• 07/20/2016
  • Filled more information into [Accelerators Google Sheet]
  • Narrowed the companies down with the criteria on the Houston Accelerators (issue brief) page
  • discussed how to judge the organizations more
  • Finished updated PortCo lists for companies 'E:\McNair\Projects\Houston\Startup Source Files\Accelerators\Updated Portfolios'
  • left early to grade Organic Chem exams

• 07/19/2016
  • Filled more information into [Accelerators Google Sheet]
  • Created chart with Dylan attempting to qualify Houston Accelerators (with 11 data points it was underwhelming)
  • Perhaps we need to talk to Yael on how to judge accelerators (objectively?)
    • Yael's seed rankings
  • Deciding on a better way to document accelerators
    • Perhaps we need to look at VC earning companies (giving them an industry bias) then compare Market and Non
    • Perhaps there's another way to measure cohorts
  • Began updating cohort lists for each accelerator 'E:\McNair\Projects\Houston\Startup Source Files\Accelerators\Updated Portfolios'

• 07/18/2016
  • Finished documentation on how to use Geocode.py
  • Began initial work and planning on how to continue with Houston Accelerators (issue brief)
    • How to objectively judge Accelerators
    • How to find this information
    • How to coordinate with Dylan
  • Began filling out [Accelerators Google Sheet]
  • Began populating info into Houston Accelerators (issue brief)
  • To Work on: pick objective standards to judge accelerators on
  • To Work on: finish filling out [Accelerators Google Sheet]

• 07/15/2016
  • Added Latitude and Longitude to the Startups of Houston
  • Created a map of Houston startups
  • met with Ankita about wikipages
  • learned about wiki templates
  • created work log and research plan
  • organized my wikipages under Houston Entrepreneurship
  • Started planning Houston Accelerators (issue brief)
  • Next Time: Create a page on how to use Geocode.py