Automated and Less-Automated Character Sheets

[f1r3w4rr10r]

Ilushia is female, silly.

And how am I supposed to know that? ;P I barely deal with her in any way.

[Aqu]

Then there are still two other things I would like to discuss: The idea of replacing the Effects column with Level, Special and Skill requirements.

I'm not sure about the replacement. I've seen in a lot of games I've been in, people like to use the description tab for a blurb of flavor about their character in relation to the perk, whereas effects has... the effects. Could be a minor problem for some, so it would be better to add new columns. Even then, I'd like to not expand the page beyond a single page horizontally, so there's no need to scroll.

Other than that: What were your further plans with the fully automated sheet? What needs to be done that doesn't work?

The auto sheet still has a ton of problems, mainly just due to the damage DT formula.
For instance, if a person were to put on an item with greater DT after being shot, it would effectively heal them with the current formula because it would apply the new DT to the hits they received. I've listed out other problems in previous posts, but I can post them again if you'd like.

[f1r3w4rr10r]

Hmm...the alternative would be to not directly put the result in the HP. Like have another sheet or something for combat, where you can put in the DT for each hit received. But then again, that would just be building a calculator. I did something similar for the trading rules already for one of my groups:
https://docs.google.com/spreadsheet/ccc ... sp=sharing
It's just something that spreadsheets don't let you do with the way they are designed. You easily code that in a script or program, but spreadsheets are something to save data in, in the first place. Not something to implement complex algorithms.

[SilverlightPony]

Actually, it is possible in spreadsheets, using macros. That shit gets rather complicated, rather quickly, though.

[f1r3w4rr10r]

The OP should probably be updated, since we included the automatic perk description. Apart from that, what can we still add now, that doesn't require macros?

I mean I could have a look into JavaScript again, but I don't know if it's REALLY necessary...

[Aqu]

The OP should probably be updated, since we included the automatic perk description. Apart from that, what can we still add now, that doesn't require macros?

I mean I could have a look into JavaScript again, but I don't know if it's REALLY necessary...

Updated, thanks. Hmm, we could do weapon list integration, perhaps? Although that might be a problem with weapon mods or custom-crafted weapons.

[f1r3w4rr10r]

That starts to go into things I already have to wrap my head around first when I do real programming. Starting to do this with a spreadsheet and scripts...yeah...that goes almost more in the direction of a database...

[f1r3w4rr10r]

I removed "Sleight of Hoof" from the Less Automated Mad_Modd sheet, according to the recent removal of it from the rule set.

[f1r3w4rr10r]

Hiya!

I am happy to announce that we are currently working on a new version of the sheet for the new Google Sheets. It works pretty well so far and seems to have a fairly solid script support. So we might be able to implement some of the more advanced functions we were planning with the original automated sheet.

It also comes with a new design, that we hope will reduce the amount of page switching you will have to do inside of it.

You can have a first look here, but I don't really recommend using it yet, since a lot of stuff still needs to be implemented.
But you can leave us some comments (yes you can comment inside of the sheet) where you think it could be better.

[SilverlightPony]

I'm using this for a new game, and I just noticed that it's giving out SP at level 1. Since characters start at level 1 and only gain SP when they level up, they should not get SP until reaching level 2. A simple formula adjustment on the "Total Skill Points Available" field will fix this.