Shadowrun
Shadowrun Play => Character creation and critique => Topic started by: Aria on <08-29-19/1234:55>
-
(https://drive.google.com/uc?export=download&id=1d1QWyni0V3LS-fWG4TIa9yKCpEURMKTN)
LINK UPDATED! 6.40 with Tarnished Star and Lethal Harvest gear
Enjoy
Dropbox <CG6.40> (https://www.dropbox.com/scl/fi/0ydpz9m48izgo5u2p0h1t/CG6.40.xlsx?rlkey=iualpmgo8xdttvybjq8rayvsm&st=gnshxmyl&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!
-
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.
-
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 :)
-
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.
-
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.
-
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!
-
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!
-
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!
-
Another bug. On Qualities page, the formula for counting the # of Qualities taken should be =SUM(C11:C123), to capture Positive Qualities as well.
-
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
-
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!
-
This is great work! I'm struggling a little to parse exactly how to fill it out...but that's part of the fun ;)
-
There are some instructions of sorts on the priorities tab, can try and make them clearer...?!
-
look at priority columns from left to right. a 1 in the row of that column maps to the priority level.
-
Thanks guys...figuring it out...just required a little more brainpower than I’m used to. ;D
-
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
-
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?
-
After a few posts it goes away. Unless you're AI.
-
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.
-
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!!
-
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?
-
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
-
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).
-
Oops! They aren’t in the equipment section so I missed them, will get them on tomorrow!
-
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.
-
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
-
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
-
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
-
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.
-
Quite happy to have multiple autosoft slots... the row can also be copy pasted and it will still calculate in the total
-
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.
-
Hmmm... not on the table in the CRB so unless there’s an errata I guess it’s the same as rifles??
-
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.
-
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.
-
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...
-
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.
-
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!
-
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)!!
-
Is there an instruction guide anywhere on how to use this? I looked at it and was a bit confused.
-
The priorities tab has some brief notes on it, I can add some more detail there if needs be?
-
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.
-
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
-
Just noticed in the Cyber & Bio tab that strength for limb options was spelled "Strenght". :)
-
I’ll sort that out, the perils of ‘touch typing’ and not spell checking ::)
-
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.
-
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.
-
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
-
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)
-
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!
-
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 ::)
-
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.
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.
-
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!
-
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.
-
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 :)
-
Did the cost of used grade ware got errata?
It's 0.5 of base cost in the book but 0.75 in Excel.
-
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.
-
Oops, I think that may be a hangover from SR5, will fix tomorrow :P
-
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!
-
You find used CYBER icky?! Try used BIO!
-
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 :)
-
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.
-
Aren’t they mechanically the same thing now? Pick a mentor spirit and you’re a shaman...??
-
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.
-
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
-
Also drain for Adepts is BOD + WIL.
"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.
-
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...!?
-
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.
-
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.
-
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!
-
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!
-
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)
-
Thanks, I've made those changes and I'll update the link in a sec!
-
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).
-
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
-
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?
-
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...
-
Unarmed damage is not calculating correctly with dermal deposits at least. Should be str/2 +1 but it never adds in the +1
-
I spotted that! Built tough is added in but I’m tweaking the next version so that it shows up meta qualities automatically
-
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
-
Would it be possible to have the final “Sheet” tab include a column that listed the Attributes used for each Skill?
-
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...
-
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
-
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.)
-
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.
-
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.
-
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 :)
-
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.
-
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!
-
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!)
-
I spoke too soon lol... will check those and try to upload tomorrow...
-
Took some head scratching but I think it's right now... link updated!
-
Took some head scratching but I think it's right now... link updated!
Link still takes me to the draft. :D
-
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
-
Beautiful!
I have 10 pregens to make by Saturday and this will help a lot!
-
Good luck!
This may help: Ajax's reworked archetypes (https://forums.shadowruntabletop.com/index.php?topic=30450.msg529613#msg529613)
-
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!
-
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.
-
Thanks for the notes, I’ll look in to it ASAP and sort it out!
-
I've made those tweaks and uploaded the latest version. If you spot anything else please let me know :)
-
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
-
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!
-
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 :)
-
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
-
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
-
Thank you! I've been using this generator extensively and it's been very helpful.
-
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!
-
Thanks for this one as well!
-
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)
-
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)
-
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?
-
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...
-
Spotted a glitch that has been corrected... same link will work, apologies to anyone who's already downloaded .05 :-\
-
<CG6.xx> (https://drive.google.com/file/d/1Dtg8kb9izi6MxzJn-y-lOjfzM5YF9Uo9/view?usp=sharing) v6
-
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
-
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.
-
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)
-
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.
-
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).
-
Link updated with v.10 which includes Returning Soldiers from Slip Stream and some bug fixes
-
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
-
Link has been updated to version 12, with another character sheet output, some houserule calculations added etc
-
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)
-
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
-
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 :)
-
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
-
Link has been updated with Traditions info from Street Wyrd on the Mentor spirits tab
-
Link updated with Power Play qualities!
Enjoy, some fun ones in there!
-
Link updated with version 19, adding 'knock off' as an option on the weapons tab plus the SRM FAQ spells
-
Link updated to Dropbox to make it easier to download :)
-
Link updated with the Seattle City Edition of the core rulebook info
Also a copy of my 6E spirits excel generator in there too
-
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!
-
Link updated with v23
-
Any particular version / year of Micro$oft Office required or does this work on 2016ish versions?
-
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?!?)
-
It also works just fine when turned into a google docs spreadsheet :-)
-
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)
-
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!
-
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.
-
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!
-
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
-
Aria, any plans to add point buy / Companion source material?
-
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
-
Links in the first post have been updated to Point Buy and general qualities from Sixth World Companion, enjoy!
-
Links have been updated with the metavarients, changelings, non-metahumans (although not infected yet) and some house rules from Sixth World Companion
-
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
-
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.
-
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!
-
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).
-
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
-
+1
Thanks!
-
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.
-
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
-
Very much so for all the Ghoul variants.
-
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!
-
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
-
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
-
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.
-
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
-
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!
-
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!
-
Links have been updated with the Monad rules from Whisper Nets
-
Links have been updated with Bestial Nature, Body Shop will follow shortly!
-
Links have been updated with the cyberware and bioware in Body Shop. Nano tech etc still to follow...
-
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
-
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 :)
-
Links updated with the rest of Body Shop and some bug fixes
-
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.
-
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
-
Links have been updated with Scotophobia and Astral Ways!
Enjoy
-
Awesome!
-
Links updated for C6.38 with Falling Point, FastJack's Zero's Grimoire and some other minor tweaks
Dropbox: <<CG6.38>> (https://www.dropbox.com/scl/fi/ga5goc7g9im3dst85mz1d/CG6.38.xlsx?rlkey=a3s1xayohbb0vqon7nfstmb8i&st=0l20k1if&dl=0)
-
Links updated with Smoot Operations!
Enjoy
-
Links have been updated to 6.40 with Tarnished Star and Lethal Harvest gear
Enjoy!