Page 114 to 118.

And...



Augmentation, page 64.

Sorry to answer everybody else's stuff. I just happen to be sitting here with all the books around me working on a character.

Thanks Dues Innomen. I will add these last two things then release 9b tonight.

edit: Added 6 missing bioware items from p. 64 and 65. Adding program options will require a major revision to hacking, so it going to wait for another day.

Version 9b is now available.

I revised the 'Raise' column on attributes when not in Karma_Build_System mode. The drop down will now only display values greater than your BP base.

Added some missing wares, fixed several formulas.

Thank you very much DamienKnight. Sheet works great, and you have created an amazing player resource.

Kudos.

The Technomancer tab shows up when you first open a "virgin" copy of 9b. It goes away if you select anything but Technomancer (or "reselect" none).

Not exactly a big deal, but I just happened to notice ^_^

It appears that the Vehicle Modification Improved Economy (Arsenal Pg. 138) is missing from the drop down lists. Also the Standard Upgrades for many of the vehicles are not included in their descriptions in the White Box below the Other Notes section (Arsenal Pg. 106 Lists the Standard Upgrades for Vehicles from the SR4 Core Rule Book in a Sidebar and the Standard Upgrades for the New Vehicles are listed with their descriptions on Arsenel Pages 107 thru 123). These standard upgrades do not use up any of the Vehicle Upgrade Slots (Arsenal Pg. 131 Off-the-Rack Vehicles with Upgrades)

Finally when I select to add a Weapon Mount to the First Vehicle on the Vehicle Sheet it adds the Description of that Weapon Mount to the White Box description of all of the Vehicles below it and selecting a Weapon Mount for the Other Vehicles on that sheet do not add any description of the mount anywhere at all. The weapon mounts all seem to properly add to the Used Slots they are just failing to properly add their descriptions to the White Box area.

Thank you for all the Hard work on this great resource, keep up the good work.

GrimDarkKnight

Yep. If you have scripts enabled it hides sheets you dont need and reveals them only if you are going to need them. IE, only a technomancer needs to see a technomancer page, only a PhysAd, Mage or Magic Adept need to see the Magic page, and Technomancers dont need the hacking page.

All of the sheets are available as default so that those with Open Office who cannot run the vbscripts are able to see the pages without manually showing them.

Also a note, when you are in Developer mode (Ctrl+Shift+D) the show/hide script only reveals, but does not hide.

For those with excel who might want to edit the sheet, Developer mode shows the column labels, unprotects the sheets, and optionally unhides all of the data sheets. Ctrl+Shift+D to switch back to Production mode, which hides all data sheets, protects all non-data sheets, and hides column labels.


I will work to address the mounted weapon issue. The vehicles page could use a total revision but I am not ready for that.

As for missing items, please unhide the vehicles data page, see the fields I am using, and give me all the data I would need to enter, or optionally send me a corrected sheet that I can pull the data from. I am not very interested in alot of data entry at this point.

Does anyone know if it is possible for a spreadsheet to have both embedded vbscript and embedded OObasic scripts and work properly in both Excel and OO?

for some reason 9b crash over and over again for no reason (before I do anything when I start it up, after a click on a dragdow menue ect) got to go back to 9a.

I have win xp and I use Open Office 3.0

I just had a quick glance at Beta 9b, as with Beta 8 i still get a VB Runtime-Error 1004 something like "Unable to set the color property of the interior object" the exact message is: "Die Color-Eigenschaft des Interior-Objektes kann nicht festgelegt werden". I Use MS Office 97. Probably due to this error the checkboxes for the optional rules are missing, up to Beta 7 they worked. As with all versions i tested, setting the priting field in CharSheet does not work. Same error code different text. I have to do it manually.

Thanks for all the work you put into the sheet, DamienKnight. Keep it up.

That's the same error I'm getting with Office 2000. In my case, that error creates a green column of boxes that either say True or False where the toggles for the optional rules ought to be. The checkbox for the optional rules isn't gone; for some reason, it's all the way at the extreme right end of the sheet. Move your scroll bar all the way to the right and you should find it. It still seems to work just fine for me.

I've been playing with the gear section, and I noticed that in the B&E gear section, the Maglock Passkey, the Keycard Copier, and the Sequencer aren't available with adjustable ratings. Per page 327 of the BBB, they're available in rating 1-6. The Keycard copier has a flat availability of 8 and a cost of (rating x300), the passkey has an availability of (rating x3) and a cost of (rating x2000), and the sequencer has a availability of (rating x3) and a cost of (rating x200).

