Functions

ExtractElement(str,n,sep)

Returns the nth element from a string, using a specified separator character

• Parameter: str as String, n as Integer, sep as String
• Example: =ExtractElement("Monkey&Apes&Chimps",2,"&")
• Returns: Apes

Ordinal(n)

Given an integer, returns a string with that number, and the ordinal of that number.

• Parameter: n as Integer
• Example: =Ordinal(3)
• Returns: 3rd

ConcatenateStrings (range,column,filter,filter column,separator)

Takes a range of values, and concatenates them together with a separator

• Parameters:
  • Range  : Required, range to concatenate from.
  • Column  : Optional, numeric value, defaults to 1, column to concatenate from.
  • Filter  : Optional, string value, defaults to "", condition to search for (ex. return all classes with a Poor combat value "Poor")
  • Column  : Optional, numeric value, defaults to 1, column to search for filter condition
  • Sep  : Optional, separator, defaults to ",", value to separate each value.
• Example: =ConcatenateStrings(t_Class,1,"d12",index_Class_HD,"~")
• Returns: Barbarian~Dragon Disciple~Dwarven Defender~Legendary Dreadnought~Barbarian (P)~Dragon Disciple (P)~Stalwart Defender (P)~Breaker (P)~Brutal Pugilist (P)~Drunken Brute (P)~Elemental Kin (P)~Hurler (P)~Invulnerable Rager (P)~Mounted Fury (P)~Savage Barbarian (P)~Superstitious (P)~Totem Warrior (P)