Go Back   EN World D&D / RPG News > D&D 4th Edition Discussion > 4e Fan Creations and House Rules

4e Fan Creations and House Rules Working on variant powers? Statting up a PC race or your version of a monster? Creating or converting an adventure? Put it here!

 
Share LinkBack Thread Tools Display Modes
Old 3rd August 2008, 07:59 PM   #1 (permalink)
Registered User
 
RigaMortus2's Avatar
 
Join Date: Apr 2003
Posts: 3,228
RigaMortus2 Goblin Sharpshooter (Lvl 2)
4E Character Sheet Generator (Excel)

I had this posted in the 4E rules forum, but since this is where fan created stuff goes, I am reposting here.

This is inspired by Kenad's most excellent Star Wars Saga character generator found here.

I took the format and some of his ideas, but the code is all mine (mainly because I couldn't figure out how he coded his sheet). Please be advised, I am an amateur when it comes to Excel, so you'll have to forgive me if there are "better" ways to do things.

This isn't 100% complete (it probably never will be) and is still a work-in-progress. But for those that would like a quick and easy way to create characters, this should suffice.

I am sure there are bugs and such, and I will update it as I find time.

So, without further ado...

Updated 8/3/08
D&D Character Sheet 2

Enjoy!
__________________
It is difficult to get a man to understand something when his salary depends on him not understanding it -Upton Sinclair


Imagination is more important than knowledge. For knowledge is limited to all we now know and understand, while imagination embraces the entire world, and all there ever will be to know and understand. -Albert Einstein

Alignment is what you are when no one is watching. -Yakoska, fellow D&D player.

RigaMortus2 is online now   Reply With Quote
Old 3rd August 2008, 08:01 PM   #2 (permalink)
Registered User
 
RigaMortus2's Avatar
 
Join Date: Apr 2003
Posts: 3,228
RigaMortus2 Goblin Sharpshooter (Lvl 2)
Reposting this from the other thread, as there are some issues I am aware of, so no need to rehash them here.

Quote:
Originally Posted by DanChops View Post
-I think the reflex defense formula has some problems. I have a character with 12 Dex and 16 Int (with a light shield, since I can't choose "no shield). The sheet shows my Ref as 12. It looks like it's basing it off of my Dex, rather than my Int. (Incidentally, the AC value is 14 - so that looks like it's working with no problems.
The Reflex Defense issue should be fixed now.

Quote:
Originally Posted by DanChops View Post
-There doesn't seem to be a "no shield" option
Hmmm, I guess I can put one in. For now, you can simply select that cell and click DELETE. It will delete the selection that is currently in there and should help.

Quote:
Originally Posted by DanChops View Post
-On the "Abilities and Class" sheet, there is an extra drop-down box with ability scores in it. If I choose an ability score that my race doesn't have a bonus in, then I get a +2 bonus in that ability. However, if I choose an ability score that my race does have a bonus in, then it doesn't affect anything.
This is the same issue w/ the shield. That selection is if you pick Human as your race. If you are not Human, click on that cell and hit DELETE. I am working on a way to make that cleaner for non-humans so people don't get confused.

If anyone finds any other errors or has suggestions or questions, post them.
__________________
It is difficult to get a man to understand something when his salary depends on him not understanding it -Upton Sinclair


Imagination is more important than knowledge. For knowledge is limited to all we now know and understand, while imagination embraces the entire world, and all there ever will be to know and understand. -Albert Einstein

Alignment is what you are when no one is watching. -Yakoska, fellow D&D player.

RigaMortus2 is online now   Reply With Quote
Old 26th August 2008, 02:32 AM   #3 (permalink)
Registered User
 
Talysian's Avatar
 
Join Date: May 2008
Location: Dallas,TX
Posts: 50
Talysian Goblin Sharpshooter (Lvl 2)
Send a message via Yahoo to Talysian
I'm having an issue where it autosets str to 14 in the final stat even though I have a ten str no bonuses or anything any suggestions?
Talysian is offline   Reply With Quote
Old 26th August 2008, 01:19 PM   #4 (permalink)
Registered User
 
Join Date: Jul 2008
Posts: 25
SJay Goblin Sharpshooter (Lvl 2)
Hey, this is not too bad, esp if your an "amateur" at Excel as claimed.

One thing i noticed on a quick look over is that cell Feats!D2 is not counting when a feat is taken more than once. Changing cell Feats!F1 to =SUMIF(E6:E201,">0") should solve the problem. (Can't remember if 03 brings up an error with that... don't think if does, in any case there are other ways to solve the problem, this is just the cleanest).

Anyway the real reason I had a look was I'm building my own and wondered if you had managed to get hold of all the powers in an excel sheet. Obviously makes it a lot easier.

Cheers,
Shaun

Last edited by SJay; 26th August 2008 at 01:28 PM..
SJay is offline   Reply With Quote
Old 8th January 2009, 06:51 PM   #5 (permalink)
Registered User
 
Join Date: Jan 2009
Posts: 3
meleeman Kobold Slinger (Lvl 1)
Hey, I saw your Character generator and tried it out. I like it so much more than all the others, but I noticed that it was incomplete. Are you planning on finishing it, and if not, you mind if I fill in everything and post it back up here? I've already started filling in the feats, and I'm moving on to weapons next.
meleeman is offline   Reply With Quote
Old 8th January 2009, 10:03 PM   #6 (permalink)
Registered User
 
Wystan's Avatar
 
Join Date: Jul 2004
Posts: 1,112
Wystan Goblin Sharpshooter (Lvl 2)
Please update???
__________________
Quote:
Originally Posted by Dave Mage 06-06-05 - Regarding the hiring of Mearls by WOTC
I think we may have just witnessed the birth of the 4th edition development process...

August 2007.
Spoiler:

I wrote this:
17 Archer Feats

Slife - Almost all MMORPGs make sense if you assume the god of time has gone horribly, horribly mad.

Quote:
Originally Posted by catsclaw
We'll know how closely 4e mimics WoW by the first table you play at at a con. If one player hands the DM a sheet of paper that says "I find the nearest mining node, and mine it. Then I repeat." and leaves the table, and another player starts yelling at all the other players to buy his gold, then yeah--it's a WoW clone.

Short of that, you're not really getting the MMO experience.
Wystan is offline   Reply With Quote


Bookmarks

Tags
(excel), character, generator, sheet

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


And yet another word from our sponsors
Visit Our Sponsors
Visit Our Sponsors... Again
Powered by vBadvanced CMPS v3.0.1

All times are GMT +1. The time now is 07:32 PM.


Site Contents © 2008 ENWorld
PHP Ajax Multimedia Web Framework © 2008 Digital Media Graphix
Powered by vBulletin® Version 3.8.0 Beta 1
Copyright ©2000 - 2009, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.2.0

"Vault Data" powered by VaultWiki v2.5.1.
Copyright © 2008 - 2009, Cracked Egg Studios.