Shadowrun

Shadowrun Play => Character creation and critique => Topic started by: Aria on <08-29-19/1234:55>

Title: [6E] Excel Character Generator
Post by: Aria on <08-29-19/1234:55>
Hi folks...

I've 'rushed out' an update for Firing Squad for those that want to use the generator and have the book with stats etc.  Some of the population of the character sheet tabs might be a bit wonky and I will iron that out in the next release shortly.

<CG6.03> (https://drive.google.com/file/d/1_zJtPzM-9WbdH90wFk-FfiVDgD4H1IVM/view?usp=sharing)

As ever, please let me know if you spot any problems

A

***

Following the errata (and Adversary) here's version .02 of the generator.  I'm pretty sure I've picked up all the changes but if anyone spots any errors please shout!

<<CG6.02>> (https://drive.google.com/open?id=1P_7pkcD6qZSrg_2hrZF41BDv7SjWi9xw)

I'll keep version 1 live for now in case people want a pre errata version  :o


Ok, I think I've ironed out the glitches and filled in all the notes sections so ready to call this the 'final' version of 6.01 (subject to anyone else finding mistakes of course)

To keep it clean it has a new link: <<CG6.01 Final>> (https://drive.google.com/open?id=1Rf_qpUryq3d-C3d0byH-qt5Fq-GLmSNh)

Enjoy!


***

Ok folks, this is very much a work in progress based on the similar SR5 character generator that I built (with lots of help).  Iím putting it up here as a draft so that people can start to make use of it (it should calculate all the stats and allow you to buy gear etc), although it needs much tidying up, rules summaries, spells and CFs etc all adding to it.

Any comments / errors etc, please shout, I will continue to polish it off and get a more finished version up soon!

You should be able to download the file from this linkÖ

<< CG6.01 DRAFT >> (https://drive.google.com/open?id=1HgUQPBL9C4PuZbDv7Kc9F_jvt11hQ25p)

It makes a few assumptions and Iím trying to pick up errata that I see, eg Adepts losing a point of powers when their magic is reduced as previous editions, that can be knocked out if needed (or left in as a house rule perhaps)

Title: Re: [6E] Excel Character Generator
Post by: markelphoenix on <08-29-19/2128:17>
Ok folks, this is very much a work in progress based on the similar SR5 character generator that I built (with lots of help).  Iím putting it up here as a draft so that people can start to make use of it (it should calculate all the stats and allow you to buy gear etc), although it needs much tidying up, rules summaries, spells and CFs etc all adding to it.

Any comments / errors etc, please shout, I will continue to polish it off and get a more finished version up soon!

You should be able to download the file from this linkÖ

<< CG6.01 DRAFT >> (https://drive.google.com/open?id=1HgUQPBL9C4PuZbDv7Kc9F_jvt11hQ25p)

It makes a few assumptions and Iím trying to pick up errata that I see, eg Adepts losing a point of powers when their magic is reduced as previous editions, that can be knocked out if needed (or left in as a house rule perhaps)

This is a life saver. Will be using this to gen my players characters for them this following weekend. Will help simplify the book keeping for this. Ultimately waiting for HeroLabs Online, but this is a great help until then.
Title: Re: [6E] Excel Character Generator
Post by: Aria on <08-30-19/0410:03>
Glad itíll be useful! Just a quick note, the pre-genned equipment lists on the equip summary tab are all still SR5 (why I greyed them out) so as a suggestion only... will probably work on those next as I find them useful for generating NPCs :)
Title: Re: [6E] Excel Character Generator
Post by: markelphoenix on <08-30-19/1908:01>
Glad itíll be useful! Just a quick note, the pre-genned equipment lists on the equip summary tab are all still SR5 (why I greyed them out) so as a suggestion only... will probably work on those next as I find them useful for generating NPCs :)

Yeah, already suggested to a potentially player to ignore the gear select portion and just use the nuyen resources and then reference the book for gear.
Title: Re: [6E] Excel Character Generator
Post by: markelphoenix on <08-31-19/1847:33>
Just made another char using this. Made it so easy on me. Thank you.

FYI, slight bug. Exotic Weapons Skips on the main Sheet tab, so it throws off everything after Exotic Weapons by one under the specialization column. For example, go to Skills (Tab 3), do 1 in Specialization under Sorcery, put the text Spellcasting in the specialization description on that tab, switch to the Sheet tab and look at skills.
Title: Re: [6E] Excel Character Generator
Post by: Aria on <09-02-19/0425:37>
Thanks, Iíll sort that out ASAP

Edit: Iíve updated the version on the link with the correction and some of the pre-genned equipment lists are now in 6... Iíve hidden the ones that are still 5 to avoid any confusion!
Title: Re: [6E] Excel Character Generator
Post by: markelphoenix on <09-02-19/1103:49>
Thanks, Iíll sort that out ASAP

Edit: Iíve updated the version on the link with the correction and some of the pre-genned equipment lists are now in 6... Iíve hidden the ones that are still 5 to avoid any confusion!

Awesome contributions, Aria. I will let you know if I spot anything else! Thank you again for your modifications!
Title: Re: [6E] Excel Character Generator
Post by: Aria on <09-02-19/1252:42>
On a roll today and Iíve already uploaded another draft...(realised Iíd managed to miss off exceptional attribute somehow)

Link should be the same!
Title: Re: [6E] Excel Character Generator
Post by: markelphoenix on <09-02-19/1324:31>
Another bug. On Qualities page, the formula for counting the # of Qualities taken should be =SUM(C11:C123), to capture Positive Qualities as well.
Title: Re: [6E] Excel Character Generator
Post by: Aria on <09-03-19/1125:03>
Starting to feel like an overly optimistic first draft lol

Thanks for all the help snagging this, Iíve credited those helping on the sheet!

Should have a much improved version up in a couple of hours - not the finished beast but it has a load more detail in it
Title: Re: [6E] Excel Character Generator
Post by: markelphoenix on <09-03-19/1949:00>
Starting to feel like an overly optimistic first draft lol

Thanks for all the help snagging this, Iíve credited those helping on the sheet!

Should have a much improved version up in a couple of hours - not the finished beast but it has a load more detail in it

All your effort is appreciated. Been sharing this with my group and on forums when I can!
Title: Re: [6E] Excel Character Generator
Post by: AJCarrington on <09-04-19/1252:41>
This is great work! I'm struggling a little to parse exactly how to fill it out...but that's part of the fun ;)
Title: Re: [6E] Excel Character Generator
Post by: Aria on <09-04-19/1315:19>
There are some instructions of sorts on the priorities tab, can try and make them clearer...?!
Title: Re: [6E] Excel Character Generator
Post by: markelphoenix on <09-04-19/1704:56>
look at priority columns from left to right. a 1 in the row of that column maps to the priority level.
Title: Re: [6E] Excel Character Generator
Post by: AJCarrington on <09-04-19/2359:02>
Thanks guys...figuring it out...just required a little more brainpower than Iím used to. ;D
Title: Re: [6E] Excel Character Generator
Post by: Aria on <09-05-19/0750:04>
Few more tweaks to the file, I've tried to make the priority table a bit more obvious... let me know if that helps!  Link in the first post still the same

A
Title: Re: [6E] Excel Character Generator
Post by: Arky on <09-05-19/0900:06>
I went ahead and joined the forum to make communication easier, as emails can get a little bogged down after a while. This will be easier on Aria, but more of a pain on me because of the anti spam with (I'm assuming) new accounts. Lol~

There's a typo on the contacts tab, A-4. hse, instead of use.
Adept tab, A-4. Mysad?
Title: Re: [6E] Excel Character Generator
Post by: Michael Chandra on <09-05-19/0913:35>
After a few posts it goes away. Unless you're AI.
Title: Re: [6E] Excel Character Generator
Post by: Arky on <09-05-19/1006:39>
After a few posts it goes away. Unless you're AI.

I thought as much, good to know. Other than the things I emailed, the only things I've noticed since are a few typo's, but that's it. I will have more time to play with it today once I'm home from Lexington.
Title: Re: [6E] Excel Character Generator
Post by: Aria on <09-05-19/1048:27>
The hse was actually an abbreviated version of house... as in house rule, will make it clearer next time round! In fact I might put it on the first tab with a series of other house rules that can be switched on or off!!
Title: Re: [6E] Excel Character Generator
Post by: skalchemist on <09-05-19/1157:36>
I really appreciate your work on this.

Just to be clear, the link on the first page always links to the most recent version, right?
Title: Re: [6E] Excel Character Generator
Post by: Aria on <09-05-19/1239:35>
It should do for all of 6.01 until I issue the 'final' version... I tend to add a new link when I issue version .02 but that is likely to be when there's a significant errata release or a new book to add in that didn't make it in to 6.01

EDIT: I try and keep the opening post updated with any new links and I've amended my sig now with the link too so should always be easy enough to find
Title: Re: [6E] Excel Character Generator
Post by: skalchemist on <09-05-19/1246:38>
It should do for all of 6.01 until I issue the 'final' version... I tend to add a new link when I issue version .02 but that is likely to be when there's a significant errata release or a new book to add in that didn't make it in to 6.01
That's good.

Possible errata: I can't find Rigger Command Consoles (table pg 197).
Title: Re: [6E] Excel Character Generator
Post by: Aria on <09-05-19/1313:29>
Oops! They arenít in the equipment section so I missed them, will get them on tomorrow!
Title: Re: [6E] Excel Character Generator
Post by: Arky on <09-05-19/2006:06>
The hse was actually an abbreviated version of house... as in house rule, will make it clearer next time round! In fact I might put it on the first tab with a series of other house rules that can be switched on or off!!

Showing my newb here. :> RIP me. I apologize as I was unaware, 5E was my first Tabletop as a GM. ^^; I'm still not completely up to speed on all the slang.
Title: Re: [6E] Excel Character Generator
Post by: Aria on <09-06-19/0803:38>
Not to worry!  Don't think it's 'proper' slang... anyway, I've moved it to the first tab under House Rules... will try and add in ones here that repeatedly come up, provided they affect character generation.  Any suggestions welcome!

Couple I'm considering...

Let adepts get magic points (and therefore power points)  from Adjustment points (this one seems to go directly against RAW but I can see some people wanting it as a yes/no option).  Personally as someone who has made many many adepts over the years I think it's refreshing that they don't all start with 6 power points out of the gate but I know that's not shared by all  ??? ::)

Contacts connection rating can be up to Cha +2 rather than Cha, don't see why a low cha person couldn't get to know someone up the food chain, sure cap loyalty but why connection?

Oh, and link has been updated again with Rigger Control Decks :P
Title: Re: [6E] Excel Character Generator
Post by: markelphoenix on <09-06-19/0844:23>
Not to worry!  Don't think it's 'proper' slang... anyway, I've moved it to the first tab under House Rules... will try and add in ones here that repeatedly come up, provided they affect character generation.  Any suggestions welcome!

Couple I'm considering...

Let adepts get magic points (and therefore power points)  from Adjustment points (this one seems to go directly against RAW but I can see some people wanting it as a yes/no option).  Personally as someone who has made many many adepts over the years I think it's refreshing that they don't all start with 6 power points out of the gate but I know that's not shared by all  ??? ::)

Contacts connection rating can be up to Cha +2 rather than Cha, don't see why a low cha person couldn't get to know someone up the food chain, sure cap loyalty but why connection?

Oh, and link has been updated again with Rigger Control Decks :P

I've pretty much been doing that PhysAdept HouseRule by overriding the formula and just setting PowerPoints to = Magic
Title: Re: [6E] Excel Character Generator
Post by: Aria on <09-06-19/1233:09>
Yet another version on the link, this time with some refinements to the contacts section and a few more 'PACKS' added to the Equip summary tab
Title: Re: [6E] Excel Character Generator
Post by: skalchemist on <09-06-19/1303:53>
I think some more rigger related stuff is missing from the equipment lists, as with RCC probably because it is not in the gear chapter...

Vehicle Control Rigs - pg 197

Drone related autosofts - pg 201

There may be more, I'm working my way through trying to create a rigger in the spreadsheet.
Actually, on reflection I can't for the life of me find the cost of VCRs in the rulebook or the errata.  So I have no idea how much they should cost.

EDIT: doh!  Now I see it.  It just doesn't have the word "vehicle" associated with it on page 284.  I was searching for "vehicle control", which seemed reasonable.   And I also just found "Autosoft" in the Electronics tab of the spreadsheet, but the way it is currently set up it doesn't really work for Rigger characters, because a Rigger character will need multiple autosofts.  I guess you could just put in the sum of all ratings of all Autosofts needed?  Mathematically that would work, but it is not the descriptive.

EDIT2: removed the post I quoted above, because it was not helpful.
Title: Re: [6E] Excel Character Generator
Post by: Aria on <09-06-19/1416:42>
Quite happy to have multiple autosoft slots... the row can also be copy pasted and it will still calculate in the total
Title: Re: [6E] Excel Character Generator
Post by: Arky on <09-07-19/0009:57>
On the weapons page, in ammo, there's no specification on ammo for shotguns at all.

So it's kind of unclear on what ammo to use for them.
Title: Re: [6E] Excel Character Generator
Post by: Aria on <09-07-19/0317:28>
Hmmm... not on the table in the CRB so unless thereís an errata I guess itís the same as rifles??
Title: Re: [6E] Excel Character Generator
Post by: Arky on <09-07-19/1538:29>
I'm slowly learning how to link fields in excel just by looking around, it's neat. I'm not able to do the legit shit you are doing yet though.
Title: Re: [6E] Excel Character Generator
Post by: markelphoenix on <09-08-19/0218:47>
So, just finished a Run I GMed with chars generated using Excel. Only thing that would make life a lot easier, is some sort of mapping form the Gear Sheets, Spell Sheets, and Power Sheets to the Front Sheet that is printer friendly. Friend tried to print char sheet, noticed a lot of stuff was missing on the main sheet, so tried to print entire Excel workbook...which lead to hundreds of pages trying to print due to the formulas.

Not a bug, per se, more of a user feedback on what would be valuable for next iteration.

Again, as always, thank you so much for your work of passion and helping the community.
Title: Re: [6E] Excel Character Generator
Post by: Aria on <09-08-19/0342:13>
That level of mapping is beyond my excel skills unfortunately, without listing everything on the sheet Iíve no idea how youíd just isolate it to stuff youíve selected/bought... for now itís copy and paste to the sheet unless anyone can point me in the direction of how to map it??

Failing that I can look over the tab formatting so that itís a bit more printer friendly perhaps...
Title: Re: [6E] Excel Character Generator
Post by: markelphoenix on <09-08-19/0950:14>
That level of mapping is beyond my excel skills unfortunately, without listing everything on the sheet Iíve no idea how youíd just isolate it to stuff youíve selected/bought... for now itís copy and paste to the sheet unless anyone can point me in the direction of how to map it??

Failing that I can look over the tab formatting so that itís a bit more printer friendly perhaps...

This pretty much is the how to:
https://zapier.com/blog/excel-macros/

I will try to do an example if I can scrounge the time. Still shaking out a hang over, so we'll see where day takes me.
Title: Re: [6E] Excel Character Generator
Post by: Aria on <09-09-19/0331:15>
I had a glance at the macros thing... hmmm, it looks good in principle but I'll start by formatting the sheet in a more printer friendly option first I think  ::)

EDIT: link updated with a slightly more printer friendly version, it clocks in at 41 A4 sheets if you print every tab... but you should be able to Ctrl click the tabs you want to print and use 'active sheets' to just print those.  It's a start anyway  ;D  You can also right click and 'hide' tabs your character is never going to need... I suggest that rather than deleting them as that can frag up the formulae sometimes and you don't want to have to fix those if you can help it!
Title: Re: [6E] Excel Character Generator
Post by: Aria on <09-10-19/0750:40>
Link updated once again...

New 'PACK'
CFs described plus the odd gear tweak
House rules sections added with Adept adjustment points affecting power points and essence loss reducing power points (I'm pretty sure these work but shout if they don't)!!
Title: Re: [6E] Excel Character Generator
Post by: Moonrunner on <09-10-19/1042:59>
Is there an instruction guide anywhere on how to use this? I looked at it and was a bit confused.
Title: Re: [6E] Excel Character Generator
Post by: Aria on <09-10-19/1314:39>
The priorities tab has some brief notes on it, I can add some more detail there if needs be?
Title: Re: [6E] Excel Character Generator
Post by: markelphoenix on <09-10-19/1909:19>
Is there an instruction guide anywhere on how to use this? I looked at it and was a bit confused.

Scroll up, I give a brief explanation.
Title: Re: [6E] Excel Character Generator
Post by: Aria on <09-11-19/0755:40>
Is there an instruction guide anywhere on how to use this? I looked at it and was a bit confused.
I've added an 'intro' tab (link updated) where I've tried to capture the way to use the sheet... have a look and see if that helps or if you think it could do with some more tweaks?

Thanks
Title: Re: [6E] Excel Character Generator
Post by: Gorstavich on <09-12-19/1511:48>
Just noticed in the Cyber & Bio tab that strength for limb options was spelled "Strenght".    :)
Title: Re: [6E] Excel Character Generator
Post by: Aria on <09-13-19/0606:23>
Iíll sort that out, the perils of Ďtouch typingí and not spell checking  ::)
Title: Re: [6E] Excel Character Generator
Post by: Arky on <09-15-19/1403:32>
We're all guilty of it from time to time, you're doing awesome, I've made a few characters with this now and for the most part everything is working out pretty well.

You've managed to stream line a lot so far, making it difficult to run into issues anymore. I'm going to try making some out of the box characters to see if issues arise this coming week.
Title: Re: [6E] Excel Character Generator
Post by: Arky on <09-15-19/2051:19>
On the Complex forms portion, Static Veil and Stitches have each other's description. Stitches is supposed to be the form that heals sprites, Static Veil covers Overwatch for sprites or illegal access, they're right next to each other on the list, so it's an easy mistake.
Title: Re: [6E] Excel Character Generator
Post by: Aria on <09-16-19/1023:00>
Link has been updated with the errors corrected and the weapons tab pretty much complete... I canít be the only one who is questioning the cost of the Ruger 100, or that they forgot to reduce the DV of grenades when they lowered all the other weapons?!? :P
Title: Re: [6E] Excel Character Generator
Post by: Aria on <09-30-19/0802:08>
Link has been updated with the cyberware summaries filled in and a tweak to the sheet output to once more show attributes as natural and boosted (rather than just boosted)
Title: Re: [6E] Excel Character Generator
Post by: ZeroSum on <09-30-19/0832:23>
Minor note: On the Misc Gear sheet, the calculation for nuyen spend in cell G136 is =SUM(G8:G93), but it should be =SUM(G8:G134); it is currently not counting nuyen spent on Formulae, Magical Supplies, Toxins, Drugs, or Instruments.

Personal preference: I added conditional formatting on cells T11-T29 in the "3 Skills" sheet, and cells Q26-Q35, to match your formatting elsewhere of turning the cell Blue when a non-zero value exists. This just makes it easier to see which skills and attributes you've picked and what their ratings are.

Thanks again!
Title: Re: [6E] Excel Character Generator
Post by: Aria on <09-30-19/0846:03>
Thanks for the spot!  And I've tweaked the formatting as suggested :)

Link updated... not far off declaring 6.01 complete... at least until the errata changes a load of things  ::)
Title: Re: [6E] Excel Character Generator
Post by: ZeroSum on <10-02-19/0658:22>
Found a minor issue with Unarmed Attack Rating calculation on sheet "2 Attributes";
Current formulae is =Q28+Q29+'Cyber & Bio'!C68+'Cyber & Bio'!C69*2+'Cyber & Bio'!C70*3

