Here's an excel file I created for quick human characters in RQ6 (bottom). There are various tabs, the first is an auto-roll for Characteristics, the second allows you to add your own, and the final ones are auto-rolled for a variety of backgrounds (Primitive, Civilized, etc.). The latter is not fully filled out, but it's a preliminary start.

Any feedback is very welcome, and please feel free to use it for your own NPCs or character creation.

RQ6 Character Sheet v1

RQ6 Creature Character Sheet v1 - This uses a macro button to recalculate the Characteristics.

EDIT: RQ6 Character Sheet v1 with Reroll button. This will require you to allow macros, but I assure you I've not put anything bad in the file. :)

Any feedback is very welcome, and please feel free to use it for your own NPCs or character creation.

RQ6 Character Sheet v1

RQ6 Creature Character Sheet v1 - This uses a macro button to recalculate the Characteristics.

EDIT: RQ6 Character Sheet v1 with Reroll button. This will require you to allow macros, but I assure you I've not put anything bad in the file. :)

[Last edited Jan 19, 2013 00:35:07]

Looks like a good start on a cool idea! Is there a way to trigger it to re-roll the stats without closing and re-opening the file?

Also, it looks like the HP isn't being calculated right sometimes - I've seen it give a character 0 HP for their head.

Also, it looks like the HP isn't being calculated right sometimes - I've seen it give a character 0 HP for their head.

If you press F9, you can "re-roll" the Characteristics. I'm sure there's a more cool way to do it, but I'm not sure how. :)

Re: HP: In the "Human Manual" tab, I tried entering 1 CON & 1 SIZ, but still came up with at least 1 for the Head HP. Can you tell me what Characteristics you have that come up with a 0 HP?

Re: HP: In the "Human Manual" tab, I tried entering 1 CON & 1 SIZ, but still came up with at least 1 for the Head HP. Can you tell me what Characteristics you have that come up with a 0 HP?

Con 10, Siz 12, on the random roll human tab.

I may not be the best person to test this though - I realized I'm using Open Office, not Microsoft Excel to open it. The F9 thing doesn't work for me, probably because Open Office doesn't have exactly the same shortcut keys.

I may not be the best person to test this though - I realized I'm using Open Office, not Microsoft Excel to open it. The F9 thing doesn't work for me, probably because Open Office doesn't have exactly the same shortcut keys.

I believe Ctrl+Shift+F9 should work in Open Office.

Rechecking my calculations for HP. Thanks!

Rechecking my calculations for HP. Thanks!

Added a separate file with a button to "re-roll" characteristics to the original post.

I'm not sure why, but it appears that Open Office interferes with some of the calculations.

I'm not sure why, but it appears that Open Office interferes with some of the calculations.

Ok, cool.

One thing you might try is having it only calculate the value for one hit location (such as chest) directly, then infer all the other hit locations from there. Chest is equal to 2 + Ceiling((CON+SIZ)/5), head is Chest - 2, abdomen is Chest - 1, etc. The only oddity is that at extremely low values of CON+SIZ, Arm gets rounded up to 1 instead of the 0 that would otherwise be calculated.

One thing you might try is having it only calculate the value for one hit location (such as chest) directly, then infer all the other hit locations from there. Chest is equal to 2 + Ceiling((CON+SIZ)/5), head is Chest - 2, abdomen is Chest - 1, etc. The only oddity is that at extremely low values of CON+SIZ, Arm gets rounded up to 1 instead of the 0 that would otherwise be calculated.

Thanks bluefenix, that's very helpful. I could easily change those equations to include that alternative. So if I'm reading you right, each arm would be Chest - 3, with the exception of the lowest equation, where it's rounded up to 1?

In the RQ6 book, the lowest limit for any point would be 1 from what I remember. I'm not sure why it's coming up with 0 for you, as I don't have that equation in my cells at all. :/ Normally it just comes up with ERROR for me if the number doesn't fit in the equations given.

In the RQ6 book, the lowest limit for any point would be 1 from what I remember. I'm not sure why it's coming up with 0 for you, as I don't have that equation in my cells at all. :/ Normally it just comes up with ERROR for me if the number doesn't fit in the equations given.

This is the formula I see for Head hp in your document:

"=IF((B10+B11)<=5;"1";IF((B10+B11)<=10;"2";0))"

