Barf Forth Apocalyptica

powered by the apocalypse => Dungeon World => Topic started by: Gornul on March 11, 2013, 12:24:53 AM

Title: Google Docs character sheets
Post by: Gornul 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 (https://drive.google.com/previewtemplate?id=0AnxvxwzqLnPPdFcyX0lEbmRnay0taVBvRlo1N3E0aVE&mode=public).  Here are my group's sheets, as an example of how they look in practice. (https://docs.google.com/spreadsheet/ccc?key=0AnxvxwzqLnPPdDMtWWFiOG5CenE4N1FlVzVveERGZFE#gid=19)  Enjoy, and happy gaming all!

Title: Re: Google Docs character sheets
Post by: Connallmac on March 11, 2013, 09:02:55 PM

Very cool, thanks for posting them!

Title: Re: Google Docs character sheets
Post by: LD 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.

Title: Re: Google Docs character sheets
Post by: Gornul 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. ;)

Title: Re: Google Docs character sheets
Post by: LD 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.

Title: Re: Google Docs character sheets
Post by: Gornul 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.

Title: Re: Google Docs character sheets
Post by: LD 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

Title: Re: Google Docs character sheets
Post by: way 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)

Title: Re: Google Docs character sheets
Post by: Gornul 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.

Title: Re: Google Docs character sheets
Post by: Gornul 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.

Title: Re: Google Docs character sheets
Post by: Gornul 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!