This does take into account the AR bonus provided by Bone Lacing, but not that provided by Bone Density.
Quote from: SR6 p.291
Your Body attribute is increased by the bone density rating for the purpose of Damage Resistance tests. Your Damage Value and Attack Rating are also changed for unarmed attacks.

I think the formula should be
=Q28+Q29+'Cyber & Bio'!C68+'Cyber & Bio'!C69*2+'Cyber & Bio'!C70*3+'Cyber & Bio'!C217+'Cyber & Bio'!C218*2+'Cyber & Bio'!C219*3+'Cyber & Bio'!C220*4

Would it be possible to add Unarmed DV as a calculated value similar to Attack Rating, as well. This is something that will follow a set pattern (STR/2 + ratings for Bone Lacing/Bone Density, and possibly other factors? I'm reviewing this right now).

EDIT:
Also, on the "Sheet" sheet, the calculations for augmented stats are off by two columns. For example, D13 should be referencing ='2 Attributes'!Q26, but it is referencing ='2 Attributes'!S26.
Title: Re: [6E] Excel Character Generator
Post by: Aria on <10-02-19/0811:52>
Bone density is +1, +2, +2, +3 to unarmed AR... added to the calculation (+'Cyber & Bio'!C217+'Cyber & Bio'!C218*2+'Cyber & Bio'!C219*2+'Cyber & Bio'!C220*3)

Don't see why I couldn't do unarmed DV too :)

