[X] My Assistant

[SpellBinder]

To help make the spells bit a bit easier, right click on any of the sheets at the bottom and choose unhide. Select "Magic_Data" from the window that appears and click okay. You'll then have to find where the spells list and their details are. You can use Ctrl-F to help find if your spell is already in the list.

And to help so your custom spells show up, insert cells within the list to make room. Otherwise, if you just added them at the bottom of the list and do nothing else they won't show as they'll be out of the ranges the Magic sheet looks at; inserting a whole row can mess things up elsewhere. Otherwise you'll have to dig deeper into Excel to figure out how to expand those zones to fix it. If you're using Excel 2007 (what I've got) I can help there too to fix a range.

Also, a bit of advise, when you make custom changes make sure you save it under a new name. That way, if you really mess up you've got the original to restart from.

[Gamer6432]

Just a note for those of you who are type-A like me:

To fix the free knowledge point calculation, stick this formula in cell AD8 (the cell just to the left of where it tracks your free point usage)

CODE

=IF(Karma_Build_System,AW8,MAX(AV8-Free_Knowledge_BP,0))

That should tide you over until DamienKnight gives us Version L.

[Tyro]

Just a note for those of you who are type-A like me:

To fix the free knowledge point calculation, stick this formula in cell AD8 (the cell just to the left of where it tracks your free point usage)

CODE

=IF(Karma_Build_System,AW8,MAX(AV8-Free_Knowledge_BP,0))

That should tide you over until DamienKnight gives us Version L.

Many thanks, mi amigo!

[Mäx]

Well it does pull all of those spells from a hidden table so you could add that spell in there(i think there are intruction on how to acces those tables somewhere in the 15 pages)
But first sheck if the list allready includes a spell called frost, thats the name given in street magic for a singletarget cold spell, i would sheck my self but the generator currently crashes my home exel.

It didn't include it, but here's a version that includes all variant elemental effect spells from sidebar at page 168 of Street Magic.

I hope you dont mind Damienknight, just say and i remove it and feel free to include that added spell table to official version if you like.

[Gamer6432]

Also noticed, Eagle Shifters have Low-Light vision listed in their inherent qualities. According to the book, they should only have Enhanced Senses (Vision Enhancement(2), Vision Magnification).

[Mr. Mage]

Well it does pull all of those spells from a hidden table so you could add that spell in there(i think there are intruction on how to acces those tables somewhere in the 15 pages)
But first sheck if the list allready includes a spell called frost, thats the name given in street magic for a singletarget cold spell, i would sheck my self but the generator currently crashes my home exel.

I'll have to look, I couldn't find the spell originally but if its there then hopefully I'll find it

To help make the spells bit a bit easier, right click on any of the sheets at the bottom and choose unhide. Select "Magic_Data" from the window that appears and click okay. You'll then have to find where the spells list and their details are. You can use Ctrl-F to help find if your spell is already in the list.

And to help so your custom spells show up, insert cells within the list to make room. Otherwise, if you just added them at the bottom of the list and do nothing else they won't show as they'll be out of the ranges the Magic sheet looks at; inserting a whole row can mess things up elsewhere. Otherwise you'll have to dig deeper into Excel to figure out how to expand those zones to fix it. If you're using Excel 2007 (what I've got) I can help there too to fix a range.

Also, a bit of advise, when you make custom changes make sure you save it under a new name. That way, if you really mess up you've got the original to restart from.

I usually save it under the character's name and don't edit the original at all. And I'll have to play around to see if I can do my own spells

Thanks!

[SpellBinder]

I might do the same, depending on the character. However I find that more encompassing global changes are better put into a core blank sheet. I'm usually making that determination based on how many characters might use the change.

But it sounds like you're on a good step, so have fun (IMG:style_emoticons/default/smile.gif)

[Deadmannumberone]

Just a note for those of you who are type-A like me:

To fix the free knowledge point calculation, stick this formula in cell AD8 (the cell just to the left of where it tracks your free point usage)

CODE

=IF(Karma_Build_System,AW8,MAX(AV8-Free_Knowledge_BP,0))

That should tide you over until DamienKnight gives us Version L.

I'm using Open Office 3.2 and that just gives an "Err:508" in the cell.

[Gamer6432]

I use Office 2007. I'll D/L Open Office and play around with it.

Edit: Found the issue. Open Office doesn't like commas, it wants semicolons. Bloody syntax differences...

So for Open Office the input should be

CODE

=IF(Karma_Build_System;AW8;MAX(AV8-Free_Knowledge_BP;0))

[DamienKnight]

To help make the spells bit a bit easier, right click on any of the sheets at the bottom and choose unhide. Select "Magic_Data" from the window that appears and click okay. You'll then have to find where the spells list and their details are. You can use Ctrl-F to help find if your spell is already in the list.

And to help so your custom spells show up, insert cells within the list to make room. Otherwise, if you just added them at the bottom of the list and do nothing else they won't show as they'll be out of the ranges the Magic sheet looks at; inserting a whole row can mess things up elsewhere. Otherwise you'll have to dig deeper into Excel to figure out how to expand those zones to fix it. If you're using Excel 2007 (what I've got) I can help there too to fix a range.

Also, a bit of advise, when you make custom changes make sure you save it under a new name. That way, if you really mess up you've got the original to restart from.

Its appropriate that someone named 'Spellbinder' would so aptly explain how to 'Bind' new spells to your sheet (IMG:style_emoticons/default/smile.gif)

For your convenience, I have added some placeholders for spells.

There is a new [Element] Bolt, [Element] Blast and [Element] Wave available in version L. Fill it in with appropriate element name, or whatever you like. Effects are appropriately listed no matter the element type.

I may add in [Custom Spell] available at several different drain levels to the end of the list.

[crash2029]

I must admit, I am quite looking forward to version L. I really have to thank y'all for making such a great tool.

[toturi]

Can someone tell me where the innoculations are listed under?

[DamienKnight]

Can someone tell me where the innoculations are listed under?

Are you referring to Transgenic infusions? If so, they are under cyber/bioware. If you are referring to something else, please point me to which book/page number and I will see about adding it.

[Tyro]

Blood Fetishes aren't giving the discount for black market pipeline (magic).

Docwagon contracts per month should be 416 and 2/3 (IMG:style_emoticons/default/nuyen.gif) , not 5k (that's the one-year cost).

A notes section for contacts would be VERY useful.

[cndblank]

Great work.

I did have an idea.

It would be nice to have a notes section on the positive and negative qualities and some other places like contacts.Looks like I'll be able to get a sitter for Catan.

[toturi]

Are you referring to Transgenic infusions? If so, they are under cyber/bioware. If you are referring to something else, please point me to which book/page number and I will see about adding it.

Augmentation p135

I can't find them Pharmaceuticals. I think I haven't seen the Biomeds either.

[Gamer6432]

Are you planning to add a house rule option for Extra Races to be BPx1 for Karmagen? If not, I'd like to request it.

[Dumori]

It's in there look at the settings tab.

[Gamer6432]

Not for shapeshifters and the like. Those are Free or BPx2.

[Mäx]

It's in there look at the settings tab.

That option is only availebul to basic metahumans, all else only have free and the 2Xbd option.

[DamienKnight]

Are you planning to add a house rule option for Extra Races to be BPx1 for Karmagen? If not, I'd like to request it.

Added the option for extended races being x1 instead of x2. Also, it seems the Other Races FREE was not working properly. That is fixed now in version L.

Augmentation p135

I can't find them Pharmaceuticals. I think I haven't seen the Biomeds either.

Added this in to version L. Thanks for the page reference!

[Mäx]

Added the option for extended races being x1 instead of x2. Also, it seems the Other Races FREE was not working properly. That is fixed now in version L.

Thanks a ton, this makes this sheet massivly more usable, mostly the problem was meta-variants at least for me.
Well mostly the fact that there was no way to tell what was included in the basic races and what not and it took a while for me to notice why my build had less points left then it should have had. (IMG:style_emoticons/default/embarrassed.gif)

[Arz]

Been having trouble opening this file in the newest version. Unfortunately I lost my copy of the old ver that did work. Do you have back ver downloads available somewhere? Like to compare and find out what is going on. Pretty sure I skipped a few iterations.

Arz

[Gamer6432]

Added the option for extended races being x1 instead of x2. Also, it seems the Other Races FREE was not working properly. That is fixed now in version L.

Thank you (IMG:style_emoticons/default/biggrin.gif)

Also:
The Renraku Manservant-3 drone entry is missing the 'n' in Renraku.
The vehicle page does not increase the cost for upgrading signal or response of any vehicle drone not using the first box.

[DamienKnight]

Thank you (IMG:style_emoticons/default/biggrin.gif)

Also:
The Renraku Manservant-3 drone entry is missing the 'n' in Renraku.
The vehicle page does not increase the cost for upgrading signal or response of any vehicle drone not using the first box.

Indeed! Fixed in version L. Thanks for brining this to my attention.