A suggestion for adding custom skills, this one for active skills. Note that the Active_Skills_List name isn´t used. Data input and alphabetical sorting are automatic.

One thing I think would make the sheet better is an easier way to buy ammo. Currently, you have to buy it in batches of 10, which is normal, but you have to select the items each time for each batch of 10. Maybe instead the number of groups of 10 could be put in the rating box and set ammo to be multiplied by the rating?

DamienKnight:
First off, THANK YOU for adding the gear selection. It makes my life MUCH easier.

Second: Cell AA6 on the Main_Sheet page seems to be adding the BP cost of Foci twice. In other words, if you have a Force 3 focus, it calculates the cost as 6 BP instead of only 3. Isolating this further, it only happens if you put the X into BP -- if you leave the X off, it charges the correct amount.

EDIT: This is in version 9b, btw.

I'm finally making another character, so more feedback:

• The Class I/II/III Surge qualities don't actually take any BP Cell A39 has no formula
• Cyberware compatability should be metagenetic, since it's really just a flavor of Biocompatability (from Augmentation, you can have it for bioware or cyberware, not both), and Biocompatability can be metagenetic - how this actually makes sense, I don't know, but it seems to be RAW.
• The freeze pane on the main page annoys me - the instructions for how to remove it are really nice to have. Thank you
• Customized limbs (+body, +agi, and +str) don't increase the availability of the limb as they should (Aug, 44) - maybe they should be a in separate area to the right of cyberlimb boxes specifically for these customizations and custom purposes (see next point)
• Optimized cyberlimbs (Aug, 45) don't seem to be anywhere on the cyberlimb page. In addition to the possible placement above, they could also just go into their respective arms/legs menus as pre-modified full obvious/synthetic choices (since you can only have one optimization and it's always a full limb)
• I really like the martial arts styles/maneuvers section. My one issue with it is that the advantages menu is too narrow to read the whole line that goes with it.

My internet is offline at home, possibly until Wednesday (CHARTER CABLE, YOU ARE THE BANE OF MY RECREATION TIME!)

Until then, no fixes. For those with macro issues, please disable macros. Go to your security settings and set it so that your excel prompts you whenever macros are in a sheet, then whenever opening the Character Generator when it asks if you want macros enabled, select 'No'.

Someday I may try to add something to the macros that checks to see what version of excel you are running and disables different parts of the macros appropriately. For now, the sheet works perfectly well without macros installed, so just use it without macros.

The control box is way to the right on purpose... so it is not in the way if you have macros disabled. With macros disabled the control box does not work (at least in excel 2003). Basically I distribute the sheet in a format that is compatible with Macro-Free users, then have MACROS that hide/move control options when the sheet is opened, and rehides it when the sheet is closed.

Thanks for all the feedback on 9b!

Odd. On the Gear page, cell B54 is missing the cost formula. Cells above and below it had the formula, however. It should be

Request for 9c: Add a "Count" column to gear, which defaults to 1. I went to buy 10 Stim Packs and had to add one ten times. Kinda messy.

Great improvements! A couple things I noticed though; if you select drake it does not subtract bp from total on main page and there does not seem to be any listing for libraries for mages outside the pocket one (rating1-3). Nitpicking on the library I know but I like playing mages.

Another minor nitpick - comments this time. The note for knowledge and language skills says that specialization isn't supported, but it now is

Also, the comment on cash remaining on the cyberparts screen is in a too-small box.

----

Just noticed that the skill group changes from the beta-7 series seem to have been lost along the way. I don't know if that was deliberate or not. I just noticed the spot for putting in an adjustment, so clearly it was deliberate.

Could you elaborate on this Bob? In version 9 I removed the 'FIND' and 'MATCH' forumlas that were detecting Group/non-group, and added a hidden column on the right that pulls in the 'GS' 'SK' code for the skill selected, then the hidden column is referred to for conditional formatting and forumlas. This change likely broke something else, or maybe I had versioning issues when updating. Either way, let me know what you want me to change.

Excellent suggestions. I will be sure to fix these all in 9c.

That is a nice suggestion, and good work with the code.

I am actually thinking about disabling the macros for entering custom skills. Because I am referring to the lists on the data page using formulas within Named Ranges, the named ranges cause errors when being used in macros in many versions of Excel (although Excel 2003 SP2 seems to be immune to the problems).

The code for adding in new skills was a neat idea at the time, but I never developed it further since not many can make use of it. I have resolved to only add in macros that are useful for development by me personally, since I have no guarantees anyone else will be able to use them.

