Search the Forums
Options
Keywords search:


Search in Forum...

Search within...

Match...

Antiquity...

Player messages...
You are here: FFG Forums /  Roleplaying Games /  Rogue Trader

Rogue Trader
Ambition Knows No Bounds
Moderator: FFG Andy FischerffgjafferFFG_Sam StewartGeckoMack MartinThe Spaniard Topics: 1755 | Posts: 23901
Excel based Character Sheet
by Memetix
Published on 15 May 2010 - 22:22:01
Page 6 of 54 (803 messages) « First page... 4 5 6 7 8 ...Last page »
Reply #76 | Published on 06 October 2010 - 03:19:32

Starx - can I clarify a few things?

Firstly, I'm glad to hear it is still working on the Mac.

By the Final sheet I'm assuming you mean the "Character Sheet" sheet. The acquisitions section on the character sheet shows what ever has been typed into the Acquisitions data entry box on the Equipment sheet, unless you are a Psyker, when the acquisitions are appended to the gear section and the Acquisitions section is replaced with all your Psyker information.

What are the "Homeworld" traits you are talking about and what do you see on the Character sheet in the Acquisitions section?

If you are running a version of Mac Excel that supports macros, can you email me your save file please? If not, the saved .xls would be fine.

 

On a side note, I am aware that a few people have created characters (Orks) with too many starting talents to fit on the Talent summary sheet.
I'm working on a fix for this.
 

Rogue Trader/Dark Heresy/Deathwatch character sheet

Lord of the Ring LCG: Custom quests OCTGN

Reply #77 | Published on 06 October 2010 - 04:17:52

I've found a small problem while creating an Ork Freebooter:

If I choose the Evil Suns Klan with Tech-Use as Trained Skill and combine it with the Orky Know-Wotz Mekboy (also grants Tech-Use as Trained Skill), I find myself with Tech-Use +20 instead of +10.
Maybe this is an error with the script for summing up several instances of training for a single skill.

A voice from the chaos spoke:
Dont worry, smile and be happy. It could be worse.
I smiled and I was happy and it got worse.

Reply #78 | Published on 06 October 2010 - 05:21:36

Leviathan, thanks for the feedback. I've identified the bug and will fix it in the next release.

Rogue Trader/Dark Heresy/Deathwatch character sheet

Lord of the Ring LCG: Custom quests OCTGN

Reply #79 | Published on 06 October 2010 - 13:57:39

I can't seem to figure out how to level a character up.

I go to the advancement screen after I have spent enough XP to level, but the down box for rank 2 has nothing but white in it.

Am I just doing it wrong?

Without Signature
Reply #80 | Published on 06 October 2010 - 14:16:22

FarseerWraith07 said:

I can't seem to figure out how to level a character up.

I go to the advancement screen after I have spent enough XP to level, but the down box for rank 2 has nothing but white in it.

Am I just doing it wrong?

 

Also, I have tried opening it in Office 2010 as well as Office 2003

Without Signature
Reply #81 | Published on 06 October 2010 - 14:45:36

 Farseer - that is an odd bug you've found. I haven't seen that one myself.

Off the top of my head, could it be that the down list is scrolled down and the real options (at the top) are not visible.

If you can email me the .rtc file I'll see if I can reproduce the error. What career is your character?

Rogue Trader/Dark Heresy/Deathwatch character sheet

Lord of the Ring LCG: Custom quests OCTGN

Reply #82 | Published on 06 October 2010 - 15:12:14

Will send it on over.

The character is a Psyker, but I have tried generating other classes with the same results.

I got this version of your spreadsheet from Dark Reign, if that makes any difference.

Without Signature
Reply #83 | Published on 07 October 2010 - 08:45:13

Well the down box is completely blank, not just out of range.

I tried it again on Office 2003, and it seemed to work, the only issue with it is that it was ultra slow.

Still does not work with Office 2010.

Without Signature
Reply #84 | Published on 07 October 2010 - 12:03:41

 Having looked into Farseer's issue it appears that on his version of Office 2010, the spreadsheet is somewhat corrupted when opened (in compatibility mode). The pulldown menus are not referring to the correct cells and therefore appearing as blank.

Can I do a straw poll please? Is anyone else who uses 2010 seeing the same problems?

Alternatively, are there 2010 users out there that are seem to be working correctly?

