Advanced Race Creation Guide:Feats

Advanced Race Creation Guide:Feats

Intro to feats

LapTop Advice Column

=IF(tSel_Race="Aasimar (ARG)",IF(AND(COUNTIF(tSel_Feats,"Angelic Blood")=1,COUNTIF(tSel_Feats,"Angelic Flesh (*)")=1,COUNTIF(tSel_Feats,"Angel Wings")=1),"OK","No"),"n/a")

1. Metallic Wings:

=IF(COUNTIF(tSel_Feats,"Metallic Wings")=0,"n/a",IF(ParseEffect("Metallic Wings Prereqs Met",t_Integration)>0,"o/r",IF(OR(tSel_Race<>"Aasimar (ARG)",COUNTIF(tSel_Feats,"Angelic Blood")=0,COUNTIF(tSel_Feats,"Angelic Flesh (*)")=0,COUNTIF(tSel_Feats,"Angel Wings")=0),"No","OK")))

1. Celestial Servant:

needs animal companion, mount, or familiar class features. PE_FamiliarLevel for the familiar PE_AnimalCompanionExLevel for Animal Companion levels

For MOUNT class feature, Cavalier

ISERROR(SEARCH("Slippery Mind (Ex)",res_ClassFeatures))

• IMPLEMENTED with:

  - Prereq:

=IF(COUNTIF(tSel_Feats,"Celestial Servant")=0,"n/a",IF(ParseEffect("Celestial Servant Prereqs Met",t_Integration)>0,"o/r",

   IF(OR(tSel_Race<>"Aasimar (ARG)",AND(PE_FamiliarLevel=0,PE_AnimalCompanionExLevel=0)),"No","OK")))
  - Prereq Details

=IF(OFFSET($A$1,ROW()-1,COLUMN()-2)="No", IF(tSel_Race<>"Aasimar (ARG)","Celestial Servant: Aasimar (ARG) Race required!"&CR,"")& IF(AND(PE_FamiliarLevel=0,PE_AnimalCompanionExLevel=0),"Celestial Servant: Must have an Animal Companion or Familiar!"&CR,""),"")

1. neat stuff here.

http://theonlysheet.com/wiki/index.php?title=Functions

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

So in order for Feats to register an X checkmark if the prereqs aren't met, you have to fill in the Prerequisite Details column, like so:

1. Channel Force | Aasimar, channel energy 2d6 | When you channel energy to deal damage, you may choose to affect only a single target within 30 feet. In addition to dealing damage, if that single target fails its saving throw, you may pull or push the target up to 5 feet for every 2d6 points of channel energy damage you are capable of dealing

=IF(E567="No",IF(PEP_ChannelEnergyLevel=0,"Channel Force requires the Channel Energy class feature"&CR,"")&IF(PEP_ChannelEnergyLevel<3,"Channel Force requires Channel Energy of at least 2d6 (Currently "&rankp_KnowReligion&")"&CR,""),"")

Broken down:

=IF(E567="No",

    IF(PEP_ChannelEnergyLevel=0,"Channel Force: Must have the Channel Energy class feature!"&CR,"")

& IF(PEP_ChannelEnergyLevel<3, "Channel Force: requires Channel Energy of at least 2d6 (Currently "&PerUse(res_ClassFeatures,"6","d")&"d6)!"&CR,"") ,"")

1. Improved Channel Force | Channel Force, Aasimar, channel energy 4d6 | When using Channel Force, you can affect all creatures in a 60-foot line or a 30-foot cone-shaped burst. You must choose to either push or pull all creatures within the affected area that fail their saves.

=IF(E567="No",IF(PEP_ChannelEnergyLevel=0,"Improved Channel Force: Must have the Channel Energy class feature!"&CR,"")&IF(COUNTIF(tSel_Feats,"Channel Force")=0,"Improved Channel Force: Must have Channel Force!"&CR,"")&IF(PEP_ChannelEnergyLevel<7,"Channel Force: requires Channel Energy of at least 4d6 (Currently "&PerUse(res_ClassFeatures,"6","d")&"d6)!"&CR,""),"") =IF(E567="No",

    IF(PEP_ChannelEnergyLevel=0,"Improved Channel Force: Must have the Channel Energy class feature!"&CR,"")

& IF(COUNTIF(tSel_Feats,"Channel Force")=0,"Improved Channel Force: Must have Channel Force!"&CR,"") & IF(PEP_ChannelEnergyLevel<7, "Channel Force: requires Channel Energy of at least 4d6 (Currently "&PerUse(res_ClassFeatures,"6","d")&"d6)!"&CR,"") ,"")

1. Greater Channel Force | Channel Force, Improved Channel Force, channel energy 6d6 | When using Improved Channel Force, you can affect all creatures in a 30-foot-radius burst