And yes, arm is Chest - 3 except at the lowest end of the table (CON+SIZ of 5 or less, which actually shouldn't be possible for a human normally anyway, because rolling 3d6 guarantees 3 in each stat minimum, giving CON+SIZ = 6 minimum).

"=IF((B10+B11)<=5;"1";IF((B10+B11)<=10;"2";0))"

And yes, arm is Chest - 3 except at the lowest end of the table (CON+SIZ of 5 or less, which actually shouldn't be possible for a human normally anyway, because rolling 3d6 guarantees 3 in each stat minimum, giving CON+SIZ = 6 minimum).

Hmm, OK, the full formula for Head should be:

=IF((B10+B11)<=5,"1",IF((B10+B11)<=10,"2",IF((B10+B11)<=15,"3",IF((B10+B11)<=20,"4",IF((B10+B11)<=25,"5",IF((B10+B11)<=30,"6",IF((B10+B11)<=35,"7",IF((B10+B11)<=40,"8",IF((B10+B11)<=45,"9",IF((B10+B11)<=50,"10",IF((B10+B11)<=55,"11")))))))))))

I'm trying to keep a generic format as much as possible, as I'd like to incorporate other species into the table as well (Mostali, Durulz, etc.) later on.

Try it now - I just updated the formulas in every sheet, including the macro-enabled one.

=IF((B10+B11)<=5,"1",IF((B10+B11)<=10,"2",IF((B10+B11)<=15,"3",IF((B10+B11)<=20,"4",IF((B10+B11)<=25,"5",IF((B10+B11)<=30,"6",IF((B10+B11)<=35,"7",IF((B10+B11)<=40,"8",IF((B10+B11)<=45,"9",IF((B10+B11)<=50,"10",IF((B10+B11)<=55,"11")))))))))))

I'm trying to keep a generic format as much as possible, as I'd like to incorporate other species into the table as well (Mostali, Durulz, etc.) later on.

Try it now - I just updated the formulas in every sheet, including the macro-enabled one.

There are easier ways. Excel has a function for divide by X and round up though I forget its name. The formula would be then

Head = mysteryfunctionname(CON+SIZ,5)

Chest would be Head+2

Arm would be max(1, head-1) and so on

A generic way of writing it is.

HP = mysteryfunctioname(CON+SIZ,5)

Then for humans

Leg = HP

Arm = max(1, HP-1)

Chest = HP+2

and so on.

Head = mysteryfunctionname(CON+SIZ,5)

Chest would be Head+2

Arm would be max(1, head-1) and so on

A generic way of writing it is.

HP = mysteryfunctioname(CON+SIZ,5)

Then for humans

Leg = HP

Arm = max(1, HP-1)

Chest = HP+2

and so on.

Hi Bruce, I believe you're thinking of the CEILING formula which bluefenix mentioned above (http://www.techonthenet.com/excel/formulas/ceiling.php), but correct me if I'm wrong.

What I entered for the formula for chest was =2+(CEILING((CON+SIZ)/5,1)) but the lowest number for a human (3) came back with a 4 for chest, so my formula's not correct.

What I entered for the formula for chest was =2+(CEILING((CON+SIZ)/5,1)) but the lowest number for a human (3) came back with a 4 for chest, so my formula's not correct.

OK, I spent more time on it and the file should be updated with the CEILING function working correctly for area HP. It does not work for total HP (SIZ + CON) less than 6 though and comes back with 0 for the arms...

That doesn't matter since the minimum SIZ+CON for a human is 8+3 = 11.

Right, but just in case there's a creature out there with <3 for SIZ or CON, I'd love to keep the formula as close to the table in RQ6 as possible. ;)

EDIT: as I would like to use the spreadsheet to help create quick non-human NPCs or player characters (and even creatures) eventually.

EDIT: as I would like to use the spreadsheet to help create quick non-human NPCs or player characters (and even creatures) eventually.

[Last edited Jan 16, 2013 22:51:11]

Brian, you can sort out the arms problem by using max

max(1, ceiling((CON+SIZ),5)-1) will work.

That way if ceiling() returns 0 then max will set the value to 1.

max(1, ceiling((CON+SIZ),5)-1) will work.

That way if ceiling() returns 0 then max will set the value to 1.