D&D 5E Complete Random Character Generator (2.0)

Should be a great start!

Will test over the holiday break.

jh

Version 9.0 is Released!

Updated: Ability score randomization choices
Fixed: height, weight, speed, and racial abilities not showing up.
Rearranged: USER TAB Race, Class, Level, and Ability Score generation show up first

https://www.dropbox.com/s/06z6f5lww...acter Generator 9.0 release version.xlsx?dl=0

Enjoy!


Jh

Release version 9.1: Ability score errata correction

https://www.dropbox.com/s/xr8anueq2...acter Generator 9.1 RELEASE VERSION.xlsx?dl=0

jh


VERSION 9.1 FIXED REFERENCE ERRATA
SKILLS:
DONE: Skills: added Proficiency title bar and bonus: CELL SKILLS!G27 to the bottom: =IF((SUM(D27:F27 ))<>0,MATH!$C$46,0)
DONE: Skills!G47, G48 reference two of the skills. Should reference ALL CLASS skills
DONE: Corrected cells BN8,9: were referencing races 28,29 rather than the drow, eladrin (23,24

TOP SHEET:
DONE: corrected column reference for Racial Wepaon proficiency box: PAGE 1: Weapon proficiencies lower cell: =VLOOKUP(MATH!C11,RACE!B6:O34,14,)

DONE: EB28,28: only shows “ki save” and number if character is a monk
DONE: Fixed: CS37, etc. only shows if character is a Mystic
DONE: Fixed: missing racial spells

RACE:
DONE: Corrected Resistances: gnomes (none), tiefling fire, dragonborn type

MATH:
DONE: d49: corrected reference column: =VLOOKUP(C11,RACE!$B$6:$AD$50,27)

ABILITIES
DONE: Fixed min-max reference error on CLASS: i4:n4 :::: Set to reference =ABILITIES!H36 to h41 as correct scores now
DONE: Fixed reference error to MIN-max to raw scores: ABILITIES!D71 =IF(USER!$L$6=3,USER!K15,INDEX(CLASS!$I$6:$N$18,MATH!$C$8,1)) etc.
DONE: fixed reference error if user wants to keep both chosen scores and chosen scores in specific order. ABILITIES!N71 (etc) now corrected:
=IF(USER!$O$6=4,USER!K15,INDEX($H$70:$K$76,2,(1+USER!$O$6)))

DONE: Add OR function to RANd+Save order determination to get correct output: ABILITIES!:f59 etc.
*************THEY ARE SET TO NON-MIN MAX, SO MAY GET A MONK WHO IS MORE WISE THAN STRONG



USER
DONE: ADDED: “NON RANDOM USER SET” choice to : USER!ABILITY SCORE RANDOMIZATION so USER determines the min-max order

9.2.2 Version:

Rearranging p.2,3

MATH:
DONE: Added categories for Skill total score and cells for having total score after the proficiency for the Abbreviated Stat block reference (e.g. Stealth +6, etc.)
DONE: Cosmetic fix to commas for MATH: SKILLS PROFICIENCY SCORES for abbreviated stat block.
QUIRKS, appearance: paragraph form
REMOVED: clutter
FIXED: fixed wealth on p.1. may move to p.3
ADDED non-proficiency/non-stat Racial abilities
DWARF (BASE AND INDIVIDUAL RACE):
Darkvision: see in dim light within 60' as bright light, and in darkness as dim light. | Dw. Resilience: Advantage on saves vs. poison, and resistance vs. poison damage. | Stonecunning: Intelligence(History) check for stonework doubles proficiency bonus.
ELF BASE
Darkvision: see in dim light within 60' as bright light, and in darkness as dim light. | Fey Ancestry: Adv on saves vs charm and immune to sleep magic. | Trance: Do not need sleep. Semiconscious meditation for 4 hours counts as 8 hours sleep. |
Wood:
Darkvision: see in dim light within 60' as bright light, and in darkness as dim light. | Fey Ancestry: Adv on saves vs charm and immune to sleep magic. | Trance: Do not need sleep. Semiconscious meditation for 4 hours counts as 8 hours sleep. | Mask of the Wild: May hide even in only lightly obscuring natural phenomena.
Drow:
Superior Darkvision: see in dim light within 120' as bright light, and in darkness as dim light. | Sunlight Sensitivity: Disadvantage on attacks and Perception checks that rely on sight when in direct sunlight. | Fey Ancestry: Adv on saves vs charm and immune to sleep magic. | Trance: Do not need sleep. Semiconscious meditation for 4 hours counts as 8 hours sleep. |
Halfling
Lightfoot
Lucky: May re-roll a 1 on attack, ability, or save but must take new roll. | Brave: Advantage on saves vs. being frightened. | Halfling Nimbleness: Can move through the space of any creature that is a size larger. | Naturally Stealthy: Can attempt to hide even when obscured only by a creature one size larger.
stout
Lucky: May re-roll a 1 on attack, ability, or save but must take new roll. | Brave: Advantage on saves vs. being frightened. | Halfling Nimbleness: Can move through the space of any creature that is a size larger. | Stout Resilience: Advantage on saves vs. poison, and resistance vs. poison.
Draconic
Breath Weapon: (phb P.34). | Damage Resistance: vs. type associated with ancestry.
Gnome Forest
Darkvision: see in dim light within 60' as bright light, and in darkness as dim light. | Gnome Cunning: Advantage on all Int, Wis, and Cha saves vs. magic. | Speak with Small Beasts: Can communicate simple ideas with small or smaller beasts.
Gnome rock
Darkvision: see in dim light within 60' as bright light, and in darkness as dim light. | Gnome Cunning: Advantage on all Int, Wis, and Cha saves vs. magic. | Artificer’s Lore: Add 2x proficiency bonus to Intelligence (History) checks related to magic items, alchemical objects, or tech devices. | Tinker: May construct tiny clockwork device (PHB p.37). |
Halfelf
Darkvision: see in dim light within 60' as bright light, and in darkness as dim light. | Fey Ancestry: Adv on saves vs charm and immune to sleep magic. Halforc
Darkvision: see in dim light within 60' as bright light, and in darkness as dim light. | Relentless Endurance: If reduced to 0 hp, may raise it to 1 hp once until next long rest. | Savage Attacks: Roll an additional damage die on a melee critical. |
Tiefling
Darkvision: see in dim light within 60' as bright light, and in darkness as dim light. | Hellish Resistance: resistance to fire damage. | Infernal Legacy thaumaturgy (see p.43). |
Eladrin
Darkvision: see in dim light within 60' as bright light, and in darkness as dim light. | Fey Ancestry: Adv on saves vs charm and immune to sleep magic. | Trance: Do not need sleep. Semiconscious meditation for 4 hours counts as 8 hours sleep. | Fey Step: may cast Misty Step once until next long rest. |
Aasimar
Darkvision: see in dim light within 60' as bright light, and in darkness as dim light. | Celestial Resistance: resistance to Necrotic damage and Radiant damage. | Celestial Legacy (see DMG p.287).

===
https://www.dropbox.com/s/5yukcj63trxmlyy/D%26D%205e%20Random%20Character%20Generator%209.2.2%20WORKSPACE%20VERSION.xlsx?dl=0

Version 9.4
aDDED: Bladesinger, SCAG pantheon, squashed two major bugs: 1) USER archetype choice error, 2) skills addition error

https://www.dropbox.com/s/sj5maspmi...ator 9.4 WORKSPACE VERSION RELIGION.xlsx?dl=0

ENjay!

jh

Version 9.6.1: Finished SCAG archetypes, added the extra gnome, moved all class stuff to the Class tab.

https://www.dropbox.com/s/0d8ggbaex...ter Generator 9.6.1 RELEASE VERSION.xlsx?dl=0

Will start adding Xanathar's Archetypes at some point.

Enjoy!

Jay H

Squashed a really nasty skill calculation bug..again...

https://www.dropbox.com/s/crwo6cvy1...ter Generator 9.6.2 RELEASE VERSION.xlsx?dl=0

FINAL UPDATE FOR A WHILE (EXCEPT IF YOU GUYS FIND ERRATA):

9.7 has the XANATHAR's ARCHETYPES!

https://www.dropbox.com/s/ijoh07ykh...cter Generator 9.7 RELEASE VERSION.xlsx?dl=0

Enjoy!

jh

Hey there! A little late to the party, but I just updated to the latest version on ADnD Downloads.

Thanks a lot for the hard work!

https://www.adnddownloads.com/en/resource/dnd-5e-random-character-generator

Thanks!
My next goal is to get in the following:
Revised Ranger
Eberron Race options

jh