I'm using Excel 2000.

On tools, macros, security... set to medium to prompt you for macros...

Aha. That did it. Awesome. Thanks.

I had some problems:
1) when you select software for your vehicle, the availability becomes "#NV"
2) when I choose Armor I get a Script error (around "Set Gear_List_Range = ThisWorkbook.Names("Gear_List").RefersToRange")
3) when I choose Karma creation and "race is free", the race isn't free.

Its correct that vehicles operate their own firewall software.

It was my experience that any player that was purchasing software always got at least a 1 skill in software. This enables them to copy the software as many times as they like (p.228, SR4).

The test is an Extended Software (Piracy) + Logic test, interval 1 hour with 10 to 20 threshold. Even someone without the software skill could conceivably copy their firewall after a couple of days trying. Because software piracy is the standard, I setup the sheet to assume that all programs need only be purchased once. This is not only reflected in the firewall, but in all drones because you can purchase 10 copies of the same drone and just one copy of the software to make them all work (hence the mulitplier near vehicles, which muliplies base cost, excluding software costs).

If you want to go outside the norm and pay for multiple copies of software, simply make a note on the Gear section and apply the appropriate costs.

Scripts seem to be a problem for all those not using the newest excel. This should not be a big deal though.

Whenever you select your magic type (ie. Technomancer, adept, none, etc) it shows and hides sheets using a VB macro. You can manually show or hide sheets without using the script. In Excel it is under 'Format->Sheet->Unhide'.

Scripts do the following:

- Show hide sheets based on magic selection
- When new skills are chosen that are not in the list, user is prompted to add, if
they choose 'Yes' then it unhides the data sheet and moves to the area where the skills are listed. This also
works for all weapons, armor, spells, powers and wares.
- I setup some dice rolling macros. They are pretty basic, but offer Verbose and basic mode, and a Karma Mode
roll which rerolls 6's for extra successes. They have shortcuts defined, which can be seen at the bottom of the
Main_Sheet or by selecting 'Tools->Macro->Macros->' highlight macro then choose 'Options'.

