Actually what seems to be buggering the mods (at least for what I'm doing) is that the Complete_Vehicle_Mod_Table cell range stops at Nitrous Injection so I get an error for Rigger Adaptation

Good observation Cabral. Fixed in 7.


Yeah, orcs lifespan is so short and their intellect so lowly, I did not figure any of them would live long enough to actually beat a new language into their thick heads.

Erm...no, no meta hating here. Or'zet added in Beta 7.


14 is the range code for light pistols. Where is this number showing up at? I am not seeing it on the CharSheet. Are you on a version prior to beta 6?

See the earlier discussion on attribute raising in this sheet. When you enter a value, that is your desired attribute base, before modifying it by race. If you set it to 2 edge for troll, your modified edge is 2. If you set it to 2 on human, who get +1 racial modfier on edge, it will be 3, and you will pay the cost of raising it from 2 to 3 (instead of 1 to 2). If you have a different suggestion for how the sheet should work, please provide a mock up of agility on a new spreadsheet, and allow the user to select troll/elf/human. If it works better than the one Arturkis created, I will gladly use it in the next version of the spreadsheet.

Now I know you are on an old version, as this problem does not exist in Beta 6.

I agree about contacts. I think there should be a whole page set aside for them, and will work on this for version 8 or 9. Any suggestions on what to include in this sheet are much appreciated.

Yes, skills dont have an attribute column. There is no place to mark off used ammo. These are cosmetics on the CharSheet. Its not that I do not want to improve the CharSheet, I just need inspiration. How would you like to see marked off ammo recorded on the sheet? Does anybody else want an attribute column on skills?

Personally I don't have any trouble remembering which attribute is linked to which skill seeing as they are fairly sensibly assigned, so that always seemed like a waste of space to me. I can change the formatted sheet though, if enough in the community are interested in it.

Also, I never mark ammo off on my char sheet... its a sacred sheet that shouldnt be scribbled on. I have yellow sticky notepads for junk like that. Again, if enough are interested in this I will look into it.

Personally I would like to see CharSheet style areas for all of the details of a character sheet. Rather than dumping all of those into the Character generator, I would like to get the save to text file option working, then start a new project for formatted character sheet design which can import characters from any generator, not just this one. See the discussion on Standardized Character Formatting

The name on the version I used was: SR4Chargen_Upgraded_Beta6.xls
The time stamp for the file was Thursday, October 23, 2008, 11:03:00 PM


The CZ120 error is just showing up on the first row (Columns DEF on Charsheet) of the ranged weapons table, I added another CZ and it showed up as Light pistol. It was also showing up numbers for SMGs, Assault rifles and so on.


The minute I've updated skills and stats on my characters I tend to reprint them, so scribbling all over them is not such a big deal for me. The character sheet I use for myself has a sheet listing skills and attributes, edges, flaws and augmentations, a sheet specifically designed for combat (ammo tracking and damage tracking are on this sheet.), a sheet for the PAN, a sheet for the vehicles, a sheet for contacts and a sheet for character notes and it is in excel.

While I'm thinking it could easily be meshed (via internal links) with the character generator you're working on, other formats would have some difficulty(Mac users in particular). I uploaded a copy of what I have here: http://www.mediafire.com/?myuhdb7yjfb

Actually, I checked it over and realized the attributes were off. I tweaked many of the functions here and it is now working properly in 7 for races with racial modifiers less than -1.

Keen insight. Indeed the Additional clip needs to only lose capacity for pistols. I changed the datapage to have a pistol and non-pistol version of the Additional Clip mod. I do not double clip sizes... they stay the same, with a note at the bottom that it has two clips.

Astute observation. The formulas were correct but the data page was not. Corrected in 7.

Negative Cabral. Epic perception failure! Since the attributes are totaled separately from the race the limit should stay at 375.

Sure. Standard Races Cost is calculated, you are correct. This field is then multiplied against the BP cost of the race to determine the karma cost. Basically there are 3 options for standard races karma cost. It can be normal, which means it follows the standard 2xbp cost. There is reduced, which is 1xbp cost. And then there is Free, or 'Standard Races Cost' = 0.

Other Races are handled seperatly from standard races. In one of the gaming groups I designed this sheet for, they have reduced cost for standard races, and full cost (2xbp) for non-standard with the karma system. I programmed this seperation into the sheet to serve their house rules.

You can simply rename the fields to TRUE or FALSE to manipulate them. I should probably highlight them in blue or something.


Great idea! I think I will copy the data straight out of this post and use it in the sheet. Thanks for the suggestion!

edit: By the way, anyone copying/pasting in their skills from an old sheet is going to need to add two spaces in front of any skill names that are part of a group, as I am using spaces in the name for indenting as above. So much more readable!


I added a cyberlimbs implant category for skull and added fangs, horns and hair after our previous penile discussion.

Interestingly, Mysterious Implant was left out of the negative qualities. Apparently, I can add it myself, but I wasn't sure if this was by design or simply an oversight.

Very awesome work, though!

How mysterious.

In standard Karma Build. There is no Racial cost. See step 1 and Step 3 on page 42, RC

Lol, cheesy ... and I like it!


I believe you are experiencing a chain of botched perception rolls here. Race cost is free if you set it to free. This sheet is built to serve the community and therefore is engineered to handle different house rules, which you can decide on. Please see my discussion on the optional rules and TRUE/FALSE switches just a few posts ago.

He does have a point. By RAW, race costs are free. You probably should just make that toggled to true by default, and then people can uncheck it based on house rules.

No, I think, what he wants to point out is the following:
As RAW state, race costs are free - and your maximum Karma spent on attributes during creation is half the Krma you have PLUS twice the BP-Cost of your race as it WOULD cost, if it weren't free.
Hope, I got it as it is to be. =)

