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

[DamienKnight]

tested!

I dint even get to click a drop down it crashed right after it said for security reason... macro are disabled. then another window pop up wich ask : This file contains link to other files, should they be updated? y/n.

say yes goto crash

say no and... well its working. I am trying a charater. will update if I get another crash.

Edit: okay I opened twice, did lots of drop down choice and it did not crash. This version seems stable if you dont update link to external file...

Anybody know why it does that?

The other version crash on yes and no...

Thanks for looking into it.

Excel posts 'Refresh link to other file' if there is another file linked in a formula, OR if one of the sheets has a space in its name and is referred to by a named range. That is why I have underscores _ in sheet names.

Open Office must have some other condition that causes this prompt accidentally. Probably has to do with named ranges. Ill look into it.

The change that made this version not crash was removing the named range 'Magic' because it shared a name with the Magic sheet.

OO users feel free to use Test 3 for now. I will include this OO fix in the next version.

[yokyok]

Hi,

I just tested the sheet under the following environment :
OpenOffice 3.0
Ubuntu 8.0.4
Asus eeePC 901

And the sheet just crashes my OpenOffice, it happens at least with all beta 9x sheet.

By the way, if someone know how to get some log or trace from OpenOffice on ubuntu, it would help me find some more clue.

Yok

[DamienKnight]

I have been working on the spreadsheet all day while watching Burn Notice and contemplating 'How can my runners be more like Michael Westen'.

"Too many different formats"

If anyone has ever encountered this error, you know the nightmare I am facing. Apparently Excel stores all of its cell formats in Formatting objects, not within the cell object themselves. The cells simply point to the Formatting object. Its a fantastic way to save resources when you have alot of similarly formatted cells, and I dont think there is a better way of doing it.

The issue is, Excel has a built in limit of 4000 Formatting objects. This includes number formats and Font/Shading/Border formats, and conditional formats. I have analyzed the sheet using a number of tools and decided the only way for the sheet to continue to grow without dividing it into multiple sheets is to revamp the formatting. It needs to be more uniform and basic, and without borders. Borders cause alot of unique cell formats, and requires alot of conditional formatting to keep them looking right.

I am going to spend a bit of time reformatting the sheet, and... making it more OO compatible. I have OO available to me for awhile, so I am doing some testing.

I still welcome all suggestions and bug notifications, and will attempt to address everything in its own time.

Thanks for the continued support. Ill keep you updated.

[Fyndhal]

Ugh, I feel your pain. I get the "Too Many Formats" error at work now and again and it's a major hassle. For a while, I tried switching to Excel 2007, since it has a lot more format functionality (Sort by conditional formatting result.../swoon!) but the overall user interface annoyed too many of my users and we had to migrate back to Excel 2003.

Interesting side note on the Macro issue:
I use Excel 2000 at home. Version 9c of your spreadsheet gave me the macro error on opening it. Version 9b did not. This was a head scratcher, since the macros had not changed. Then I remembered that I had saved 9b after doing some editing at work (using excel 2003.) Apparently, saving the file in 2003 made the errors that were appearing in 2000 disappear. Interesting. Not helpful to folks who don't have access to multiple versions of excel, but still interesting.

[Tyro]

Could you change Allergy, Addiction, Prejudice etc. to be editable so we can specify what they're for/to? I like how you did that for certain Adept powers.

Issues I've found with 9c:

• Augmentations to the Reaction attribute don't appear to add up properly on the Cyberware_Bioware tab of 9c. I noticed it when using synaptic booster 3 with reaction enhancer 3; the total added to 3, not 6. I believe the RAI is to allow the two together, as the reaction enhancer does not add initiative passes and the move-by-wire system in Augmentation specifically allows reaction enhancers.
  
• Maneuvers aren't costing me any Karma, and when I put an x into the box beside the maneuver entry, said box turns yellow (and still doesn't cost karma).
  
• The Karma cost for the Martial Arts Positive Quality isn't adding to the total Positive Quality points tally in the top frame (where everything is added up).
  
• Exceptional Attribute is adding 2 to the max. for an attribute (I checked all of them) instead of 1. Lucky works fine.
  
