Forums of the Megaverse®

Greg Diaczyk wrote:I tried to set up print areas in earlier versions, but found that it ended up printing weird sizes and shapes and make a printed copy look really odd. I forgot about it in the later versions though. If you unprotect the sheet you can add your own print areas and print as you like.

Dakchronos wrote:Fantastic Content. The more I use RACS the more I Love it.

Could use a bit of a fix though, For PP and PE, the bonuses gained calculate past 30, Our game group likes to tie in HU2 with our Rifts so Stats get chunky.
The fix so far has been to adjust our bonuses accordingly.

Ankhr wrote:I've used the sheet, and like it. I have noticed the strength calculations seem to be high. Are the using the HU formula, because it seems high to me.

Greg Diaczyk wrote:

Ankhr wrote:I've used the sheet, and like it. I have noticed the strength calculations seem to be high. Are the using the HU formula, because it seems high to me.

Yes, you are correct, the lifting and carry capacity are from Heroes Unlimited. I've always found it more useful especially when a dragon tries to pick up and toss a giant robot, those values may have snuck in from my own game. My apologies, I'll be sure to add that to errata list for the next update.

The Strength calculations for damage are from Rifts Ultimate Edition, starting on page 285.

Ankhr wrote:

Greg Diaczyk wrote:

Ankhr wrote:I've used the sheet, and like it. I have noticed the strength calculations seem to be high. Are the using the HU formula, because it seems high to me.

Yes, you are correct, the lifting and carry capacity are from Heroes Unlimited. I've always found it more useful especially when a dragon tries to pick up and toss a giant robot, those values may have snuck in from my own game. My apologies, I'll be sure to add that to errata list for the next update.

The Strength calculations for damage are from Rifts Ultimate Edition, starting on page 285.

Thanks for your answer. No problem at all. I love your sheet. I'm using it alot. very well done.

Greg Diaczyk wrote:

Dakchronos wrote:Fantastic Content. The more I use RACS the more I Love it.

Could use a bit of a fix though, For PP and PE, the bonuses gained calculate past 30, Our game group likes to tie in HU2 with our Rifts so Stats get chunky.
The fix so far has been to adjust our bonuses accordingly.

You are correct, there is no camp in the formula. I was expecting GMs to have warn players about limits, thus players would not build character with a P.P. or P.E. above 30. But in the event that that is the case, just put a negative value in the custom section to offset the extra bonus. We will look into putting a cap on the next update.

Greg Diaczyk wrote:Hey folks,
This threat is for anyone who has questions about the Rifts Automated Character Sheet, how to use it, what's part of it, troubleshooting issues, etc. Feel free to post away and I'll do my best to answer it.

Borast wrote:

Greg Diaczyk wrote:Hey folks,
This threat is for anyone who has questions about the Rifts Automated Character Sheet, how to use it, what's part of it, troubleshooting issues, etc. Feel free to post away and I'll do my best to answer it.

Depending on the nature of the threat, it could be a Criminal Offence.

I very much like the idea, hope my W7 laptop with Office 2007 can run it!



Before anyone says it... BAD! BAD you! NO to W10!!!!!

hup7 wrote:@Arrow Just google "Data validation in excel" and "vlookup in excel" to learn how to do lookup tables.

Tiny spelling mistake in data!e10 +5% of Gymnastics known, +2% if Hunting known

Janos2001 wrote:I might be making some serious mistakes, but The magic Section does not seem to have drop down menus available (or at least, not on the one I got). Instead you have to type in the spell name itself, at which time it does fill in the rest to a certain point. If the description is to long it will end up not being able to get more than the first line of the Spell Effects listed, and if you enter the name again, it just gives you the exact same thing.

Also, the part about the protect and unprotect... those options do not show up when I right click either. All in all, it has so much promise, but it definitely is not working as advertised (or as the instructions tab says it should).

I have completely removed the program and re-downloaded it, with the exact same results. I have looked to see if maybe there is an update and can not locate one either. I have not tried some of the other things, so I can't state anything in regards to them (though I can say that the things I did try besides Magic were working, except the part about Unprotect and Protect).

Thank you for your time and any assistance.

1: Typo on "Instructions" tab, User Instructions, "Main" Sheet: In some cases (such as the skills), the list is quit large ...

2: On the "Main" tab, took me a moment to figure out why the bonuses from Boxing weren't showing up in the Combat Skill (Melee) section. After a bit, I realized that it was adding the bonuses to the Hand to Hand skill instead of showing them for the individual skill. I get why, and I'm okay with that, but took me a while to figure out that this only displayed for situational modifiers instead of all modifiers. Note: I didn't watch many tutorial videos, so if this is brought up in those, then that's on me. If not, then something you may want to mention at some point.

3: If I'm understanding the way this works correctly, the skills add the "per level" bonus starting at level 1. This is not the official rules, as the "per level" bonus for skills do not start until level 2 (so in my formula, I just used "LVL-1", or equivalent since it's not drawing the level from the character level). Which is fine as long as you're aware and this is a conscious choice. Note: RUE, page 279, Skill Check/Roll Under Your Skill (read the example). I believe the rule is located other places as well, but that's at least one source that I could list with relative ease.

4: On the "Skills" tab, "Lore: Demons & Monsters" with the synergy bonus from "Mythology" doesn't seem to add the +5 that's listed on the "Data" tab. I'm not sure if the formula is wrong, or if the Data tab is wrong for listing it. Maybe I did something, but feel free to check it out.

P.S. A poster on the All Things Palladium Books section of the forums was asking about version compatibility with your sheet (Excel 2007). The topic can be found here: viewtopic.php?f=1&t=176753