In fact, I may remove all macros entirely except for the Dev mode macros, the dice rolling macros, and the control box macros. Sheet hiding is frivolous when weighed against the problems everyone is having with errors in newer/older versions of excel.

However! Perhaps your script would be handy just for me personally, since it would make adding new data simple. If I add alphabetic sorting to it, I could set it up for all different kinds of lists, such as gear. Perhaps if I can write a modular function, that reads in what your data validation refers to, then reads in headings from that range and prompts for data entry.... hmm. It should not take any sort of priority, but you are inspiring the code geek inside me...

Actually, I see what it's doing now. It changed from the "-X" notation it had before which is what I was expecting, but this makes a lot more sense.

Another issue: On the cyberparts screen, I don't think cyberskull values for stats should be averaged in with the others. I can't find any rules specifying whether it gets counted or not - the closest I can find is from SR4 (p. 335) "When a particular limb is ued for a test ... use the attribute for that limb (natural or cyber); in any other case, take the average value of all limbs involve din teh task (round down)." The way I read this, it's merely a bookkeeping convenience to actually note the modified attribute on your character sheet - the stat doesn't really change, but since most of what you do is whole-body, you're usually averaging all limbs. Following this logic, since your head's strength/agility is rarely involved in doing something, it probably shouldn't be included in the convenience averages for those stats.
Body, of course, you can make a case for. However, looking at the example provided on that page, Critical George has Body 3, with one Body 6 limb and one Body 5 limb. (6 torso+5 leg+3 arm + 3*2 natural leg&arm)/5 = 4, but if it was including the skull, it'd only be 3.88, and thus 3, not the listed 4.

Nicely researched, and a very logical supporting argument. I am convinced, and will update the cyberparts average attribute calculations in 9c. Can you even purchase strength upgrades on a head? I guess it would give you a nice headbutt attack!

Thanks, I´m glad if it is of some use to you. The code works for me, but I would be in the 2003 SP2 camp. Removing Name usage is rather easy, if that is the only hang-up. This minor code-geek wouldn´t know.

Yeah, that's what I figured. You *could* buy agility or strength or body for a cyberskull (it never says you can't), but they'd only be useful for headbutts, gore attacks if you have horns, and resisting headshots.

Personally, I'd rather just say that the only thing you can add to a cyberskull is armor. And that for averaging armor the skull does count. But I'm not sure that that's supported anywhere.

I am having trouble getting to the point of being able to download this. I am very intrigued and would like to give a once over. ANybody else having this issue?

Couple things,
When selecting a mage the 15 bp's are being counted towards the positive edge qualities limit. Is that right?
Also, under gear when selecting items with ranks the ranks are not transfering to the printable character sheet.

Yep. This is really important too, because it adds alot of balance to the game.
Good catch. Ill add this to my list of things to fix in 9c.

Mediafire has scheduled maintenance today and should be back online after 1pm CST.

If you cannot get the file from mediafire, PM me and I will do my best to help you.

That would explain it, I will try later this evening then. Thanks.

Many thanks for this project.

If a GM is working on a NPC, is there any way to bypass the edits?

Also for an on going campaign, some room for extra quantities would be nice.

Same goes for options on a cyberlimb.

Keep up the good work.

Unsure if this has been asked previously, but is there a way to inject extra cash at character creation? I'm trying to to a character rebuild with this new generator

Virtual Personality is missing from negative qualities (Unwired pg 38) and Drone Rack is missing as a standard modification on the Vehicle Sheet (pg 135 Arsenal).

The easiest way would be to increase your BP/karma allotment, and spend those points on ressources.

Or just ignore the errors

Three issues with gear/weapons I just came across. Only the first is a serious issue.

1) There's no way to specify accessories for weapons in any way linked to those weapons. You can do modifications on the weapon page, or buy accessories on the gear screen, but no way to specify which accessories go with which (and which of the top/barrel/underbarrel slots it takes up)
2) As a consequence of #1, if you select "Smartgun, internal" from the gear page, the cost box errors.
3) The recoil box for weapons displays it as (2)1 rather than the book's 1(2). This may be deliberate, but it's odd-looking.

the custom weapons screen needs more modifercation slots due to overmoding or the - slot mods you can have as i have run out of slots with only 4 slots actuality used up

Version 9b:
I don't know if this is because I had to disable macros because I am using Excel 2000 SP3, but there are #REF! errors in the formulas on tab CharSheet in cells P8 and P77. The cells should probably look like this:



Likewise, the neighboring cells in T8 and T77 also have broken #REF! formulas:



btw: DamienKnight, thanks for taking Blakkie's and Autarkis' "pretty kewl" sheet and making it AWESOME!

