[SR5] Excel Based Character Generator

I've started to create my own excel based character creator, using the priority system from the new core-book. So far it's nowhere near finished, but I'm making an early release for feedback and criticism:

Version 0.11:
https://docs.google.com/file/d/0B7KaFhodT908N0FwS19IT01Bclk

Changing the priorities doesn't work in Excel 2003, the dropdown entries are empty.

I must've uploaded a version, where priorities were already set... Excel is a bit boneheaded about this. Either hit "Delete", or just select one of the blank fields. The later behavior is intentional, as you assign priorities, the priority list gets pruned.

A new version (with partial Quality support impleneted) has been uploaded:
https://docs.google.com/file/d/0B7KaFhodT908dVFFTFpOWUQxQjg

Ah, now I see how it works. A little confusing at first, but interesting approach.

Karma should be 25, shouldn't it?

*edit* Your new version is still locked private.

Fixed the access issue... and indeed it should be 25 karma, just type the new value into E8.

Kind of a bug: if you set a quality with sub-properties, but change that quality to one that doesn't have sub-properties, you cannot delete the sub-property.

I'm afraid that's a bug users will have to live with, as I can't dynamically erase a cell's value when another's value is changed without resorting to VB scripts (AKA macros). For security reasons and maximum compatibility, I'd like to keep this as "vanilla" Excel as possible. Just hight-light the cell and hit "Del".

EDIT:
Newer version, added more qualities, further refinements
https://docs.google.com/file/d/0B7KaFhodT908ZDNqQTlqOGJ1NkU

Dumb-Dreck question, but how does one test this version? Do you have to have visual studio to run it? or can you use Chummer's file structure to get it going?

(I'm an excel guy, coding isn't my strong point, but I'm willing to give the datafiles a go)

Umm, you just open it with excel.

Selected Code of Honor: Warrior's Path and got -15 points for it. That is correct. However, I then picked "Insomnia" and "Severe" and it gave me 0 points. Same happened with Allergy. It looks as if it is giving Base Points only for Qualities -- it isn't grabbing the values in the tables below.

That's because I haven't implemented the lookup of quality sub-choices... I'm still thinking about how I want to do this.

Try now, the proper formula has been developed:
https://docs.google.com/file/d/0B7KaFhodT908TFIwanRZN0tleUU

And, this was posted in the wrong topic, of course.

Disregard completely

Works great! And that's one hell of an IF statement!

Not shure if its on the todo list, or got missed.
I think its the former... Anyway
Mystic Adepts --> way to buy power points with Karma.
I think it should be somerwhere by the attributes, which is the reasion I think it might have been forgotten.

It might be a good idea, to post the todo list, so you dont get false/redunant bug posts.

Made an account just to tell you that this sheet is looking amazing keep up the good work!

Been trying to figure out how to do various bits and peices to see if i can speed things along. If i have any breakthroughs I'l llet you know

Anything in particular I should look at?

...and another update:
https://docs.google.com/file/d/0B7KaFhodT908bHQ4Ykpta3ZjTFE

The sheet now has most of the code for Augmentations committed. Am working now on the implant location feature - to track capacities - and will work on implants affecting stats and limits later.

Do you have an idea as to how you're going to implement skills yet?

I don't want to use a drop-down list for skills, as you can use even ones you default on, and skillwires allow a quick change of your skillset... the only exception might be exotic skills, but then I'll simply let you type in the parameters.

I will probably list them together with skillgroups, so the user can imediately see which group affects which skills. Next to each skillgroup and skill will be a field for buying ranks with skillpoints/skillgroup points, then a field to do the same with karma. Finally a field showing your effective pool, maybe a field showing what the linked stat is. What I'm not sure is how I'll handle the breaking of skillgroups, maybe I'll put a drop-down somewhere that lets you toggle it between yes/no, and make the skillgroups data-validation, so you can only spend further points if all the skills have the same rank.

Another update:
https://docs.google.com/file/d/0B7KaFhodT908WGpLZk9aZGdpVUk

The augmentation section is finally done, correctly tracking capacities, costs, availability and essence. It doesn't (yet) affect attributes. Also added calculation for condition monitors on a whim.

...and another update:
https://docs.google.com/file/d/0B7KaFhodT908TEJmQlVuaVFsZ2s

No new features this time, just a bunch of refinements and lots of bugfixes! Turns out my augmentation code had lots of iffy things in it... shame on you people for not booing at me!

Awesome! Loving this sheet

This sheet is awesome! Especially for not using macros, and therefore LibreOffice liking it too!

I could be wrong, or may even be doing something wrong but whenever I choose my priorities and then go to choose race no matter which race I choose it affects karma negatively. After choosing, let's say for example Orc, at the top of the right hand sheet it shows karma correctly at 25, but at the bottom it shows karma as being 0. It's even worse if human is chosen as it'll show karma as -10 regardless of which priority is chosen for meta-type.

I've unintentionally left 2 in the karma field of edge, meaning the sheet automatically tries to raise edge 2 ranks. (The differing cost is because humans have a starting edge of 2). Remove the number and karma expenditures should normalize.

Char Sheet, Magic Rating should reference D42 not C42?

ie.: =WENN('Character Creation'!F42="";'Character Creation'!D42;'Character Creation'!F42)
instead of =WENN('Character Creation'!C42="-";"";'Character Creation'!C42)

Please give me a specific location (which sheet, which cell) for the formula and whether you're referring to the cell content or data validation as I can't even locate the section you're talking about.

C33 on 'CharacterSheet'

There is no sheet titled 'CharacterSheet' in my work, C33 on the 'Character Creation - USE THIS!' sheet is a drop-down box, its data validation formula is not the one you're referring to. What file are you looking at to begin with?

I chose ECDBA for my priorities, Human for metatype, and Adept for subtype, and my Karma went to -10. Is it supposed to do that? It looked like because of my natural minimum 2 to Edge, it was deducting Karma for it (35 points worth?)

Check the white, Karma column next to edge. I've unintentionally left number 2 typed into that cell in the latest release.

I was just about to edit my post: you are correct. Thanks!

Excellent work so far. Kudos!


I assume that the skill section is on the to-do list as my download didn't have one.

I second this! You still working on it? I only ask cos none of your links are working for me

Great sheet. I am just too stupid to figure out how the qualities work. I can select them. They give me costs but they are not substracted from the karma...
(Works now fine. I guess I had some accident in excel after reloading the version it worked...)
(Could you edit the first post and but the most advanced versions there?)

So far this is looking really good. I only have 1 suggestion so far... Can you make the Augmentations section a bit larger? There are a lot of low cost, low essence items that can be squeezed in for Resources-A characters.

Due Real Life™ issues, I was away for a while, but I finally had some time to continue development.

Here is version v0.10, with Skill support:
https://docs.google.com/file/d/0B7KaFhodT908S2t6ZUFNMGpKZDA

Here's a new version, at user request I've expanded the Augmentation list to 25 items... something that turned out to require a lot more changes than I initially assumed. I *tried* making it, just "drag & dropable" but unfortunately the spreadsheet is smeared over too many sheets to facilitate this. (At least, I've made almost every range used in the calculation, named & dynamically expanding).

Version 0.11:
https://docs.google.com/file/d/0B7KaFhodT908N0FwS19IT01Bclk

Disregard, updating LibreOffice resolved.