D&D 5E ForgedAnvil D&D 5E Character Generator

[smbakeresq]

That would be cool, but I would not hold my breath at this point. The original creator went M.I.A. after receiving a WotC C&D order, and the team that took over has not been heard from for some time (we are still waiting for a non-beta version with the Xanathar material). WotC wants you to use D&DBeyond and is actively suppressing cool (and free) tools like this one.

I wouldn’t mind using Beyond although I think the application is clunky. However I am not going to pay again for material I already have. I get that Curse has to make their money also, but I don’t have to pay them.

 

[phoffman]

Some fixes

Don't attempt these changes unless you are well versed in xls. I will not respond to any requests.

I have a guess that the same reason your spells don't show unless ALL is selected is the same reason Forest gnome didn't show unless ALL is selected.

[sblock=FIXES]Some Changes to 2.28b8. All changes to Cells are on Worksheet "Tables"


Fix PHB options not showing when "All" isn't selected on Start sheet. A few different ways to do this formula but this worked for BSQ2:


BSQ2 =IF(INDEX(Start!$AJ$3:$AJ$12,MATCH("PHB",Start!$AG $3:$AG$12,0))=OptionSelect,OptionSelect,"")


Feral Tiefling overrides statistics of any subrace:


CR17 =IF(RaceBase=$A$29,"",1)


CS10 =IF(RaceBase=$A$29,2,"")
CS11 =IF(RaceBase=$A$29,2,1)
CS12 =IF(RaceBase=$A$29,2,"")
CS13 =IF(RaceBase=$A$29,2,1)
CS14 =IF(RaceBase=$A$29,2,"")
CS15 =IF(RaceBase=$A$29,2,"")
CS16 =IF(RaceBase=$A$29,2,"")
CS17 =IF(RaceBase=$A$29,2,"")


CT14 =IF(RaceBase=$A$29,"",1)


CU11 =IF(RaceBase=$A$29,1,"")
CU12 =IF(RaceBase=$A$29,1,"")
CU13 =IF(RaceBase=$A$29,1,"")
CU14 =IF(RaceBase=$A$29,1,"")
CU17 =IF(RaceBase=$A$29,1,"")


Fix Level advancement class abilities for custom subclasses, May fix other issues.


GP2 =26


Fix Sword Bard Proficiency with Medium Armor


ABM85 =IF(ABM$1>2,$WW85,"")
ABM86 =IF(ABM$1>2,$WW86,"")
ABM87 =IF(ABM$1>2,$WW87,"")
ABM88 =IF(ABM$1>2,$WW88,"")
ABM89 =IF(ABM$1>2,$WW89,"")
ABM90 =IF(ABM$1>2,$WW90,"")


Fix Sword Bard to only show selected Fighting Style [Known Issue as a result of this change, if multi-classing, Fighting Styles shown in drop down selection for Bard Swords Level 3 will list those available to all classes. Selecting anything other than Dueling or Two-Weapon Fighting will not display that fighting style Under this class feature.]


[Trying to minimize changes made. This solution for IO50 isn't elegant and if the text changes in IN50 the numbers in the formula will need updating. This solution is to get around the 255 character limit in formulas.]

Copy Existing Cell IO50 to cell IN50


IO50 =LEFT(IN50,259)&IF(QT10=QR31,MID(IN50,420,137),IF( QT10=QR34,MID(IN50,557,135)," (" & SelectText&")
"))&RIGHT(IN50,1451)
[/sblock]

 

[BAM-0]

Hi,

I wanna translate into German, the German is kinda bad in some areas, but I don't know how to. @ForgedAnvil Please can you advice ?

Thank you

 

[Timtumm]

Minor bug report

I am using Beta 8 version 2.28 (Thank you, you amazing person).
Thanks for adding "Mordenkainen's Tome of Foes" races to the generator.
When I create a character (I tried level 1 Wizard) with a race of "Elf - Sea Elf", there is an error that made the pane "Character Details" on the right display "#N/A" instead of the stats for Sea Elf, or Wizard. Other races I tried (did not try all) worked great.

Thanks again!

 

[phoffman]

Type "Sea" under subrace. There is an issue with selecting "Sea Elf"

I am using Beta 8 version
2.28 (Thank you, you amazing person).
Thanks for adding "Mordenkainen's Tome of Foes" races to the generator.
When I create a character (I tried level 1 Wizard) with a race of "Elf - Sea Elf", there is an error that made the pane "Character Details" on the right display "#N/A" instead of the stats for Sea Elf, or Wizard. Other races I tried (did not try all) worked great.

Thanks again!

 

[bschrempp]

255 character limit in formulas

I think you are using an old version of Excel. I believe this was increased in Excel 2007 and later. "Length of formula contents 8,192 characters", this is from
Excel specifications and limits
https://support.office.com/en-us/ar...d-limits-1672b34d-7043-467e-8e27-269d656771c3

Bob

 

[phoffman]

Text values in formulas are still limited to 255 characters.

 

[Conandar]

Each text may be limited to 255, but multiple texts can be strung together "text 1" & "text 2" & "text 3", and thereby bypassing the 255 limit. At least, that is what FA told me before he went M.I.A., and that solved a problem I was having.

 

[Chris Wetzel]

re: forged anvil generator.
well if it found its way to krs.wetzel@gmail.com that said person would be most appreciative as his copy has stopped working apparently

thanks if possible or not

krs

 

[phoffman]

Each text may be limited to 255, but multiple texts can be strung together "text 1" & "text 2" & "text 3", and thereby bypassing the 255 limit. At least, that is what FA told me before he went M.I.A., and that solved a problem I was having.

Ah I will have to try that.