Random Character Generator (beta 1.0)

[fireinthedust]

I'd like to see if I could create my own random generator for spells. I may have to look at an Excel sheet tutorial, but I'm wondering how to randomly select something from a list. One cell says "random" while others have #. I suspect I fill in the cells I want to select from randomly, and then put those cell numbers/letters into a formula(?)

 

[Emirikol]

Here's how you do the random spell listings:

I'll write it up for you. You need to randomly order the spells, and then select the first 6 (see how I did the ability scores). Otherwise you end up with duplicates if you just randomly roll on the table multiple times.

The best current example is look how I did the SKILLS tab. First it references the class chosen. Second it references the skills for that class. Third it randomly ranks the skills of that class. Lastly, it references the first few on the list.


Give me a couple minutes I'll do it right now.


jh

 

[Emirikol]

Here is the preliminary version (Go to the SPELLS tab): https://dl.dropboxusercontent.com/u/167876/D&D Stuff/D&D 5e Random Character Generator 2.2.xlsx


[edit: FIXED.......(my wife is cleaning..so you know what that means...)]



jh

 

[Emirikol]

Love it!

How do I steal the code?

And can it be set up to work in, say, a forum like this one? Like, if I wanted to run a 5e game with players making up random characters (or just as an option) and they can upload a copy of the completed sheet in the thread?

Also: how do I change it to be the character I want? Like, if I want an Illusionist instead of a Conjurer, or a Sage instead of a Noble? Or add a level, or change the race/gender, etc?

To steal the code, you just copy/paste what you want and how I did it :_)

Copy/paste to a WORD program works great for copying a character to a sheet. Set your text color to BLACK.


If you wanted to set it to a particular character class:
Go to the "MATH" tab.
Set b6 to the class number you want (look at the class tab) instead of being random (e.g. 1 for cleric, 2 for fighter, 3 rogue, 4 wizard).

You can just track down where those other random references and put in a specific number in those as well. You could also create a drop-down.










..

 

[Emirikol]

I just set up the character sheet page so that if a wizard is rolled, there will be a spellbook with random spells that will appear at the bottom.


[edit: added random arcane focus as well and automatic items)
jh

 

[fireinthedust]

sweet! I'll re-download, then, and try these out.


How would I add the standard array rather than 4d6+race?

 

[Emirikol]

Go to the ABIL tab and in T1 to T6 just enter the standard array. It will automatically choose the top two and randomize the final four from there.

jh

 

[fireinthedust]

is this still a thing? I'm using a different computer now, so would love to port this over.

 

[Emirikol]

Yep, it's still running


Version 5.0. http://community.wizards.com/content/blog/4124231

jh

 

[Khaalis]

Very nice utility. Great Job. I wish I had the patience to do this kind of work in excel. Kudos.