EDIT: something like this i think... (=ROUNDUP(Q29/2,0)+Adepts!C11*'Cyber & Bio'!C68+'Cyber & Bio'!C69+'Cyber & Bio'!C70*2+'Cyber & Bio'!C217+'Cyber & Bio'!C218+'Cyber & Bio'!C219*2+'Cyber & Bio'!C220*2)

I've deliberately not done bonuses to Bod for damage tests only (or other attribute or skill bonuses that are situational), maybe that needs a box somewhere as it's a common enough buff!?

I've fixed the sheet too... sometimes forget that excel changes cells when you copy and paste :P

EDIT 2: Link updated!
Title: Re: [6E] Excel Character Generator
Post by: ZeroSum on <10-03-19/0526:37>
Awesome :)

I noticed that the calculation for Initiative is missing one component; attribute augments.

The formula on 2 Attributes Q41 is =N41+P41, but P41 has no formula. Simply adding =P28+P32 to P41 fixes this minor glitch.

Alternatively, calculate this similarly to Astral Initiative in Q43, which uses the Q column directly.

Thanks so much again for all your efforts on this.
Title: Re: [6E] Excel Character Generator
Post by: Aria on <10-03-19/0750:46>
Fixed :)

Also tinkered with the 2 main sheet outputs to better show unarmed damage / AR etc...

