2017-08-02: Edited excel charts from 08-01. Continued on xpath project, completed IPCR sections. For Copy of Rankingv3_Diana's_workingfile in E:\McNair\Projects\Ecosystem\Ranking, added data on population, political activity in the 2016 presidential election, whether it had a university (using a filter of organizations that gave out doctorate degrees in Carnegie Classifications 2015_cleaned in E:\McNair\Projects\University Patents).
2017-08-03: For the cities ranked 1-50 in Top50_Table in E:\McNair\Projects\Ecosystem\Ranking, found 1)City 2) State 3) Dollars invested 4) first-round deals 5) Active Startups 6) Density (Active Startups per Capita). Found percent of 3, 4, and 5 among the totals for all of the US, and for each of 8 metro areas as a proportion of the US' totals. Saved file as "Cleaned ranking table Aug 3", saved in E:\McNair\Projects\Ecosystem\Ranking.