TOPIC: Amorgen's Character Designer (Excel Spreadsheet)

Apologies if it has been asked already and I missed it...I'm assuming the AoW effect for this year is too much effort to implement for a one off effect?

Cain Eyebright wrote: Apologies if it has been asked already and I missed it...I'm assuming the AoW effect for this year is too much effort to implement for a one off effect?

To be honest, I don't even know what the effect will be. I saw the one mentioned for TD Celebration in the TokenDB, but no indication what it will be for GenCon. Once I know what it is, I'll have to evaluate whether it can be set up or not.

The effects for variable effect tokens should stay throughout the 2017-2018 season.

IIRC it was posted that Origins would be the same as TDC as would GenCon. Not sure I saw anything about GameholeCon though.

OK. The Amulet of Wonder effect as stated would not be easy to accomplish. I'll give it some thought, but I doubt the amount of work to add tripling / quadrupling and open effects will be worth it for a single year effect.

Amorgen Burke wrote: OK. The Amulet of Wonder effect as stated would not be easy to accomplish. I'll give it some thought, but I doubt the amount of work to add tripling / quadrupling and open effects will be worth it for a single year effect.

I thought that would be the case, as the easiest way I could come up with involved creating new iterations of the runestones that could be multiplied and linking them to the slot used for the 4th ring last year. If I can find some free time while I am at work this week, I might see how many tokens that would be...

OK, I think I've worked it out well enough to implement with minimal work for you.

Attached is a file with the line items for the 'extra runestones' with the triple and quadruple effects/wording (rename to .xlsx)
I gave them token id's in the 9000's to make them easy to differentiate. I also set their types so they can't be picked in the regular runestone slots, just the amulet slot.
Besides adding them to the token data tab, the BF2 cell on each class tab would need to be changed to the following equation

=IF(C22="Amulet of Wonder","RunestoneAoW",IF(ISNA(MATCH("Golden Apple of Eris",C42:C56,0)),"No AOW","RunestoneAoW"))


That seems to work for all the tests I've done so far. The only thing I didn't try to add was the effect of using an eldritch runestone with the amulet. If you combine those, looks like it would add 3/4 ioun stone slots which is more than we currently have options for.

Cain Eyebright wrote: OK, I think I've worked it out well enough to implement with minimal work for you.

Attached is a file with the line items for the 'extra runestones' with the triple and quadruple effects/wording (rename to .xlsx)
I gave them token id's in the 9000's to make them easy to differentiate. I also set their types so they can't be picked in the regular runestone slots, just the amulet slot.
Besides adding them to the token data tab, the BF2 cell on each class tab would need to be changed to the following equation

=IF(C22="Amulet of Wonder","RunestoneAoW",IF(ISNA(MATCH("Golden Apple of Eris",C42:C56,0)),"No AOW","RunestoneAoW"))


That seems to work for all the tests I've done so far. The only thing I didn't try to add was the effect of using an eldritch runestone with the amulet. If you combine those, looks like it would add 3/4 ioun stone slots which is more than we currently have options for.

You are very close. BF2 refers to the Amulet of Wonder drop down which was used last year to add the extra ring slot. A better way for this would be to put the formula in DE2, but using "Runestone" instead of "No AOW". This way if you have the Amulet of Wonder, you'll get the AOW Runestone choices, but if you don't, you'll get the standard Runestone choices.

=IF(C22="Amulet of Wonder","RunestoneAoW",IF(ISNA(MATCH("Golden Apple of Eris",C42:C56,0)),"Runestone","RunestoneAoW"))

According to TokenDB, the Eldritch runestone doesn't work with the Amulet of Wonder Effect. Since it adds an additional Ioun, I repurposed the BF2 Amulet of Wonder slot from last year as an Eldritch Runestone slot for this year.

Version 2017.20 Notes

• Updated for 2017 year-specific effects, as follows:
• Converted last year's Amulet of Wonder slot to Eldritch Runestone slot to support the extra Ioun stone
• Added logic for Amulet of Wonder to switch Runestone selection to the AOW tripled or quadrupled options (and added the supporting entries in the token list).
• Updated Special (Ultra Rare) to add 1 level

Thanks to Cain Eyebright for creating the entries I would need to add to accommodate the Amulet of Wonder effect this year. Definitely saved me some time.

Amorgen Burke wrote: Added logic for Amulet of Wonder to switch Runestone selection to the AOW tripled or quadrupled options (and added the supporting entries in the token list).

It's in compliance with this clarification , yes?

Druegar wrote:

Amorgen Burke wrote: Added logic for Amulet of Wonder to switch Runestone selection to the AOW tripled or quadrupled options (and added the supporting entries in the token list).

It's in compliance with this clarification , yes?

Yes. The player will be able to pick the x3 or x4 (obviously the spreadsheet won't know if you turned it in or not, but the player coach will on site). Since it replaces the options for the Runestone slot and doesn't affect the Runestone Fitting Base slots, it holds them to the single affected runestone.

Sweet, thanks!