Upgraded Character Generator, Updated Generator Based on work from Autarkis and Blakkie Options

[Sengir]

SR4CG_DK version 1g is now available.

http://www.mediafire.com/file/4nmzyh0jdob/SR4CG_DK_1g.zip

Where's my prayer mat? (IMG:style_emoticons/default/biggrin.gif)

[Delarn]

I'll test the AI chargen next week.

[SpellBinder]

Regarding Excel in Office 2007, I just resave the sheet as an XLSM file and the warning upon opening disappears (I think I've disabled others since this is the only macro sheet I even use). The file is also less than half the original size, too, once it's an XLSM. Otherwise works just fine for me, unless karma normally is calculated on the Technomancer page (echos and upgrading complex forms are still free (IMG:style_emoticons/default/wink.gif) ).

Currently I just use the karma mod box on the Main_Sheet to help with the complex forms/echos & karma.

[bmcoomes]

Some of the prices for the Transgenics wrong

Augmentation Q&A

[DamienKnight]

Regarding Excel in Office 2007, I just resave the sheet as an XLSM file and the warning upon opening disappears (I think I've disabled others since this is the only macro sheet I even use). The file is also less than half the original size, too, once it's an XLSM. Otherwise works just fine for me, unless karma normally is calculated on the Technomancer page (echos and upgrading complex forms are still free (IMG:style_emoticons/default/wink.gif) ).

Currently I just use the karma mod box on the Main_Sheet to help with the complex forms/echos & karma.

Thanks for the reminder. Fixed this in version 1h.

Some of the prices for the Transgenics wrong

Augmentatio Q&A

Thanks for pointing this out. I now have adjusted the Transgenic prices to match the Transgenic section in Augmentation, rather than the appendix tables. This update will be available in 1h.

[SpellBinder]

No problem. Also had an idea posted on the previous page on how to expand for the Adapsin to track the essence loss.

Though in messing around I did notice that the cell for Logic on the Karma side comes up as a warning regardless of what is put in it. Even if using the BP system and the attribute is the same in both BP and Karma boxes, it's a warning. Karma still calculates as normal, though.

I did some poking around and actually did find the error, believe it or not, and it's fixable for anyone with just a little Excel knowledge like myself. In the conditional formatting rule that causes the cell change you can see the name of the attribute that's checked. In the code, there's bpLogica where I figured it should've been bpLogic, based on how the other working cells were set. Just deleted that "a" and it works. Can't recall now where to go in previous versions of Excel, but in Office 2007 it's through Home > Conditional Formatting > Manage Rules and then you can edit the rule in question. Just gotta make sure the right cell is selected.

[DamienKnight]

Good catch. Cell P9, in excel 2003 it is 'Format->Conditional Formatting'.

I will have to abbreviate developments on the current version so the fix can get out sooner.

In version 1h I went ahead and added support for Adapsin (Once you have selected adapsin, you can put a check mark next to any cyberware which was installed after getting the Adapsin treatment and it will cost 10% less essence).

[Eugene]

Just a couple of quick things using version 1g. When making an AI, the rating of some inherent programs (Black Hammer and Stealth at least) doesn't show on the character sheet, even if you've increased their rating with BP. Also, it'd be neat to have a spot for an AI's home node with its ratings, perhaps integrated somehow with the lifestyle tag. Also, speaking of lifestyle, what to do if you just want a regular level but don't want to go into all the detail? On older sheets there was a spot to purchase them in the Gear section.

[mindcandy]

can anyone tell me if it's possible to make the skills list print more skills on the actual character sheet - or print in columns?
one of my guys is playing a skills heavy advisor/face character and there's just not enough room

also I was wondering if there is an official donate button to say thanks for DK's work on this - it's a great tool and I'd like to buy the bloke a beer!

[cndblank]

Recently installed Office 2007.

I'm getting this when I open up SR4CG_DK_1g.xls.




"Compatibility Report for SR4CG_DK_1g.xls
Run on 3/14/2010 14:06

The following features in this workbook are not supported by earlier versions of Excel. These features may be lost or degraded when you save this workbook in an earlier file format.

Significant loss of functionality # of occurrences

This workbook contains data in cells outside of the row and column limit of the selected file format. Data beyond 256 (IV) columns by 65,536 rows will not be saved. Formula references to data in this region will return a #REF! error. 3
'Magic'!N4:N17"

[SpellBinder]

I remember getting that too. Wish I could recall what I ended up doing to fix it as I no longer get that error from the old file format; might be in Excel Options > Advanced or the error itself to clear it. All I get is an error about labels and that they'll be replaced with cell references; just hit Yes on that one and it works fine.

In the very least, try resaving it as an XLSM file, close, and open the new file. Oh, and don't forget to turn off the auto-save, else it'll seem to lock up Excel every ten minutes.

[mindcandy]

Possible error on sheet?

I've found that the value/rating of an additional language does not transfer through to the character sheet. (Office 2007 - Macro's enabled).

[cndblank]

I had the Karma option turned on and the sheet was blank other wise.

But thanks

[DamienKnight]

Just a couple of quick things using version 1g. When making an AI, the rating of some inherent programs (Black Hammer and Stealth at least) doesn't show on the character sheet, even if you've increased their rating with BP. Also, it'd be neat to have a spot for an AI's home node with its ratings, perhaps integrated somehow with the lifestyle tag. Also, speaking of lifestyle, what to do if you just want a regular level but don't want to go into all the detail? On older sheets there was a spot to purchase them in the Gear section.

The formula is missing from C42 and C44 on the hacking page. You can figure out the right formula by examining the other cells. This is now fixed in 1h. Thanks for checking out the new inherent programs!

I like the idea of having a node section on the lifestyle page. I will look into this. [Edit] Added this feature in version 1h.

I'm getting this when I open up SR4CG_DK_1g.xls.
This workbook contains data in cells outside of the row and column limit of the selected file format. Data beyond 256 (IV) columns by 65,536 rows will not be saved. Formula references to data in this region will return a #REF! error. 3
'Magic'!N4:N17"

Magic N4:N17 had data validation with relative references (A1 - A13). This was an error, they should have been static references to $A$1. I have corrected that in 1h. Let me know if that fixes this error when 1h is released.

Possible error on sheet?

I've found that the value/rating of an additional language does not transfer through to the character sheet. (Office 2007 - Macro's enabled).

