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

[crash2029]

The thing is I cannot find the quality in the positive qualities dialog box.

[Eugene]

Great work as always, DamienKnight! Is it possible to add a spot on the character sheet to upload an image?

[SpellBinder]

Great work, I must say. Never even had any of the crashing problems with my really old copy of Excel.

Though I've noticed a few things that don't appear to have been noticed or mentioned here since I started using these sheets. Largely vehicle related.

First, Arsenal pg 131 says that percentages are based on the vehicle's base speed only. This would mean that a vehicle that normally does not have smart tires or any engine customization which is later upgraded with all would still have the same speed and acceleration scores. The vehicle entry does not calculate speed or acceleration this way, and the vehicle subsequently ends up with a reduced speed and acceleration. Same also holds true for just speed enhancers, where racing tires and engine customization for speed should be a +30%, not +32% as it is actually calculated.

Also, the monetary cost for tires is not quite accurate right off, unless you use the misc. gear section. The arsenal listed cost is per tire, so for example, a set of smart tires for most vehicles (assuming four wheels) should be 10,000 instead of 2,500.

There are also no costs for the morphine license plate or spoof chip (1000 and 500 respectively). The errata also lists the Horizon Double Revolution and Tata Hotspur with a base pilot rating of 2, not 1.

Last to mention is in the qualities section. The last three boxes don't calculate negative metagenic qualities properly, the points are not deducted to cover the positive SURGE quality first.

And thanks for expanding more on the Technomancer sheet. Still needs some work with all the sprites, but at least it's nice to be able to record the stream now.

Again, great work on this project DamienKnight. I think you deserve more thanks than you're getting.

[DamienKnight]

Same also holds true for just speed enhancers, where racing tires and engine customization for speed should be a +30%, not +32% as it is actually calculated.

I see. Replaced multiplication formula with addition/multiplication formula. Tests on racing tires + Engine cust. Speed successfully.

And thanks for expanding more on the Technomancer sheet. Still needs some work with all the sprites, but at least it's nice to be able to record the stream now.

I see that the Sprites listed for the stream were all drawing on the first sprite entry. Fixed this in the next version.

Last to mention is in the qualities section. The last three boxes don't calculate negative metagenic qualities properly, the points are not deducted to cover the positive SURGE quality first.

Fixed in upcoming version.

Thanks for the feedback Spellbinder!

[DamienKnight]

I just have to say that I have been using this and it is great. Everyone involved is doing an excellent job.

But I am having problems with the latest version. It is very prone to crashing in open office. I'm not sure if anyone else is having this problem. I have been running Beta7b and had no problems with that.

Weirdly, I'm getting no crashes in OO.

The difference is probably your operating system. We have observed OO crashes alot when running this sheet from Windows XP. It seems to be quite a bit more stable in Vista.

[StealthSigma]

The difference is probably your operating system. We have observed OO crashes alot when running this sheet from Windows XP. It seems to be quite a bit more stable in Vista.

I've observed the sheet crashing in WinXP using Excel 2000.

Once it crashed when switching it from Karma gen to BP after just opening it.
Once it crashed when disabling freeze frames then scrolling down.

I can't remember any other crashes explicitly, but I do remember those. So it may very well be OS based without even considering the spreadsheet application.

[DamienKnight]

Great work as always, DamienKnight! Is it possible to add a spot on the character sheet to upload an image?

I would be happy to make some custom CharSheets. Link me to a sheet style you are interested in, or an image of something you have drawn out/laid out in excel.

I am fidgety about the sheets... I am not sure what people are really looking for. I have added a Magic page and a Vehicle page, and have a couple slightly different versions of the main Charsheet. What next?

I was thinking about a weapons page, which listed weapon descriptions, had places for ammo/clips, and displayed your Martial Arts/Maneuvers. Maybe Maneuvers should be on the main page?

I also think I want to add foci from the Magic Page to the Gear list on the Charsheets. Any other Charsheet suggestions?

[Orcus Blackweath...]

Looks really good. A couple of items that I noticed, not sure if they are User error or bugs.

I downloaded DK_1a.
1) Could not find DMSO Narcoject capsule rounds. I found the capsule rounds, but could not find Narcojet anywhere.
2) Audio enhancement does not allow purchase of ratings I get the warning red letters when I try to select rating 3. (Vision enhancement works just fine)

[Tachi]

