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: 1743 | Posts: 23807
Excel based Character Sheet
by Memetix
Published on 15 May 2010 - 03:18:43
Page 50 of 54 (802 messages) « First page... 48 49 50 51 52 ...Last page »
Reply #736 | Published on 29 October 2012 - 09:44:07

Another request: Include threshold values for Psychic powers. And perhaps Cast time and Sustainability as well? :)  

Tarald - The Dark Lord of Smeg
You're not drunk if you can lie on the floor without holding on

Author of the Players Datapad & The Excel Combat Datapad
Darth Smeg's House rules for playing DH with OW rules

 

 

 

 

Reply #737 | Published on 08 November 2012 - 09:22:33
6
0

I noticed teh Crimson Guard option doubles at rank 2, its listed twice,.  At rank 3 The Flesh Is Weak 5 and 6 make the armor points dissappear from the character sheet.  At Rank 3 or 4 the option for the Crimson Guard is no longer an option you can take, sometimes its 3, sometimes 4, but it dissappears totally as an option.

 
Reply #738 | Published on 08 November 2012 - 12:35:12

Ragoth said:

I noticed teh Crimson Guard option doubles at rank 2, its listed twice,.  At rank 3 The Flesh Is Weak 5 and 6 make the armor points dissappear from the character sheet.  At Rank 3 or 4 the option for the Crimson Guard is no longer an option you can take, sometimes its 3, sometimes 4, but it dissappears totally as an option.

Crimson Guard is an odd one since you actually gain some benefit from taking the alternate rank more than once. I've allowed the rank to be selected 3 times as "Crimson Guard", "Crimson Guard " and "Crimson Guard  " (1 or 2 spaces at the end of the name).

I'll try to update the sheet to ensure you can only select the "next" level and I'll take a look at the armour points bug.

Rogue Trader/Dark Heresy/Deathwatch character sheet

Lord of the Ring LCG: Custom quests OCTGN

Reply #739 | Published on 08 November 2012 - 19:22:27
6
0

Memetix said:

 

Ragoth said:

 

I noticed teh Crimson Guard option doubles at rank 2, its listed twice,.  At rank 3 The Flesh Is Weak 5 and 6 make the armor points dissappear from the character sheet.  At Rank 3 or 4 the option for the Crimson Guard is no longer an option you can take, sometimes its 3, sometimes 4, but it dissappears totally as an option.

 

 

Crimson Guard is an odd one since you actually gain some benefit from taking the alternate rank more than once. I've allowed the rank to be selected 3 times as "Crimson Guard", "Crimson Guard " and "Crimson Guard  " (1 or 2 spaces at the end of the name).

I'll try to update the sheet to ensure you can only select the "next" level and I'll take a look at the armour points bug.

 

 

 

Would it be easier to make the Crimson Guard its own career?  It does have a listing all the way to rank 8 like the base careers.

 
Reply #740 | Published on 12 November 2012 - 12:57:59
0
0

This has probably been asked multiple times in this thread, but it's a little too long to find individual questions. Is there any plan to update the sheet with options from all the unsupported books? Specifically, Deathwatch Chapters from Honor the Chapter.

Also, does anyone have a quick reference for what to type in the Custom Chapter section for the chapters from Honor the Chapter?

Without Signature
Reply #741 | Published on 16 November 2012 - 00:01:45

First off: excellent character sheet. Highest quality sheet I have ever had the honor of getting my hands on.

