SR4Chargen excell sheet updated for augmentation, Why yes, I have been gone for 18 months Options

[MaxHunter]

Great work dudes! keep it up!

A fan

Max

[Cthulhudreams]

http://personal.palouse.net/shade/sr4/SR4C...%20Arsenal).xls

There's mine then. Enjoy.

Sweet sheet man. Thanks.

[WearzManySkins]

The Spreadsheet does not implement Genetic Optimization ie Body, Str etc.

I like transgenetics also.

WMS

[It trolls!]

I went back to using Office 2004 for now because 2008 is a buggy pile of drek. My guess is that MS themselves can't decide about proper OOXML in their own products...
While entereing a recent char with skimmer discs in draft 9 I noticed there are no modular cyberlimb plugins in the sheet. I guess there's already a plan for that stuff?

[fatal2ty]

I just noticed this and thought I should note it.

The main post claims its Draft 7, but I just downloaded it as draft 8 from the link provided.

just in case people where waiting for an update its there

[ikarius]

Hurrm,
Just found a bug- The "Type O System" positive trait from augmentation does not appear to work in the .xls spreadsheet. I see something referencing it in the essence cost formula, but I get no change in the essence costs for bioware.


--Ikarius

[Mäx]

Hurrm,
Just found a bug- The "Type O System" positive trait from augmentation does not appear to work in the .xls spreadsheet. I see something referencing it in the essence cost formula, but I get no change in the essence costs for bioware.

I don't know what going on in your preadsheet, becouse it definedly works for me at least(using draft 8, if it makes a difrence) it correcly halfs the essence cost for basic bioware.

[ikarius]

I've tracked this down a bit better. The bug is definitely there, and it manifests when you do NOT check the House Rule of "Modifiers are handled additively". I was mistaken in the "no change"; that was for a piece of cultured bioware. Basic bioware actually goes UP in essence cost when you do not check the house rule, and goes down in cost by half when you do check the rule. I tracked down the cell named Bio_Essence_Reduction, which does 2 different calculations based on the state of the house rule, and if the house rule is checked, it comes out as -0.5, if the house rule isn't checked, it comes out as 0.5; no negative. I'll see if I can decipher what the non-additive method was supposed to be and come up with a working replacement formula.

Ikarius

[Shadow]

If someone can email me the file, kelvaris (at) gmail (dot) com, I would be happy to host it on my domain, add free. I have a couple of gigs of bandwidth so I think I would be okay.

[Shadow]

Ok I got that site to let me download it. If you keep me posted on the revisions I will happily mirror for you. It's a lot easier to click on a link and start the download then to jump the add hoops.


sr4chargenrev8

this is the non rar version as is compatible through office 07 as far as I know.

[Narse]

Hey Guys, I'm here posting just to let you all know that I really appreciate the hard work you all have put into this wonderful sheet. Also: I eagerly await the new and improved revised draft. Keep up the great work!

This sheet is seriously probably the best community tool out there for all us SR4 players. If there is anything I can do to help bring this next release to fruition, let me know. I don't know excel but can probably learn.

Most Gratefully,
Narse

Edit: Just fired up the sheet again after several months, and realized that I never mentioned that draft 8 still gives an Err:502 in the modified initiative pass field right from the get go. Edit2: Tracked this down to cell T34 on the cyber/bio ware page. It's formula is:

CODE

=MAX(T2:T33)