Thanks to ZeroSum for all the checking, added your handle to the play testers :)
Title: Re: [6E] Excel Character Generator
Post by: Jimmy_Pvish on <10-03-19/0940:35>
Did the cost of used grade ware got errata?

It's 0.5 of base cost in the book but 0.75 in Excel.
Title: Re: [6E] Excel Character Generator
Post by: ZeroSum on <10-03-19/1015:07>
Did the cost of used grade ware got errata?

It's 0.5 of base cost in the book but 0.75 in Excel.
Wow, good catch! I completely missed that one.
Title: Re: [6E] Excel Character Generator
Post by: Aria on <10-03-19/1528:56>
Oops, I think that may be a hangover from SR5, will fix tomorrow :P
Title: Re: [6E] Excel Character Generator
Post by: Aria on <10-04-19/0359:28>
Link has been updated again with the fix to the price of Used cyberware grades (until they errata it back to 0.75 anyway :P) ...apologies to anyone who made characters with older versions of the generator, trying to stay on top of glitches  ::)

...and who uses used cyberware anyway?? That's yurrrk  ??? :o ;D. Donít give the organleggers your cash!
Title: Re: [6E] Excel Character Generator
Post by: Michael Chandra on <10-04-19/0503:50>
You find used CYBER icky?! Try used BIO!
Title: Re: [6E] Excel Character Generator
Post by: Aria on <10-04-19/0537:57>
Iíll pass thanks... although back in the day I played the Ďusedí muscle toner 3 trick to bypass availability caps (along with many others)... usually fluffed it as Ďknock-offí rather than Ďripped outí though :)
Title: Re: [6E] Excel Character Generator
Post by: ZeroSum on <10-04-19/1134:31>
I might just be missing it, but is there a way to set your Tradition as a Magician?

