Shadowrun 5 Excel CharGen Sheet, Looking for testers Options

[Doc Chaos]

*edit* Since my group has switched to a different rule-system for playing Shadowrun, I no longer support this sheet. I will leave it up and if someone else wants to work in any changes that may happen (or already have happened, I did not read the errata), feel free to do so. */edit*

Hi chummers!

I put together a CharGen sheet in Excel and I am pretty sure there's problems in there (nothing is ever that good on first draft), so I am asking for help in spotting mistakes I made. (IMG:style_emoticons/default/smile.gif) This is not a fully fledged Character Generator and it will never be. The design goal is a rather lightweight support tool to help with the number crunching of Priority system based character creation.

The sheet can be downloaded here: https://docs.google.com/file/d/0B9ilRupFha7...3RHa2RGbzA/edit V0.6d

This sheet uses VB scripts! If you don't trust me in that I have no reason whatsoever to spread a virus or something, don't download it.

Any help is greatly appreciated. (IMG:style_emoticons/default/smile.gif)


Changelog

V0.6d - Fixed spelling mistake

V0.6c - Fixed calculation of Modified Initiative on Character Creation page; expanded Cyber/Bioware field on Character Creation page; fixed error in Astral Initiative visuals; removed unnecessary Additional Connection Points field; changed method of Qualities karma gain/cost calculation; various formating fixes

V0.6b - Fixed error in calculation of Magic and Resonance attribute on Character Sheet page;

V0.6a - Fixed calculation of 'Power Points Left' on Character Sheet page; fixed calculation of Initiative on Character Sheet page; fixed Magic attribute reference on Character Sheet page

V0.6 - Fixed calculation of Attributes-Only Test pools; Added the first page - Character Sheet

V0.5b - Karma raise of free skills and skillgroups should now work correctly

V0.5a - added Modified Rating and Karma point raise to Knowledge and Language skills box

V0.5 - added option for Mystic Adept Power Points; Free skills of certain Magic user types fixed

V0.4 - Karma cost for Attribute, skill group and skill raises now calculated by sheet (kudos to Flaser for passive help with the formula!); method of Karma raise changed (again, kudos to Flaser for the idea)

V0.3 - Added Attribute-Only Tests and base carrying capability; calculation of Magic and Resonance attribute now factors in loss of Essence; modified Limits now factor in Karma Raise

V0.2 - Fixed spelling (Resources), added Contacts, fixed calculation of Resources (Lifestyle cost now factored in correctly)

V0.1 - Initial Draft


Known bugs/problems:

The sheet does NOT support breaking up Skillgroups when spending Karma. At this point I am not sure if it ever will.


Known mistakes:

None at the moment

[Fyndhal]

Downloaded, but AFB. I'll poke around during my lunch break and see if I spot any issues.

EDIT:
The obvious first comment is there is no data pre-entered -- no dropdowns for Advantages/Disadvantages, Gear, Powers, Spells and such. That's more than likely still on the "ToDo" list, but I figured I should mention it.

Other than that, I played around with swapping priorities around and got the expected warnings, races and special attributes seemed to work properly, as did adding positive and negative advantages. I'll play around with skills and specializations later to make sure they are correct.

Definitely a good start.

[NitricAcid]

Did you keep working on this? It's the best from the ones I've seen - yeah, there aren't pulldowns, but that's fine for me.
A few things I added myself [and so should be added to the 'official' version]:
1) A 'contacts' session + contact point counter
2) Composure/judge intentions/lift+carry/Memory information
3) Stun/Wound counter
4) I made the skill tables actually look at the 'karma raise' tables, so it'll show the 'rating' as whichever is highest.

There were only two things that were 'broken' [and, not at all big deals] that I noticed:
1) It's spelled "Resources" [you got this right at least once, so..?]
2) Your resource-counter isn't including lifestyle cost. Just have to move the little box-selector-thing down one.

[Doc Chaos]

Edited the first posting, version 0.2 is up. (IMG:style_emoticons/default/smile.gif)

EDIT:
The obvious first comment is there is no data pre-entered -- no dropdowns for Advantages/Disadvantages, Gear, Powers, Spells and such. That's more than likely still on the "ToDo" list, but I figured I should mention it.
Definitely a good start.

Thank you. (IMG:style_emoticons/default/smile.gif) Additional dropdowns are not planned. This sheet is meant as a support with the number crunching in character creation, not a fully fledged character generator. IMHO nothing beats the fun of going through the book(s) when creating a new character. (IMG:style_emoticons/default/smile.gif)

A few things I added myself [and so should be added to the 'official' version]:
1) A 'contacts' session + contact point counter
2) Composure/judge intentions/lift+carry/Memory information
3) Stun/Wound counter
4) I made the skill tables actually look at the 'karma raise' tables, so it'll show the 'rating' as whichever is highest.

I was on vacation for a week, plus Shadowrun Returns happened. (IMG:style_emoticons/default/wink.gif) Thank you for your feedback!

1) Added in V0.2, thanks!
2) Not sure if I will include that in the Character Creation page of the sheet, but it will be in the Character Sheet page of the sheet.
3) as 2)
4) I can't really visualize what you mean, would you kindly send me your version?

There were only two things that were 'broken' [and, not at all big deals] that I noticed:
1) It's spelled "Resources" [you got this right at least once, so..?]
2) Your resource-counter isn't including lifestyle cost. Just have to move the little box-selector-thing down one.

1) fixed (the word is 'Ressourcen' in German, frustratingly misleading (IMG:style_emoticons/default/wink.gif) )
2) fixed

