The physad power point as magic mentioned above is an optional rule from Street magic or it's Errata I think. Basically for an adept heavy game where you want to play more power based you can just initiate and instead of metamagic gain a points worth of powers, but not the actual magic point, I personally would not touch it with a ten foot pole but a lot of adept lovin groups seem to like it. Probably best for a house rules button that adds it to the choice list.

I've got the same problems under Office 2007

So where is this legendary version 9 I hear whispers of???

Right here.


Version 9a is released.

- Attributes revised
- Martial arts corrected
- Misc Gear section added
- Other misc tweaks

Thank you, DK! Ever since I found your generator I use it exclusively...

Just thought you'd like to know (IMG:style_emoticons/default/smile.gif)

Cool, a new version! I just love this sheet (IMG:style_emoticons/default/smile.gif)

Sadly I still have the 'runtime error (1004)' problem every time I select a skill (for example). The debugger sends me to the line

Set Active_Skill_List_Range = ThisWorkbook.Names("Active_Skills_List").RefersToRange

For now I have to use your sheet without Macros (IMG:style_emoticons/default/ohplease.gif)

Ooo. I definitely like the new Gear section. Kudos, this is an awesome update, Damien.

Xerxos, I don't get that error. What are ya using to run the sheet? (Excel? OO? What version?)

Great Job DK, your generator is getting better and better!


The debugger doesn´t like taking formulas as input for .RefersToRange, the runtime error goes away if you link your skill list names to fixed ranges.

Office 2007

Great work on 9a DK, and I will repeat what was said earlier, this spreadsheet is the only one we use for character creation. As the GM, I find in invaluable for creating NPC's quickly and effortlessly. Thanks again for all the hard work.

Now, a minor error. On the skills dropdowns, Unarmed Combat is treated as a skill group rather than an actual skill. If you select it, you get a maximum of 4 skill levels, can not specialize, etc. Like I said a minor quibble.

Thanks again.

exellent work so far! thanks!

oki I will try to put the bugs I caught so you can fix them:)

in the hacking page, the Agent cost doest not add to the total cost

=SUM(I2:I5) agents are on I6.

Gear and weapon is soooo much better on this one! kudos!

would it be possible to make a 3rd character sheet with way more cyberware space?

Ill add them as I find them, hope it helps!

Hi all, I'm new to this forum so .. greetings all (and happy new year by the way)



I just get the same error since 8e using excel 2003 sp3 when looking for Active_Skill_List manually (Ctrl + T or Edition > Atteindre -- sorry my interface is french (IMG:style_emoticons/default/nyahnyah.gif) ), I just can't find it.

The names"Knowledge_Skills_List", "Active_Skills_List", "Language_Skills_List", and "Qualities_List" need to be set to fixed ranges.

Active_skills_ list ("=area.move(Misc_Data!$A$2;0;0;ANZAHL2(Misc_Data!$A:$A);1)" or something like that in English) needs to be defined as "=Misc_Data!$A$2:$A$91" for example.

@yokyok: Welcome! As for your problem, I would assume that your Misc_Data sheet is hidden? If yes, unhide it.

I'd appreciate a separate entry for characters who don't want the extra point of Ballistic armor (for encumbrance reasons).

The new Gear section is awesome. I'd love a freeze pane for just the very top part showing nuyen spent etc.

Biofabrics should cost 100; they're listed as costing 0.

Great work DK!
One thing I noticed, troll dermal armor seems to be missing? I could have missed it though.

Formerly the sheet was using a FIND formula to search for the '(Group)' text. I decided to put the 'ID' column to use instead, which seems less complex to me. It seems the Unarmed skill had a GS when it shouldve had an SK. Thanks for the tip Fubar, I have fixed this for the next update.


I have started defining named ranges more dynamically using OFFSET formulas. This allows users to add new data to lists without worrying about updating the ranges.

As far as I understand it, these names work in formulas, but in some spreadsheet programs they do not work in the macros. If anyone is able to work around this without removing the dynamic functionality let me know. So long as this problem only affects macros, it is not a big deal, since most of the macros are not important.