It looks to me like it defaults to Hermetic, but I'm trying to build a Shaman.
Title: Re: [6E] Excel Character Generator
Post by: Aria on <10-04-19/1145:41>
Arenít they mechanically the same thing now? Pick a mentor spirit and youíre a shaman...??
Title: Re: [6E] Excel Character Generator
Post by: ZeroSum on <10-04-19/1150:06>
Kind of. I'm still reading through the Magic section, but the first thing that stood out to me is that you resist Drain with Magic + Tradition Attribute, which is Logic for Hermeticists and Charisma for Shamans.

There may be other calculated values that I haven't found yet, like Astral stuff.
Title: Re: [6E] Excel Character Generator
Post by: Aria on <10-04-19/1231:38>
Ah!  I haven't listed drain calcs anywhere on the sheets... I guess there's no reason why not, it would be another box to 'tick'   ...might not add centering / foci etc in to that though, starts to get complicated and situational :P
Title: Re: [6E] Excel Character Generator
Post by: jacx7 on <10-09-19/1054:46>
Also drain for Adepts is BOD + WIL.

Quote
"Adepts sometimes have to resist drain, which they do with Body + Willpower. Drain is Stun unless its initial value is higher than the adeptís Magic, in which case it is Physical."
CRB p.158

But this if for "Adept Adepts" not "Mystic Adepts" I assume becauso those have a shamanic or hermetic tradition.
Title: Re: [6E] Excel Character Generator
Post by: Aria on <10-09-19/1240:30>
Not sure if it's spelled out in RAW but I've always assumed that drain for adept powers is Bod+Will and mysads use that too...they only use their tradition drain stat for spellcasting/summoning etc...!?
Title: Re: [6E] Excel Character Generator
Post by: jacx7 on <10-09-19/1434:38>
I also don't know if it is spelled out, but im with you, the BOD+WIL drain is probably just used for Adept Powers Adrenaline Boost and Attribute Boost.
Although both say in the last paragraph resist as normal - suppose it means "resist as Adepts do normal for usage of Powers"?