• The auto-injector and extra dose capacity for same are missing from the Cyberparts enhancements dropdown.
  
• Armor entries below the third on the Gear tab don't show cost, armor amount, availability or mod limits properly, as they reference the D column instead of the C column.
  
• The Biometric Lock (in the "Commlinks Accessory" category of gear) has a listed cost of 0; that should be 150, as per Unwired 199. Fiberoptic cable should be (IMG:style_emoticons/default/nuyen.gif) 5/meter. There are a whole bunch of these; I suppose you're just in the middle of getting the new Gear page fully functional and I should leave you alone.
  
• Ruthenium Polymer Coating is missing from the Armor Mods list, as well as Gel Packs and Radiation Shielding. Arsenal 50. For Radiation Shielding, Auto-Injectors etc., we would need a way to enter Capacity-based armor mods.
  
• When I choose "Hardening R (1-6)" out of the "Electronics Options" category, the cells for both the category name (Electronics Options) and the item name (Hardening R 1-6) turn yellow with red text.
  
• A "Notes" section for Gear would be invaluable for things like "this SIN has my real biometrics" or "this skinlink is for this device".

I'm using Microsoft Office Excel 2003 11.8237.8221 SP3.

[Dwight]

And thanks again to Autarkis, Blakkie, Harri Tusa, and others who have created part of this or inspired my work. See the Main_Sheet for credits.

You are welcome.

Wow, nice to see folks still using this and growing it. Ensuring it runs on a variety of Netbooks? Very cool. Using macros runs straight-counter to my initial design goals but this is everyone's baby so I just hope it's doing what you all want and the macro use is worth the drawbacks that come with it.

[Marduc]

It seems a very nice sheet, a lot of options

But the sheet doesn't take the positive quality from cell W39 into the calculation of the total bp for positive qualities the martial art positive quality.

Also it doesn't seem to add the init passes from synaptic boosters to the main sheet

[Marduc]

The meta positive quality dermal deposits doesn't get added to the damage attribute of the body.
where the quality toughness is added.

also the specialty of the language/knowledge skills doesn't seem to be added to the total.

[Bobson]

Rather significant problem with martial arts, I just found out the hard way - easy fix, but important. The limits are one style advantage and two maneuvers per rank of the Martial Arts quality, not the other way around (which is how it is on the sheet). Arsenal p. 156 & 158.


Now I need to go redesign my character :/

[GreyBrother]

Found something.
The Type O Quality doesn't calculate into the Cyberparts Table.

[Dakka Dakka]

Found something.
The Type O Quality doesn't calculate into the Cyberparts Table.

That is absolutely correct. It's the cyberparts table. Type O System only works on non-cultured Bioware.

[Tyro]

That is absolutely correct. It's the cyberparts table. Type O System only works on non-cultured Bioware.

Actually, I'm pretty sure the RAI is that it works on cultured bioware as well. IIRC the RAW are a bit fuzzy on this point.

[Dakka Dakka]

I can only guess what the developpers intended but the wording is very clear. It is said that the essence loss of basic (as in not cultured) bioware is calculated as if it were delta ware.

[Tyro]

I can only guess what the developpers intended but the wording is very clear. It is said that the essence loss of basic (as in not cultured) bioware is calculated as if it were delta ware.

All right, granted, but by my understanding of how higher-grade bioware works (cultured is a clone of your tissues, but it isn't a perfect one; that's why you can get alpha/beta/deltaware cultured, as per the FAQ on the official site) and considering the extreme cost of the Quality (30 BP or 60 Karma), I would houserule it to work for all bioware.

[GreyBrother]

Whoops, sorry. I overread this part. Then nothing is wrong

[InfinityzeN]

I can only guess what the developpers intended but the wording is very clear. It is said that the essence loss of basic (as in not cultured) bioware is calculated as if it were delta ware.

Wrong... Cultured is not a grade of Bioware. The grades of Bioware are the same as Cyberware.

[Tyro]

Wrong... Cultured is not a grade of Bioware. The grades of Bioware are the same as Cyberware.

Oh, I see now facepalm

Basic doesn't mean non-cultured in this case, it means non-alpha or greater grade.

