Reply to thread

Message

<blockquote data-quote="CharlesCurtisStanley" data-source="post: 4589040" data-attributes="member: 43723">Miscellaneous fixes for 1.17Here's an attempt at correcting issues with the Genasi Frost Affinity and Versatile Resistance feats:[code]In the &quot;Extra Bonuses&quot; sheet:Cell S28: =IF(F25=0,MAX(V28:AA28)+U28+AC28,F25)Cell W24: =IF(W23=TRUE,AA19,0)+IF(AND(W23=TRUE,AA20=TRUE),5,0)Cell W25: 0Cell W26: =IF(AA20=TRUE,5,0)Cell X25: =IF(X23=TRUE,AA19,0)Cell X26: =IF(AA20=TRUE,5,0)Cell Y25: 0Cell Y26: =IF(AA20=TRUE,5,0)Cell Y28: =IF(Y23=TRUE,AA19,0)+IF(AND(Y23=TRUE,AA20=TRUE),5,0)[/code]The problems solved here are:<ul>
<li data-xf-list-type="ul">The +3 bonus for Frost Affinity was not being added to Cold Resistance</li>
<li data-xf-list-type="ul">Versatile Resistance provides a +5 bonus to Thunder, not Lightning</li>
<li data-xf-list-type="ul">The racial resistance bonuses to Fire and Cold (for Firesoul and Windsoul Genasi, respectively) stack with those provided by Versatile Resistance.&nbsp; The sheet was allowing the Versatile Resistance bonus to override the racial bonus.</li>
</ul>So, for example, a Stormsoul Genasi (heroic tier) with both feats would have resistance of 5 Fire, 5 Lightning, 5 Thunder, and 8 Cold.I would appreciate the collective wisdom of the group giving this offering a thorough review.&nbsp; Thank you.</blockquote>

[QUOTE="CharlesCurtisStanley, post: 4589040, member: 43723"] [b]Miscellaneous fixes for 1.17[/b] Here's an attempt at correcting issues with the Genasi [I]Frost Affinity[/I] and [I]Versatile Resistance[/I] feats: [code]In the "Extra Bonuses" sheet: Cell S28: =IF(F25=0,MAX(V28:AA28)+U28+AC28,F25) Cell W24: =IF(W23=TRUE,AA19,0)+IF(AND(W23=TRUE,AA20=TRUE),5,0) Cell W25: 0 Cell W26: =IF(AA20=TRUE,5,0) Cell X25: =IF(X23=TRUE,AA19,0) Cell X26: =IF(AA20=TRUE,5,0) Cell Y25: 0 Cell Y26: =IF(AA20=TRUE,5,0) Cell Y28: =IF(Y23=TRUE,AA19,0)+IF(AND(Y23=TRUE,AA20=TRUE),5,0) [/code]The problems solved here are: [LIST] [*]The +3 bonus for [I]Frost Affinity[/I] was not being added to Cold Resistance [*][I]Versatile Resistance[/I] provides a +5 bonus to Thunder, not Lightning [*]The racial resistance bonuses to Fire and Cold (for Firesoul and Windsoul Genasi, respectively) stack with those provided by [I]Versatile Resistance[/I]. The sheet was allowing the [I]Versatile Resistance[/I] bonus to override the racial bonus. [/LIST] So, for example, a Stormsoul Genasi (heroic tier) with both feats would have resistance of 5 Fire, 5 Lightning, 5 Thunder, and 8 Cold. I would appreciate the collective wisdom of the group giving this offering a thorough review. Thank you. [/QUOTE]

Verification