I am disabling some of the macros on the Main_Sheet. Since they only work for a few people now, and it seems the office 2003 SP3 is incompatible with them.

If you are thinking about installing the excel 2003 sp3 update, you may want to check this out first:

http://news.office-watch.com/t/n.aspx?a=657

Also, added cost to biofabrics, added 'Partial SecureTech Leg and Arm Casings' which are +0/+1. The price is 250 for partial. Remember you can access the Gear_Data page to add/modify armor for special circumstances.

The new Gear list needs to be massaged. Anyone feeling up to the task, just tweak the data where it doesnt match the book and send me the spreadsheet to include in the next update.

First up. The sheet rocks.

One thing i've noticed so far with 9a, when selecting Exceptional Attribute (Body) I still am unable to enter 7 in the attribute box.

Also i am wrong in assuming that if i have an exceptional attribute that the previous max that would have cost 25pts should now only cost 10pts?

eg with exceptional body a raiting of 6 should cost 50 pts? (human)?


Anyone have any suggestions?


Thanks again.

Quick question, Damien:

I just tried making a mystic adept with the sheet for the first time. I gave him Magic 5, Sorcery Group 4, and Picked 3 points devoted to sorcery/conjuring in the adept power dropdown. It's still showing maximum spells as 0, and it highlights yellow if I select manually. Is this something I need to keep track of manually?

Max spells is based on the spellcasting skill. I haven't looked at it, but I assume the "power" of sorcery/conjuring just represents magic points devoted to spellcasting, and no actual skill.

Heya

First of all this sheet is a real great work.

To me it seems that there is a bug with the nanohive.

Its essence cost is 0.5 plus (rating * 0.25). So it seems in the Wares-Table the values are in the wrong order. Sorry. My fault. It seems that the first column is always multiplied with the rating but the second is a fixed rating-independent value.
Second, if I put the nanohive in my char, each rating level cost 0.75 point, which is wrong. So mybe the corresponding formular needs to be corrected.

Your right. Corrected in 9b


It seems the formula on the Misc_Data page refered to with the range name 'Is_Spellcaster' was checking for 'Mystic_Adept' instead of 'Mystic Adept'. Corrected in 9b

The wares data page needs to be redone. It currently uses the old system, which has a 'x rating' column, with a code to determine how the availability, nuyen cost and essence cost should be multiplied. Its a neat system, but more complex that necesary. I would like to redo wares like I did Gear, and have a add and a multiply column for availability, nuyen, essence and capacity. I also want to assign a category to each item, then setup the wares page to work with categories similarly to Gear. I am going to hold off on that until version 9c or later.

I love this sheet thanks so much for your time and work

i found 2 things 1st as you can tell i'm a technomancer so that page is importent to me but it seems that not of the Karma i spend on that page is reflected on the main page. 2nd it looks like the stun track in the char sheet is based on logic instead of willpower.

i also have one little request when you have time. could you put something on the hacking and technomancer screen for program options. it would be cool if it is like the Spec columns of the active skills section where you would put the number of options the program has in either the BP column or the Karma Column.

again thanks so much for the great work you are doing.

Exeptional Sheet. Its all my group and I use. Thanks for all the hard work, keep it up.

I just downloaded the newest version, and I was having this same problem with 8f.

Enhanced Pheromone Receptors is missing from the Bioware drop down list.

As well, I can add in my Active Skills normally, up to line B49, and it adjusts my Build Points total accordingly, but from line B50 and down, I can add my skills to the sheet, but my Build Points are not affected.

If it matters, I am using Windows XP, and Office Excel 2003.

Thanks in advance.

Good catch! Both issues addressed in 9b.

Could you point me to the page in Unwired where I can review the rules for program options?

Thanks for the encouragement!

Good catch scribe! I adjusted the calculations for active and knowledge skills to extend to row 101 in version 9b. So glad to hear someone is getting use out of the extra skill slots!

If you would like me to add Enhanced Phermone Receptors, please give me the Book and page number.