So probably a better wording for the 2nd Adepts Paragraph would be:
> Adepts [and Mystic Adepts?] have to resist drain from some Adept Powers with Body + Willpower.
instead of
> Adepts sometimes have to resist drain, which they do with Body + Willpower.
Title: Re: [6E] Excel Character Generator
Post by: jacx7 on <10-12-19/1747:31>
Thanks for this great tool works like a charm!

Had a look at the Spells table and added some info:

Added Row 38 Cooling Heal
Added Row 88 Prodigal Spell
Added Spell Rng, Type, Dur, Drain, Damge & some Notes.

https://drive.google.com/open?id=1gGWc0wbyu9FAC1uRZ79UXChoFII2jwGF (https://drive.google.com/open?id=1gGWc0wbyu9FAC1uRZ79UXChoFII2jwGF)

Should be working but maybe you can take a look at it and release a new version in Post 1.
Title: Re: [6E] Excel Character Generator
Post by: Aria on <10-14-19/0333:46>
Thanks!  GargaMonk has taken a copy to add his/her prinatable sheet to it so I'll get both of these combined together and re-issued as soon as possible!
Title: Re: [6E] Excel Character Generator
Post by: Aria on <10-16-19/1235:37>
While waiting for GargaMonk's sheet I've updated the link with some of the armour stuff noted and the excellent work that jacx7 did on the spell tables!
Title: Re: [6E] Excel Character Generator
Post by: jacx7 on <10-16-19/1624:34>
Had some minor errors on the Health spells.. sorry for the inconvenience :(

took you new upload and replaced the cells on the spell page:
https://drive.google.com/open?id=1R-Nhd5d3EKQiY6QvqwnC9XstfPARYRZV (https://drive.google.com/open?id=1R-Nhd5d3EKQiY6QvqwnC9XstfPARYRZV)
Title: Re: [6E] Excel Character Generator
Post by: Aria on <10-17-19/0848:01>
Thanks, I've made those changes and I'll update the link in a sec!
Title: Re: [6E] Excel Character Generator
Post by: jacx7 on <10-24-19/1149:53>
Found a copypasta error on Totems&Initiation: H12 (Advantage-All for Firebringer)

Should be:
Edge Boosts cost 1 less for Engineering skill tests or Enchanting skill tests (choose one).
Title: Re: [6E] Excel Character Generator
Post by: Aria on <10-25-19/0755:35>
Thanks!

Fixed that and there are a few more bits of game information noted... only a couple more tabs to go and I can finally say 6.01 is done :D

Link updated
Title: Re: [6E] Excel Character Generator
Post by: Chrisfroste on <10-29-19/2145:01>
Came here to check if I am just misreading something.  For Trolls, you get 2 qualities by default, Dermal Deposits and Built Tough 2.  However, the form does not calculate this in.  Is there a way to get both of these for calculations without throwing off the Karma costs?
Title: Re: [6E] Excel Character Generator
Post by: Aria on <10-30-19/0336:04>
I will double check but I think I wrote the benefits of those qualities in to the attribute boosts etc so you should be getting them. Exciting new update coming soon thanks to gargaMonkís hard work...
Title: Re: [6E] Excel Character Generator
Post by: Chrisfroste on <10-30-19/1008:42>
Unarmed damage is not calculating correctly with dermal deposits at least. Should be str/2 +1 but it never adds in the +1
Title: Re: [6E] Excel Character Generator
Post by: Aria on <10-30-19/1221:19>
I spotted that! Built tough is added in but Iím tweaking the next version so that it shows up meta qualities automatically
Title: Re: [6E] Excel Character Generator
Post by: Chrisfroste on <10-30-19/1624:30>
Awesome.  Eagerly awaiting the update. Just learning 6E, so in my usual fashion, built a character to help learn it.  Troll brawler.  Realized the numbers werent adding up lol
Title: Re: [6E] Excel Character Generator
Post by: Ajax on <10-30-19/1624:43>
Would it be possible to have the final ďSheetĒ tab include a column that listed the Attributes used for each Skill?
Title: Re: [6E] Excel Character Generator
Post by: Aria on <10-30-19/1630:34>
On the text for the forum output sure... the printable sheet will be gargaMonkís one which is linked separately somewhere here... not sure thereís spare space on that but Iíll see...
Title: Re: [6E] Excel Character Generator
Post by: Aria on <11-01-19/1322:41>
The link has been updated with gargaMONK's sheet (I've asked for some more quality slots)... it has lots more automation now (although I've not tested it in anger yet).  Will try and pick up Ajax's request re skills and linked attributes in the next round of updates but I wanted to get this out there  ;D
Title: Re: [6E] Excel Character Generator
Post by: Ajax on <11-01-19/1426:33>
Maximum number of Qualities is six and (IIRC) the most ďfreeĒ Qualities you can gain from a Metatype is two... So 8-10 lines should be enough (in my experience, it usually isnít even necessary to record Metatype Qualities, but your mileage may vary.)
Title: Re: [6E] Excel Character Generator
Post by: Aria on <11-01-19/1536:56>
As metatype qualities have changed from 5 it seems sensible to record them, for a while at least. Can always knock them out again later on.
Title: Re: [6E] Excel Character Generator
Post by: skalchemist on <11-05-19/1131:45>
Sorry, I've lost track of this thread so I will just ask: the link in the first post and in your sig block is the most up to date version, right?

Thanks again for this, btw.
Title: Re: [6E] Excel Character Generator
Post by: Aria on <11-05-19/1234:39>
It is current although the 'final version' will be issued in a couple of days with a new link... but I'll update my sig and the first post of this thread when that happens :)
Title: Re: [6E] Excel Character Generator
Post by: Whatchamazog on <11-05-19/2224:06>
Great tool @Aria.
So it appears that the Adept Power "Improved Reflexes" is boosting the Agility attribute instead of the Reaction attribute.
The Initiative Dice feature seems to be fine though.

Thanks so much!

Edit:  It appears to only be wrong on the "Sheet CLR" and "Sheet BW" tabs.  it's right everywhere else.
Title: Re: [6E] Excel Character Generator
Post by: Aria on <11-06-19/1239:38>
Ok, I think I've ironed out the glitches and filled in all the notes sections so ready to call this the 'final' version of 6.01 (subject to anyone else finding mistakes of course)

To keep it clean it has a new link: <<CG6.01 Final>> (https://drive.google.com/open?id=1HgUQPBL9C4PuZbDv7Kc9F_jvt11hQ25p)

Enjoy!
Title: Re: [6E] Excel Character Generator
Post by: paw9000 on <11-06-19/1633:03>
Sheet CLR
1)
the adjusted body calculation I believe should be:
=H7+'2 Attributes'!P26
instead of
=H7+'2 Attributes'!P27
(Looks like it pulling from Agility instead of Body)

2)
Initiative, the d6 section is just
=1+0
My test case had Wired reflexes 2
Matrix Init is probably correct
Astral Init: has a similar problem but is
=2+0

