Topic: Excel Character Maker by "Dale"

[RandalThor]

It is this one: Buss.DaleHARPCSexpandedv3 that I am referring to.

I just need to know where to put the Focused Eloquence (Lesser) information, i.e. which sphere I am using that on so the sheet can calculate the final bonus for the spell lists instead of giving me a "REF!" indicator. Thanks.

[jdale]

I haven't been involved in any of the updates, and the closest version I could find was v4 here: http://www.ironcrown.com/ICEforums/index.php?action=tpmod;dl=item819

But it appears the error is arising because it's trying to reference a cell titled "talent_eloquence" which does not exist. You can get rid of the error by naming a cell "talent_eloquence". A bigger issue is that this was intended for the original eloquence talent that (I think) gave a +25 bonus to all spells. There's nothing in the formula on the Skills page to check the sphere. It would be better to have the focused eloquence talent as multiple talents (one for each sphere), and then have the spells only reference the correct one.

As a quick workaround, I would create a "talent_eloquence" cell anywhere inconspicuous and set the value to FALSE. Then manually put the bonus in the Other column on the skills page.

[RandalThor]

Sounds like a plan, thanks.