Character Sheet on Google Sheets

Ok - I’ll do it sometime this week!

I was about to point out what @geekalogian found out. It’s less of an error and more of an oversight, the defense scores are currently missing a “+10” base in their formulas, that’s all.

OMG - my bad. I just fixed the defense formulas and introduced a change log for these kinds of changes. As I said above, I’ll update the sheet soon to calculate attributes and feats based on XP instead level.

You definitely need to be XP aware. I say this from experience with the character builder and people’s requests for it since it was created. Be aware that the path to maximum usability will drive you mad. :slight_smile:

1 Like

@uffcool - I hear ya - I produce products for a living and I totally understand how much “fun” maximum usability can be!

That having been said - I’m totally procrastinating at work and went ahead and made the sheet calculate attributes and feats based on XP now. I went one step further and have the level also calculated based on XP. So now XP is king.

Ty, there’s also a typo in the attribute list, it says “Alternation” instead of Alteration. This causes an error when calculating dice size for Alteration favored actions.

It’s a minor thing, but it’ll avoid someone coming in the future saying: “I have a error for my Alteration actions!”

“Alternation” is totally a thing!

Fixed.

1 Like

Not in Open Legend, im afraid :stuck_out_tongue:

Ha! See the changelog.

Looks like the Def and Spd formulas are missing their reference:
=if(istext(AA24), VLOOKUP(AA24, #REF!, 4, 0),"") and =if(istext(AA24),VLOOKUP(AA24, #REF!, 5, 0),"")
Should probably be something like:
=if(istext(AA24), VLOOKUP(AA24, Reference!H2:L7, 4, 0),"") and =if(istext(AA24),VLOOKUP(AA24, Reference!H2:L7, 5, 0),"")

Good catch @oconnor0 . Fixed. Sorry for all the errors folks. But thank goodness for distributed user testing!

4 Likes

All sheets have been adjusted. Thanks!

2 Likes