Mishra has it.

I think you are referring to This Post, if not could you direct me to the post in question?
If so, it does not clearly state how to achieve a "RAW" state in the spreadsheet. (I always say understand the RAW and houserule from there, so I'd like to know how RAW works in this sheet before I let the monkeys loose (IMG:style_emoticons/default/grinbig.gif) )

Well it seems it took a team effort, but finally I have seen the light. The limit on attributes in there so that Trolls with giant minimum attributes, who are going to be paying up the wazoo to raise their attributes, are allowed to spend more karma on attributes. It totally makes sense, but I just wasnt going to grasp it until:


Alright, fixed with Beta 7. Thanks for your persistence in enlightening me Cabral. It seems I am the one who has rolled badly (or maybe my Logic attribute is junk).

DamienKnight.

I love what you have done with the sheet. I have only run into one major issue at the moment with using it, and I know it has to do with the version of Excel I am using. In Excel 2007 when I open the file I get the following message



If I click on NO, Excel closes the document.

If I click on YES it converts the document and the following things I have noticed.

Optional Rules checkboxes are gone but has the text there. If you Type the correct text value it still works but it doesn't look as pretty.
The Resources drop down list is empty. This may not be related but I just wanted to make it known.
Once the macros are enabled the text in the optional rules box vanishes,



Other bug But not related to this is There are only 4 levels to Martial Artist not 7. Unless this is some house rule that I have not seen.

If you do not have access to Excell 2007 I will be glad to try and help with fixing the sheet but I will admit that I don't know excel that well and may be asking some questions for coding help.

I am using Excel 2003. I cannot hardly believe that names would be removed in a latter version of Excel! They are so much more robust than actual cell refrerences, especially when working through multiple spreadsheet editors. Shame on you Microsoft!

The resources bug has been mentioned and is fixed in 7.

They only mention 4 levels of martial arts in the books, I assume meaning you can get up to level 4 in one style, but couldnt you get level 4 in one style, and 3 in another? To save space (and because it makes sense) I have allowed up to level 7, which would be 35 BP (the max qualities allowed), which represents 35 points worth of Martial arts, divided however you like amongst different styles (which is handled in the martial arts section next to qualities on the main page). If you do not approve of 7 levels, then feel free to delete the extra levels from the data page, or simply dont use them.

Edit:

Beta 7b is released!

Added Nanoware to Cyberware/Bioware page
Added Mentor Spirit Selection on Magic page (must select Mentor spirit quality)
Added aliases for various cell references
Add top 30 world languages to language list, fixed Italian
Added Character Data Mapping sheet and Ini/Xml output pages, sample only (pages are hidden but workable)
Fixed various bugs on vehicles, cyberware, cyberparts, and charsheet, thanks to help finding the bugs from the community
Added Symbiont and missing Cosmetic cyber modifications
Added Bobson's quick and pretty Skill Group savings (just use negative values in BP column for skills that are part of groups)

I agree. I labels are very handed, particularly when combined with defined lists. (IMG:style_emoticons/default/frown.gif) It's like C++ no longer supporting comments.

... And there was much rejoicing!

Hey there, again something from me =)
Looks like there's a little mistake in the calculation of at least one attribute for at least one race ^^'
Or perhaps two little mistakes - with the charisma for the elf.
Minimum is stated as 2 points with a maximum of 8 - but I believe, it should be a minimum of 3 points, shouldn't it?
And, when I enter a value for charisma, it doesn't show this value +2 in the appropriate column, but just the value itself (so while I should get a charisma of 6 with entering 4, I just get 4).
Hope, I'm pointing it out clear enough and can be of some help again (IMG:style_emoticons/default/smile.gif)
Best regards - and thanks so far
Mishra

