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>
(https://drive.google.com/uc?export=download&id=1d1QWyni0V3LS-fWG4TIa9yKCpEURMKTN)

LINK UPDATED! v37

Links have been updated with Scotophobia and Astral Ways!

Enjoy

Dropbox <CG6.xx> (https://www.dropbox.com/sh/fa5w297tgc4nu9u/AACn7Fvwsugt9v6ECyS6fqvQa?dl=0)
Google Drive <CG6.xx> (https://docs.google.com/spreadsheets/d/1Dtg8kb9izi6MxzJn-y-lOjfzM5YF9Uo9/edit?usp=sharing&ouid=114130415901116153183&rtpof=true&sd=true)

LINK UPDATED!
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!
Title: Re: [6E] Excel Character Generator
Post by: Aria on <07-13-20/0759:40>
Version .04 is now available with proper inputs of weapons and armour from Firing Squad along with the martial arts rules.  Krime Katalog and Ingentis will follow in .05

Enjoy

<CG6.04> (https://drive.google.com/file/d/1qt0pHXuOz6WDH8Jq-RkPr5s5JFfjWIJb/view?usp=sharing)
Title: Re: [6E] Excel Character Generator
Post by: Aria on <07-14-20/1222:34>
Faster than expected I've managed to complete Krime Katalog and Ingentis Athletes so for your Trog pleasure:

<CG6.05> (https://drive.google.com/file/d/16VR38CAxM9J0cxBJkrapG0rcPKJFX0cj/view?usp=sharing)
Title: Re: [6E] Excel Character Generator
Post by: markelphoenix on <07-19-20/1524:28>
Faster than expected I've managed to complete Krime Katalog and Ingentis Athletes so for your Trog pleasure:

<CG6.05> (https://drive.google.com/file/d/16VR38CAxM9J0cxBJkrapG0rcPKJFX0cj/view?usp=sharing)

I noticed Buy Off Negative Quality is listed twice for karma expenditures. Did you mean to add Buy Off Negative Quality and Buy Positive Quality?
Title: Re: [6E] Excel Character Generator
Post by: Aria on <07-20-20/0800:12>
I noticed Buy Off Negative Quality is listed twice for karma expenditures. Did you mean to add Buy Off Negative Quality and Buy Positive Quality?
I think I put it there twice so you could identify two buy offs, but there's no actual need for the second one.  Buying a positive quality post char gen is handled on the qualities tab and putting a '2' in the post gen box so the cost is doubled...
Title: Re: [6E] Excel Character Generator
Post by: Aria on <07-21-20/0414:27>
Spotted a glitch that has been corrected... same link will work, apologies to anyone who's already downloaded .05  :-\
Title: Re: [6E] Excel Character Generator
Post by: Aria on <07-22-20/0817:43>
<CG6.xx> (https://drive.google.com/file/d/1Dtg8kb9izi6MxzJn-y-lOjfzM5YF9Uo9/view?usp=sharing) v6
Title: Re: [6E] Excel Character Generator
Post by: Aria on <07-29-20/0516:33>
Uploaded v .07 as I discovered that the martial arts karma costs weren't being correctly taken off the total... easy enough to correct yourselves if you don't want to download a new version
Title: Re: [6E] Excel Character Generator
Post by: markelphoenix on <08-01-20/1739:51>
Aria, Found a bug in Stolen Gear Negative Quality from No Future, it shows 20 Karma gained from qualities. Stolen Gear does not add Karma. You spend Karma, like In Debt. So, choosing it at, say, 20 points would consume 20 Karma, as if you were spending 20 Karma from your 50 Karma to buy Nuyen in char gen, except it replaces the ability to spend Karma to buy Nuyen with the benefits/negative aspects of the Quality.

Fixed it locally by simply multiplying the formula in G139 by 0.
Title: Re: [6E] Excel Character Generator
Post by: markelphoenix on <08-01-20/1849:28>
Also, a suggestion. Separate the Funds for Stolen Gear from the Priority Table provided funds, given that the Stolen Gear funds need to be spent in entirety and any left over simply disappears. (i.e. I choose 195k Nuyen worth of Stolen Gear, the other 5k goes away and do not become general funds, where I would still have the remainder of starting Nuyen to spend separately from that)
Title: Re: [6E] Excel Character Generator
Post by: Quatar on <08-08-20/0543:05>
Found a few bugs on the Equip Summary page, related to metatype adjustments

1) Troll D8, totally ignores the Armor/clothing costs in D83
2) Both Dwarf and Giant seem to calculate the Runner Chic seperately into it for some reason, and don't check if you're even a dwarf, despite it already being included in the Armor field in D83
3) The Remaining Funds field in D5 totally ingores both Trolls and Dwarf markups.
4) Remaining Funds also ignores Sin Tax, In Debt Interest and Symiote food fields (though I'm not sure those aren't already included elsewhere)

Its easy to fix manually but more of a luck thing to spot its wrong.
Title: Re: [6E] Excel Character Generator
Post by: Aria on <08-14-20/0931:14>
Thanks for the checks guys, I think I've managed to pick them all up and clarify where costs are going/coming from where it wasn't clear.

The link has been updated with v09

Adept totem powers are now highlighted in the adepts tab and the cost is deducted (they still need to be selected).
Title: Re: [6E] Excel Character Generator
Post by: Aria on <08-28-20/1214:34>
Link updated with v.10 which includes Returning Soldiers from Slip Stream and some bug fixes
Title: Re: [6E] Excel Character Generator
Post by: Aria on <09-16-20/0813:37>
I somehow managed to miss the whole of the Firing Squad weapon mods and accessories, now corrected.

Other minor tweaks based on the SRM missions FAQ
Title: Re: [6E] Excel Character Generator
Post by: Aria on <11-18-20/1830:20>
Link has been updated to version 12, with another character sheet output, some houserule calculations added etc
Title: Re: [6E] Excel Character Generator
Post by: Aria on <01-11-21/0656:52>
The link has been updated with the adept power from Collapsing Now and the GreenWar weapon (couldn't find any other stuff that directly impacted on char gen but I've only skimmed so far)
Title: Re: [6E] Excel Character Generator
Post by: Aria on <02-11-21/0616:51>
The link has been updated with 'everything adept' from Street Wyrd (due to my personal bias)... I'll get the rest of SW added over the next few days :D
Title: Re: [6E] Excel Character Generator
Post by: Aria on <02-23-21/0912:26>
Link has been updated with the rest of the bones of Street Wyrd (enough that you can use it to calculate but without all the rules summaries etc)... oh and the preparations will have to follow as that's a fairly major exercise too :)
Title: Re: [6E] Excel Character Generator
Post by: Aria on <03-03-21/0926:45>
Link has been updated with the info needed to buy spells and the alchemical preparations etc.  A few community designed spells have been added in too.  I haven't managed to summaries all the crunch yet but that is a work in progress which I haven't yet managed to con anyone else in to helping with  ::) ;D
Title: Re: [6E] Excel Character Generator
Post by: Aria on <03-23-21/1856:08>
Link has been updated with Traditions info from Street Wyrd on the Mentor spirits tab
Title: Re: [6E] Excel Character Generator
Post by: Aria on <04-28-21/0615:14>
Link updated with Power Play qualities!

Enjoy, some fun ones in there!
Title: Re: [6E] Excel Character Generator
Post by: Aria on <06-10-21/1040:19>
Link updated with version 19, adding 'knock off' as an option on the weapons tab plus the SRM FAQ spells
Title: Re: [6E] Excel Character Generator
Post by: Aria on <09-10-21/0943:13>
Link updated to Dropbox to make it easier to download :)
Title: Re: [6E] Excel Character Generator
Post by: Aria on <09-21-21/0751:44>
Link updated with the Seattle City Edition of the core rulebook info

Also a copy of my 6E spirits excel generator in there too
Title: Re: [6E] Excel Character Generator
Post by: Aria on <10-18-21/0747:27>
After much hard work the link has been updated with Double Clutch information... enjoy!

I'm working up a 6E vehicle creation tool and once I've wrapped my head around that I'll add it to the Dropbox!
Title: Re: [6E] Excel Character Generator
Post by: Aria on <11-16-21/0902:56>
Link updated with v23
Title: Re: [6E] Excel Character Generator
Post by: Hobbes on <11-17-21/1239:26>
Any particular version / year of Micro$oft Office required or does this work on 2016ish versions?
Title: Re: [6E] Excel Character Generator
Post by: Aria on <11-17-21/1248:09>
Any particular version / year of Micro$oft Office required or does this work on 2016ish versions?
I think it should work on any version of Excel that can read .xlxs files (as opposed to whatever the old file format was?!?)
Title: Re: [6E] Excel Character Generator
Post by: Beta on <11-18-21/1827:24>
It also works just fine when turned into a google docs spreadsheet :-)
Title: Re: [6E] Excel Character Generator
Post by: Aria on <01-21-22/1237:15>
The Dropbox link has been updated with the latest version of my SR6 excel generator, includes the Kechibi Code

