I knew there was something else i had noticed!

1-The tough as nails quality isnt adding extra physical boxes
2-In the first few rows of the gear sheet, the quantity box doesnt always work. Does nothing for ammunition, but works for SIN's. Havent tried everything in it.
3-Martial arts that add to damage values dont seem to calculate

Alright then (I haven't upgraded since...several versions ago, don't really have a need).

Found another slight hitch. In 9i, the "BP Rank" column for Knowledge skills (Q21:Q101) is in "Text" format instead of "Number" format, basically preventing the BP counter from making the sum of all of them. Using Excel 2007.

In MS Office 2007 SP1 9i produces a runtime error 1004 as soon as I activate the macros. On a first glance most things seem to work though. The checkboxes for the houserules are way off to the right. The the menu so set the true or false values is a nice toch though.

BTW the sheet is coming along nicely, keep up the good work.
I like the new design ithout the borders.

Is there a way to change the recource to 4000 per BP ?

and it doesn't count the Knowledge point nor the connetions BP,
and the macro cause an error, using Excle 2003

You get free knowledge + language skill points equal to your logic+intuition, this is in the BBB. There is also an optional rule that is usually enabled that gives you free contact points equal to charisma x2. You just need to disable this on the main sheet page.

-Lightning reflexes quality is not adding to reaction at all (should work if no other reaction modifiers present)
-Dracoform attributes for the Sea Drake are adding +2 to agility instead of strength

Using Excel 2000....

