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

[ForgedAnvil]

Gods list isn't updated with the 'new' SCAG deities in 1.61?

Actually could use some help with this,

Could you (or someone in the forum who is willing and happy to help out!) create a list of each Pantheon (I've done the Faerûnian Pantheon, but need help with the rest)

The list should look like the following with ";" and no spaces for each section Name;Description;Alignment;Domain(s);Symbol

Akadi;Goddess of air;N;Tempest;Cloud
Amaunator;God of the sun;LN;Life, Light;Golden sun
Asmodeus;God of indulgence;LE;Knowledge, Trickery;Three inverted triangles arranged in a long triangle
Auril;Goddess of winter;NE;Nature, Tempest;Six-pointed snowflake

Need to complete Dwarven, Elven, Drow, Halfling etc.

 

[ForgedAnvil]

Translations File Version 1.62 Update

For those keen on translation, there is updated file that includes new sheet and wording used in the character sheets design

You can check it out here - ForgedAnvil 5E Character Generator

If you have updated translations let me know and I'll include them in the next release! (v1.62)

Have fun!

Cheers
ForgedAnvil

 

[Tozjia]

Ahh, I'd say it's looking up ring mail, there is very basic logic that if it cant find "ring of xx" the it will look at the first 4 characters and return the weight of the first match (in this case ring mail). If no match is found it shows "enter weight". So in this case a ring of swimming is okay, it finds and exact match, if you add - 40ft swim speed, then it finds ring mail and show 40 lb! In cases like this use the override cell to make it 0.01 (this is what I use for the signet ring and other rings)

Thanks for the update. That is exactly what I was doing. I wonder if a 40lb ring would give any type of unarmed bonus to a Monk or Brawler. :-D

 

[the_redbeard]

Really appreciate all the hours you've put into this, FA. It's a fantastic tool and looks great. I've been using it to make a ton of pregens for some newbs I'm running a game for.

I found something really odd though. I've been making my own character sheet using the variables you've defined (I have some custom character stats that I want to incorporate in my own sheet.) That's been working great - but only up to a point.

1. The "details" of the character are way more than Excel's 255 character limit for text boxes.
I'm guessing that your character details field is a cell and not a text box. I'm likely going to do something like that, but it means scrapping my work which is textboxes over a graphic of WotC's character sheet.
2. I can't find a variable that contains the character's languages.
This I hope you can help me with.

I'm totally willing to share my work if anyone wants it.

 

[ForgedAnvil]

Really appreciate all the hours you've put into this, FA. It's a fantastic tool and looks great. I've been using it to make a ton of pregens for some newbs I'm running a game for.

I found something really odd though. I've been making my own character sheet using the variables you've defined (I have some custom character stats that I want to incorporate in my own sheet.) That's been working great - but only up to a point.

1. The "details" of the character are way more than Excel's 255 character limit for text boxes.
I'm guessing that your character details field is a cell and not a text box. I'm likely going to do something like that, but it means scrapping my work which is textboxes over a graphic of WotC's character sheet.
2. I can't find a variable that contains the character's languages.
This I hope you can help me with.

I'm totally willing to share my work if anyone wants it.

Cool! Thanks for the feedback and great to hear your using the named variables.

1. My recommendation is to use a hybrid of text boxes and cells. The steps you need to do are:

a. Make the white area of the graphic transparent so you can see the cells. Select image, go to Format under Picture Tool in the ribbon menu > Color > Set Transparency Color then click on the white area of the image.
b. Hide the image to work with cell underneath. Go to Page Layout in the ribbon > Selection Pane > click the little eye closed to hide your image.
c. When designing my sheets I use a higher density cell (e.g. very small cells that are merged). All Columns are set to 0.75 width and All Rows to 6 height.
d. Unhide the image to see where you need to align your cells to match the space for details. Hide the image again to access cells. Merge area and type the named variable
e. Once you have done everything, show the image and turn off gridlines and headings under the View menu in the ribbon

2. Added a languages named variable in 1.62 =CharacterProficiencyLanguages

It'd be awesome to check our your work

 

[ForgedAnvil]

Thanks for the update. That is exactly what I was doing. I wonder if a 40lb ring would give any type of unarmed bonus to a Monk or Brawler. :-D

I'd say DC20 stunned until end of turn on hit and DC10 stunned until end of turn on first sight (what the?!)

 

[the_redbeard]

Cool! Thanks for the feedback and great to hear your using the named variables.

1. My recommendation is to use a hybrid of text boxes and cells. The steps you need to do are:

a. Make the white area of the graphic transparent so you can see the cells. Select image, go to Format under Picture Tool in the ribbon menu > Color > Set Transparency Color then click on the white area of the image.

AGH! Thank you! I was looking everywhere - but not there. hah.

c. When designing my sheets I use a higher density cell (e.g. very small cells that are merged). All Columns are set to 0.75 width and All Rows to 6 height.

Yeap, but I was trying to shortcut the process with textboxes over the graphic as I've done with pdf forms. Certainly used the method above when designing an excel character sheet for hackmaster 5th edition.

d. Unhide the image to see where you need to align your cells to match the space for details. Hide the image again to access cells. Merge area and type the named variable

The selection pane is great for hiding/unhiding and grouping as well.

e. Once you have done everything, show the image and turn off gridlines and headings under the View menu in the ribbon

2. Added a languages named variable in 1.62 =CharacterProficiencyLanguages

Wow, thanks muchly for the prompt response.

It'd be awesome to check our your work

Thanks, I will put it up on copy or something and post a link here.

 

[ForgedAnvil]

Version 1.61 ForgedAnvil D&D 5E Character Transfer Tool - Update

Updated the Character Transfer Tool to v1.61. This version only supports transfers from v1.57, 1.58, 1.59, 1.60, 1.61 to 1.61

You can check it out here - ForgedAnvil 5E Character Generator

If there are issues let me know as I haven't fully tested the tool

Have fun!

Cheers
ForgedAnvil

 

[brooksgbanks]

Updated the Character Transfer Tool to v1.61. This version only supports transfers from v1.57, 1.58, 1.59, 1.60, 1.61 to 1.61

You can check it out here - ForgedAnvil 5E Character Generator

If there are issues let me know as I haven't fully tested the tool

Have fun!

Cheers
ForgedAnvil

ForgedAnvil,

Just downloaded and used to transfer both a modified base sheet (have customer races and backgrounds unique to the campaign I'm playing in) and my actual character sheet (level 4, all the above plus modifications to the armor worn, and quite a bit of info under the Additional Details section. Everything came over correctly, with no issues I could find on a fairly detailed inspection (other than not carrying over the filter settings on CS III to remove blank lines, which doesn't surprise me).

The only question I had was, when using the transfer, and you go to do the initial save of the transferred sheet, it assumes .xlsx format, instead of .xlsm format that the actual character sheet is in. I was wondering if that was just due to have the transfer macro was written when you were doing the script to save as in order to set the file name.

 

[ForgedAnvil]

ForgedAnvil,

Just downloaded and used to transfer both a modified base sheet (have customer races and backgrounds unique to the campaign I'm playing in) and my actual character sheet (level 4, all the above plus modifications to the armor worn, and quite a bit of info under the Additional Details section. Everything came over correctly, with no issues I could find on a fairly detailed inspection (other than not carrying over the filter settings on CS III to remove blank lines, which doesn't surprise me).

The only question I had was, when using the transfer, and you go to do the initial save of the transferred sheet, it assumes .xlsx format, instead of .xlsm format that the actual character sheet is in. I was wondering if that was just due to have the transfer macro was written when you were doing the script to save as in order to set the file name.

Thanks for the feedback brooksgbanks, great to hear the transfers went well. For the format it looks like there is no associated file extension for the transferred file, hence defaults to .xlsx as the first option in the selection list. I think the behavior of how Excel executes the code may have changed (the coding hasn't changed) this might be why the .xlsm extension is lost? [Windows 10, Excel 2016]

If the file is saved in .xlsx format it will still work fine. The reset and translations won't function of course as these require macros and the .xlsm format.