Janos2001 wrote:Hey Janos2001,

You should really look at the tutorials on Youtube:
https://www.youtube.com/channel/UCUWjzM ... tdqdAuQ5kQ

But specifically this one at time interval: 6:10
https://www.youtube.com/watch?v=2vksA9Pf9bk

As observed you can type in the spell name, but if you click on the cell, a dropdown menu box and down arrow will appear to the right of the cell. click on the arrow and the dropdown menu will appear. You can then scroll through the available spells.

As for the text being lost, it is there you just need to move the column and row tabs to adjust (see the video). You can move the rows down when the sheet is protected by grabbing the row tab and dragging it down, the cell already has wrap text so it should be there. The sheet will need to be unprotected to modify the columns.

Unprotect/Protect: Are you using Excel or something else to open the file? If you are using Excel see the video, if not you may have to check the help section of your non-Excel software to see how to unprotect the sheet.

Hope that helps!
If not let me know.


Sir,

I had watched those videos (loved them by the way, they are the reason I bought the program.. that and I look forward to any updates you do). However, I Just double checked what program it was opening with and My Bad on that. I was on my Main Computer (I have several Desktops for different things) and for whatever reason I had removed Excel on this one (Win 7, other has Win 10) and it Turns out that the Computer was opening it via OpenOffice Calc and I didn't even realize it (been quite a few years since I have Used Excel for any reason). So, I apologize to you for the prior Post. I am downloading another copy of Excel 2013 to try it on. If that doesn't work I will try Excel 2019 (I just wasn't sure if 2019 would work on Win 7), and If THAT doesn't work, then I will hook up the other Comp and check there.

Again, I apologize for my prior post and I am eager to see if I can get it to work!

Very Respectfully,

Janos

Kagashi wrote:Do I have to purchase this again to get the 003 release?

Greg Diaczyk wrote:

Kagashi wrote:Do I have to purchase this again to get the 003 release?

No, its a free update for those who have already purchased it once.

Did you get in on DriveThru or here on the Palladium Store?

Kagashi wrote:

Greg Diaczyk wrote:

Kagashi wrote:Do I have to purchase this again to get the 003 release?

No, its a free update for those who have already purchased it once.

Did you get in on DriveThru or here on the Palladium Store?

Palladium Store

Greg Diaczyk wrote:

Kagashi wrote:

Greg Diaczyk wrote:

Kagashi wrote:Do I have to purchase this again to get the 003 release?

No, its a free update for those who have already purchased it once.

Did you get in on DriveThru or here on the Palladium Store?

Palladium Store

You should be able to download the most updated version from the link you used to download it in the first place. If you do not have access to that link anymore or lost it you'll need to contact Wayne at Palladium Books.

Kagashi wrote:

Greg Diaczyk wrote:

Kagashi wrote:

Greg Diaczyk wrote:

Kagashi wrote:Do I have to purchase this again to get the 003 release?

No, its a free update for those who have already purchased it once.

Did you get in on DriveThru or here on the Palladium Store?

Palladium Store

You should be able to download the most updated version from the link you used to download it in the first place. If you do not have access to that link anymore or lost it you'll need to contact Wayne at Palladium Books.

It keeps downloading 001 over and over.

swest wrote:Greetings,

I'm working through my first trial of RACS and I'm wondering something: Shouldn't there be a box on the Main page for an Initiative Bonus?

(b.t.w., I'm also new to Rifts... so, there's that.)

Thanks!

- s.west

Borast wrote:but I thought you had to *be* juggling to obtain the bonus.

Greg Diaczyk wrote:Did you catch anything else?

swest wrote:

Greg Diaczyk wrote:Did you catch anything else?

Well, this isn't a 'catch', but I am struggling to figure out where to put something.

Specifically, I'm creating a Cyber-Knight, and I can't figure out where I would account for the character's Cyber-Armor (Living Armor). As far as I can tell, only S.D.C. Armor has an Armor Rating (A.R.), but the Cyber-Armor, which is M.D.C. Armor, specifies an A.R. The Armor section on the Equipment page doesn't appear to be set up to handle Cyber-Armor, but the Cybernetics & Bionics page also doesn't seem like the right place.

Am I misinterpreting something here?

Thanks for your continued engagement.

- s.west

swest wrote:Ok, did that.

Regarding incrementing the Living Armor's M.D.C., by level, the only tricky part was dealing with the "Chest Plate (main body)" M.D.C., which adds 1D6/level starting at level 4. So what I did was to generate all 12 of the 1D6 dice rolls, put them into a running sum, and index into that running sum by level.

Although that worked pretty well, it necessitated creating a work area on the O.C.C. & Natural Abilities page, which will interfere with a clean printing of that page for a printed copy of the final character sheet.

But... even as I typed that last paragraph, I realized that I probably could have put that work area on the Data page. What do you think?

- s.west

Greg Diaczyk wrote:

swest wrote:Ok, did that.

Regarding incrementing the Living Armor's M.D.C., by level, the only tricky part was dealing with the "Chest Plate (main body)" M.D.C., which adds 1D6/level starting at level 4. So what I did was to generate all 12 of the 1D6 dice rolls, put them into a running sum, and index into that running sum by level.

Although that worked pretty well, it necessitated creating a work area on the O.C.C. & Natural Abilities page, which will interfere with a clean printing of that page for a printed copy of the final character sheet.

But... even as I typed that last paragraph, I realized that I probably could have put that work area on the Data page. What do you think?

- s.west

I probably would have done an incremental bonus of +1 (after level 3) to all M.D.C. locations, but for the chest you'd have to roll the 1D6 each level to see how much more M.D.C. you get to the main body.