Changes

Jump to navigation Jump to search
1,123 bytes added ,  13:42, 21 September 2020
no edit summary
{{Project|Has project output=Data,Content|Has sponsor=McNair Center|Has title=VC Report Houston 2017|Has owner=Dylan Dickens|Has start date=New Artifacts201702|Has deadline=201704|Has keywords=Venture Capital:All Relevant Deals|Has project status=Subsume:}}This project is a follow on to the [[Accenture Artifacts from 2007-2016 {10 year window}Work]]. The objective is to produce an issue brief within 2 weeks.
==Artifacts Sent to Accenture==:Count of IPOs by Year 2011 - 2016Steps on Wednesday:Count of Match All IPO Names with Years and M&As by Year 2011 - 2016:Count of All M&As in Finance Sector by Year 2011 - 2016:Count of Early, LateA Names with Years to Unique SEL Names and Unique True Other Names, or Seed Backed M&As by Year M&As 2011 - 2016:Count of Early, Late, or Seed Backed M&As in Finance Sector by Year 2011 - 2016:Count of All VC Investments by Year 2011 - 2016:Amount Disclosed All VC Investments by Year 2011 - 2016:All VC Investments by Industry (Broad) 2011 - 2016:All VC Investments by Industry (Specific) 2011 - 2016:Count of All VC Investments by Type of Investment 2011-2016:Amount of All VC Investments by Type of Investment 2011-2016:Count of Early, Late, or Seed VC Investments by Year 2011 - 2016:Amount Disclosed Early, Late, or Seed VC Investments by Year 2011 - 2016:Early, Late, or Seed VC Investments by Industry (Broad) 2011 - 2016:Early, Late, or Seed VC Investments by Industry (Specific) 2011 - 2016:Count of Still Active Early, Late, or Seed VC Backed Startups 2011 - 2016:Count of Earlythis is the lookup list. Then follow the filter, Lateunique, or Seed Deals and lookup methodology by Year 2011 - 2016hand.
Note: The relevant files are AccAQ, AccIP, AccVCRI, and McNairReportonVCinHouston==Data set up==
[[Category===Restrictions===*Nation:Internal]]U.S. State: TX MSA: Houston, Texas City-Galveston, Brazoria Year: 1980-2017. Venture Related: Yes*Definition of Houston: MSA Codes for Galveston, Texas City, Brazoria, and Houston, and at state=TX
===Variables Pulled===Pull round based info (through portfolio company perspective):*Company Name*Round Number*Round Date*Round Amount Disclosed (thou)*Date Company Received Last Investment*Date Company Received First Investment*Company City*Total Known Amount Invested in Company (thou)*Company Found Date*Company Stage Level 3 at Round Date*Company Industry Minor Group*Company Industry Sub Group 3*Company State (Code)*Compnay MSA (Code)*Company Street Address, Line 1*Company Street Address, Line 2*Company Zip Cd ===Exclusions and Classifications===  Seed/Early/Later (Real VC) Seed Early Stage Later Stage  Other VC Acq. for Expansion Acquisition Bridge Loan Expansion Pending Acq Recap or Turnaround  Exclude (non-VC) LBO MBO Open Market Purchase PIPE Secondary Buyout  ==Artifacts==Deals graph*Count of SEL Deals by Year *Count of Other Deals by Year *Count of Still Active SEL VC Backed Startups by year (do last) Rounds graph*Count of SEL VC Investments by Year *Amount Disclosed SEL VC Investments by Year *Count of Other VC Investments by Year *Amount Disclosed Other VC Investments by Year  Industry graph*Amount Disclosed SEL VC Investments by Broad Industry (Minor in SDC)*Amount Disclosed Other VC Investments by Broad Industry (Minor in SDC) IPO graph*Count of IPOs by Year**SEL backed**Other VC backed M&A graph*Count of All M&As by Year**SEL backed**Other VC backed*Count of All M&As in Finance Sector by Year**SEL backed**Other VC backed Broad and specific industries correspond to Minor Group and [[VentureXpert Industry Classification|Subgroup 3 ]] in the SDC terminology.

Navigation menu