<SR Dropbox> (https://www.dropbox.com/sh/fa5w297tg...CyS6fqvQa?dl=0)
Title: Re: [6E] Excel Character Generator
Post by: Tecumseh on <04-11-22/1823:48>
Still using this so thanks for your efforts on it.

Found a couple bugs on the "Equip Summary" tab.

First issue: Cells F112 and F114 are empty. They should have the same equation as F110.

Second issue: if you select "High" then no value will populate in the equations in column F. The problem is that the drop-down values for High in D110/D112/D114 include a space after the word High (so "High ") so they don't make a match with the lookups in Y110/Y112/Y114 that are looking for the word without a space ("High"). So either add a space to column Y or subtract the space from the drop-downs in column D. The other Lifestyle levels work as intended.

Thanks again for your work!
Title: Re: [6E] Excel Character Generator
Post by: Tecumseh on <04-12-22/1530:47>
Another:

On 4 Qualities & MAs, cell G281 is summing starting at G243 instead of G275. This means that means it is counting some of the Martial Arts, and thus double-counting some of the things that are already represented in G273.

Changing G281 to =SUM(G275:G280) will fix it.

----

Sheet CLR cell AN35 is not in sync with 2 Attributes cell Q54. The latter is correct because it takes into account more than just Strength and Reaction.
Title: Re: [6E] Excel Character Generator
Post by: Aria on <04-18-22/1643:36>
Still using this so thanks for your efforts on it.

Found a couple bugs on the "Equip Summary" tab.

First issue: Cells F112 and F114 are empty. They should have the same equation as F110.

Second issue: if you select "High" then no value will populate in the equations in column F. The problem is that the drop-down values for High in D110/D112/D114 include a space after the word High (so "High ") so they don't make a match with the lookups in Y110/Y112/Y114 that are looking for the word without a space ("High"). So either add a space to column Y or subtract the space from the drop-downs in column D. The other Lifestyle levels work as intended.

Thanks again for your work!
Thanks for the proof reading!  I am trying to get the next version out with Lofwyr's Legions and Emerald City so I will pick up these too!
Title: Re: [6E] Excel Character Generator
Post by: Aria on <04-19-22/1533:03>
Link has been updated to version .25

Here's a Google Drive link if anyone is struggling with Dropbox: https://docs.google.com/spreadsheets/d/1Dtg8kb9izi6MxzJn-y-lOjfzM5YF9Uo9/edit?usp=sharing&ouid=114130415901116153183&rtpof=true&sd=true
Title: Re: [6E] Excel Character Generator
Post by: markelphoenix on <05-16-22/2348:05>
Aria, any plans to add point buy / Companion source material?
Title: Re: [6E] Excel Character Generator
Post by: Aria on <05-17-22/0240:41>
I’ve added point buy, just trying to get the general qualities in too and then I will re-issue, extra metavarients etc will follow later
Title: Re: [6E] Excel Character Generator
Post by: Aria on <05-17-22/1237:42>
Links in the first post have been updated to Point Buy and general qualities from Sixth World Companion, enjoy!
Title: Re: [6E] Excel Character Generator
Post by: Aria on <06-08-22/0953:08>
Links have been updated with the metavarients, changelings, non-metahumans (although not infected yet) and some house rules from Sixth World Companion
Title: Re: [6E] Excel Character Generator
Post by: Aria on <06-15-22/0826:33>
Links have been updated with Lifestyle and Contacts rules from SWC... unless there's massive demand I'm not going to bother with Infected for now as that's a big chunk of work that will only benefit a small few.  Will get round to it eventually of course...

A
Title: Re: [6E] Excel Character Generator
Post by: Hobbes on <07-03-22/1700:36>
There is not a Mark Up on Equipment Summary tab for Kali-Ani Collective, should be 30% on clothing / Armor for the Shiva Arms 3. 
Title: Re: [6E] Excel Character Generator
Post by: Aria on <07-03-22/1804:14>
There is not a Mark Up on Equipment Summary tab for Kali-Ani Collective, should be 30% on clothing / Armor for the Shiva Arms 3.
Thanks!  I will get that added in to the next issue!
Title: Re: [6E] Excel Character Generator
Post by: Hobbes on <07-04-22/0947:28>
Martial Arts Karma costs are not calculating correctly.  Additional Techniques don't seem to be increasing costs by 5 each.  And cell G395 on '4 Qualities & MA' tab seems to be doubling the total from G387 same tab.  G395 Should probably be =SUM(G389:G394)   

G385 doesn't seem to like the value from Cell F3 on the 'MA Tech & Edge' Tab.  I think the Additional Techniques value is getting SUM'd multiple times.  Cell C386 on '4 Qualities & MA' tab should probably be =SUM(C352:C384)?

Could be that I angered the Machine Spirit with my tinkering, but those are the corrections I made to get the correct karma totals. 

Edit:  Cell G385 on '4 Qualities & MAs' Tab I used =ABS('MA Tech & Edge'!H3). 



Title: Re: [6E] Excel Character Generator
Post by: Aria on <07-04-22/1846:43>
Martial Arts Karma costs are not calculating correctly.  Additional Techniques don't seem to be increasing costs by 5 each.  And cell G395 on '4 Qualities & MA' tab seems to be doubling the total from G387 same tab.  G395 Should probably be =SUM(G389:G394)   

G385 doesn't seem to like the value from Cell F3 on the 'MA Tech & Edge' Tab.  I think the Additional Techniques value is getting SUM'd multiple times.  Cell C386 on '4 Qualities & MA' tab should probably be =SUM(C352:C384)?

Could be that I angered the Machine Spirit with my tinkering, but those are the corrections I made to get the correct karma totals. 

Edit:  Cell G385 on '4 Qualities & MAs' Tab I used =ABS('MA Tech & Edge'!H3).
I'll tweak the additional techniques select box to a yellow cell to try and make it clearer you put the number in there you want... I think that does it then
Title: Re: [6E] Excel Character Generator
Post by: Hobbes on <07-04-22/2133:26>
+1

Thanks!
Title: Re: [6E] Excel Character Generator
Post by: Slamm-O! on <08-26-22/1010:09>
Any plans to add in Infected since they are now-ish SRM legal ?  Specifically the ever lovable Ghouls ?  Looks like the proof-reading team missed costs and they are either 27 or 29 karma. 
Title: Re: [6E] Excel Character Generator
Post by: Aria on <08-26-22/1223:46>
If there's a desire for adding infected it certainly something I've been intending to get round to!  Might start with the traditional few that might see play in an 'average' runner group (ghoul, vampire, banshee), any specific requests for others then please let me know  :o
Title: Re: [6E] Excel Character Generator
Post by: Slamm-O! on <08-26-22/1502:47>
Very much so for all the Ghoul variants. 
Title: Re: [6E] Excel Character Generator
Post by: Aria on <10-26-22/1408:49>
As Shadow Cast and Hack and Slash have just been released I thought I'd push out C6.29 with the infected stuff before I delve into the new data... so the links have been updated and I will be working on the new source material in .30!
Title: Re: [6E] Excel Character Generator
Post by: Aria on <10-27-22/0545:36>
Apologies to anyone who was quick off the gun and downloaded v .29 yesterday, I've made a couple of corrections and revised the links with a new .29 version
Title: Re: [6E] Excel Character Generator
Post by: Aria on <11-16-22/1756:24>
Links have been updated with Hack and Slash info, including AI's (even got it to rename the attributes for you!)

As ever, please shout if you spot any errors
Title: Re: [6E] Excel Character Generator
Post by: GinoA on <11-18-22/2311:26>
New user.  Liking the sheet very much.

However, the double/triple charging for Martial Arts that was reported by Tecumseh & Hobbes seems to have returned.

Cell '4 Qualities & MAs'!$G$493 reads =SUM(G455:G492) and should be =SUM(G486:G492)

Thank you.
Title: Re: [6E] Excel Character Generator
Post by: Aria on <11-21-22/0411:43>
Thanks!  I've changed that in the latest WIP version, got the Shadow Cast qualities to add in and then it should be available shortly
Title: Re: [6E] Excel Character Generator
Post by: Aria on <02-27-23/1712:59>
Links have been updated with the Shadow Cast quality paths added and a house rule that gives one of the qualities (the autosoft cracking) to anyone who wants it... being a rigger is expensive enough as it is and I've always assumed they could copy their code, now there are rules for it!
Title: Re: [6E] Excel Character Generator
Post by: Aria on <03-01-23/1642:44>
Quick question... I've got the new Lifestyles mini sourcebook which offers an alternative to lifestyle generation.  I've considered cherry picking bits to see if it can be worked into the current advanced lifestyle rules but it might be easier to add as a completely separate option on the excel file... would anyone find that useful?  I could just add some blank boxes so those with the sourcebook could enter the info themselves

Thoughts appreciated!
Title: Re: [6E] Excel Character Generator
Post by: Aria on <05-02-23/0747:29>
Links have been updated with the Monad rules from Whisper Nets
Title: Re: [6E] Excel Character Generator
Post by: Aria on <07-03-23/1809:46>
Links have been updated with Bestial Nature, Body Shop will follow shortly!
Title: Re: [6E] Excel Character Generator
Post by: Aria on <07-28-23/0837:25>
Links have been updated with the cyberware and bioware in Body Shop.  Nano tech etc still to follow...
Title: Re: [6E] Excel Character Generator
Post by: MrDave on <09-29-23/0907:19>
Heya
Just a quick check-in to say that I love this Generator - it's an enormous help for me and some of the others at our table
Title: Re: [6E] Excel Character Generator
Post by: Aria on <10-02-23/0507:59>
Heya
Just a quick check-in to say that I love this Generator - it's an enormous help for me and some of the others at our table
Well thank you!  The next version with the rest of Body Shop in it should be out soon... RL keeps getting in the way but I'm working on it in the background  :)
Title: Re: [6E] Excel Character Generator
Post by: Aria on <10-12-23/1127:07>
Links updated with the rest of Body Shop and some bug fixes
Title: Re: [6E] Excel Character Generator
Post by: Red Bear on <10-22-23/2231:33>
Thank you for building and maintaining this. I've been having fun building different runners. My latest is a Valkyrie Eagle shifter.

In CG6.36.xlsx, I noticed that Valkyries do not get Priority B adjustment points as shown on page 91 of Shadowrun Companion 6e.
Title: Re: [6E] Excel Character Generator
Post by: Aria on <10-24-23/0746:22>
You're welcome :)

And thanks for the spot, I've corrected it in the next version of the sheet which will come out soon(ish)... there's not much content in Astral Ways that needs inputting  ;)

A
Title: Re: [6E] Excel Character Generator
Post by: Aria on <02-18-24/1640:47>
Links have been updated with Scotophobia and Astral Ways!

Enjoy
Title: Re: [6E] Excel Character Generator
Post by: FastJack on <02-19-24/0700:47>
Awesome!