An excel character generator that I've been working up since the beginnings of SR5 with help from a large number of people listed on the front page. Hope it's useful!
EDIT: Version .26 available with various bits tidied up and No Future stuff added
<<CG5.26>>
EDIT: Version .25 with a 'pretty sheet' added...let me know what you think!
<<CG5.25>>
EDIT: Version .24 added with Better than Bad crunch
<<CG5.24>>
Version .23 added with Kill Code
<<CG5.23>>
Version .22 added with Street Lethal
<<CG5.22>>
Any comments / suggestions please let me know!
A
Full Version: Excel Character Generator SR5
I appreciate the amount of work put into this, and that you are sharing it freely.
Is there any instructions on it's use anywhere? I did look through the pages, but didn't see anything.
Maybe I'm not enough of an Excel guru, but it doesn't seem intuitive to me at all.
I don't want to seem mean, but what is the incentive to use this sheet over something like Chummer?
I'm all for options, and alternatives to installed Windows apps are always welcome. But at first glance, it appears the learning curve for this sheet is much steeper.
Is there any instructions on it's use anywhere? I did look through the pages, but didn't see anything.
Maybe I'm not enough of an Excel guru, but it doesn't seem intuitive to me at all.
I don't want to seem mean, but what is the incentive to use this sheet over something like Chummer?
I'm all for options, and alternatives to installed Windows apps are always welcome. But at first glance, it appears the learning curve for this sheet is much steeper.
There might have been instructions once upon a time... but they may have disappeared into the ether... I think the only ones left are on the Priorities Tab which more or less align with CG in the core book, ie steps 1-9, then go through the tabs in turn.
Typically grey boxes with thick black outlines are meant to be filled in (when they turn blue so you can see them more easily) and yellow boxes require player input of values. Eventually the plan was to lock the file so only these could be manipulated so feel free to lock it if it helps? I could probably add these basic instructions in somewhere in the next revision...
I could rename the Priorities Tab to 'start here' or something if that would help? There will always be some manual filling in of the sheet with gear, spells etc as that's where my excel skills fail
I've never used Chummer myself, but in the past I found that similar programs were great but didn't offer the rules summaries I've tried to attach to each spell, piece of gear etc. As my knowledge isn't encyclopaedic I found myself missing lots of good stuff just because I forgot about them!
And at the end of the day it's set up for me to use, if it's helpful to others brilliant
Typically grey boxes with thick black outlines are meant to be filled in (when they turn blue so you can see them more easily) and yellow boxes require player input of values. Eventually the plan was to lock the file so only these could be manipulated so feel free to lock it if it helps? I could probably add these basic instructions in somewhere in the next revision...
I could rename the Priorities Tab to 'start here' or something if that would help? There will always be some manual filling in of the sheet with gear, spells etc as that's where my excel skills fail
I've never used Chummer myself, but in the past I found that similar programs were great but didn't offer the rules summaries I've tried to attach to each spell, piece of gear etc. As my knowledge isn't encyclopaedic I found myself missing lots of good stuff just because I forgot about them!
And at the end of the day it's set up for me to use, if it's helpful to others brilliant
QUOTE (Aria @ Jul 20 2017, 07:04 AM) 
And at the end of the day it's set up for me to use, if it's helpful to others brilliant
That is a perfectly acceptable answer.
And with that answer, the sheet becomes more clear to me. I took it as "here is this sheet I made for any who want to use it," which it didn't quite live up to.
As someone familiar (only barely) with spreadsheet coding I was looking at the first page thinking "it looks like I shouldn't change anything here, and yet it looks like I should start filling in these values."
For public consumption, some brief instructions are necessary. Something like
QUOTE
Start with the Priorities Tab.
Typically grey boxes with thick black outlines are meant to be filled in (when they turn blue so you can see them more easily) and yellow boxes require player input of values.
would be a good start.
Typically grey boxes with thick black outlines are meant to be filled in (when they turn blue so you can see them more easily) and yellow boxes require player input of values.
That passes my "newb friendly" check.
The only problem is, I am not a total newb.
The real test, if you were so inclined, would be to hand a copy to someone who was familiar with Shadowrun 5e, but completely unfamiliar with spreadsheets, and see if they could muddle through making a character on their own.
For its' purpose, it looks good to me though.
The only problem is, I am not a total newb.
The real test, if you were so inclined, would be to hand a copy to someone who was familiar with Shadowrun 5e, but completely unfamiliar with spreadsheets, and see if they could muddle through making a character on their own.
For its' purpose, it looks good to me though.
Still testing other things, but so far this extremely helpful to my laziness.
Thank you!
ETA: I'm an idiot & didn't notice the grey box... too many years of those not being editable I guess. Sorry about that!
Personally, I'd also probably build the increase tables to automatically treat inputs as 0 or 1, or mark with a colour anything other than a 0/1 so people don't give themselves a discount on ability buy-ups. And add auto-colour for trying to put too many skill pts into one skill, using more than allowed attribute pts or 2+ attribs at max, etc. And I don't see if / how you handled aptitude & 13 in a skill, but those are minor quibbles.
-m
This is cool. I've been spending the last while looking at it.
FYI, sheet 1b Life Module Calcs has some bad cell references.
Specifically, D35:51 should be referencing cells 2 higher than they are. EG: ='1a Life Modules'!D36 should be ='1a Life Modules'!D38
Actually, looking at it, it's the entire column starting at D35 and going to the end that is affected.
FYI, sheet 1b Life Module Calcs has some bad cell references.
Specifically, D35:51 should be referencing cells 2 higher than they are. EG: ='1a Life Modules'!D36 should be ='1a Life Modules'!D38
Actually, looking at it, it's the entire column starting at D35 and going to the end that is affected.
Thanks for the spot! I'll amend the file now and re-upload it!
I like it alot, its a bit weird at first but I figured it out eventually. The only thing I'd want to see is a prettier print out sheet similar to DKs 4e sheet. It doesnt have to be heroforge or anything.
Fair enough... I tend to use it as a text export for Obsidian Portal but maybe I'll see what I can come up with 
Version .25 with a 'pretty sheet' added...Tete, or anyone else, please let me know what you think!
<<CG5.25>>
<<CG5.25>>
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.