Automated Character Sheet 2.0

[f1r3w4rr10r]

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

[f1r3w4rr10r]

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

[f1r3w4rr10r]

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.

[TyrannisUmbra]

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.

[f1r3w4rr10r]

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.

[f1r3w4rr10r]

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.

[f1r3w4rr10r]

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)

[f1r3w4rr10r]

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.

[f1r3w4rr10r]

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]

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.