[X] My Assistant

[betterwatchit]

I've spotted some blank cost areas.

Biometric Lock costs 150
Commlink Self-Destruct costs 2,000 (Localised) or 10,000 (Area Effect)
Customised Interface costs 250
Cryptosense Module costs 1,000
Disposable Commlink costs 300
Optimisation costs 500
Simsense Accelerator costs 15,000

[InfinityzeN]

Surged Metagenic Trait still can't be assigned to an Attribute.

[DMFubar]

DK, I am getting an invalid file error when I click on the latest link to the file.

[DamienKnight]

The problem is that the sheet won't (tried it in 9h) allow you to turn it off. You have a checkbox for it, but the checkbox doesn't do anything.

It seems something broke the links between the checkbox controls and the TRUE/FALSE cells that drive the optional rules.

For now, open the sheet with macros DISABLED, and manually update the true/false cells on the Main_Sheet to control the Optional Rules.

I have fixed the controls in version 9i, along with revising some of the conditional formatting of skill columns based on Karma_Build_System switch.

DK, I am getting an invalid file error when I click on the latest link to the file.

The link is working for me. Try it again... Media Fire may have been having server problems. If you still cannot get the file, I can email it to you if you PM an addy to me.

[DMFubar]

The link is working for me. Try it again... Media Fire may have been having server problems. If you still cannot get the file, I can email it to you if you PM an addy to me.

Tried it again and it worked this time around. Thanks!

[Nigel]

Is the armor issue fixed in 9h? To clarify, I mean the one where you can't have more than 3 pieces of armor.

[Warlockco]