=IF(E567="No",

    IF(PEP_ChannelEnergyLevel=0,"Greater Channel Force: Must have the Channel Energy class feature!"&CR,"")

& IF(COUNTIF(tSel_Feats,"Channel Force")=0,"Greater Channel Force: Must have Channel Force!"&CR,"") & IF(COUNTIF(tSel_Feats,"Improved Channel Force")=0,"Greater Channel Force: Must have Improved Channel Force!"&CR,"") & IF(PEP_ChannelEnergyLevel<11, "Greater Channel Force: requires Channel Energy of at least 6d6 (Currently "&PerUse(res_ClassFeatures,"6","d")&"d6)!"&CR,"") ,"")

=IF(E567="No",IF(PEP_ChannelEnergyLevel=0,"Greater Channel Force: Must have the Channel Energy class feature!"&CR,"")&IF(COUNTIF(tSel_Feats,"Channel Force")=0,"Greater Channel Force: Must have Channel Force!"&CR,"")&IF(COUNTIF(tSel_Feats,"Improved Channel Force")=0,"Greater Channel Force: Must have Improved Channel Force!"&CR,"")&IF(PEP_ChannelEnergyLevel<11,"Greater Channel Force: requires Channel Energy of at least 6d6 (Currently "&PerUse(res_ClassFeatures,"6","d")&"d6)!"&CR,""),"")

   # Prereq? column formulas

=IF(COUNTIF(tSel_Feats,"Improved Channel Force")=0,"n/a",IF(ParseEffect("Improved Channel Force Prereqs Met",t_Integration)>0,"o/r",IF(OR(tSel_Race<>"Aasimar (ARG)",COUNTIF(tSel_Feats,"Channel Force")=0,PEP_ChannelEnergyLevel<7),"No","OK"))) =IF(COUNTIF(tSel_Feats,"Greater Channel Force")=0,"n/a",IF(ParseEffect("Greater Channel Force Prereqs Met",t_Integration)>0,"o/r",IF(OR(tSel_Race<>"Aasimar (ARG)",COUNTIF(tSel_Feats,"Improved Channel Force")=0,PEP_ChannelEnergyLevel<11),"No","OK")))

1. 1. 1. EXAMPLE

=IF(E540="No",IF(i_DEX<15,"Improved Multiweapon Fighting: Dexterity must be 15 or more! (currently "&i_DEX&")"&CR,"")&IF(COUNTIF(tSel_Feats,"Multiweapon Fighting")=0,"Improved Multiweapon Fighting: Must have Multiweapon Fighting!"&CR,"")&IF(i_BaseAttack<9,"Improved Multiweapon Fighting: Base Attack Bonus must be 9 or higher! (currently "&i_BaseAttack&")"&CR,""),"")

=IF(E540="No",

   IF(i_DEX<15,"Improved Multiweapon Fighting: Dexterity must be 15 or more! (currently "&i_DEX&")"&CR,"")

& IF(COUNTIF(tSel_Feats,"Multiweapon Fighting")=0,"Improved Multiweapon Fighting: Must have Multiweapon Fighting!"&CR,"") & IF(i_BaseAttack<9,"Improved Multiweapon Fighting: Base Attack Bonus must be 9 or higher! (currently "&i_BaseAttack&")"&CR,"") ,"")

=IF(E567="No",
    IF(PEP_ChannelEnergyLevel=0,"Channel Force requires the Channel Energy class feature"&CR,"")

& IF(PEP_ChannelEnergyLevel<3, "Channel Force requires Channel Energy of at least 2d6 (Currently "&rankp_KnowReligion&")"&CR,"") ,"")

1. Feats:
   1. Angelic Blood | Con 13 | "You gain a +2 bonus on saving throws against effects with the evil descriptor and on Constitution checks to stabilize when you are reduced to negative hit points (but not dead). Furthermore, each time you take bleed or blood drain damage, each undead creature or creature with the evil subtype that is currently adjacent to you also takes 1 point of damage."

=IF(E561="No",

IF(tsel_Race<>"Aasimar (ARG)","Angelic Blood: Aasimar (ARG) Race required!"&CR,"")&

   IF(i_CON<13,"Angelic Blood: Constitution must be 13 or more!"&CR,""),"")

=IF(E561="No",IF(tsel_Race<>"Aasimar (ARG)","Angelic Blood: Aasimar (ARG) Race required!"&CR,"")&IF(i_CON<13,"Angelic Blood: Constitution must be 13 or more!"&CR,""),"")

1. 1. Angelic Flesh (Brazen) | Angelic Blood | "You gain fire resistance 5 and a +2 bonus on saves against fire effects"

