Automated Character Sheet 2.0

A place to discuss any PnP (Pen and Paper) role-playing games you are working on.
User avatar
f1r3w4rr10r
Posts: 628
Joined: Wed Aug 01, 2012 11:26 am
Location: Germany (UTC+1)
Contact:
Status: Offline

Re: Automated Character Sheet 2.0

Postby f1r3w4rr10r » Thu Dec 17, 2015 9:28 am

I finished the manual for both players and GMs. I posted a link in the OP.

User avatar
f1r3w4rr10r
Posts: 628
Joined: Wed Aug 01, 2012 11:26 am
Location: Germany (UTC+1)
Contact:
Status: Offline

Re: Automated Character Sheet 2.0

Postby f1r3w4rr10r » Fri Dec 18, 2015 5:53 am

Also could someone please sticky this thread and unsticky the old, less automated sheet thread? Thanks.

User avatar
f1r3w4rr10r
Posts: 628
Joined: Wed Aug 01, 2012 11:26 am
Location: Germany (UTC+1)
Contact:
Status: Offline

Re: Automated Character Sheet 2.0

Postby f1r3w4rr10r » Sun Dec 20, 2015 4:41 am

So roll20 is about to push a really neat update to their character sheets, which might prompt me to have a look into them again. The main advantage would be, that bug fixes are pushed to all sheets out there and that you have all in one site and nicely integrated.

User avatar
TyrannisUmbra
Global Moderator
Global Moderator
Posts: 523
Joined: Tue Oct 18, 2011 4:46 am
Contact:
Status: Offline

Re: Automated Character Sheet 2.0

Postby TyrannisUmbra » Sat Dec 26, 2015 10:21 pm

f1r3w4rr10r wrote:Also could someone please sticky this thread and unsticky the old, less automated sheet thread? Thanks.


Will do, though I will make sure the OP of this thread has a link back to the first thread, in case someone wants the original versions.
Primary IRC nicks: TyrannisUmbra, Silver_Wing
Current PNP characters: <Non-FoE Only>

User avatar
f1r3w4rr10r
Posts: 628
Joined: Wed Aug 01, 2012 11:26 am
Location: Germany (UTC+1)
Contact:
Status: Offline

Re: Automated Character Sheet 2.0

Postby f1r3w4rr10r » Mon Dec 28, 2015 12:55 pm

TyrannisUmbra wrote:
f1r3w4rr10r wrote:Also could someone please sticky this thread and unsticky the old, less automated sheet thread? Thanks.


Will do, though I will make sure the OP of this thread has a link back to the first thread, in case someone wants the original versions.

Thanks. And it should already have a link to the old thread.

User avatar
f1r3w4rr10r
Posts: 628
Joined: Wed Aug 01, 2012 11:26 am
Location: Germany (UTC+1)
Contact:
Status: Offline

Re: Automated Character Sheet 2.0

Postby f1r3w4rr10r » Tue Dec 29, 2015 7:13 am

I had to change the conditional formatting for indicating errors to separate them more from color gradients for some values. (Color gradients only allow for the background color to change, not for the text color as I had initially thought.)
I added some color gradients for values mostly on the combat sheet.
I also added a reference for both Trick Points and Strain on the combat sheet, so you don't have to flip sheets just to look at the current values.
You still edit both of these on their respective pages though.

That's where I actually would like to ask you guys if you are OK with that or if you would prefer editing them combat sheet. I could theoretically do both, but both used Strain / TP values would then be cumulative from their respective sheet and the combat sheet.

I also changed how magazines on the combat sheet work.
It used to be that the sheet simply showed the maximum magazine size and you put in the current amount.
I changed to be more in line with the rest of the sheet. So now you put in the amount of ammo you used and the sheet only shows you the amount of ammo left in the magazine.

User avatar
f1r3w4rr10r
Posts: 628
Joined: Wed Aug 01, 2012 11:26 am
Location: Germany (UTC+1)
Contact:
Status: Offline

Re: Automated Character Sheet 2.0

Postby f1r3w4rr10r » Tue Dec 29, 2015 8:41 am