(Thanks for all the hard work on this!)
Title: Re: [6E] Excel Character Generator
Post by: Aria on <11-06-19/1754:05>
I spoke too soon lol... will check those and try to upload tomorrow...
Title: Re: [6E] Excel Character Generator
Post by: Aria on <11-07-19/0748:04>
Took some head scratching but I think it's right now... link updated!
Title: Re: [6E] Excel Character Generator
Post by: Whatchamazog on <11-07-19/1641:21>
Took some head scratching but I think it's right now... link updated!

Link still takes me to the draft. :D
Title: Re: [6E] Excel Character Generator
Post by: Aria on <11-07-19/1657:23>
Use the link in the first post (I will strike through the draft link) or my sig... both should be the final version!

Edit: ok, I fixed where the link was looking, sorry, don't know what happened there :P
Title: Re: [6E] Excel Character Generator
Post by: Whatchamazog on <11-07-19/1827:21>
Beautiful!
I have 10 pregens to make by Saturday and this will help a lot!
Title: Re: [6E] Excel Character Generator
Post by: Aria on <11-08-19/0346:36>
Good luck!

This may help: Ajax's reworked archetypes (https://forums.shadowruntabletop.com/index.php?topic=30450.msg529613#msg529613)
Title: Re: [6E] Excel Character Generator
Post by: Aria on <11-13-19/1232:53>
Spotted a glitch in the auto calculations on the forum and OP output tabs which has been corrected and I've added a couple of pre-genned cybereyes as the potentially limited number of sheet slots was filling up fast with sub options...