Now, not to be a bother but in case your not aware(just saw this thread and I don't feel like going though 50 pages) the kroot and ork careers are not available in the careers drop down menu for rogue trader.

Reply #742 | Published on 16 November 2012 - 02:40:50

Hi,

The Ork and Kroot careers are in there, you need to select 'Ork' or 'Kroot' under homeworld and then the relivant career appears at the bottom of the career menu.

Hope this helps (and works)

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

 

Reply #743 | Published on 23 November 2012 - 03:20:14

Version 6.31 available for download here.

This is a minor release with bug fixes for

  • Spelling mistakes (Artificer and Power Filed). These are auto corrected when loading in an existing .rtc file
  • Added ability to equip Luminen weapons
  • Added ability to equip Luminen shield
  • Added ability to equip Baleful eye
  • Fixed the display of the storm shield stats
  • Fixed calculation errors for some characters with 'Psy Rating +1' talent
  • Hard coded formulas in VB macros fail for some non-English language version of Excel. Fixed by copying cell's formulas rather than hard coding.
  • Ensure Diplomacy skill is correctly displayed on the character sheet(s)
  • Ensure Machine(6) trait is handled correctly

The Spreadsheet now has more than 20,000 downloads on Dark Reign (and another 5000 for the previous releases).

Thanks for your continued support.

Rogue Trader/Dark Heresy/Deathwatch character sheet

Lord of the Ring LCG: Custom quests OCTGN

Reply #744 | Published on 23 November 2012 - 13:27:51
3
0

Excellent work.

One issue I have seen is the implementation of Best Quality Synthetic Muscle Grafts.

The -10 to Agility is to Agiliity Tests not to the Agility Characteristic.

Without Signature

Reply #745 | Published on 23 November 2012 - 16:32:52

Yes, there are a few implants and cybernetics that modify tests but not the actual attribute. I haven't had the time to go through all the books and double-check to make a list for memetix, though.

Without Signature
Reply #746 | Published on 23 November 2012 - 18:28:41
3
0

Sorry. There is an issue, but I misidentified it. I now see two problems.

The first is with the 'Brute' Mutation Line 2280 - Menus sheet. This sets a -10 to agility - which is not given in the RT mutations Table (RT p369).

Correcting this leaves all Agility skills 10 points higher than they should be. I see that Synthetic Muscle Grafts (BEST) gives the 'Clumsy' Talent - which should apply a -10 to agility tests. However, this does not appear to be applied to the Character Sheets. I have yet to figure out how this modifiers are applied…

 

Without Signature

Reply #747 | Published on 24 November 2012 - 04:19:44

Fresnel said:

Sorry. There is an issue, but I misidentified it. I now see two problems.

The first is with the 'Brute' Mutation Line 2280 - Menus sheet. This sets a -10 to agility - which is not given in the RT mutations Table (RT p369).

Correcting this leaves all Agility skills 10 points higher than they should be. I see that Synthetic Muscle Grafts (BEST) gives the 'Clumsy' Talent - which should apply a -10 to agility tests. However, this does not appear to be applied to the Character Sheets. I have yet to figure out how this modifiers are applied…

 

You are right - thanks. Brute in the Dark Heresy setting does give a -10 to Ag, but not in Rogue Trader. The fix is simple, unhide the Menus sheet and delete the -10 in cell K2280.

I'll also ensure that the 'clumsy' trait automatically updates the skill values on the character sheet in the next release.

Rogue Trader/Dark Heresy/Deathwatch character sheet

Lord of the Ring LCG: Custom quests OCTGN

Reply #748 | Published on 24 November 2012 - 07:51:24
3
0

I have seen another issue:

Skills sheet: AY46:AY48

The formulas in these cells is out of step with the others:

For example: AY46

=IF(OR(AO46="",AO46="Common Lore (Int)",AO46="Schoalstic Lore (Int)",AO46="Forbidden Lore (int)",AND(AO46<>"Polyglot (int)",ISERROR(FIND("Infused",AO46)),LEFT(AO48,3)=" - ",LEFT(AO46,3)<>" - ",AU46=""),NOT(ISNUMBER(AX46))),"",ROUNDDOWN(AX46/IF(OR(AQ46=1,AU46=1),1,2),0)+10*(IF(AU46=1,2,SUM(AR46:AS46)))+IF(AV46="",0,AV46))

The figure in bold/italic/underlined should be 47 - one more than the ("Infused",AO46) test.

BTW, nicely constructed workbook. My Excel-foo is weak, but this is neat enough for me to follow. :)

 

 

Without Signature

Reply #749 | Published on 24 November 2012 - 09:16:28
3
0

Rogue Trade p 137

"Any armour that provides 7 or more AP inflicts a -30% penalty on Concealment and Silent Move tests."

Version 6.31 only gives a -20%.

So Power Armour should give a total modifier of -40 (-30% for the AP8 and -10 for Hulking).

 

 

Without Signature

Reply #750 | Published on 27 November 2012 - 03:41:00
0
0

Wow! Very impressed by this character sheet, thank you for all your hard work.

I've noticed a small bug - a shock maul doesn't seem to have any stats when it's equipped.

Quick question about Bolt weapons - I notice they all have the Tearing effect, but in vanilla Dark Heresy they don't (AFAIK). Is this a bug or something I've completly missed in the rules or just something from an expansion that doesn't apply to vanilla DH?

 

 

Without Signature
Page 50 of 54 (802 messages) « First page... 48 49 50 51 52 ...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