Those are present under 2003 SP2, too.

Delivery state, Charsheet P7, viewed with my Excel:

=D8+Cyberware_Bioware!$M$33+IF(IFERROR(MATCH("Toughness";Main_Sheet!#REF!;0));0;1)&" + Armor"

Result: IFERROR catches the #REF and returns error, always, and IF returns 0. Most people won´t notice, because Toughness is not a common favourite.


Manually corrected to

=D8+Cyberware_Bioware!$M$33+IF(IFERROR(MATCH("Toughness";Main_Sheet!W35:W49;0));0;1)&" + Armor"

it works as intended, because the constant #REF error is gone.

You are welcome, and thank you for the suggestions. I will be adding quantities to gear in version 9c.
Please elaborate on your question about bypassing the edits.
Not bad advice. Also, there is a field called 'Current Nuyen' on the Main Sheet which can be used to override the Nuyen Remaining field. After character creation is finished, try using the Current to override and track Nuyen yourself. I will mod 9c so that whenever there is a value in the 'Current' field, the remaining field will be hidden.
Smartlink via the Gear sheet is intended for purchasing the part separate from the weapon. Once it has been added to the weapon, the weapon should be moved to the Custom weapons area and the smartlink mod should be added
More slots is a good idea, I will look into it.

I believe this issue is addressed in 9c, as I am not seeing it on the 9c Charsheet.

In 9c I modified the Qualities_Data sheet so that there is a disable quality column. If the value in that column evaluates to true, the quality will not be displayed in the dropdown list on the Main Sheet. The sheet already hides qualities based on Infection/Metagenetic status. In the new column I put in formulas for both Thermographic Vision and Mentor Spirit. These are examples. I could use assistance identifying qualities with special conditions. If you notice a quality showing up in your dropdown that shouldnt be (ie, it is meant for mages only, and you are not a mage, or it is meant for Technomancers only and you are anot a technomancer, etc) then please post the name of the quality, and what conditions make the quality invalid.

Beta 9c is released!

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

- Fixed various bugs
- Added qualities filtering
- Added optional rule from SM p.31 for Adepts Selecting specific Geas per power (thanks for the suggestion Caadium!)
- Added some race summary data below qualities on Main_Sheet
- Added Quantity field on Gear page

You're on a roll!

All right lets try to get attention again:

9a was working perfectly with OO 3.0

9b and 9c crash as soon as I click on any drop down menu (exemple I click on human to change to elf, click on elf, the program freeze and bang crash)

Macro is disabled.

something was changed from 9a to 9b that Open Office doesnt like.

Is there a way to fix this please?

=D8+Cyberware_Bioware!$M$33+IF(IFERROR(MATCH("Toughness";Main_Sheet!#REF!;0));0;1)&" + Armor"

The issue persists in 9c/ 2003 SP2. If you want help finding the cause, I would need to see your original cell content, as I´m currently afraid that my Excel is holding some secrets from me.

The positive, non-metagenetic, non-infected qualities:

Macros should be more compatible now, as I have removed all data entry macros.

The optional rules check boxes are linked to the green true/false cells on the main page. If macros are disabled, the check boxes wont work and the green cells must be altered manually. If macros are enabled and working, they will hide the green cells and move the options control boxes over the area where the green cells appeared.

My recommendation is, if you have any trouble at all with macros, disable them and use the green true/false cells as switches instead. This is what all Open Office users must do, and because of the differences between 97, 2000, 2003 sp2, 2003 sp3, 2007... some excel users may need to disable macros.

This is a huge issue, and I am sorry that 9c did not fix it.

In order to determine what is causing the issue, I have created two test versions of the spreadsheet. If someone with Open Office could try both sheets (with macros disabled) and report back the results, it would be very helpful to me.

Test 1 (removed shapes, control boxes, all macros)
Edit: Still crashes OO on dropdown list

Test 2 (removed attribute formulas and attribute sheet)
Edit: Still crashes OO on dropdown list

I downloaded both test sheets and opened them in OpenOffice 3. Both test versions are still crashing when you click on a dropdown menu.

Thanks for testing that blind. I will keep looking into it.

Test 3
http://www.mediafire.com/?xjne9exu4xj

Using OO 3, the only failing dropdown I noticed was the Special selection (Magic_Type). Its validation was pointing to the named range 'Magic'.

I changed the range name to Magic_Type_List to conform with my Naming schema, and to remove the conflict with the Magic page. This fixed the problem for me.

Please examine this version and let me know if it is still crashing in OO for anyone. I recommend updating if you are using an old version.

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.