Rogue Trader/Dark Heresy/Deathwatch character sheet

Lord of the Ring LCG: Custom quests OCTGN

Reply #85 | Published on 07 October 2010 - 15:52:21

I appologise if it sounds like I'm sending out a stream of complaints, but this sheet is really useful and I'm bored and like building characters. 

Rogue Trader character class lacks the +10 advancement for Common Lore (Rogue Traders), should be at rank 4 and 200 XP.

Pride is not a sin. Hubris is not a failing. The galaxy is not a mere collection of stars, it is our birthright! For too long have men looked up the infinite expanses of darkness before them and looked back inward, seeking solance in their huddled, weak soulfires. I see the black depths before me and all I can see is an eternity of war and conquest in the Emperor's name.

-Lord Solar Macharius

Reply #86 | Published on 07 October 2010 - 16:32:41

 Keep the feedback and bugs coming, its is only through all the good testing that it gets better.

I've been adding in the Radicals Handbook data today, expect a release soon.

Rogue Trader/Dark Heresy/Deathwatch character sheet

Lord of the Ring LCG: Custom quests OCTGN

Reply #87 | Published on 07 October 2010 - 21:28:06
6
0

I noticed a couple things, the sollex background is missing the skills and talents it is supposed to come with, you get the stat and insanity modifiers though.  And the Mechanator array is missing its stat modifiers when you select it.

 
Reply #88 | Published on 07 October 2010 - 23:22:55
0
0

I was having the same problem as farseer.  I'm on a Mac and using Office 2011.  The only down menu I noticed the problem with was the advancements one.  I didn't know anything about excel, but I really wanted to get the damn thing to work, extremely helpful for making my NPC's.  Basically for anyone who needs to fix this before a proper update you need to UNHIDE sheet 6 I think (whichever one is CAREER RANKS) and unprotect the advancement sheet.  Then in each of the rank selection downs run nthe DATA>VALIDATION command.  That will automatically shoot you over to the hidden Career Ranks sheet, once there you just redfine the fields it's looking at.  There is a grey set of fields at the upper right of that page, starts with K2 to K7 (I think) for first rank.  Just do that for every down rank field, it's pretty easy, then save the sheet, voila, Office 2010-2011 problem solved.  I'm not entirely sure if I managed to articulate that correctly.... hope it helps someone. 

Without Signature
Reply #89 | Published on 08 October 2010 - 03:29:20

Thanks for the help with the 2010/2011 problem.

I have tracked it down and will release a proper fix in the next couple of hours, along with the new Radicals Handbook material.

Basically, Excel does not allow you to refer to cells in another sheet when setting up down menus. The only way around this is to use a named range on the other sheet and refer to that. In all the other down menus I had done exactly that, however the rank advancement menus referred to the Career Ranks sheet directly and hence produced a rather random effect in 2010/11 but worked fine in 2003 and 2010.

I've updated the Sollex (Thanks Ragoth) but I've left the stat adjustments of the Machinator array as a manual update by the user, but I have prompted that this needs to be done manually. The "Bonus" column on the Character Generator sheet is designed exactly for this sort of thing.

Rogue Trader/Dark Heresy/Deathwatch character sheet

Lord of the Ring LCG: Custom quests OCTGN

Reply #90 | Published on 08 October 2010 - 06:43:28

Just have to say what a fantastic tool and I can't wait for the Radical Handbook/Deathwatch updates.

I've got some of the DW upgrade tables (namely Tactical Specialty and Generic Marine) already typed into excel as part of my own character creation sheet, if these would be of help to you PM me an e-mail address and I'll send it over.

Thanks again for a brilliant tool.

Surak

Knowledge is power,power corrupts. Therefore Libraries are the source of all evil.

Link to my Only War character calc

http://www.fantasyflightgames.com/edge_foros_discusion.asp?efid=292&efcid=46&efidt=768793&efpag=0#772078

 

Page 6 of 54 (803 messages) « First page... 4 5 6 7 8 ...Last page »
You are here: FFG Forums /  Roleplaying Games /  Rogue Trader

© 2013 Fantasy Flight Publishing, Inc. Fantasy Flight Games and the FFG logo are ® of Fantasy Flight Publishing, Inc.  All rights reserved.
Privacy Policy | Terms of Use | Contact | User Support | Rules Questions | Help | RSS