Ben Baldazo (Work Log)

From edegan.com
Revision as of 18:22, 20 November 2017 by BenBaldazo (talk | contribs)
Jump to navigation Jump to search

Fall 2017

Ben Baldazo Work Logs (Work Log)

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

Fall 2016

  • 11/18/2016 2:00pm-5:00pm
  • 11/15/2016 1:00pm-5:20pm
  • 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
  • 10/24/2016 2pm-4:50pm
    • Finished IPO information
    • Ran into difficulty with M&A pull from SDC

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?)
    • 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/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
Retrieved from "http://www.edegan.com/mediawiki/index.php?title=Ben_Baldazo_(Work_Log)&oldid=22002"