Link updated!
Title: Re: [6E] Excel Character Generator
Post by: Bookwyrme on <11-16-19/1745:54>
Thank you for making this. We have 4 new players, two are basically brand new, and this has been a huge help. Your work is much appreciated.
I found a few errors while helping folks make characters. 
Stun Grenades are missing their status effects in the notes
The electronics tab has several issues-
The capacity and rating are in the same column as one number, but aren't always supposed to be the same number, either or is listed, but some have both.
An example of the issue is the single sensor, which has a capacity of one, but it has a cost of ratingX100. There is nowhere to change the rating. Several enhancements and sensor housings have either this cost issue or don't have a capacity listed. 
The select sound filter does not have an availability listed.
Spatial Recognizer in the electronics tab has the wrong wifi bonus and note.
Thank you again! My apologies if I have misunderstood how something works.
Title: Re: [6E] Excel Character Generator
Post by: Aria on <11-17-19/1544:28>
Thanks for the notes, Iíll look in to it ASAP and sort it out!
Title: Re: [6E] Excel Character Generator
Post by: Aria on <11-18-19/1231:19>
I've made those tweaks and uploaded the latest version.  If you spot anything else please let me know :)
Title: Re: [6E] Excel Character Generator
Post by: Aria on <11-28-19/0742:08>
The link has been updated again with some more tidying up and adding some of the weapons/armour  automation to the text/OP output tabs
Title: Re: [6E] Excel Character Generator
Post by: Bookwyrme on <12-04-19/0402:04>
Found another one for you.  When a character has the networker quality, the points remaining cell  for contacts doesn't show the right amount.

For instance, I have networker and get 30 contact points from my charisma. I have 6 contacts and they add up to 36, which is 30 points spent with the networker deduction. The sheet totals it to 30, but up in the points remaining cell, it says I have 5 remaining.   We haven't been able to figure out why.
Thanks!
Title: Re: [6E] Excel Character Generator
Post by: Aria on <12-04-19/1025:40>
There was some strange double counting going on... I think it should all now be fixed and Iíve updated the version in the link!

Any more glitches just let me know :)
Title: Re: [6E] Excel Character Generator
Post by: Aria on <01-22-20/0902:49>
Following the errata (and Adversary) here's version .02 of the generator.  I'm pretty sure I've picked up all the changes but if anyone spots any errors please shout!

<<CG6.02>> (https://drive.google.com/open?id=1P_7pkcD6qZSrg_2hrZF41BDv7SjWi9xw)

I'll keep version 1 live for now in case people want a pre errata version  :o
Title: Re: [6E] Excel Character Generator
Post by: Aria on <06-09-20/1033:04>
Hi folks...

I've 'rushed out' an update for Firing Squad for those that want to use the generator and have the book with stats etc.  Some of the population of the character sheet tabs might be a bit wonky and I will iron that out in the next release shortly.

<CG6.03> (https://drive.google.com/file/d/1_zJtPzM-9WbdH90wFk-FfiVDgD4H1IVM/view?usp=sharing)

As ever, please let me know if you spot any problems

A
Title: Re: [6E] Excel Character Generator
Post by: Tecumseh on <06-09-20/1223:19>
Thank you! I've been using this generator extensively and it's been very helpful.
Title: Re: [6E] Excel Character Generator
Post by: Aria on <06-09-20/1300:36>
Youíre welcome! Iíve got one of my PCs to assist in the data entry for 6.04 so hopefully that will be available soon!
Title: Re: [6E] Excel Character Generator
Post by: Johnny Analog on <06-14-20/2142:35>
Thanks for this one as well!