There are alot of things missing (Metavarient infected, Martial Arts, Milspec(not sure what that is, but its not in there). This is a beta version and contains basic stuff that covers most players.

Because of the way that I setup custom races, I would have to create alot of data in order to add metavarient infected (basically because infected are setup as their own race, so I would have to have a new race for each metavarient infected combination).

I also dont have options for Drakes or Free Spirits. I will eventually add these in, but I am addressing obscure needs last.

Thanks to LordTorgo I have a more complete knowledge skill list (based on skills from contacts in all 4th edition books) and a few other fixes/changes. A new version will be available shortly.

Good catch. It seems that the code that added the extra 15 BP for rating 6 attributes was not coded to handle the karma raises. I will fix this in my next version


There is no easy way to do this in excel. I am going to have to write a macro to handle this perhaps. It is achievable manually using cell X13 and x14 on the Main_Sheet. Basically if you have a skill group and split it into its individual items you can add the difference of BP or Karma cost to those cells so they are subtracted from your total cost. For example, lets say you have Melee Combat Skill Group at 4, which costs 40 BP. You decide to break it apart, so you add 'Unarmed 4', 'Blades 4', and 'Clubs 4' to your list of skills, and remove the Melee Combat Skill group. Now this costs 4BP x 4 skill rating x 3 skills = 48 BP. You have now lost 8 BP. To get it back, just record '8' into cell X13.

I would like to do two things with this. Create a chart of what skills are in each skill group, and then have a macro that runs through your skills and finds any complete set of skills at their minimum level and subtract the difference in BP cost, up to rating 4. For example, if you never had any skill group, but you had Unarmed of 4, Blades of 3 and Clubs of 5, it would see that you had all three skills that are in the Melee Group, find the minimum, which is 3, then adjust your group savings by 6 BP.

To achieve this without any Macro, perhaps I could setup skill groups as a negative BP value, representing how much you save with the group, then you must select each skill from the group also. That sounds even hokier though... I think I will stick with this system and add a Macro to assist with it. I am open to suggestions though...

I just wanted to drop in and say how great this is, I haven't had a chance to really fiddle with it but from a cursory glance it looks powerful and well put together. I am looking forward to the finished release.

Thank you.

Update:

-Added Complete list of knowledge skills from Contacts in all SR4 books (thanks LordTorgo)

-Fixed BP cost on Karma raise stats to max.

-Added Martial Arts Styles, Advantages, and Manuevers. Add the quality and the martial arts section will appear on the Main Sheet below credits.

-Revised Infection to be separate from Race. Now any race can select any infection (though mismatches are highlighted, ie. Humans shouldn't be Banshees)

You can download the revised version HERE.

Next areas to tackle:

Add programs from Unwired.

Create option for creating an AI character.

Further down the road:

Add options for Drakes and Free Spirit characters.

Completely revise Skills to better facilitate Skill Groups ??

What if splitting a skill opened another workpage with all the skills/groups listed...

So for instance if I take a group at 4... then split it later... the other page shows up after I mark the skill as split and gives me each skill at 4... and then I can spend karma to increase? Since Knowledge skills don't have that... they could remain as is...

Drakes and Infected can be handled as qualities with compatibility checking rather than races as they stack with other race choices.

How about making the sheets less macro dependent for us Open Office users? You could replace the checkboxes with dropdown lists, for example. Right now in Open Office, because of the macros, we can't use the Karma Based Character system (requires macros to update the setting).

I just wanted to say how awesome this sheet is, and how much I appreciate your gift to the community. I know how much work this must have been and its easy to pick stuff apart, but man this is a quality tool. AFter having used this I went to work on a character with my group using paper and pencil, and was in shock of the difference. Anyway this is a great tool, and one of the best community offerings I have ever seen for a table top game. ROCK ON!!!

just a quick parallel update note. I've been tinkering with the doc in Open Office and I appear to have the Karma system working using drop downs. I took a look at OpenOffice.org Basic and ... O.O ... I'm not touching that terse pile of anti-copyright dancing for a bit. As I fiddle, I'll see what I can do for getting a sheet working for us Freeware advocates.

Viva la Revolucion!

Nice work - this looks really well thought out. Thanks!!

Here are a few things I found when tinkering with it:

There are a few problems form me not all the wear is in the sheet there needed to be more space on the cyber/bio page gene-mods need to be added as well. In karma gen you still get free knowledge skill points. Your race costs karma no-matter what. There is no ability to initiate. I think I might be better to make two sheets one for karma gen the other for BP.

Great work, just a minor nit pick


This is all the nano stuff, both nanoware and nano systems.

thanks for you work

Ignore, I seem unable to get things...

LordTorgo found a problem with skill costs in the Karma system (work fine if you have any points in BP then raise with Karma).

I will have an update out later this week that fixes this, but for those who cant wait, here is the corrected formula. Place it on the Main_Sheet in cell AM18 then copy it down through cell AM46.

=IF(E18>D18,IF(ISERROR(FIND("Group)",$A18)),VLOOKUP($E18,Complete_Karma_Math_Table,3,FALSE)-VLOOKUP(IF($D18="",0,$D18),Complete_Karma_Math_Table,3,FALSE),VLOOKUP($E18,Complete_Karma_Math_Table,6,FALSE)-IF($D18="",0,VLOOKUP($D18,Complete_Karma_Math_Table,6,FALSE))),0)

I did not realize the check boxes did not work with Open office. I may try and create some alternative later. For the mean time, the check boxes just set a cell to true or false, so if you manually set the cell the sheet should function.

Main_Sheet, Cell AM14 is for the Option Contacts Rule
Main_Sheet, Cell AM15 is for the Clout rule
Main_Sheet, Cell AM16 is for the Karma Build System
Main_Sheet, Cell AQ16 is for the Free Race option

My groups have found that the Karma Build System is vastly overpowered compared to the BP system, especially if you are starting with 750 or even 650 karma. That is why we decided to add in race costs.

Looking at it now it seems the Race/Infection costs are not calculating right. Ill make that a priority in my to-do list.

It was setup by Blakkie or Arturkis to allow you to have positive/negative qualities in the same area. This is so you can have more Positive if you like or more negative. The seperation is cosmetic.

Since the drop down lists are blank, when you click them it goes to the first blank spot on the list, which is before the Positive qualities.

Specializing Knowledge skills... we dont do that in our group, and I dont suggest you do either. Knowledge skills in SR4 are supposed to be more specific... Like Seattle Redmond Geography. There is no specialization for that, and if you can think of one, then it needs to be its own knowledge skill. As long as my group plays like that, I am unmotivated to change that on the sheet. As with copied software costs, I am setting the sheet up for what I think its the best way to do things. Its not meant to serve every need, just the most common ones.

I will look into adding 'Used' wares and check on skills from the other books. Does any one have a complete list of skill that are missing so that I can add them all at once?

Might want to add the specilization of Knowledge skills... as that's allowed in the BBB. 1 BP per specialization of a knowledge skill..

Think of it as Mafia Safehouses (Redmond Barrens).

You know the general location of Mafia Safehouses, but really know where they are in Redmond.

Moved to the appropriate forum.

How do you enter lifestyles so that it shows up on the character page right?

Haha, you dont. Sorry, it seems that is a part of the charsheet that came from Wizdoc by Harri T.

Currently lifestyle must be purchased on the gear section, and then is simply displayed in your gear list.

Does lifestyle warrant its own page. I see that is how it was done in other sheets, allowing you to break your lifestyle down into security/entertainment etc., and add edges and flaws to it. Personally I dont get too involved with lifestyles and keep it simple.

Right now I am leaning towards recording your lifestyle on the gear sheet (right below the gear list), then you actually list the duration and cost in the list, and it will display the lifestyle selected on the CharSheet. I am open to input on this.

You could use mine. No need to reinvent the wheel.
If it's too complicated just throw away the parts you don't need.

This looks really great. It's too bad I didn't know you were working on this or else we could have combined forces to work together on it. Something I noticed that you're missing is the Weapon Focus option in the Magic Worksheet. Also, if you have an item over the availability limit of 12, it should check to see if you have Restricted Gear before turning the cell yellow with red text.

You're welcome to use anything I input into the Collaborative Excel Project: Such as Mentor Spirits, Paths, the Lifestyles worksheet, etc.