Yet another Excel Based Character Genrator Options

[Flaser]

[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

[Doc Chaos]

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

[Flaser]

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

[Doc Chaos]

Ah, now I see how it works. A little confusing at first, but interesting approach. (IMG:style_emoticons/default/smile.gif)

Karma should be 25, shouldn't it?

*edit* Your new version is still locked private. (IMG:style_emoticons/default/smile.gif)

[Flaser]

Ah, now I see how it works. A little confusing at first, but interesting approach. (IMG:style_emoticons/default/smile.gif)

Karma should be 25, shouldn't it?

*edit* Your new version is still locked private. (IMG:style_emoticons/default/smile.gif)

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

[Doc Chaos]

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.

[Flaser]

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

[Pollution]

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)

[Mäx]

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.

[Fyndhal]

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.

[Flaser]

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.

[Flaser]

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

[Pollution]

Umm, you just open it with excel.

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

Disregard completely

[Fyndhal]

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

Works great! (IMG:style_emoticons/default/smile.gif) And that's one hell of an IF statement!

[Korwin]

So far it's nowhere near finished, but I'm making an early release for feedback and criticism:

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.

[Archmike]

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 (IMG:style_emoticons/default/smile.gif)

Anything in particular I should look at?

[Flaser]

...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.

[Archmike]

...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? (IMG:style_emoticons/default/smile.gif)

[Flaser]

Do you have an idea as to how you're going to implement skills yet? (IMG:style_emoticons/default/smile.gif)

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.

[Flaser]

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.

[Flaser]

...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!

[Archmike]

...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 (IMG:style_emoticons/default/smile.gif)

[ssfsx17]

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

[Rebeldawg]

...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!

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.

[Flaser]

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.