I love this sheet.
But, before I moved I had a player who was from India who, for fairly obvious reasons, was rather fond of the nartaki ([slap]distinctive style[/slap]) which you misspelled in your sheet, nartaki, not natarki, (though he says it should actually be narthaki, but that's not what RC says, so whatever). The only problem, and I'm not really Excel literate so I don't know if you can change it; if one takes the nartaki, or just the shiva arms metagenetic quality, there is no change in the "cyberparts" section of ANY of the sheets I've seen to reflect the possibility of 4+ cyberarms. So, I was wondering if it would be possible to change it so that each time Shiva-arms were taken (as nartaki or as a separate SURGE quality) the "cyberparts" section added another pair of arms. I have no idea how this would be handled Essence wise, probably full cost to replace each arm.

Anyway, just my .02 (IMG:style_emoticons/default/nuyen.gif) .

As I said, I love this sheet, I've been using it for a while and I'm very happy. Nice work.


BTW I noticed that almost all the sheets I've seen with the nartaki metavariant are all mispelled. They all say natarki. hehe.

[Translucent Wolf]

2) Audio enhancement does not allow purchase of ratings I get the warning red letters when I try to select rating 3. (Vision enhancement works just fine)

Run the macro to switch to dev mode, and then fix the rating in the 'gear data' tab. Same is true of vision enhancements, and the cost for ratings on vision enhancements. Fix is to change cost to 0, and change x cost to 25/50/100, etc. as per book.

T.W.

[Orcus Blackweath...]

Hmm I managed to switch to dev, and make the changes, but can't seem to switch back I get the error"

Not a Data page: Main_Sheet--1004Application-defined or object-defined errir

[SpellBinder]

Something more I found in the qualities section. Don't ask why, but I have a tendency to start with the negative qualities at the bottom of the list, and work my way up.

Anyway, two things, and one seems to be confined to the last three that were added a few versions ago. The qualities that affect essence loss due to cyberware and bioware don't reflect properly in the Cyberware/Bioware page if it's in the last three. Maybe you caught that with the metagenic issue I mentioned, don't know, but I thought I'd at least mention it.

