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)