Ben Baldazo (Work Log)
Revision as of 18:05, 29 March 2017 by BenBaldazo (talk | contribs)
Ben Baldazo Work Logs (Work Log)
- 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
- 2/01/2017 2:00pm-5:30pm
- Report on Houston Issue Brief
- 12/02/2016 2:00pm-4:00pm
- 11/29/2016 1:00pm-5:00pm
- 11/28/2016 2:00pm-5:00pm
- 11/22/2016 2:00pm-5:30pm
- 11/21/2016 3:00pm-5:45pm
- 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
- 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)
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
- Created timelines representing the Houston area in terms of entrepreneurial growth
- 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/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