Advanced - Parse Effect String type

From Wiki for The Only Sheet
Jump to: navigation, search

The 'String' type is used to define a string result inside an effect.

Example of the String type
Effect Target Effect Type Effect Modifier
Extra Fire Damage String '+2d4 Fire


To access the effect above, you will need this Parse Effect() formula:

=ParseEffect("Extra Fire Damage",t_Integration,"String")

If you put the formula above in the Special Damage section of a weapon, you will get your weapon damage with the string "+2d4 Fire" appended to it!


Exclamation.gif

In Excel, if you start a string with the + symbol, Excel thinks you are entering a formula. Use the ' character in front of the string, as shown above, to avoid this problem!


BACK to Effects