Reply to thread

Message

<blockquote data-quote="xone01" data-source="post: 4498706" data-attributes="member: 77778">All right, I think i've isolated the problem with adding enhancement damage twice.&nbsp; On the Transport Attack sheet, the &quot;modifiers sign&quot; formula (in row 12) should be &quot;=IF(C11&gt;=0,&quot;+&quot;&amp;C11,C11)&quot; obviously, this formula needs to be translated for each power to the corresponding cellsAlso, I've noticed that Eladrin Soldier was still not granting proficiency with all spears or bonus damage with any of the weapons.&nbsp; The fixes were easy...&nbsp; For bonus damage:&nbsp; On the Proficiency tab, in column J replace &quot;$S$36&quot; with &quot;$S$37&quot; (it was accidentally referring to Dwarven Weapon Training instead of Eladrin Soldier)For weapon proficiencies:&nbsp; Copy the formula in cell E28 on the Proficiency tab into the cells in column E corresponding to the spear weapons.&nbsp; You'll also want to use the same formula for the axes and hammers, replacing &quot;$S$37&quot; with &quot;$S$36&quot; so that Dwarven Weapon Training gives the proper proficiencies as wellI did have one question, while I was throwing together a swordmage, I noticed a couple powers that weren't in the FRPG (specifically Frigid Blade and Dimensional Thunder).&nbsp; Can anyone tell me where these powers come from?loving this sheet, keep up the good work.</blockquote>

[QUOTE="xone01, post: 4498706, member: 77778"] All right, I think i've isolated the problem with adding enhancement damage twice. On the Transport Attack sheet, the "modifiers sign" formula (in row 12) should be "=IF(C11>=0,"+"&C11,C11)" obviously, this formula needs to be translated for each power to the corresponding cells Also, I've noticed that Eladrin Soldier was still not granting proficiency with all spears or bonus damage with any of the weapons. The fixes were easy... For bonus damage: On the Proficiency tab, in column J replace "$S$36" with "$S$37" (it was accidentally referring to Dwarven Weapon Training instead of Eladrin Soldier) For weapon proficiencies: Copy the formula in cell E28 on the Proficiency tab into the cells in column E corresponding to the spear weapons. You'll also want to use the same formula for the axes and hammers, replacing "$S$37" with "$S$36" so that Dwarven Weapon Training gives the proper proficiencies as well I did have one question, while I was throwing together a swordmage, I noticed a couple powers that weren't in the FRPG (specifically Frigid Blade and Dimensional Thunder). Can anyone tell me where these powers come from? loving this sheet, keep up the good work. [/QUOTE]

Verification