[Dreadlord]

The Karma Focus Bonding calculations on Magic tab Cell AD23 are not multiplying correctly. Apparently it has been that way for a while, since Beta7 at least, and still exists on Beta9c.

Counterspelling Foci should be Force * 3, it is showing as Force * 4.
Sustaining Foci should be Force * 2, it is showing as Force * 4.
Banishing Foci should be Force * 3, it is showing as Force * 4.
Binding Foci should be Force * 3, it is showing as Force * 4.
Power Foci should be Force * 8, it is showing as Force * 5.
Weapon Foci Reach 0 should be Force * 3, it is showing as Force * 5.
Weapon Foci Reach 1 should be Force * 4, it is showing as Force * 5.

Toodles!

[Warlordtheft]

Hey, just a question. Why is spanish not listed in the languages? It does not seem to be under a different name like Aztlanter Spanish, Cuban Spanish.

[Tyro]

Mutli-Fuel Engine is costing a flat 32k (IMG:style_emoticons/default/nuyen.gif) instead of the Body x 1,000 it's supposed to in version 9c (Arsenal 138, table at the bottom of the page).

Suncell is costing a flat 16k (IMG:style_emoticons/default/nuyen.gif) instead of Body x 500 (Arsenal 142).

The Anti-Theft System is costing a flat (IMG:style_emoticons/default/nuyen.gif) 6400 instead of Body x 200 (Arsenal 133).

Motorcycle Gyro Stabilization is costing a flat (IMG:style_emoticons/default/nuyen.gif) 9600 instead of Body x 300 (Arsenal 138).

[Dakka Dakka]

Wrong... Cultured is not a grade of Bioware. The grades of Bioware are the same as Cyberware.

This is correct but has no impact on the rules of the type o system quality.

Basic bioware is a type of bioware, just as headware or bodyware. So the rules say that the reduction applies to the items on the list for basic bioware (bbb p. 338 and augmentation p.171 f.) but not for items on the list for cultured bioware (bbb. p 339 and augmentation p. 172).

[yokyok]

Hi,

I just tested the sheet under the following environment :
OpenOffice 3.0
Ubuntu 8.0.4
Asus eeePC 901

And the sheet just crashes my OpenOffice, it happens at least with all beta 9x sheet.

By the way, if someone know how to get some log or trace from OpenOffice on ubuntu, it would help me find some more clue.

Yok

Hi I made some more testing on Ubuntu 8.10 and a standard PC (thought it's 3 years old) wich has 3 Go of RAM, I'll check if adding some more RAM to the eeePC makes it work or not.

[Tyro]

This is correct but has no impact on the rules of the type o system quality.

Basic bioware is a type of bioware, just as headware or bodyware. So the rules say that the reduction applies to the items on the list for basic bioware (bbb p. 338 and augmentation p.171 f.) but not for items on the list for cultured bioware (bbb. p 339 and augmentation p. 172).

I'm pretty sure they meant to say "standard", as in not alpha or greater.

[Draco18s]

I'm pretty sure they meant to say "standard", as in not alpha or greater.

Good luck ever figuring that out. I sent WizKids an email back in November about what happens to worn equipment when a drake (or shapshifter) changes forms. A flak jacket on a dragon (or not) makes a huge difference: If the armor is absorbed (as cyberware is mentioned as doing) then you end up with 4/4 Hardened armor (useless). If the armor is destroyed (as per the novels) then you're out a flack jacket and have 4/4 Hard armor. If it stays worn and provides its bonus, that's 14/12 armor: Hardened or not?

(All values assume the drake did not take (Mystic)Adept/Mage and does not have magically enhanced armor--my character is +2/+2 above the noted values)

I should also note that the Critter Power "Mystic Armor" and the Adept Power "Mystic Armor" don't do the same thing. C.P. is astral defense, A.P. is generic bonus armor that applies on both the physical and the astral.

[Tyro]

I would tell a player who wanted his drake to wear armor that he would have to create a unique magical item specifically designed to change form when he did.

Or just commission some drake barding and have your buddies put it on you after you transform (IMG:style_emoticons/default/smile.gif)