2nd Edition Character Sheet (2 pages - compact) - Fillable and Auto-Calculating

12 posts / 0 new
Last post
Drynne Drynne's picture
2nd Edition Character Sheet (2 pages - compact) - Fillable and Auto-Calculating

https://drive.google.com/open?id=1dfFrhLsxxp-dAM2zYCXIG3EzkCZ1OoHL

Hey! I’ve made ElDaniello’s amazing characters sheets fillable.

They also have javascript in order to make basic calculations and make character creation quicker (Fray, initiative, total skills, aptitude’s checks and etc). I still haven’t tested them with my players, so if any errors appear, please, let me know! Suggestions are very welcomed.

Many thanks to ElDaniello for the character sheets, they’re incredible. You can find the original post here:
https://eclipsephase.com/2nd-edition-character-sheet-2-pages-compact



EDIT 1: Fixed the code for perceive, fray and initiative.

EDIT 2: Fixed the code for Vehicles and Bots (apparently things made of steel have more durability than meat!).

Now you can choose if the Know fields use Intuition or Cognition (The same for Extra skills). Thanks, Praxidicae!

I though that the movement rate was coded(It wasn’t) so I fixed that.

Several small mistakes were fixed, like, the font size being very large for the several fields (They’ll shrink automatically now) or Survival using Cognition instead of Intuition.

Also, I added the option to make a skill show only the aptitude, you only have to write “*” (without the quote) in Rank. Thanks, Coram for the suggestion!

EDIT 3: Now people can modify Aptitude Checks, Body and Mind Stats. So if a trait gives the character + 5 COG Checks and another gives more 10, then you add 15 in the Modifier field.

Also, if you write “Muse” in the Type field the sheet will not think that your character’s muse is made of flesh anymore.

(Thanks again, Coram for both suggestions!)

Burnsidhe Burnsidhe's picture
It looks like you've posted

It looks like you've posted two versions of the same sheet. Is there a difference or is it really the same one posted twice?

Drynne Drynne's picture
I didn’t saw that I uploaded

I didn’t saw that I uploaded the same sheet twice. Thanks for noticing it!

Burnsidhe Burnsidhe's picture
Fray does not calculate its

Fray does not calculate its total correctly. It should be (REF x 2) + Ranks, instead it is (REF) + Ranks if ranks > null.
Similarly, Perceive should be (INT x 2) + Ranks. Instead it is (INT + Ranks) if Ranks > null.

Both the current calculations are incorrect, shortchanging the total by REF or INT if you put *any* points into these skills.

Drynne Drynne's picture
Fixed! I totally

Fixed! I totally misinterpreted the rule for calculating perceive and fray. Sorry about that.

praxidicae praxidicae's picture
Drynne wrote:Fixed! I totally

Drynne wrote:
Fixed! I totally misinterpreted the rule for calculating perceive and fray. Sorry about that.

First off, this is awesome. Nicely laid out and very useful.

To flag one minor error, all six of the Know skill slots are based on Cog, two of them should probably be based on Int to represent the 'Arts' skills (or possibly a dropdown in the relevant field to select one of the two - I have no idea about coding this type of thing so have no idea how difficult that would be, feel free to ignore/ridicule if that is impossible/insanely difficult).

Nocturne Nocturne's picture
Another issue, Survival

Another issue, Survival appears to be linked to COG instead of INT for total skill.

Coram Coram's picture
Fillable sheet - Errors

This sheet is great but I noticed some oddities.

  • Is there a way to force skills with no ranks to just display the aptitude score?
  • Is there a way to force APT check scores when things like Resolve are taken? For example, the Resolve trait gives +5 per level of Resolve taken to Will checks.
  • Occasionally the font size clips outside of the field. For example, the Languages field cuts off letter descenders, while the Item fields in the GEAR section cuts off the top bits.
  • Is there a way to make it so text fields automatically shrink text, rather than continuing past the field and hiding text beyond the field? For example, typing 100 in the Morph Avail. field cuts off the last 0.
  • You fixed Fray and Initiative so that's all good...
  • The first MOVEMENT field for the BOTS - VEHICLES fields seems to copy what's written and overlay it over what was written.
  • You've got the Death Rating formula for the BOTS - VEHICLES fields set to DUR x 1.5, rather than DUR x 2 like it should be for bots.
I think that's about everything... Also totally not criticizing, clearly I'm only pointing these out because I have no idea how to do what you did myself. Hopefully this helps a bit!

praxidicae wrote:
Drynne wrote:
Fixed! I totally misinterpreted the rule for calculating perceive and fray. Sorry about that.

First off, this is awesome. Nicely laid out and very useful.

To flag one minor error, all six of the Know skill slots are based on Cog, two of them should probably be based on Int to represent the 'Arts' skills (or possibly a dropdown in the relevant field to select one of the two - I have no idea about coding this type of thing so have no idea how difficult that would be, feel free to ignore/ridicule if that is impossible/insanely difficult).

Below the last Know: field, you can enter your own skills. Typing INT into the APT column for any skill you've added will give the correct number.

Drynne Drynne's picture
praxidicae wrote:Drynne wrote

praxidicae wrote:
Drynne wrote:
Fixed! I totally misinterpreted the rule for calculating perceive and fray. Sorry about that.

First off, this is awesome. Nicely laid out and very useful.

To flag one minor error, all six of the Know skill slots are based on Cog, two of them should probably be based on Int to represent the 'Arts' skills (or possibly a dropdown in the relevant field to select one of the two - I have no idea about coding this type of thing so have no idea how difficult that would be, feel free to ignore/ridicule if that is impossible/insanely difficult).

Thank you! I added the option for choosing COG or INT. I hope the sheet helped a little with all the math.