The other is that Albinism is listed as an applicable negative metagenic quality, and it doesn't calculate that way at all. Biocompatability for Cyberware also doesn't calculate right, though the Bioware option does. (Yeah, I've been messing around with a lot of SURGE characters lately).

As for suggestions, the only thing I can think of would be adding something like the Ally_Spirit for a technomancer's option of a Bonded Sprite.

Again, DK, great work.

[Penta]

Is it me, or...?

Using Vista SP2, OO 3.1...1a sheet.

I'm trying to add a free contact on a character in chargen. I see no way to flip the switch on earned contacts to make this contact earned.

[DamienKnight]

Hmm I managed to switch to dev, and make the changes, but can't seem to switch back I get the error"

Not a Data page: Main_Sheet--1004Application-defined or object-defined errir

Not sure why you would get this error. All that script does is Hide all data pages, protect all non-data pages, and move the selection to cell A1. All this can be done manually.

Tools->Protection->Protect Sheet
will let you protect the pages.

Format->Sheet->Hide
can be used to hide the data sheet and any other sheet you are not using. Do not delete sheets!

Something more I found in the qualities section. Don't ask why, but I have a tendency to start with the negative qualities at the bottom of the list, and work my way up.

Anyway, two things, and one seems to be confined to the last three that were added a few versions ago. The qualities that affect essence loss due to cyberware and bioware don't reflect properly in the Cyberware/Bioware page if it's in the last three. Maybe you caught that with the metagenic issue I mentioned, don't know, but I thought I'd at least mention it.

The other is that Albinism is listed as an applicable negative metagenic quality, and it doesn't calculate that way at all. Biocompatability for Cyberware also doesn't calculate right, though the Bioware option does. (Yeah, I've been messing around with a lot of SURGE characters lately).

As for suggestions, the only thing I can think of would be adding something like the Ally_Spirit for a technomancer's option of a Bonded Sprite.

Again, DK, great work.

Updated the 'Qualities_Area' name to include the last three rows. This fixed the Connected -Wares and other traits affected.

Flipped metagenic switch on Albinism. Also copied it to the Metagenic area of qualities.

I will look into the Bonded Sprite thing. Good suggestion!

Is it me, or...?

Using Vista SP2, OO 3.1...1a sheet.

I'm trying to add a free contact on a character in chargen. I see no way to flip the switch on earned contacts to make this contact earned.

The cell simply needs to contain any character in order for the switch to be flipped. Added a comment in the next version.

[Orcus Blackweath...]

Thanks Damien. I did that, and it worked.

I also answered my own question about Narcojet. It is listed as a combat chemical, I was looking in toxins.

To buy Narcojet buy 1 ammunitionX10 Capsule rounds, and 10 doses of Narcojet.

[DamienKnight]

Thanks Damien. I did that, and it worked.

I also answered my own question about Narcojet. It is listed as a combat chemical, I was looking in toxins.

To buy Narcojet buy 1 ammunitionX10 Capsule rounds, and 10 doses of Narcojet.

The gear in the Gear sheet is organized exactly as it is listed in the tables in the SR4 book, that is to say, it is organized very strangely. I would very much like to see things categorized differently. If anyone would like to help me out ALOT, they could come up with a better grouping for the gear, and send me a list of gear in the fashion of:

Gear Old Category New Category


That would help me ALOT, and make gear selection so much easier.

[DamienKnight]

As for suggestions, the only thing I can think of would be adding something like the Ally_Spirit for a technomancer's option of a Bonded Sprite.

I would absolutely like to do that. Could you give me the page reference that has the Bonded Sprite rules. Didnt realize that technomancers could get Ally Sprites. Having trouble finding this in Unwired.

[Tyro]

Chameleon coating is still costing a flat 16k for vehicles instead of 1k x body.

"Audio Enhancements" under "enhancements" should be "Audio Enhancement (1-3)", and the category would be much easier to find as "Audio Wear Enhancers" (with the "audio enhancer" category renamed to "audio enhancement wear"). The Rating box turns yellow if I add a rating to Audio Enhancements (but the cost works out fine anyway).

[Edit:] It looks like I was editing a character on the old Gencon Edition sheet. Please disregard any of the above which has already been addressed.

[Phoenix (A-Team)]

I was wondering...

The cap on Qualities is supposed to be 35/-35. Should it become a house rule to exceed this number? Thus far I haven't seen the Quality areas light up yellow when I exceed the cap, it only says its capped in the note and in the books.

I was also wondering what you wanted to be different in the organization of the gear categories. Yours/the books' categories group appropriate things together, but can be a bit dizzying if you don't know where to look for something. What would you like to see changed?

You were completely right about the sensor question I had last. So the problem is that, like BTLs, they never gave us a price for any of these instruments (RFID tags, micro sensors, and handheld chassis?

[DamienKnight]

The cap on Qualities is supposed to be 35/-35. Should it become a house rule to exceed this number? Thus far I haven't seen the Quality areas light up yellow when I exceed the cap, it only says its capped in the note and in the books.

If you use the Karma system it is a 70 cap. The sheet ignores the cap once you have begun earning Karma, since a character in play can pick up additional qualities through gameplay (such as hunted) and the highlighting is annoying.

Remove their earned Karma and see if the cap highlights when exceeding the limit.

[SpellBinder]

I would absolutely like to do that. Could you give me the page reference that has the Bonded Sprite rules. Didnt realize that technomancers could get Ally Sprites. Having trouble finding this in Unwired.

The rules for free sprites starts on page 157 with the bonding suggestions listed on page 160. There's sadly not a whole lot there, but much of what's printed is rather open ended still.

[DamienKnight]

The rules for free sprites starts on page 157 with the bonding suggestions listed on page 160. There's sadly not a whole lot there, but much of what's printed is rather open ended still.

Ah. This will not require a page similar to the Ally_Spirit page, but will simply require an elaborate on the Resonance Bond Quality on the Main_Sheet.

[rob]

Re: Gear organization: I have been writing something like that. I can implement it in the sheet myself. it ain't hard.

Also, on my version of the sheet I've completely rewritten the hacking page to include programs, options, and bundles. Do you have an address i can send it to?

[DamienKnight]

Re: Gear organization: I have been writing something like that. I can implement it in the sheet myself. it ain't hard.

Also, on my version of the sheet I've completely rewritten the hacking page to include programs, options, and bundles. Do you have an address i can send it to?

I would like to see your reorganization, and your revised hacking page. PM me.

[ravensoracle]

The difference is probably your operating system. We have observed OO crashes alot when running this sheet from Windows XP. It seems to be quite a bit more stable in Vista.

I have saved the document as a .ods document and have yet to experience a crash with the sheet. I have used it over a period of about 4 hrs putting old characters into a digital format. Before when it was an .xls I would matbe get 5 minutes out of it. Hope this helps.

On another note, I am not finding the Human Looking positive quality listed.