Small Fix with the conditional formatting blocking out certain elements of magic if you are a shaman. (Spread Thin was still visible, if the character was a shaman, but didn't have innate magic.)
The fix is a bit more complicated, so I tried to be as clear as possible.
Spoiler: show
Formatting!D20:
has no shaman magic

Formatting!D21:
has no unicorn magic

Formatting!E20:
=NOT(AND(IFERROR(getRaceAttribute(Character_Race,8),FALSE),Trait_Shaman="Yes"))
->Right Click on Cell->Define Named Range...->Name: Format_NoShamanMagic, Range: Formatting!E20

Formatting!E21:
=NOT(IFERROR(getRaceAttribute(Character_Race,4),FALSE))
->Right Click on Cell->Define Named Range...->Name: Format_NoUnicornMagic, Range: Formatting!E21

Formatting!F20:
=INDIRECT("Format_NoShamanMagic")

Formatting!F21:
=INDIRECT("Format_NoUnicornMagic")

Formatting!B20:
=AND(Format_NoShamanMagic,Format_NoUnicornMagic)

Stats!V35:
->Right Click on Cell->Conditional Formatting...->Select only rule in there->Custom Formula: =INDIRECT("Format_NoUnicornMagic")

Stats!AC35:
->Right Click on Cell->Conditional Formatting...->Select only rule in there->replace range with: AC35:AH35

Stats!AX18:
->Right Click on Cell->Conditional Formatting...->add new rule->set range to: AX18:BA19
--->set to custom formula->Formula: =INDIRECT("Format_NoShamanMagic")
--->set both foreground and background color to the 4th grey from the left

Magic!A2:
->Right Click on Cell->Conditional Formatting...->Select only rule in there->Replace range with: A2:I3,K2:O3,K6:M6,N5:O6,AA2:AG6
--->change custom formula to: =INDIRECT("Format_NoUnicornMagic")

Magic!A4:
->Right Click on Cell->Conditional Formatting...->Add new Rule->set range to: A4:I4
--->set to custom formula->Formula: =INDIRECT("Format_NoShamanMagic")
--->set both foreground and background color to the 4th grey from the left

Magic!Q2:
->Right Click on Cell->Conditional Formatting...->Add new Rule->set range to: Q2:Y7,AI2:BG5,A10:BL39
--->set to custom formula->Formula: =INDIRECT("Format_NoMagic")
--->set both foreground and background color to the 4th grey from the left

Only if you have the version with the Strain quick reference on the combat sheet already in place:
Combat!R32:
->Right Click on Cell->Conditional Formatting...->select the top rule->replace range with: A26:Y29
--->click Done
--->Add new Rule->set range to: R32:S32
--->set to custom formula->Formula: =INDIRECT("Format_NoUnicornMagic")
--->set both foreground and background color to the 4th grey from the left
--->click Done
--->drag the new rule to the top of the list (the dots on the left when you hover over it)

User avatar
f1r3w4rr10r
Posts: 628
Joined: Wed Aug 01, 2012 11:26 am
Location: Germany (UTC+1)
Contact:
Status: Offline

Re: Automated Character Sheet 2.0

Postby f1r3w4rr10r » Tue Dec 29, 2015 9:31 am

I made the manual a bit easier to understand. I also added links to the forum thread and the sheet in the manual as well as links to the manual and forum thread into the sheet. Further I added a few notes here and there for some less known rules where it might be hard to understand how things work.

User avatar
f1r3w4rr10r
Posts: 628
Joined: Wed Aug 01, 2012 11:26 am
Location: Germany (UTC+1)
Contact:
Status: Offline

Re: Automated Character Sheet 2.0

Postby f1r3w4rr10r » Tue Dec 29, 2015 9:54 am

I am terribly sorry but I just discovered another bug relating to flight movement distances. Luckily the fix is a lot easier. The cause was that Flight Rank got applied twice to Regular Flight and Charge Flight.
Here is the fix:
Spoiler: show
Combat!E21:
=ROUND(E22/2,1)

Combat!E23:
=E22&" (max "&Movement_MaxCharge&"x)"

DrarenThiralas
Posts: 13
Joined: Thu Nov 06, 2014 9:33 am
Status: Offline

Re: Automated Character Sheet 2.0

Postby DrarenThiralas » Tue Jun 28, 2016 6:11 pm

For some reason, "capped for stats lethal" in the Var Store, is stuck at "loading" indefinitely for Strength and Perception, and as a result these stats and everything dependent on them can't be calculated. I haven't changed anything at all, in fact, that's how the linked sheet is displayed for me (but a copy has the same issue).

EDIT: After some searching, it seems that your sheet suffers from an "infinite loading" bug, that is apparently a known problem in google sheets.


Return to “PnP RPG”

Who is online

Users browsing this forum: No registered users and 3 guests