Automated and Less-Automated Character Sheets

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

Re: Automated and Less-Automated Character Sheets

Postby f1r3w4rr10r » Thu Jan 16, 2014 4:54 am

SilverlightPony wrote:Ilushia is female, silly.


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

User avatar
Aqu
Posts: 128
Joined: Tue Jan 01, 2013 3:57 pm
Status: Offline

Re: Automated and Less-Automated Character Sheets

Postby Aqu » Thu Jan 16, 2014 6:16 am

f1r3w4rr10r wrote: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.

f1r3w4rr10r wrote: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.

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

Re: Automated and Less-Automated Character Sheets

Postby f1r3w4rr10r » Thu Jan 16, 2014 6:23 am

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.

User avatar
SilverlightPony
Global Moderator
Global Moderator
Posts: 493
Joined: Sat Mar 17, 2012 4:21 pm
Status: Offline

Re: Automated and Less-Automated Character Sheets

Postby SilverlightPony » Thu Jan 16, 2014 11:54 am

Actually, it is possible in spreadsheets, using macros. That shit gets rather complicated, rather quickly, though.
Silverlight the Unicorn
Host, Voice of Equestria Podcast
http://www.voiceofequestria.com/

Image

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

Re: Automated and Less-Automated Character Sheets

Postby f1r3w4rr10r » Thu Jan 30, 2014 2:48 am

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...

User avatar
Aqu
Posts: 128
Joined: Tue Jan 01, 2013 3:57 pm
Status: Offline

Re: Automated and Less-Automated Character Sheets

Postby Aqu » Thu Jan 30, 2014 8:01 am

f1r3w4rr10r wrote: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.

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

Re: Automated and Less-Automated Character Sheets

Postby f1r3w4rr10r » Thu Jan 30, 2014 9:03 am

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...

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

Re: Automated and Less-Automated Character Sheets

Postby f1r3w4rr10r » Wed Mar 05, 2014 3:31 am

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

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

Re: Automated and Less-Automated Character Sheets

Postby f1r3w4rr10r » Thu Mar 06, 2014 9:20 am

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.

User avatar
SilverlightPony
Global Moderator
Global Moderator
Posts: 493
Joined: Sat Mar 17, 2012 4:21 pm
Status: Offline

Re: Automated and Less-Automated Character Sheets

Postby SilverlightPony » Sun Apr 06, 2014 1:10 am

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.
Silverlight the Unicorn
Host, Voice of Equestria Podcast
http://www.voiceofequestria.com/

Image


Return to “PnP RPG”

Who is online

Users browsing this forum: No registered users and 2 guests