What he means is that points spent in knowledge and contacts are *not* counted... at all. This is because the cells for Knowledge skills and Contact attributes are, by default, set to "Text Input" format. Thus, the formula in the BP calculator fails to make the result sum of those cells (since it can't sum up letters with letters, and 2007 refuses to automatically-convert text cells that contain numbers for the purposes of such transformations), and they end up as "free".

The workaround for contacts is to use the drop-down menus for their Loyalty and Connections instead of manually typing a number. The only solution for knowledge is to unprotect the sheet, select all the pertinent cells, and change their format from "Text" to "Number", then re-enter the numbers. Once you've done that with your baseline template sheet, it should be fixed for any and all future edits.

Do not forget to set the decimal to 0 digits. It'll make the numbers visible that way.

I mean that the cells AA8 for knowlegde skills and the Cell AA12 for Contacs keep showing 0

oops, didnt notice that error as i use the drop downs for contacts and hadnt checked knowledges yet. Sorry about that.

Your sig links to the newest version (9i), but the OP still links to 9g.

[Edit:] the Nanohive is taking up 2 capacity PER RATING instead of a flat 2. Unless it was changed in SR4A, it should cost 2 Capacity, period.

Im having issue Even DL this. It tells me that My Username and PW are invalid am I clicking the Wrong DL Button

Fixed.
Fixed.
Fixed.

Also, added a large list of Qualities validation from a list Bobson PMed me.

9j is coming along. Any suggestions on what we should name the 1.0 release of this spreadsheet?

When I choose a language (Or'zet in this case, from the dropdown) and enter a number, the Knowledge/Language tally changes to #N/A, as does the total tally (obviously).

9i, Excel 2003 SP3

9i also crashes for me in the latest version of Open Office (trying to get around my crash issue with it in excel...)

I just noticed the "custom items" part of the Gear section. THANK YOU!!!

[Edit:] Anti-Theft System is costing a flat 6400 instead of (Body*200)

[Edit 2:] I would LOVE a "Notes" section for advanced Lifestyles (and for weapons, and vehicles, and armor, for that matter

[Edit 3:] "Vision Enhancement" is misspelled "Vision Enhancment" on the dropdown on the cyberparts screen.

I opened it in Open Office 3.0 without any problems. Did you disable macros?

So far very kewl, I'd like to see program options I happened to add them to the old sheet last night. Add in looking for some help today I found this one. Looks good.

Thanks,
Brent

Don't I need macros in order for the sheet to work? I will try again with macros disabled in a couple of hours.

{edit}
just checked, and even with macros disabled, as soon as I select Night One as my race, it crashes.
{/edit}

{re edit}
ok, something must be up with that computer. Tried it on another, and it opened just fine...

One thing I did find was if I select SURGE III I am supposed to be able to take 30BP worth of positive MG qualities, and 15 worth of negative. It just adds the MG to the total qualities, so I end with 60 BP worth of +qualities.

still adding to this post to avoid double posting...

Create a bear shapeshifter with metagenetic improved body, and exceptional attribute body, gives him a body of 15, max this out. make him an adept, magic of 6, and the adept power of improved physical attribute body (>max) of 3. look at the char sheet. damage overflow shows Err:502

born rich and in debt do not seem to function correctly
{/re edit}

I've found another small problem: the BBB shotguns are missing.
Thanks for the great work, DamienKnight.
(Is it possible to add, as I requested a bit before, a tickable box which would make some piece of cyberware part of a cybersuite? It would just add a 10% decrease in essence cost and nuyen cost, and some GMs might have a use for that).

Seconded! (And don't forget cyberlimbs if you do add it! - and the fact that individual upgrades need to have boxes too, since some might come with the suite and therefore be cheaper, and some might be added on later)

You can edit the values in the Misc_Data page in the Nuyen column.

In excel 2003 to unhide a page goto 'Format->Sheet->Unhide' then select Misc_Data from the list.
Can cyberlimb components be part of a suite? Does the book specify? If not, what is the community consensus?

There is something wrong with Knowledge skills when using the Karma generation system. I get N/A for total cost.

As far as I can tell, spells bought with Karma are not calculated in if the character does not use his maximum allotment during BP-Charactergeneration. Maybe you could include a switch like with contacts/specializations.

I don't know if this is planned be implemented but so far it is impossible to remove standard upgrades from vehicles and weapons and free up mod slots

There is nothing stated about this matter in Augmentation, but the provided examples of cybersuites show cybereyes upgrades, so it's a silent nod.

You cant remove standard upgrades from vehicles/weapons, and since they dont take up any mod slots to begin with-being built into the item at the factory- why would you?

I just quickly checked version i, it seems in open office you the drop down menu/input in general for magic of resonance isn't working properly.

This may be due to the version of open office I'm using, I will update and see if that fixes the problem

Im having issues with using the program with OpenOffice. Any dropdown I select in any tab after the Cyberparts tab crashes the file 100% of the time. In the other tabs, about 40% of the time it crashes when I try to select something. I've updated OpenOffice to the latest version, tried opening it with macros enabled AND disabled but no change.

Version 9j is here.

- Addressed many issues pointed out in this forum
- Added some missing items (sm foci, core shotguns, etc)
- Added many Qualities disabling formulas (thanks for the input on that Bobson!)
- Added cybersuite column in cyberware-bioware
> Enter any name in Suite column next to wares
> All wares will be displayed in CharSheet organized by Suite if available
> Not yet available for Cyberparts
- Finished character saving feature for Excel
> Tested in excel 2003 and 2007. Use the Beta9 schema to export your character to .xml
> Can re-import data to restore character *check for numbers as Text after importing
> No save feature for Open Office yet (it is not .xsd+xpath compatible like excel)
- Implemented small test of SRSchema_v4 for exporting character to community xml standard
> Used data arranged in hidden sheet xmlExport
> Only saves character name and primary attributes. Proof-of-concept only
> Not compatible with Import (dont even try it!)

Enjoy!

btw, there are still some missing features I am aware of: Milspec armor, Martial Arts DV bonus not on CharSheet, Cybersuites not available for Cyberparts, No Free Spirit Support

I am very interested in hearing input about any missing options for AI characters. Also, still hoping for suggestions on new name for the spreadsheet. Its almost time for 1.0!

*edit: Ignore the comment in the sheet saying that only the main sheet is saved. The entire sheet is saved now if you are using the Beta9 schema.

V 9J is great and its far more stable but Im still having crashing issues. Its far less common and its now random, but it is still crashing.

These crashes are in which suite? By the above post I am assuming OpenOffice.

This is not limited to after market modifications. So An Ares Alpha with the grenade launcher removed should have 6+3 slots and a Imgram Smartgun whose Gas Vent 2 ist replaced by a Gas Vent 3 should still have 5 remaining slots.

Factory standards are not 'modifications'. Ignore above, carry on.

I was able to run it in 3.0 and use various drop downs without having it crash. I did not create a full character, and it is possible the crash issues only manifest after a certain amount of usage. Can you pinpoint a specific action you were taking when the sheet crashed? Can you observe any patterns in the instability, such as 'after the main sheet is completed and I move on to Magic', or 'when I add cyberparts' etc.

There are ALOT of formulas for the spreadsheet to check/refresh as values change. Excel does a much better job of refreshing large numbers of formulas in the background. I know it would really make the sheet next to worthless, but you might try turning off the auto-refresh in open office and see if it makes it more stable. If it still crashes the same, at least we could elimate OO refresh as the culprit.

I agree with Infinity. The factory mods are what makes a gun unique. If you do not like them, pick a different gun! Remember, you can always use the weapon bases at the bottom of the ranged weapons list if you want to create your gun from scratch.

OpenOffice, latest version.

Before 9J any tab usage after the Cyberparts tab would crash the program. Now its seemingly random, the last crash happened when I was adding Black Market Pipeline - Electronics. Ill play with it some more and see if a patern emerges

The crashes seem to be random. I built two characters and I dont see any pattern with the crashing. It happens far less than it used to.

-I notice when trying to select a Power level for Adept powers it tells me I need to select a number that's between one and my magic rating. Well my Magic rating is 4 and Im punching in 2 and it gives me the same message. Im trying to up the Analytics skill which DOES have multiple levels.

-Entering a Quantity in the Gear section results in an Invalid Value message

-NOTES in the Gear section is a Protected Cell and cannot be modified

-The costs for a lot of the gear disappears and there is an error swatch when entering a Rating for certain gear

-Lifestyles have no cost

-Inputting Pilot or Sensor or other similar information about a vehicle causes an Invalid Value message

-Inputting a rating for vehicle mods causes Invalid Value message

Great work, DK! I wish I could give more than complaints and moral support

While I like this approach, it is not RAW. AFAIK there is no way to create items from scratch. BTW how did you come up with the stats for the different weapons? The existing guns vary widely enough in many of the categories that I think your values are pretty arbitrary.
But enough of this here, I opened a new thread there.

I did not get the Value error when adding quantities in Excel. Any clues why the formula would evaluate to an error in OO? Is this only happening with a specific piece of gear?

The Notes in the custom section were not locked, but the rest on Gear were. For the selectable columns these were placeholders for if I decided to add notes to the data table for selectable items. Since that has not been implmented, I will change the color of the notes to input blue/purple and unlock them.

Some gear does not have costs, or their cost is based on variable codes I have not yet programmed into the cost calculation on the right side (hidden cells) of the data page. If there is a specific piece of gear on the data page that is missing a cost and you would like to use it, please post the Item name and Cost (or other missing data) and I will get these updated in the next version. Also, you have the option of updating the Gear_Data page in your own sheet, or manually specifying item details in the custom gear section at the bottom of Gear.

Lifestyles DO have costs, but you must select a length in order for the cost to show up. Ie. get a middle lifestyle for 5k will show 0 cost, but add 2 months to the Months column and it will show 10,000 cost.

This is the same for simple lifestyles in the Gear page, and for advanced lifestyles in the Lifestyles page.

I did notice that the final cost was calculating off of Months remaining, which is silly. Fixed that for the next version. Also I saw that the third lifestyle on the Lifestyles page was not calculating into Total Nuyen Remaining. Fixed.

The problems with ratings on Vehicle Mods has to do with importing text from .xml

Right now whenever you export a character to .xml using the beta9 schema, when you re-import them back into the spreadsheet it inserts numbers as Text. This has to be manually corrected. Still better than re-entering the entire character with every release...

So it seems when I was testing Import, I had some cells mussed with. I have corrected them and will release a new version soon. Until then, just select the cell you are having trouble with and change its format to Number instead of Text.

it's getting there, I'd like to see cyberparts have a suite box too, plus program options. I've added program options to the old sheet already if you'd like to see it. it's here.

haven't played with it much yet, but I really like what I see. Well done!

I am suffering a PBC&K board or 1D10T error.

using Excel 2007.

When I try to enter a Level for any Adept Power, I keep getting an error
"You must choose a value between 1 and your Magic rating, inclusive, or leave this blank for Powers that do not have multiple levels"

I am sure this is user error, any help appreciated.

It seems to happen with any piece of gear although I only tried it with gear that had a rating.

Sorry to complain so much Its a fantastic generator

The Adept Power "Power Throw" (SR p. 179) does not influence the ranges of melee-weapons.

I've got an Adept with Strength 7 and Powerthrow 2. So the strengths for reach and damage of weapons is to low, because the Strength with the Power is 11 instead of 7.

Could you check this?

For some odd reason now, the generator is crashing like mad. I used it yesterday and it was working very well but now its crashing like mad again.

When I first start it up, ANYTHING I set (about 90% of the time) will crash it.

Factory-installed features do not take up any of the items available modification slots, & thus do not give any back if you remove them. Removing them, however, should be possible.

I might be missing something, but I can't type in specializations for weapon skills - I have to select from the drop-down list of skills.

I have a similar problem with languages - I can't select "Spanish" from the list. I find this curious, as I am able to select Malayalam, a language spoken almost exclusively in the somewhat backward Kerala province of India - only about 3% of the population of a single country.

Also, the "rating" box for cyberware/bioware turns yellow regardless of what number is entered into it.

I'm running the spreadsheet through Gnumeric under Linux. (OpenOffice Spreadsheet wouldn't display it properly for some reason.)

Otherwise, this thing is just awesome.

For some reason now its failing 100% of the time when I use or do ANYTHING.

I can input one value or select one option from a drop-down, I get the hourglass next to the mouse pointer for about three seconds, then I get the full hourglass, then it crashes. I can restore it and what I selected is there but I have to repeat this to enter anything else.

Specializations for weapons... try clicking the cell and typing in the name. That works in excel and Open Office. If Gnumeric does not allow manual entry in optional data validation cells, then you should try disabling data validation on the cell you are attempting to use as a specialization. I will not be removing the drop down skill list from the sheet to accommodate Gnumeric's lackings.

36+ million people across Singapore, Malaysia, the Persian Gulf and Kerala speak Malayalam. Kerala has a 96% literacy rate... I would hardly call it backwards. I added languages from a list of the worlds more commonly spoken languages. It seems 'Spanish' was replaced when that list was entered.

A simple "Languages - Add Spanish" would suffice next time.

The rating box for cyberware/bioware works fine in Excel. You are only supposed to enter ratings for items that expressly allow ratings (usually have a (1-3) or (1-6) type of suffix).

This problem has to do with the errors from testing xml import. The rating column was set to 'TEXT' by excel when I imported from the .xml file in testing. I saved the changes without realizing all of the changes it has made. Simply format the rating column to be 'Number' and the problem should not persist. This will be fixed in the next version.