Good catch. It seems there were issues with the formulas on the main sheet. Corrected in 1h.

[cndblank]

Under the 1G karma system it seemed like Knowledge skill specializations were running 2 Karma instead of the 1 karma.

[SpellBinder]

Interesting that there was an error in the magic section. As much as I've messed with it I don't recall having had any issues with the magic section.

Now I know I've mentioned this before, but the speed calculation for vehicles is still off for all but the first entry when racing tires or smart tires are selected with either engine customization option.

Also, the capacity calculation for nanohives in a cyberlimb is still off; it's a flat 2 for capacity, regardless of the rating.

Added: Also stumbled on this when trying to overload a motorcycle with gear. Found that the 20% speed penalty for having a modified armor rating greater than the vehicle's body rating is not calculated properly. It's in all vehicle entries.

[mindcandy]

Another possible error on sheet?

I can't find a way to add lingo's (language specialisations/core rule book p130) - putting an 'x' in the BPSpec box doesn't cost 1 point.

Logically I feel as if I should be entering English as a second language with a specialisation in 'Wiz' or 'Trog' or 'Cityspeak' or whatever even though I have already stated English is my native laguage. It also seems as if I should be able to enter mutiple lingos/specialisations that derive from the same root language (english) since an ork street shaman living in Seattle would conceivably know Wiz, Trog and Cityspeak.

