Ben Baldazo (Work Log)

Ben Baldazo Work Logs (Work Log)

• 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

End of Summer

• 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