Nocturne wrote:
Another issue, Survival appears to be linked to COG instead of INT for total skill.

Fixed it!

Coram wrote:
This sheet is great but I noticed some oddities.
  • Is there a way to force skills with no ranks to just display the aptitude score?
  • Is there a way to force APT check scores when things like Resolve are taken? For example, the Resolve trait gives +5 per level of Resolve taken to Will checks.
  • Occasionally the font size clips outside of the field. For example, the Languages field cuts off letter descenders, while the Item fields in the GEAR section cuts off the top bits.
  • Is there a way to make it so text fields automatically shrink text, rather than continuing past the field and hiding text beyond the field? For example, typing 100 in the Morph Avail. field cuts off the last 0.
  • You fixed Fray and Initiative so that's all good...
  • The first MOVEMENT field for the BOTS - VEHICLES fields seems to copy what's written and overlay it over what was written.
  • You've got the Death Rating formula for the BOTS - VEHICLES fields set to DUR x 1.5, rather than DUR x 2 like it should be for bots.
I think that's about everything... Also totally not criticizing, clearly I'm only pointing these out because I have no idea how to do what you did myself. Hopefully this helps a bit!

Thanks for telling me these errors! It helped a lot actually. If you put “*” without the quotes in Rank, the aptitudes will appear in Total. Also, I’m not offended at all, I greatly appreciate the feedback because it means that some people are interested.

About the aptitude checks and Resolve, you meant to ask if the sheet could recognize the trait and add its bonus to the aptitudes, right? (My English is rusty as hell). I just began to learn javascript so I won’t be able to give you a definitive answer, sorry. I probably could do it, though I just need to learn java a little more.

Coram Coram's picture
Drynne wrote:

Drynne wrote:

About the aptitude checks and Resolve, you meant to ask if the sheet could recognize the trait and add its bonus to the aptitudes, right? (My English is rusty as hell). I just began to learn javascript so I won’t be able to give you a definitive answer, sorry. I probably could do it, though I just need to learn java a little more.

Oh, no no. Sorry, I should have worded that better. I meant that having a trait like resolve gives +5 to a given aptitude check, but there's no way to force the APT CHECK field to a number. It always calculated from the rank in Aptitudes. So for example, the test character I built (who I really want to play now) has WIL 15, so an APT check of 45, but I also gave it 2 levels of Resolve, so the check should be 55. All I want to be able to do is enter 55 directly into the APT CHECK field and have it stay like that. As it is now it just automatically goes back to 45 after a minute or so.

Hopefully that makes more sense. The other changes are awesome though, thank you!

EDIT: Just transferred everything from the previous sheet over to the fixed one and it's working perfectly. Fantastically done :D. The APT CHECK thing really isn't that big a deal.

EDIT 2: Realised that the sheet doesn't include anywhere to key in Muse stats. I started entering some Muse info into the ALI - CREATURES fields, but the DR calculates as 1.5x the DUR. According to the corebook on p.326, "All ALI informorphs have WT 4, DUR 20, and DR 40 for mesh combat." I can't imagine it's important for a Muse to have listed numbers for mesh combat ('cause why would you do that), but is there a way to choose between ALI/Creature for these fields? I have no idea where you'd put it on the sheet of course.

Drynne Drynne's picture
Coram wrote:

Coram wrote:

Oh, no no. Sorry, I should have worded that better. I meant that having a trait like resolve gives +5 to a given aptitude check, but there's no way to force the APT CHECK field to a number. It always calculated from the rank in Aptitudes. So for example, the test character I built (who I really want to play now) has WIL 15, so an APT check of 45, but I also gave it 2 levels of Resolve, so the check should be 55. All I want to be able to do is enter 55 directly into the APT CHECK field and have it stay like that. As it is now it just automatically goes back to 45 after a minute or so.

Hopefully that makes more sense. The other changes are awesome though, thank you!

EDIT: Just transferred everything from the previous sheet over to the fixed one and it's working perfectly. Fantastically done :D. The APT CHECK thing really isn't that big a deal.

EDIT 2: Realised that the sheet doesn't include anywhere to key in Muse stats. I started entering some Muse info into the ALI - CREATURES fields, but the DR calculates as 1.5x the DUR. According to the corebook on p.326, "All ALI informorphs have WT 4, DUR 20, and DR 40 for mesh combat." I can't imagine it's important for a Muse to have listed numbers for mesh combat ('cause why would you do that), but is there a way to choose between ALI/Creature for these fields? I have no idea where you'd put it on the sheet of course.

I haven’t read the whole book yet (Principally the crunch) and it didn’t even crossed my mind that some traits would modify the aptitude checks or that the sheet was only designed for printing and I needed to modify it. Thanks a lot for having the patience to use this sheet. (No need for apologizing. Your choice of words were totally fine, it was only my bad English that is really rusty)

I added the option to modify aptitude’s checks, mind and body stats. Also in “Type”, if you write “Muse”, the sheet will calculate correctly.

Coram Coram's picture
Fantastic

You're amazing. Literally the only thing I noticed that went funny is the Body Stats don't want to calculate quite correctly when adding a modifier. Example: My Ikon morph has DUR 30, Toughness 1 gives +5 DUR, and Persistence ware gives +10 DUR. If I enter 30 in the DUR rank and 15 in the MOD field, it properly calculates both DUR and DR, but doesn't affect WT. I was able to trick it into working right by first entering a 3 in the WT MOD field, then entering 15 in the DUR MOD field, so it's really just a tiny quibble. But of course I can skip all of it and just enter 45 directly into the rank and not fuss with the modifiers field.

You've made a truly amazing fillable sheet which I think is perfect. Respect to both you and Eldaniello for this. And thank you for listening to feedback!