Attribute calculations are a bit difficult to understand...

What would be nice is if I could just enter either

1. how many stat points I wanted to add to the base state and let the sheet calculate the BP or Karma costs

2. What value the stat should be and just use the minimum and maximum for the race to figure out the BP.

ie. setup a table on a hidden sheet with each race and the racial mins and maxs for each stat, use VLOOKUP to get the info.

I figured out how to do group-breaking in a workable (although not entirely intuitive) manner.

Three steps:

1. Change validation of column D to allow for values down to -4
2. Wrap column AN in a MAX(....., 0)
3. Replace column AQ with =IF(E29>ABS(D29),IF(ISERROR(FIND("(Group)",$A29)),
   VLOOKUP($E29,Complete_Karma_Math_Table,3,FALSE)-VLOOKUP(IF($D29="",0,ABS($D29)),Complete_Karma_Math_Table,3,FALSE),
   VLOOKUP($E29,Complete_Karma_Math_Table,6,FALSE)-IF($D29="",0,VLOOKUP(ABS($D29),Complete_Karma_Math_Table,6,FALSE))),0)

Then, when you want to say that a skill was raised to X as part of a group, you buy the group as normal, and give the skill a value of -X. Then the karma costs for raising beyond X are calculated appropriately.



Also, More than Metahuman (uw) is missing from the positive quality list, and the bioware/cyberware costs seem to have reverted to an older version, or something - they aren't halving the lesser of the two any more.

Yes, the charisma formula is wrong. Fixed it, will release 7a soon. Charisma should be very similar to Agility calculation, if anyone is impatient and wants to fix this themselves.


The sheet currently employs method 1. There is a hidden sheet called 'RACE' which it does lookups on.

.

No it doesn't... and that's what's confusing.

Take the sheet, make a Dryad... put a 1 in the Base for Charisma. If it employed 1... the Charisma of the Dryad should be 3. But it's still 2.

What's worse, is it costs 10 BP to set it to 2 if I put 2 in the base column... The base for a Dryad is 3... But even so... if I put a 2 in the Build column it should be 2 - Racial minimum (which is incorrectly 2) = 0 * 10 = 0 BP, in Beta 7 it shows 10.

Each attribute's cost formula should be IF(Value = Max,25 + 10*(Value - (minimum + 1)),10*(Value-minimum))

Try looking at an attribute besides charisma. Refer to my previous post:

Well ok so I played with Agility.

If I put a 1 in for the Base Agility... it stays at 2. Which contradicts what I said above... If I want to add 1 to the base stat for a Dryad it should be 3.

If I put in a 2 for the Base Agility.... it goes to 3... When it should be a 4 if your operating on the type 1 I have above.

The stats are just counter intuitive... Adding tons of explanation to the sheet still leaves them so...