Thanks! (IMG:style_emoticons/default/smile.gif)

[Doc Chaos]

V0.3 is up, see first post for new link and changes

[Doc Chaos]

V0.4 is up, see first post for new link and changes

[Korwin]

Thank you. (IMG:style_emoticons/default/smile.gif) Additional dropdowns are not planned. This sheet is meant as a support with the number crunching in character creation, not a fully fledged character generator. IMHO nothing beats the fun of going through the book(s) when creating a new character. (IMG:style_emoticons/default/smile.gif)

Should'nt Exceptional Attribute raise the maximum?
I am able to raise it over maximum, so that my be working as designed...

[Doc Chaos]

Should'nt Exceptional Attribute raise the maximum?
I am able to raise it over maximum, so that my be working as designed...

At the moment there is no cross-check of metarace-attribute/max-attribute/rating and the shown max ratings are not dynamic. I am unsure if I will implement this, it would require extensive programming.

[Doc Chaos]

V0.5 is up, see first post for new link and changes

[Archmike]

Any chance of you doign stuff with mentor spirits?

[Doc Chaos]

Any chance of you doign stuff with mentor spirits?

In what way would you like to see Mentor spirits in the sheet?

[Archmike]

In what way would you like to see Mentor spirits in the sheet?

Well in an ideal world:

i take mentor spirit as a quality then pick from a drop down list, then dependent on whether I'm an adept or magician the relevant stuff is added to the sheet (IMG:style_emoticons/default/smile.gif)




Edit: Actually thinking about it the "ideal" world situation would be to select the quality then have my chosen spirit mentor appear next to me and grant me magic powers but i think that's expecting a bit much from excel ^_^

[Doc Chaos]

Version 0.5a is up, see first post for new link and changes

Well in an ideal world:

i take mentor spirit as a quality then pick from a drop down list, then dependent on whether I'm an adept or magician the relevant stuff is added to the sheet (IMG:style_emoticons/default/smile.gif)

Sorry, but no. I don't do dropdown lists for qualities etc., as this would require extensive programming across the whole sheet and take it from number crunching support far into full CharGen territory.

[Doc Chaos]

Version 0.5b is up, see first post for new link and changes

[Lusis]

Awesome! Thanks!

[Doc Chaos]

Version 0.6 is out - big update

Version 0.6 now has the first page, the Character Sheet. This is automatically filled with everything you put into the Character Creation page. It also has some additional features:

-Karma tracker (complete with calculation of Streed Cred)
-Calculation of Condition Monitor boxes
-Calculation of either Astral Attributes or Living Persona

The Character Sheet page is kind of printer-friendly, although I realize the sheet is not much use if used as a hardcopy. (IMG:style_emoticons/default/smile.gif)

See first post for new link and small changelog

Awesome! Thanks!

You are welcome, glad to see this is of use to someone. (IMG:style_emoticons/default/smile.gif)

[Lusis]

You are welcome, glad to see this is of use to someone. (IMG:style_emoticons/default/smile.gif)

Np, my whole group on Rolld20 is using this sheet to roll toons.

BTW, on thing I see some people needing with the new wireless Matrix rules is a means to network diagram our wireless devices. At least that's what I wish for when I read threads like this

[Doc Chaos]

Hm. I have some space left on the equipment page, I'll think about it and see if I can cook up something. (IMG:style_emoticons/default/smile.gif)

[faustaff]

Thanks for the sheet. I really appreciate the time spent on this endeavor.

There are two problems I found on the new Character Sheet Page so far. First, Initiative is pointing at Logic as opposed to Intuition. Magic is pointing to C42 instead of D42. Both are easy enough to fix, but I thought you might want to know for future updates.

*EDIT* Also "Power Points left" should have the formula "=M59-(SUM(O62:O84))"

[Doc Chaos]

Version 0.6a is up, see first post for new link and changes

Thanks for the sheet. I really appreciate the time spent on this endeavor.

There are two problems I found on the new Character Sheet Page so far. First, Initiative is pointing at Logic as opposed to Intuition. Magic is pointing to C42 instead of D42. Both are easy enough to fix, but I thought you might want to know for future updates.

*EDIT* Also "Power Points left" should have the formula "=M59-(SUM(O62:O84))"

You are welcome! (IMG:style_emoticons/default/smile.gif)

Thank you for the great feedback, much (many?) kudos to you, V0.6a has the errors you spotted corrected. (IMG:style_emoticons/default/smile.gif)

[Doc Chaos]

Spotted an error, had to do a quick hot-fix:

Version 0.6b is up, see first post for new link and changes

[Doc Chaos]

Version 0.6c is up, see first post for new link and changes

[Chrysalis]

This is really helpful when creating a character.

Will you also add a function for weapons and armour next?

There is also a spelling mistake on the first worksheet Foki instead of Foci.

-Chrysalis

[Doc Chaos]

This is really helpful when creating a character.

Will you also add a function for weapons and armour next?

No. This is not a Character Generator, just a sheet to support you with the number crunching during character creation.

There is also a spelling mistake on the first worksheet Foki instead of Foci.

-Chrysalis

Thank you! (IMG:style_emoticons/default/smile.gif)

*EDIT*: Version 0.6d is up, see first post for new link and changes

[Doc Chaos]

Since my group has switched to a different rule-system for playing Shadowrun, I no longer support this sheet. I will leave it up and if someone else wants to work in any changes that may happen (or already have happened, I did not read the errata), feel free to do so.