Difference between revisions of "Talk:Accelerator Seed List (Data)"
BenBaldazo (talk | contribs) |
BenBaldazo (talk | contribs) |
||
| Line 2: | Line 2: | ||
=Intro= | =Intro= | ||
| − | Welcome to the project. The documents are here: | + | Welcome to the project. The documents are here: '''E:\Mcnair\Projects\Accelerators''' |
| − | + | SQL documents are here: '''E:\Mcnair\Projects\Accelerators\SQL_Data''' | |
| − | SQL documents are here: | + | Database Drive is here: '''Z:\Bulk\Accelerators''' |
| − | |||
| − | Database Drive is here: | ||
| − | |||
=important docs= | =important docs= | ||
| − | The SDC pull that includes all of the round data since 1999: | + | The SDC pull that includes all of the round data since 1999: '''E:\Mcnair\Projects\Accelerators\VC_Data_Repeated_Down.txt''' or '''E:\Mcnair\Projects\Accelerators\"VC Data.xlsx" ''' |
| − | + | The Cohorts of accelerators (under the '''updated''' tab on the bottom): '''E:\Mcnair\Projects\Accelerators\"Clean Cohort Data.xlsx" ''' | |
| − | |||
| − | |||
| − | The Cohorts of accelerators (under the '''updated''' tab on the bottom): | ||
| − | |||
The Crunchbase Snapshots of organizations: | The Crunchbase Snapshots of organizations: | ||
Revision as of 11:03, 24 April 2017
Hi Veeral,
Intro
Welcome to the project. The documents are here: E:\Mcnair\Projects\Accelerators SQL documents are here: E:\Mcnair\Projects\Accelerators\SQL_Data Database Drive is here: Z:\Bulk\Accelerators
important docs
The SDC pull that includes all of the round data since 1999: E:\Mcnair\Projects\Accelerators\VC_Data_Repeated_Down.txt or E:\Mcnair\Projects\Accelerators\"VC Data.xlsx" The Cohorts of accelerators (under the updated tab on the bottom): E:\Mcnair\Projects\Accelerators\"Clean Cohort Data.xlsx" The Crunchbase Snapshots of organizations:
Here's a to-do list:
Rank on VC
- Getting a VC percentage for each Accelerator
Also categorize
- Age
- Nonprofit or not
- Location
RegEx Code for repeating data down for the round data from SDC:
\n([^\t]+\t[^\t]*\t[^\t]*\t[^\t]*\t[^\t]*\t[^\t]*\t[^\t]*\t[^\t]*\t[^\t]*\t[^\t]*\t)(.*)\n\t\t\t\t\t\t\t\t\t\t
\n\1\2\n\1
=if(isnumber(search("blah",B2))=TRUE,1,0) where blah is the substring (what you're searching for), B2 is the string (what your searching in) and 1 represents that it's present and 0 means it isn't.
=sum(A1:C1) This just sums the cells from A1 to C1
