Difference between revisions of "Talk:Accelerator Seed List (Data)"

From edegan.com
Jump to navigation Jump to search
Line 12: Line 12:
  
 
\n\1\2\n\1
 
\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

Revision as of 16:44, 17 April 2017

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