Since T2 throught T33 can have blank values (and do before I add any ware that modifies IP's) I would guess that this is another Open office issue with lookups of blank cells throwing Err:502. (T34 displays Err:502 in these circumstances). I consider this bug to be of low importance, because the field on the main sheet displays the proper value as long as IP enhancing augmentations are present. Note, however that if a character is built with adept powers that enhance IP's and no IP modifing ware (but why would someone buy Wired Reflexes if they also had Improved reflexes?) then the field (main sheet: O14) displays Err:502.
On a related note the cell Magic.P17 (the total IP mod due to adept powers) does not throw Err:502. I believe this is because it calls SUM(P3:P16) rather than MAX(x:y). This seems to cause bugs in very uncommon circumstances. That is when multiple instances of Improved Reflexes are taken. This of course is obviously a bad user input, and therefore is potentially not worth worrying about. However, it does seem significantly more likely that more than one piece of IP modifying 'ware may be present (what with 3 different ways of increasing IP via ware) which precludes using the same formula (i.e. SUM, specifically Cyber_Bio.T34=SUM(T2:T33) ) for the calculation of total Initiative Pass modifier due to ware.

To conclude: Change the formula of cell Cyberware_Bioware.T34 so that if all the cells that are referenced are blank it assumes a value of 0 (all the other cells in that row take 0 when the above cells are blank [at least in open office]) Potentially consider using this same function for cell Magic.P17. I think you could try to do some error handling here (if excel/OO even allow that) as you only need to set the values of the cells to zero if MAX(x:y) throws Err:502. Of course, this might break excel compatibility as you mentioned that excel returns 0 from blank cells and OO returns Err:502. Note that this would still allow you to call MAX($Cyber_Bio.T34;$Magic.p17) in the main sheet as both cells would always have a value in them of at least zero.
Perhaps you could use the following for Cyber_Bio.T34 (top line) and Magic.P17 (bottom line):

CODE

=IF(SUM(T2:T33)=0;0;MAX(T2:T33))

=IF(SUM(P3:P16)=0;0;MAX(P3:P16))

This takes advantage of the fact that SUM(x:y) returns 0 even if MAX(x:y) returns Err:502 (which is the case as far as I understand it.) Anyhow, since I don't know excel, you should really double check my work as I am only guessing that =IF(x;y;z) means "If x is true, then assign value y, otherwise[else] assign value z" from the context it seems to be used in, in the worksheets.

Hope this was helpful,
Narse

[Kyoto Kid]

...cool cool cool.

thanks.

The larger gear page is sweet. I actually prefer the manual gear entry as it allows you to put in comments like "Fake License 4 [Concealed Weapon] or "Virtual Person [Mom]" without having to hack into various tables.

[cryptoknight]

...cool cool cool.

thanks.

The larger gear page is sweet. I actually prefer the manual gear entry as it allows you to put in comments like "Fake License 4 [Concealed Weapon] or "Virtual Person [Mom]" without having to hack into various tables.

I agree, but I'd like some way to pick the gear from a list as well... After a while, I get tired of looking up prices for everything.

[WearzManySkins]

The packages cyberware suites do not give the bonuses to stats or skills. If you format the cells to have borders it makes it easier to see which column to add the stat bonuses to.

Genetic Optimization gives not bonus to any stats?
You will need to add/insert these to the Advantage list on Sheet1
Genetic Optimization (Body)
Genetic Optimization (Agility)
Genetic Optimization (Reaction)
Genetic Optimization (Strength)
Genetic Optimization (Charisma)
Genetic Optimization (Intuition)
Genetic Optimization (Logic)
Genetic Optimization (Willpower)

Then add/edit the following to the cells in the M2-M9 cells to implement it.

IF(AA2=-1,5,IF(AA2=-2,4,6+AA2))+IF(ISERROR(MATCH("Exceptional Attribute (Body)",O33:O46,0)),0,1)+IF(ISERROR(MATCH("Genetic Optimization (Body)",Cyberware_Bioware,0)),0,1)

Insure that each cell for each stat is changed to reflect that stat ie Body for Genetic Optimization (Body) etc.

Genetic Heritage/Genecrafted gives no cost savings on Genetic Optimization.

Why was the karmic analysis added? I must have missed that topic discussion?

Also add/insert to the Advantage list on Sheet1
Martial Art 1 5
Martial Art 2 10
Martial Art 3 15
Martial Art 4 20

WMS

[WearzManySkins]

To implement some transgenetic features add the following to the WareList sheet

Trans Alt Alien Look Gen 0.2 10 40,000
Trans Alt Minor Modification Gen 0 4 1,000
Trans Alt Moderate Modification Gen 0.1 6 2,000
Trans Alt Severe Modification 1 Gen 0.3 6 10,000
Trans Alt Severe Modification 2 Gen 0.4 8 10,000
Trans Alt Severe Modification 3 Gen 0.5 12 10,000
Trans Alt Metatype Change Gen 0.3 8 25,000
Trans Alt Sex Change Gen 0.3 6 20,000
Trans Alt Animal Features Gen 0.3 10 45,000
Trans Alt Chameleon Skin Gen 0.2 6 4,000
Trans Alt Dynamic Chameleon Skin Gen 0.2 8 7,000
Trans Alt Clean Metabolism Gen 0.1 4 2,500
Trans Alt Chloroplast Skin Gen 0.1 4 2,500
Trans Alt Dietware Gen 0.1 4 2,500
Trans Alt Hair Growth Gen 0 4 A 500
Trans Alt Sensitive Skin Gen 0 4 2,500
Trans Alt Silky Skin Gen 0 4 1,500
Trans Alt Skin Pigmentation Gen 0 4 1,500
Trans Alt Bio Tattoos Gen 0 4 A 1,500
Trans Alt Bone Density Augmentation (1-4) Gen 0.3 12 A 20,000
Trans Alt Cat's Eyes Gen 0.1 4 7,500
Trans Alt Chemical Gland Gen 0.3 12 30,000
Trans Alt Exhalation Spray Gen 0.1 5,000
Trans Alt Internal Release Gen 1,000
Trans Alt Spit Gen 0.1 3,000
Trans Alt Weapon Reservoir Gen 0.1 2,000
Trans Alt Digestive Expansion Gen 0.5 4 20,000
Trans Alt Echolocation Gen 0.1 8 15,000
Trans Alt Elastic Joints Gen 0.3 10 15,000
Trans Alt Enhanced Pherome Recepters (1-3) Gen 0.1 10 E 5,000
Trans Alt Extended Volume (1-3) Gen 0.1 10 E 4,000
Trans Alt Gecko Hands Gen 0.1 6 12,000
Trans Alt Gills (1-2) Gen 0.2 6 E 12,000
Trans Alt Hands and Foot Webbing Gen 0.1 6 6,000
Trans Alt Hearing Enhancement Gen 0.1 6 5,000
Trans Alt Muscle Augmentation (1-4) Gen 0.2 5 1 7,000
Trans Alt Muscle Toner (1-4) Gen 0.2 5 1 8,000
Trans Alt Nicitating Membrane Gen 0.1 4 2,000
Trans Alt Quills Gen 0.25 6 2,500
Trans Alt Skin Pocket Gen 0.1 4 5,000
Trans Alt Spidersilk Gland Gen 0.3 10 40,000
Trans Alt Tactile Sensitivity Gen 0.2 8 4,000
Trans Alt Tailored Critter Pheromones (1-3) Gen 0.2 4 1 15,000
Trans Alt Tailored Pheromones (1-3) Gen 0.2 4 1 15,000
Trans Alt Troll Eyes Gen 0.1 6 8,000
Trans Alt Vocal Range Extender Gen 0.1 8 12,000

To change over to Franks rules save spreadsheet to another name ie "halfcost" etc. Then load that spreadsheet and change the following cells
Main Sheet AA18 to =IF($A18<>"",IF(ISERROR(FIND("(Group)",$A18)),D18*2+IF(D18>6,2,0),D18*5),0
Main Sheet AB18 to =IF(F18<>"",1,0)
Then just dragfill the cells down to line 46.

For Race Edit Main Sheet S3 for the costs of Franks Races
For racial costs on my sheets I used a different method since I have put the subraces and other things into effect.

WMS

[WearzManySkins]

Formula in sheet Bioware_Cyberware cell D2 is
=IF($A2="","",(VLOOKUP($A2,Complete_Ware_Table,4,FALSE))*(IF($B2="",1,IF(ISERR(FIND("A",VLOOKUP($A2,Complete_Ware_Table,5,FALSE))),$B2,1)))-IF($C2="2nd Hand",1,IF($C2="2nd Alpha",1,0)) + IF($A3<>"",IF(ISERR(FIND("P",VLOOKUP(A3,Complete_Ware_Table,5,FALSE))),0,$D3),0))

Why is it referencing cells A3 and D3?

The entire column of D has the same error?

WMS

[WearzManySkins]

I think the error in that cells formula is supposed to reference the availability code of the cell above it, the "P" flag in your sheet is for a added feature of a piece of cyberwear.

WMS

[Kithran]

I've only just started looking at SR4 and thus it may be me missing something from the rules, but as Magic is a stat shouldn't you be able to take Exceptional Apptitude (Magic). I notice this doesn't seem possible with the sheet but wasn't sure if it was me missing a rule or finding something missing form the sheet.

Kithran

[Sombranox]

I've only just started looking at SR4 and thus it may be me missing something from the rules, but as Magic is a stat shouldn't you be able to take Exceptional Apptitude (Magic). I notice this doesn't seem possible with the sheet but wasn't sure if it was me missing a rule or finding something missing form the sheet.

Kithran

I think it says in the description of exceptional aptitude that it can only be taken for physical and mental stats, which is the normal six. And then somewhere in the magic section that the only way to raise magic limits is through initiation.

Which is good, because mages are scary as hell as it is at Magic 6 starting out. Once they start initiating, they can get truly nasty.

I don't have my books on this computer, but I'm semi-sure that those wordings were in there.

[Speed Wraith]

I've only just started looking at SR4 and thus it may be me missing something from the rules, but as Magic is a stat shouldn't you be able to take Exceptional Apptitude (Magic). I notice this doesn't seem possible with the sheet but wasn't sure if it was me missing a rule or finding something missing form the sheet.

Kithran

Book says "The Exceptional Attribute quality allows a character to possess a natural Physical or Mental attribute at a level above the metatype maximum." Magic (and Resonance) are classified as Special attributes, which leaves them out.

[krakjen]

With is further confirmed by the Lucky quality that allow to raise edge (a special attribute too) by 1 point.

[quentra]

Wait, one of my players had the draft 9 version of the sheet, w/Arsenal and Frank's custom rules imped. I looked over the thread, but didn't find it. I missed it somewhere?

[WhiteWolf]

Wait, one of my players had the draft 9 version of the sheet, w/Arsenal and Frank's custom rules imped. I looked over the thread, but didn't find it. I missed it somewhere?

Links not working, but if you look on this page someone quoted the person who has a link to draft v9.

[Mickle5125]

Soo.... what ever happened to the update that was supposed to be coming out that gave drop down lists for items, weapons, and other fun things?

[Nigel]

I'm getting a very odd error. My Physical Attributes are all messed up in the XLS for Loki (in sig). It says Err:502 but I use OpenOffice, so that may be a unique error to OO. Can anyone verify if my error happens elsewhere, or how to fix it?