Let me know if I'm missing something...

Edit: hmmm - possible you picked up on this when I mentioned the previous issue since you mention broken formulas?

Looking forwards to 1h!

[DamienKnight]

Interesting that there was an error in the magic section. As much as I've messed with it I don't recall having had any issues with the magic section.

There was not an error, just a quirk in 2007 that had to be accounted for in the Conditional Formatting.

Now I know I've mentioned this before, but the speed calculation for vehicles is still off for all but the first entry when racing tires or smart tires are selected with either engine customization option.

How about a specific example? Please include a list of what vehicle, mods, and what you think the modifiers should be, and what they actually are on the sheet.
[Edit] Found what you were talking about. Fixed in 1h.

Also, the capacity calculation for nanohives in a cyberlimb is still off; it's a flat 2 for capacity, regardless of the rating.

Indeed, thanks for the reminder. It is now fixed in 1h.

[SpellBinder]

Interesting about 2007. Oh well.

YW, and thanks for all the hard work you put into this.

[Brol_The_Mighty]

A couple things when working with 1g.

Every time I try to adjust my Logic attribute, it seems to yellow out on my like something is wrong. I've checked to makes sure I'm not over Karma or anything. It just yellows out.

Also, I can't find where its listed for some of the transgenetic treatments. Stuff like Infusions, with the option of permanent, or Genewipe and the like. As well as the attribute optimization from that section.

[bmcoomes]

if you on the little earlier posts it's the conditional formatting you need to remove the "a" from the string so that is has the right name of the cell.

[DamienKnight]

I can't find a way to add lingo's (language specialisations/core rule book p130) - putting an 'x' in the BPSpec box doesn't cost 1 point.

It will cost you 1 knowledge point if you still have any available, otherwise it charges BP.

I can't find where its listed for some of the transgenetic treatments. Stuff like Infusions, with the option of permanent, or Genewipe and the like. As well as the attribute optimization from that section.

Thanks for the reminder. Added phenotype adjustments to 1h, including functional Genetic Optimization for all attributes.

Infusions... bleh. I will add them, but I am going to make them highlight no matter what. It should be VERY rare that a character has a permanent Genetic Infusion, and I do not want to encourage players to select the option on a whim.

[mindcandy]

It will cost you 1 knowledge point if you still have any available, otherwise it charges BP.

Cheers for that - I had missed it.

[Draco18s]

Note on additional information on character sheets:

I created a new cell for myself so that I could easily reference my Spellcasting-available Magic as a Mystic Adept without having the flip over to the magic sheet (and without it I was rolling more dice than I should (IMG:style_emoticons/default/wink.gif) ). So it might be handy to have a cell set aside for that on the Main Sheet* (I found room for both a 'spell magic' and a 'current edge' so...) and the printable sheets.

*As I use this over any other page 95% of the time, as I'm not printing my sheet and have more info available on screen at one time than when looking at the printable sheets. I just have it reference the "Magic Left" value, under adept powers, on the magic sheet.

[DamienKnight]

Note on additional information on character sheets:

I created a new cell for myself so that I could easily reference my Spellcasting-available Magic as a Mystic Adept without having the flip over to the magic sheet (and without it I was rolling more dice than I should (IMG:style_emoticons/default/wink.gif) ). So it might be handy to have a cell set aside for that on the Main Sheet* (I found room for both a 'spell magic' and a 'current edge' so...) and the printable sheets.

*As I use this over any other page 95% of the time, as I'm not printing my sheet and have more info available on screen at one time than when looking at the printable sheets. I just have it reference the "Magic Left" value, under adept powers, on the magic sheet.

As a mystic adept, your Adept powers are listed in the multi-purpose box in the CharSheet. The level you have in '--Mystic Adepts-- Sorcery/Conjuring' should tell you how much magic is available for spellcasting. The only other factor may be Power or Spell foci that are bonded, but which may or may not be active.