I noticed in 9g that the Positive Quality: Latent Dracomorphosis 5 BP (p 76 Runner's Companion) was not an option.
I have just downloaded 9h so haven't had a chance to check for it.

[Ovarwa]

Hi,

Has anyone tried this under OpenOffice? It crashes for me.

Anyway,

Ken

[killerdbz]

Yes the newest update crashes for me in open office. It will load but when I attempt to use a drop down or change a value it crashes.

[risingstar]

Went through the vehicle customization and noticed that a few things are missing. Most notable was the Winch.

[DamienKnight]

I've spotted some blank cost areas.

Biometric Lock costs 150
Commlink Self-Destruct costs 2,000 (Localised) or 10,000 (Area Effect)
Customised Interface costs 250
Cryptosense Module costs 1,000
Disposable Commlink costs 300
Optimisation costs 500
Simsense Accelerator costs 15,000

Thanks for the help betterwatchit. I added these costs to the Gear_Data page for version 9i.

Surged Metagenic Trait still can't be assigned to an Attribute.

Good point Infinity. After glancing at this I realized that this is a big deal, as its a really nice metagenetic quality that I bet alot of Surged characters choose. I changed this to having a distinct entry for each stat, and calculated it into the Attributes_Data page so it is reflected in the stat drop-downs.

Is the armor issue fixed in 9h? To clarify, I mean the one where you can't have more than 3 pieces of armor.

Yes.

I noticed in 9g that the Positive Quality: Latent Dracomorphosis 5 BP (p 76 Runner's Companion) was not an option.
I have just downloaded 9h so haven't had a chance to check for it.

I added this quality in, and gave it the Disable Clause of 'Is_Drake', meaning Drakes cannot add the quality. It will not create an error if you already have the quality after becoming a Drake, it will just not be selectable in the List for Drakes. Look for it in 9i.

Yes the newest update crashes for me in open office. It will load but when I attempt to use a drop down or change a value it crashes.

I was working on correcting this problem when I ran into the style issue. I am going back and finding the problems that are causing this. I believe it is related to using the 'INDIRECT' statement to generate data for the attribute drop downs. I had this problem before, but then it was caused by using forumulas in the Named Ranges Range definition, which OO sometimes hates.
Edit: Removed all INDIRECT statements from attribute list calculation and I was able to open and use the sheet in OO 3.0 without error (with Macros DISABLED).

Went through the vehicle customization and noticed that a few things are missing. Most notable was the Winch.

Added the Winch(Standard) and Winch(Enhanced).

Version 9i is coming along. Working on creating a good XSD to enabled exporting/importing data via XML.

[InfinityzeN]

9i is looking good then. I've been building characters in the 800 point thread and that version will be a big help.

[DamienKnight]

Version 9i is available.

http://www.mediafire.com/?yjc2onz1mmj

- Attribute dropdowns now work in Open Office
- Various fixes and additions.
- *Added integrated .xsd for exporting character data from Excel to .xml

I have created a custom .xsd that can be used by Microsoft Excel users for exporting data from the Main_Sheet into an .xml file, and in turn can be used to import the data back in. Look at the commented line above the LEGEND on the Main_Sheet for instructions.

This initial version only works with the data entry portions of the Main_Sheet. I would like the community to test the functionality and verify that the .xsd is working before I go through and create output for the rest of the sheet.

As far as I know, Open Office is not compatible with xsd/xpath for exporting spreadsheet data. If anyone knows a way to do this in Open Office, please share your knowledge with us.

But do not dispair my fellow opensource champions! I believe there is a way to create .xml data from OO spreadsheets:
As I understand it, Open Office .osd files are actually just zipped .xml files, so the best way to export cell data from open office is to write an xslt file, which basically can be used to filter/convert one .xml into another .xml format.

I will research this more and hope to include .xml output functionality in a future chargen release.

[DMFubar]

A minor error I have found in 9h and 9i. Several skills on the Active Skills drop-down are repeated. Climbing, Disguise, Ritual Spellcasting and Spellcasting all show up twice.

[cyberDrake]

If I enable macros it crashes excel. The following was done with macros disabled.

Surges don't give the free points of positive metagenetic qualities. (the number after the slash in the top section of the sheet is correct, but I cannot get the sheet to take from it instead of the general pool of qualities)

Also the Black market Pipelines do not seem to work properly

Knowledge skills do not seem to be accounted for in the top part correctly

Contacts seem to always be free, even with the house rule turned off.

[Stormdrake]

New version looks great. If you enter cyberware/bioware and hacking programs, the later appears on the character sheet but cyberware/bioware does not. Also, if you select a moderate amount of things from the gear list the character sheet runs out of room. Is there a way to increase the size of the boxes on the character sheet or decrease the size of the text?

[DamienKnight]

If I enable macros it crashes excel. The following was done with macros disabled.

What version of Excel are you using? I have tested the macros in Excel 2003 sp2

[cyberDrake]

What version of Excel are you using? I have tested the macros in Excel 2003 sp2

Excel 2003 Professional SP3

[crazyconscript]

The surge traits still aren't calculating properly, they keep taking out of general qualities. But metagenic improvement being specific is cool, thanks for putting that in!

[Misdemeanor]

this Sheet is Awsome...The only thing that I would like to see as of the 5 minutes i've looked at the sheet is that the negative quality indebt doesnt add its value to your Resources (IMG:style_emoticons/default/nuyen.gif)

[Draco18s]

this Sheet is Awsome...The only thing that I would like to see as of the 5 minutes i've looked at the sheet is that the negative quality indebt doesnt add its value to your Resources (IMG:style_emoticons/default/nuyen.gif)

That's because debt isn't resources. Your "remaining money" is Resources + Debt - Gear Costs.

[Bobson]

Ok, I'm back, after a few months of inactivity (the last version I used extensively was 9c). Here's what I've run into in the new version:

1. Excel issue on load - When I open it up in Excel 2007, I get an error about "labels in formulas" which are no longer supported, and will be replaced by cell references. It seems to work just fine after this, but it's a bit odd. I'm not sure what changed, but it seems like something that ought to be not to hard to fix.
2. Border lines - The lack of outer borders works just fine, and the internal separators do their job well. It doesn't look quite as clean, and I wouldn't miss seeing them return, but it's not bad as it is (except for the next point). I have no problem with the internal dividers going away permanently, but it'd be nice to have the outer borders back if it became feasible. There's a few exceptions to this: The Custom Ranged Weapons section NEEDS borders.
3. Background colors - The bright blue background color is very painful, and the first thing that grabbed my attention when I opened the new version (the blue contacts section) The green is good. I didn't even notice that skill groups no longer had their color changed until I did a side-by-side comparison (side note: The label saying it turns a darker green on Cell B20 is incorrect now). I like the idea of alternating the colors of columns of the same type to distinguish them. It makes the lack of vertical separators not noticeable.
4. Graying out of fields - This I miss. Especially on the cyberware page - if the piece of cyberware doesn't have ratings, it'd be much more convenient to keep the rating field grayed out instead of changing the color of the rating once I put it in (which is also much less noticeable).
5. Quality list
   • The negative quality list starts too early - Setea and Shiva arms show up at the top of the list.
   • It would be nice to have editable fields next to the box to type in specifics (such as what your signature or distinctive style is).
   • Books are showing up in the field which is supposed to be for Metagenetic Y/N (Column AV on the main page, G on the quality data page). This is breaking the metagenetic calculations.
   • Cell AS39 is blank
6. Magic - I really like the reworking of the magician screen (not new in this version, but I haven't really looked at it since it got revised. Shielding foci are missing. It also doesn't support buying extra power points with initiation.
7. Sheet tab colors - Very cool.
8. Gear - Armor is missing milspec armor (although it includes milspec only mods) and ballistic shields. Also, gel packs as a mod seem to be missing, and items put on subsequent rows with "( Mods )" don't count towards the mod limit of the parent armor. Let me know if you'd like me to mail you the data on milspec.
9. XML Export - I figured out how to export to Excel in 2007 (instructions here), and I have to say that I'm impressed. It worked just fine for me (except for attributes, which imported correctly, but were colored yellow until I retyped them), but I really like it. Congrats! (IMG:style_emoticons/default/biggrin.gif)

[Dumori]

Bobson a few of your errors are due to formatting space. As excel only allows so many cells of a certain type of formatting. 1 has been mentioned before (I believe its a personal preference of DamienKnight) The rest have not been covered before as far as I know.

[DMFubar]

That's because debt isn't resources. Your "remaining money" is Resources + Debt - Gear Costs.

I checked it myself today, and the debt did not add into the Remaining Money on version 9i.

[WhiteReaper]

on the gear sheet I7 to I11 is linked to D7 , D8 ... indeed of C7, ...
so impact armor of the clothes isn't shown