Made an .ods (Open Document Spreadsheet) character sheet

[Narf the Mouse]

I wrote it using the official character sheet as a base; everything's in roughly the same place and roughly the same size.

It calculates and totals Characteristics costs for you, totals Skills, Perks and Talents costs, totals Powers/Equipment costs, totals Complication points, calculates Average Defense and Armor Weight, Spent and Unspent Character Points and Experience, Lift (in kg; I tried to edit it for tons, KT, MT and GT, but the nested IF statements started glitching it. There's probably an easier way), STR damage dice and Presence Attack dice.

Note that it will put a decimal point after STR damage and Presence Attack dice in integer numbers. This is, as far as I can tell, unavoidable.

 

It can also handle full- and partial-coverage armor, the same as a written character sheet can.

 

So, download it, try it out, tell me how it works - Or doesn't.

[Christopher]

Re: Made an .ods (Open Document Spreadsheet) character sheet

 

Lift (in kg; I tried to edit it for tons' date=' KT, MT and GT, but the nested IF statements started glitching it. There's probably an easier way)[/quote']

I take a look at this and perhaps the Die Presentation. I think one way to deal with this would be to replicate a complete STR-List (for every STR from 0 to 100 or higher) and then use VLOOKUP (or it's OO equivalent) on that table to find the right value. When it is not important that the values stay numbers, I could make workarounds with the various String functions.

 

Still have trouble with the creation of a self-filling table. Couldn't find out what the formula behind the lifting weight increase is yet. But I take a look at that.

[Christopher]

Re: Made an .ods (Open Document Spreadsheet) character sheet

 

Okay, got the lifting progression.

Aparrently there is an artifact/use of designers license. Every 50 Str (first at 45, again at 95) the value is 12.5 instand of the expected (6.4 times two or 12.8). I caught that with an if and modulo-operation and unless he changes the progession somewhere beyond 100 I can say that 400 STR has lifting capacity of about 2.5 * 10^25 kg.

The suns mass is about 1.9891 * 10^30 kg

The earths mass is about 5.9736 * 10^24 kg.

So you could move aproximately 4,185 times the mass of earth with 400 STR.

 

Still have to add the Damage Dies, vlookup and the string manipulation functions before the modifications are complete and I can post it.

 

Edit: Just realised, that only the multiples of 5 are correct. The values between are off and I am not jet certain how to compensate for this. The STR-Chart is more difficulty than I thought at first. Currently I try to figure out what the values between should be:

25 - 800

26 - ???

27 - ???

28 - 1200

29 - ???

30 - 1600

[Narf the Mouse]

Re: Made an .ods (Open Document Spreadsheet) character sheet

 

Okay, got the lifting progression.

Aparrently there is an artifact/use of designers license. Every 50 Str (first at 45, again at 95) the value is 12.5 instand of the expected (6.4 times two or 12.8). I caught that with an if and modulo-operation and unless he changes the progession somewhere beyond 100 I can say that 400 STR has lifting capacity of about 2.5 * 10^25 kg.

The suns mass is about 1.9891 * 10^30 kg

The earths mass is about 5.9736 * 10^24 kg.

So you could move aproximately 4,185 times the mass of earth with 400 STR.

 

Still have to add the Damage Dies, vlookup and the string manipulation functions before the modifications are complete and I can post it.

 

Edit: Just realised, that only the multiples of 5 are correct. The values between are off and I am not jet certain how to compensate for this. The STR-Chart is more difficulty than I thought at first. Currently I try to figure out what the values between should be:

25 - 800

26 - ???

27 - ???

28 - 1200

29 - ???

30 - 1600

The intermediate STRs are probably rounded off to the nearest one-digit-less-than-the-leftmost.

 

Also: 2^(1 / 5) = X

X^5 = 2.

 

Although that's not the formula I used, try it and see if it's more accurate.

[Christopher]

Re: Made an .ods (Open Document Spreadsheet) character sheet

 

The intermediate STRs are probably rounded off to the nearest one-digit-less-than-the-leftmost.

 

Also: 2^(1 / 5) = X

X^5 = 2.

 

Although that's not the formula I used, try it and see if it's more accurate.

I am slowly starting to think, that he just wrote down 50 Numbers and repeated them, each time he got to the 50., the X in 10^X increased. I could copy that, if I would knew the numbers. Or perhaps he only got every 5th Number, and the the ones that are 2 before ervery 5. (i.e. 10, 13, 15, 18, 20, 23, 25), omitting every else.

 

Of course it would help to know, what the Hero designers says about the intermediate numbers. Unfortunately it is the only part of the Hero-System I can't buy per PayPal on DriveThruRPG, so I don't know the values.