Google Docs character sheets

  • 10 Replies
  • 8954 Views
Google Docs character sheets
« on: March 11, 2013, 12:24:53 AM »
Howdy folks.  Been playing some Hangouts and Play-by-Post games, and loving every minute. I put together some character sheets in Google Docs that I wanted to offer to the community; they've made our games a lot easier.

Here they are, as a blank template set.  Here are my group's sheets, as an example of how they look in practice.  Enjoy, and happy gaming all!
« Last Edit: March 11, 2013, 12:29:04 AM by Gornul »
"That which does not kill you has made a tactical error."

Re: Google Docs character sheets
« Reply #1 on: March 11, 2013, 09:02:55 PM »
Very cool, thanks for posting them!

*

LD

  • 11
Re: Google Docs character sheets
« Reply #2 on: March 12, 2013, 03:31:27 PM »
That's a heck of a lot cooler looking than the sheets I hacked together. Nice one.

Re: Google Docs character sheets
« Reply #3 on: March 12, 2013, 04:20:08 PM »
Any feature requests?  I'm considering adding a front page of a basic quest log, player roster, but really I can do just about anything that the community would find useful.

...This is the result of having a very Excel-heavy job; now everything looks like it can be solved with a spreadsheet. ;)
"That which does not kill you has made a tactical error."

*

LD

  • 11
Re: Google Docs character sheets
« Reply #4 on: March 13, 2013, 12:13:20 AM »
The only thing I can think of is having the STR/DEX/CON/INT/WIS/CHA bonuses calculated through a formula.

Re: Google Docs character sheets
« Reply #5 on: March 13, 2013, 01:54:10 PM »
If I can figure out how to do that, that's definitely going in the v3 release.
"That which does not kill you has made a tactical error."

*

LD

  • 11
Re: Google Docs character sheets
« Reply #6 on: March 14, 2013, 01:21:53 AM »
Code: [Select]
=if(B13="","[  ]",if(B13<1,"Too Low",if(B13<4,"[ -3 ]",if(B13<6,"[ -2 ]",if(B13<9,"[ -1 ]",if(B13<13,"[ +0 ]",if(B13<16,"[ +1 ]",if(B13<18,"[ +2 ]",if(B13=18,"[ +3 ]","Too High")))))))))That'll do it. I'd put money on there being a much cleaner method than nested if statements... but I have no idea what that method is :)

It'll show blank when there's no stat in the cell, "Too High" for numbers over 18 and "Too Low" for numbers lower than 1. Otherwise it follows this table:
Score
Modifier
1-3
-3
4-5
-2
6-8
-1
9-12
0
13-15
+1
16-17
+2
18
+3

*

way

  • 23
Re: Google Docs character sheets
« Reply #7 on: March 17, 2013, 04:59:28 PM »
=CHOOSE(A1,-3,-3,-3,-2,-2,-1,-1,-1,0,0,0,0,+1,+1,+1,+2,+2,+3)

Re: Google Docs character sheets
« Reply #8 on: March 18, 2013, 09:11:44 PM »
Works, but loses the displayed + on positive numbers and won't take a ' or [] to display the full string.  I'll keep playing with it.
"That which does not kill you has made a tactical error."

Re: Google Docs character sheets
« Reply #9 on: March 31, 2013, 01:00:32 PM »
Kicking this one to the top because there's like 30 of you using it.  Looking for additional feedback while I keep toying with the features that have already been requested.
"That which does not kill you has made a tactical error."

Re: Google Docs character sheets
« Reply #10 on: July 04, 2013, 01:46:58 PM »
The V3 release is live in the original template.  Now features a campaign-info front page (DM/Players/Story So Far) and upgrades to the Loot Tracker and PC Sheet (with props to LD for the Nested-If solution on Ability Mod autocalculation).  Feedback welcome!
"That which does not kill you has made a tactical error."