=IF(E561="No", IF(tsel_Race<>"Aasimar (ARG)","Angelic Flesh (Brazen): Aasimar (ARG) Race required!"&CR,"")& IF(COUNTIF(tSel_Feats,"Angelic Blood")=0,"Angelic Flesh (Brazen): Must have Angelic Blood!"&CR,""),"")

=IF(E562="No",IF(tsel_Race<>"Aasimar (ARG)","Angelic Flesh (Brazen): Aasimar (ARG) Race required!"&CR,"")&IF(COUNTIF(tSel_Feats,"Angelic Blood")=0,"Angelic Flesh (Brazen): Must have Angelic Blood!"&CR,""),"")

1. 1. Angelic Flesh (Golden) | Angelic Blood | "You gain a +2 bonus on saves against blindness, dazzling, patterns, and effects with the light descriptor. When you cast spells or use spell-like abilities that are from the illusion (pattern) subschool or have the light descriptor, you do so at +1 caster level"
   2. Angelic Flesh (Silver) | Angelic Blood | "You gain a +2 bonus on saves against paralysis, petrification, and poison, and your unarmed strikes or natural weapons count as silver for the purpose of overcoming damage reduction"
   3. Angelic Flesh (Steel) | Angelic Blood | "You gain a +1 natural armor bonus to AC, and your unarmed strikes or natural weapons count as cold iron for the purpose of overcoming damage reduction"

1. 1. Angel Wings | Angelic Blood, 10th level | "You gain a pair of gleaming feathered wings that grant a fly speed of 30 feet (average maneuverability) if wearing light armor or unencumbered, or 20 feet (poor maneuverability) with a medium or heavy load or medium or heavy armor. Fly is a class skill for you."

=IF(E561="No", IF(tsel_Race<>"Aasimar (ARG)","Angel Wings: Aasimar (ARG) Race required!"&CR,"")& IF(COUNTIF(tSel_Feats,"Angelic Blood")=0,"Angel Wings: Must have Angelic Blood!"&CR,"")&

   IF(i_characterlevel<10,"Angel Wings: Character level must be level 10 or higher!"&CR,""),"")

=IF(E560="No",IF(tsel_Race<>"Aasimar (ARG)","Angel Wings: Aasimar (ARG) Race required!"&CR,"")&IF(COUNTIF(tSel_Feats,"Angelic Blood")=0,"Angel Wings: Must have Angelic Blood!"&CR,"")&IF(i_characterlevel<10,"Angel Wings: Character level must be level 10 or higher!"&CR,""),"")

Encumbrance effect on fly speed: =IF(OR(b_MediumArmor,b_MediumLoad,b_HeavyArmor,b_HeavyLoad),20,30)

1. 1. Metallic Wings | Angelic Blood, Angelic Flesh, Angel Wings, 11th level | You gain two wing attacks. These are secondary natural attacks that deal 1d4 points of slashing damage (or 1d3 if you are Small).

=IF(E571="No", IF(tsel_Race<>"Aasimar (ARG)","Metallic Wings: Aasimar (ARG) Race required!"&CR,"")& IF(COUNTIF(tSel_Feats,"Angelic Blood")=0,"Metallic Wings: Must have Angelic Blood!"&CR,"")& IF(COUNTIF(tSel_Feats,"Angelic Flesh (*)")=0,"Metallic Wings: Must have Angelic Flesh!"&CR,"")& IF(COUNTIF(tSel_Feats,"Angel Wings")=0,"Metallic Wings: Must have Angel Wings!"&CR,"")& IF(i_characterlevel<11,"Metallic Wings: Character level must be 11 or higher!"&CR,""),"")

=IF(E571="No",IF(tsel_Race<>"Aasimar (ARG)","Metallic Wings: Aasimar (ARG) Race required!"&CR,"")&IF(COUNTIF(tSel_Feats,"Angelic Blood")=0,"Metallic Wings: Must have Angelic Blood!"&CR,"")&IF(COUNTIF(tSel_Feats,"Angelic Flesh (*)")=0,"Metallic Wings: Must have Angelic Flesh!"&CR,"")&IF(COUNTIF(tSel_Feats,"Angel Wings")=0,"Metallic Wings: Must have Angel Wings!"&CR,"")&IF(i_characterlevel<11,"Metallic Wings: Character level must be 11 or higher!"&CR,""),"") =IF(OFFSET($A$1,ROW()-1,COLUMN()-2)="No",IF(tSel_Race<>tSel_Race_Name,"Metallic Wings: "&tSel_Race_Name&" Race required!"&CR,"")&IF(COUNTIF(tSel_Feats,"Angelic Blood")=0,"Metallic Wings: Must have Angelic Blood!"&CR,"")&IF(COUNTIF(tSel_Feats,"Angelic Flesh (*)")=0,"Metallic Wings: Must have Angelic Flesh!"&CR,"")&IF(COUNTIF(tSel_Feats,"Angel Wings")=0,"Metallic Wings: Must have Angel Wings!"&CR,"")&IF(i_CharacterLevel<11,"Metallic Wings: Character level must be 11 or higher!"&CR,""),"")

' append this string to the formula, to advise the player to equip the weapon: &IF(NOT(OR(tSel_Weapon1="2x Metallic Wings",tSel_Weapon2="2x Metallic Wings",tSel_Weapon3="2x Metallic Wings",tSel_Weapon4="2x Metallic Wings",tSel_Weapon5="2x Metallic Wings",tSel_Weapon6="2x Metallic Wings")),"Metallic Wings: "&CRT&ErrStart&"Equip '2x Metallic Wings' as a Natural (secondary) weapon!"&ErrEnd&CR,"")

1. 1. Heavenly Radiance | Aasimar, Daylight (Sp)

IF(IFERROR(SEARCH("Daylight",tSel_Race_RacialTrait3),0)

=IF(E571="No",

IF(tsel_Race<>"Aasimar (ARG)","Heavenly Radiance: Aasimar (ARG) Race required!"&CR,"")& IF(IFERROR(SEARCH("Daylight",tSel_Race_RacialTrait3),0),"Heavenly Radiance: Must have Daylight (Sp)!"&CR,""),"")

=IF(E571="No",IF(tsel_Race<>"Aasimar (ARG)","Heavenly Radiance: Aasimar (ARG) Race required!"&CR,"")&IF(IFERROR(SEARCH("Daylight",tSel_Race_RacialTrait3),0),"Heavenly Radiance: Must have Daylight (Sp)!"&CR,""),"")

=IF(COUNTIF(tSel_Feats,"Heavenly Radiance")=0,"n/a",
IF(ParseEffect("Heavenly Radiance Prereqs Met",t_Integration)>0,"o/r",
IF(OR(tSel_Race<>"Aasimar (ARG)",
     not(IFERROR(SEARCH("Daylight",tSel_Race_RacialTrait3),0))

),"No","OK")))

=IF(COUNTIF(tSel_Feats,"Heavenly Radiance")=0,"n/a",IF(ParseEffect("Heavenly Radiance Prereqs Met",t_Integration)>0,"o/r",IF(OR(tSel_Race<>"Aasimar (ARG)",not(IFERROR(SEARCH("Daylight",tSel_Race_RacialTrait3),0))),"No","OK")))

Add String effect for the Bonus Spell!! Then describe in the Effect name!!

Nbr of Daylight Uses | Unnamed | 1  | Daylight Bonus Spell | String | Searing Light

tSel_Race_Setup8Opt1 is:

="Daylight (Sp): "&1+COUNTIF(t_Feats,"Heavenly Radiance (*)")&"/day against evil, as the spell, CL"&i_CharacterLevel&IF(t_CM="",""," <"&t_CM&"> ")

' There's a bug above! &t_CM& at the end should be '&REPT(t_CM,1+ParseEffect("Nbr of Daylight Uses"))&

="Daylight (Sp): "&ParseEffect("Nbr of Daylight Uses")&"/day, as the spell, CL"&i_CharacterLevel&IF(t_CM="",""," <"&REPT(t_CM,ParseEffect("Nbr of Daylight Uses"))&"> ")
&IF(ParseEffect("Daylight Bonus Spell")=0,"",CRT&"Can alternatively cast: "&ParseEffect("Daylight Bonus Spell"))

1. 1. Celestial Servant | Aasimar, druid companion, familiar, or mount

IF(COUNTIF(tSel_Feats,"Celestial Servant")=0,"n/a",
IF(ParseEffect("Celestial Servant Prereqs Met",t_Integration)>0,"o/r",
IF(OR(tSel_Race<>"Aasimar (ARG)",AND(PE_FamiliarLevel=0,PE_AnimalCompanionExLevel=0)),"No","OK"))) 

=IF(E566="No",

IF(tsel_Race<>"Aasimar (ARG)","Celestial Servant: Aasimar (ARG) Race required!"&CR,"")& IF(AND(PE_FamiliarLevel=0,PE_AnimalCompanionExLevel=0),"Celestial Servant: Must have Animal Companion or Familiar!"&CR,""),"")

=IF(E566="No",IF(tsel_Race<>"Aasimar (ARG)","Celestial Servant: Aasimar (ARG) Race required!"&CR,"")&IF(AND(PE_FamiliarLevel=0,PE_AnimalCompanionExLevel=0),"Celestial Servant: Must have Animal Companion or Familiar!"&CR,""),"")

PE_FamiliarLevel for the familiar PE_AnimalCompanionExLevel for Animal Companion levels