Excel Character Sheet

Post/Author/DateTimePost
#1

abanathie

Jul 18, 2014 23:43:56

I created a simple excel character sheet.  I attempted to keep the general format used in the WotC character sheets; however, I did have to make some changes for functionality.  It does some minor calculations for the player.  There are fields that don't have calculations; I'll work on those in the future.  I don't want to do anything as involved as the old Heroforge sheet; however, I would like to develop something that is helpful to players as they put their characters together.

 

Here's the link:  https://drive.google.com/file/d/0B4gvPZEkHJ9N0N6ZGxXRFpMOWc/edit?usp=sharing

 

EDIT: Updated the sheet.  Unfortunately, I noticed that it clips the bottom few boxes when viewed from the internet.  In MS Excel, it formats properly as two separate sheets: the main character sheet and spell sheet.  Weird, I'll keep looking into fixing that part...  I wonder how it looks in OpenOffice...

 

I changed the format, due to some PM inputs, on the attack field.  I made the damage field larger to accommodate adding "effects" to any spell entries.  The attack modifier also auto updates; however, it doesn't take magic weapons into account.    

 

I got other inputs; I'm working them one at a time due to time constraints.  If you have any inputs, please post them here.

 

I think my next step is to create the "second" optional sheet in the character sheet zip.  That way, I have alittle more freedom in moving stuff around...  In addition, I was thinking of creating some blank spell cards...

 

EDIT: Added the second details sheet and a set of spell cards...

 

Here's the link:  https://drive.google.com/file/d/0B4gvPZgEkHJ9ejlqMWIyLVp2dEE/edit?usp=sharing

 

EDIT: New link with some updates:

 

Updated on 20140904

 

EDIT: Reformatted the sheets to by "friendlier" for front and back print outs.  I still need to rearrange the spell sheets though.  I redid the spell cards; they now, well sorta, support front and back printouts.  The spell cards need some major rearrangement to make it user friendly.  Unfortunately, I still work out of town and updating is abit of a pain.  I'll continue to work on it though.  I also added a booklet sheet.  This sheet is designed to be printed out in landscape format and folded in half.  It has a simplified power list that some users have asked for.  I appreciate any input on making the booklet better, or any other part.


Updated on 20140927

 

EDIT: Cleaned up some things.  New spellcards!  I made these larger.  The old cards are around 2x3 inches; the new cards are 3x4 inches.  I'm getting old and my eyes needed larger print.  I now have multiple characters in the Adventure League.  I'll try to incorporate lessons learned as I play these other toons into future character sheets.  Per request, I also added a blank sheet. 

 

The first sheet is an example of a character.  It's just there to give a player an idea on how one can fill out the sheet.  The second sheet is blank; you can start your character from scratch without having to delete all of my data.


Updated on 20150318

Blank Sheet

#2

Berliad

Aug 02, 2014 8:56:09

I really like this one.  It's a nice balance between no calculations (form-fill pdf's) and the spreadsheets that are so programmed that they're inflexible.  I made a couple modifications to help automate hit dice and hit points based on level.  But I like being able to write in my own calculations that are customized for each character, and that's east to do with your sheet.

 

I love the spell cards.  Very helpfulat the table!

 

Thanks again!

#3

abanathie

Aug 02, 2014 13:49:16

You are welcome.

#4

RadperT

Aug 04, 2014 16:49:49

I tried it in Open Office.  Had to quit the browser but that's a file-sharing issue, it was opening in read-only mode.  Once I could edit it, all I had to do was manually set the top & bottom margins to .50" and it worked great!

#5

abanathie

Sep 03, 2014 7:45:01

Updated the character sheet.  First, I enlarged the size of the spell cards.  The original were functional, but, at me advanced age, they weren't desirable at the table.  Second, I moved the main character sheet to one worksheet, the spell sheet and spell cards to another sheet and created an AL log sheet.  Third, I fixed some formatting issues. 

 

I know that at least one user wanted a powers list; I was thinking of creating a short "cheat" sheet that would just detail some of the important stats on one sheet.  Anyone want one of those?

#6

blake_marlowe

Sep 03, 2014 8:19:04

good-looking, good combination of automation vs fill-in. the spell cards should help facilitate better player choices at the table.

 

i'm not sure i understand re: the powers list: ?

#7

abanathie

Sep 03, 2014 8:24:23

blake_marlowe wrote:
#8

blake_marlowe

Sep 03, 2014 8:38:44

o! i hadn't been thinking of that but yeah, that would make sense. i suppose sorcery points would make sense too.

#9

Clutchbone

Sep 03, 2014 10:54:51

I noticed that under Spellcasting Class, it auto-fills "Wisdom" in Primary Ability for paladins. This should be "Charisma" instead. Otherwise it looks great!

#10

blake_marlowe

Sep 03, 2014 14:16:46

i believe the search skill is missing on the sheet.

#11

abanathie

Sep 03, 2014 18:16:59

Clutchbone wrote:
#12

blake_marlowe

Sep 03, 2014 19:53:42

ah--my mistake. thanks!

#13

abanathie

Sep 03, 2014 20:10:20

No worries...  It does take some getting used to...

#14

abanathie

Sep 27, 2014 22:36:55

I've updated the sheet. 

 

I changed the spell cards, again.  They now have a backsheet; I still need to rearrange the cards to better support front and back printing.  It's something that I will continue to work on; however, the margins and columns are set up so that cards mirror front and back.

 

I reformatted the main character sheet to maximize the area usage. 

 

I added a booklet that is designed to be printed out in landscape and folded in half.  It's basically your cheat sheet for your character.  It lists the basic stats and has an area to list powers.  I'm not sure if the power list will work for everyone though; any advice on moving things around would be appreciated.

 

 

#15

abanathie

Mar 18, 2015 12:27:30

I went to my first 5e Adventure League convention.  People seemed to like the character sheet booklet; so, I decided to upload the latest version.  I redid the spell cards again.  The old ones are still there; however, my eyes aren't young anymore.  I need the larger spell cards. 

 

I have other characters in the AL now; so, I will be incorporating any lessons learned from playing those characters into future versions of the sheet.

(Reply to #15)

zagora_01

abanathie wrote:
#17

abanathie

Mar 19, 2015 11:42:23

Added a blank character sheet per your request.  I kept the old filled in sheet as an example for anyone interested.  The blank sheet is there to keep others from having to delete all of my stuff from the example.

#18

Nod_Hero

Mar 19, 2015 13:45:58

For the blank sheet link I get a note from Google Drive "You need permission"

#19

abanathie

Mar 19, 2015 19:40:44

Nod_Hero wrote:
#20

Nod_Hero

Mar 21, 2015 0:36:15

Sheet is accessable now.

#21

abanathie

Mar 21, 2015 16:07:51

Nod_Hero wrote: