Author Topic: [RMSS] Excel Character Sheet  (Read 5532 times)

0 Members and 1 Guest are viewing this topic.

Offline Sable Wyvern

  • Initiate
  • *
  • Posts: 144
  • OIC Points +0/-0
[RMSS] Excel Character Sheet
« on: January 07, 2018, 01:09:34 AM »
This will probably be of limited utility to most, since it's designed specifically with my own settting and my own house rules in mind, but it's possible some of you may find some value in the linked Excel character sheet.

It's pretty comprehensive, and goes from initial character generation up to level 30. Almost anything that's derived directly from a player decision is auto-calculated.

It's about six-month's worth of sporadic work.

I had mate that played around with it a bit, and added in some code for hiding and unhiding cells, which is why it has macros. The sheet will still work fine if you deny macro permissions.

https://drive.google.com/file/d/1TOLqt3N3d57kcnGPlOfX99BH56ro8DF8/view?usp=sharing

Offline craggles

  • Senior Adept
  • **
  • Posts: 621
  • OIC Points +0/-0
  • I intend to live forever ... or die trying!
    • Personal Sketchpad
Re: [RMSS] Excel Character Sheet
« Reply #1 on: January 07, 2018, 05:38:10 AM »
On the contrary, this will be VERY helpful! Thank you very much!!  ;D

This may be better located in the Vault?

Are the complete Talents list used? And I can't seem to find the Flaws.

PS - That's my favourite Rolemaster logo too.  ;)
Logo Rolemaster (Unified). Illustration of 2 Covers.
Logo Re-Vamp of Shadow World.
Illustration, Page Design & Layout of Shadow World Players Guide - The World.
Illustration of various other Shadow World products
Logo Design, Page Design & Layout of HARP SF & SFX
Feel free to browse my gallery

Offline Sable Wyvern

  • Initiate
  • *
  • Posts: 144
  • OIC Points +0/-0
Re: [RMSS] Excel Character Sheet
« Reply #2 on: January 07, 2018, 05:45:33 AM »
No flaws, and a significantly reduced talent list.

The list of included talents starts in cell A347 on the Tables sheet.

I also uploaded an xlsx copy to the Vault.

Offline Sable Wyvern

  • Initiate
  • *
  • Posts: 144
  • OIC Points +0/-0
Re: [RMSS] Excel Character Sheet
« Reply #3 on: January 07, 2018, 06:02:58 AM »
Changes from RAW found in the sheet (the ones I could recall with a quick scan):

* Setting specific races and cultures.
* RM2 Potential generation method.
* A lot of variant priests from Channeling Companion.
* A couple of variant Paladins
* Heavily stripped-down skill list.
* Numerous categories combined.
* A few skill costs tweaked.
* MAC Martial Arts Styles are almost all the historical styles from the MAC, but have been renamed.
* Initiative influenced by OB.
* Fumble ranges, breakage numbers and weapon strength tweaked.
* AT2 is cloth. AT1 is Special/Supernatural.
* No flaws.
* Reduced talent list.
* Caster level equals ranks in PP Development.

Also, I left out instructions for the Injuries field. Enter the original penalty and days to heal, and don't change those values. As you add days of healing in the Heal Time column, the penalty will reduce.

I take it the logo is yours? I'm happy to add a credit and/or a link if you let me know what name you want used.

Offline Sable Wyvern

  • Initiate
  • *
  • Posts: 144
  • OIC Points +0/-0
Re: [RMSS] Excel Character Sheet
« Reply #4 on: January 07, 2018, 06:50:04 AM »
Meh ... I just found a bunch of minor errors that slipped in today while I was finishing it off. Corrected now.

Offline craggles

  • Senior Adept
  • **
  • Posts: 621
  • OIC Points +0/-0
  • I intend to live forever ... or die trying!
    • Personal Sketchpad
Re: [RMSS] Excel Character Sheet
« Reply #5 on: January 07, 2018, 06:52:46 AM »
I like the logic behind a lot of the functions and other choices you've made in reducing some of the elements.

I take it the logo is yours? I'm happy to add a credit and/or a link if you let me know what name you want used.

Thanks for the list and that's not necessary - I'm just pleased it's being used pre-RMU  ::)
Logo Rolemaster (Unified). Illustration of 2 Covers.
Logo Re-Vamp of Shadow World.
Illustration, Page Design & Layout of Shadow World Players Guide - The World.
Illustration of various other Shadow World products
Logo Design, Page Design & Layout of HARP SF & SFX
Feel free to browse my gallery

Offline Sable Wyvern

  • Initiate
  • *
  • Posts: 144
  • OIC Points +0/-0
Re: [RMSS] Excel Character Sheet
« Reply #6 on: January 07, 2018, 07:44:09 AM »
I like the logic behind a lot of the functions and other choices you've made in reducing some of the elements.

Thanks. It's by far the most complex thing I've done in Excel. If I could go back to the start, I'd definitely change the way I handled the professions with subclasses (Paladins, Priests, Elementalists) to streamline things and make a lot of subsequent formulas much simpler, but overall I'm pretty happy with it.

Offline craggles

  • Senior Adept
  • **
  • Posts: 621
  • OIC Points +0/-0
  • I intend to live forever ... or die trying!
    • Personal Sketchpad
Re: [RMSS] Excel Character Sheet
« Reply #7 on: January 07, 2018, 08:23:05 AM »
If I could go back to the start, I'd definitely change the way I handled the professions with subclasses (Paladins, Priests, Elementalists) to streamline things and make a lot of subsequent formulas much simpler.

Out of interest, how would you have done them - if it's a quick explanation?
Logo Rolemaster (Unified). Illustration of 2 Covers.
Logo Re-Vamp of Shadow World.
Illustration, Page Design & Layout of Shadow World Players Guide - The World.
Illustration of various other Shadow World products
Logo Design, Page Design & Layout of HARP SF & SFX
Feel free to browse my gallery

Offline Sable Wyvern

  • Initiate
  • *
  • Posts: 144
  • OIC Points +0/-0
Re: [RMSS] Excel Character Sheet
« Reply #8 on: January 07, 2018, 03:57:35 PM »
Out of interest, how would you have done them - if it's a quick explanation?

I didn't want a 20-odd priest professions clogging up the list when players initially select profession, so I split them out, and did the same thing with elementalists and paladins. This was a good decision IMO.

Unfortunately, as a result of this decision, I also ended up tabulating the priest, elementalist and paladin information separately to the other professions. This means whenever the sheet needs to check profession information, it can't just do a simple lookup, it first needs to determine which of the four profession summaries to check.

If everything had been tabulated together, this check could have been done once, and every lookup could have pointed to a single, unified table, making for simpler formulas and fewer errors.

It's all quite obvious in retrospect, but I don't actually do a lot of work in Excel, so I hadn't been thinking that far ahead at the time.

Offline jdale

  • RMU Dev Team
  • ****
  • Posts: 7,099
  • OIC Points +25/-25
Re: [RMSS] Excel Character Sheet
« Reply #9 on: January 07, 2018, 08:11:42 PM »
I did the same thing for priest, except instead of having the main part of the character sheet read the priest table, I have the cells in the profession table read the data from the priest table. So there's one unified professions data table to read, it's just that the entries in that table are dynamic in the column for the priest.
System and Line Editor for Rolemaster

Offline craggles

  • Senior Adept
  • **
  • Posts: 621
  • OIC Points +0/-0
  • I intend to live forever ... or die trying!
    • Personal Sketchpad
Re: [RMSS] Excel Character Sheet
« Reply #10 on: January 07, 2018, 08:25:11 PM »
Do you have descriptions for the MA Style special abilities by any chance?  ???
Logo Rolemaster (Unified). Illustration of 2 Covers.
Logo Re-Vamp of Shadow World.
Illustration, Page Design & Layout of Shadow World Players Guide - The World.
Illustration of various other Shadow World products
Logo Design, Page Design & Layout of HARP SF & SFX
Feel free to browse my gallery

Offline Sable Wyvern

  • Initiate
  • *
  • Posts: 144
  • OIC Points +0/-0
Re: [RMSS] Excel Character Sheet
« Reply #11 on: January 07, 2018, 08:51:41 PM »
Do you have descriptions for the MA Style special abilities by any chance?  ???

Most of them can be found in MAC once you match the styles to the MAC styles, but I'll PM you some more info.

Offline Sable Wyvern

  • Initiate
  • *
  • Posts: 144
  • OIC Points +0/-0
Re: [RMSS] Excel Character Sheet
« Reply #12 on: January 07, 2018, 09:01:00 PM »
I did the same thing for priest, except instead of having the main part of the character sheet read the priest table, I have the cells in the profession table read the data from the priest table. So there's one unified professions data table to read, it's just that the entries in that table are dynamic in the column for the priest.

Huh ... that would have been an easy fix that I really should have thought of once I recognised the issue. I might even go back and implement that at some point.

Offline Sable Wyvern

  • Initiate
  • *
  • Posts: 144
  • OIC Points +0/-0
Re: [RMSS] Excel Character Sheet
« Reply #13 on: January 08, 2018, 02:10:39 AM »
v1.05 with a few more minor fixes.

https://drive.google.com/file/d/1U8UVb9EgHR1ybN-pxPe83Ka9ex0v-ing/view?usp=sharing

* Rounding error in MMP, Missile Penalty and Qu Pen fixed.
* Additional base lists now appearing on Spells sheet.
* Error with Paladin (and probably Elementalist) Spell category bonus fixed.
* Sprikkas Power Perception was incorrectly being treated as Restricted.
* Reality Awareness total ranks was displaying incorrectly.
* Stunned Manoeuvring removed from Adolescence skill list.
* Closed Essence Familiar Mastery was incorrectly listed as Familiar Summons.
* A couple of other minor fixes.