Functions

Created by admin

BitWise functions

BAND(x,y)

Returns the bitwise AND value between x and y

• Parameter: x and y: numbers
• Example: =BAND(1,2)
• Returns: 0

BOR(x,y)

Returns the bitwise OR value between x and y

• Parameter: x and y: numbers
• Example: =BOR(1,2)
• Returns: 3

BXOR(x,y)

Returns the bitwise XOR value between x and y

• Parameter: x and y: numbers
• Example: =BXOR(1,2)
• Returns: 3

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

TrackInfo(ability_name)

Returns the usage per day/min of an ability defined in the INFO section of the BACK worksheet

• Parameter: ability_name as a String (i.e. the name of the ability to track)
• Example: =TrackInfo("Hand of the Apprentice")
• Returns: 9 (assuming you have a Wizard (P) of the Universal school with 9 use per day of his Hand of the Apprentice ability)
• Notes: The function will search only in the INFO section of the BACK sheet, and it will return the number preceding the '/' character which can be found after the 'ability_name' defined. It is based on the PerUse() function created by Jeffk88

Created by user Jeffk88

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)

PerUse (SearchText, Time, Separator)

Search text for a particular time frame, looking for a separator to find the # of uses

• Parameters:
  • SearchText, required, text to search, like spell text, feat text, etc.
  • Time, optional, string, defaults to "D", item to look for near the separator
  • Separator, optional, string, defaults to "/", the separator to look for to determine the # of uses.
• Example: =PerUse("You can cast this spell 3/Day")
• Returns: 3

PerDay (SearchText, Separator)

Search text for many combinations that represent Day, (D,Da,Day,Dy)

• Parameters:
  • SearchText, required, text to search, like spell text, feat text, etc.
  • Separator, optional, string, defaults to "/", the separator to look for to determine the # of uses.
• Example: =PerDay("You can cast this spell 5/Dy")
• Returns: 5

FeatUse(FeatName, Time, Column, Separator)

Search feat table for a particular feat, particular column for a particular time frame, looking for a separator to find the # of uses

• Parameters:
  • FeatName, required, feat to search for
  • Time, optional, string, defaults to "D", item to look for near the separator
  • Column, optional, string, defaults to "index_Feats_Desc", **Must be the string name, not the column #.
  • Separator, optional, string, defaults to "/", the separator to look for to determine the # of uses.
• Example: =PerFeat("SomeCoolFeat") --Assumes feat desc has "Useable 3/Day"
• Returns: 3

SpellDuration(SpellName, Time, Separator, Column)

Search feat table for a particular feat, particular column for a particular time frame, looking for a separator to find the # of uses

• Parameters:
  • SpellName, required, spell to search for
  • Time, optional, string, defaults to "M", item to look for near the separator
  • Separator, optional, string, defaults to "/", the separator to look for to determine the # of uses.
  • Column, optional, string, defaults to "index_Spell_Duration1", **Must be the string name, not the column #.
• Example: =SpellDuration("Enlarge") --if you are 5th level
• Returns: 5

Created by LordVorp

EffectIsActive(str)

(ALSO available on TOS FIVE!)

Returns TRUE is the Active Effect Table (Laptop worksheet) contains the effect named 'str'. It will return FALSE if either this effect is not defined in the active effect table -OR- if it is currently set to OFF.

• Parameters: str a string
• Example: =EffectIsActive("Inspire Courage (Bard)")