Printable Version of Topic

Posted by: Doc Chaos Jul 19 2013, 12:09 PM

*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. 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/0B9ilRupFha7zbFppX3RHa2RGbzA/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.


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

Posted by: Fyndhal Jul 19 2013, 02:19 PM

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.

Posted by: NitricAcid Jul 28 2013, 08:20 PM

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.

Posted by: Doc Chaos Jul 31 2013, 06:54 AM

Edited the first posting, version 0.2 is up.

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



I was on vacation for a week, plus Shadowrun Returns happened. 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?



1) fixed (the word is 'Ressourcen' in German, frustratingly misleading )
2) fixed

Thanks!

Posted by: Doc Chaos Aug 1 2013, 08:37 AM

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

Posted by: Doc Chaos Aug 1 2013, 10:13 AM

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

Posted by: Korwin Aug 1 2013, 12:40 PM

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

Posted by: Doc Chaos Aug 1 2013, 01:02 PM

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.

Posted by: Doc Chaos Aug 2 2013, 07:00 AM

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

Posted by: Archmike Aug 2 2013, 07:58 AM

Any chance of you doign stuff with mentor spirits?

Posted by: Doc Chaos Aug 2 2013, 08:33 AM

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

Posted by: Archmike Aug 2 2013, 09:22 AM

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




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 ^_^

Posted by: Doc Chaos Aug 2 2013, 09:42 AM

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

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.

Posted by: Doc Chaos Aug 5 2013, 08:41 AM

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

Posted by: Lusis Aug 5 2013, 11:57 PM

Awesome! Thanks!

Posted by: Doc Chaos Aug 7 2013, 09:34 AM

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.

See first post for new link and small changelog

You are welcome, glad to see this is of use to someone.

Posted by: Lusis Aug 8 2013, 09:08 PM

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 http://forums.shadowruntabletop.com/index.php?topic=12089.0

Posted by: Doc Chaos Aug 9 2013, 07:13 AM

Hm. I have some space left on the equipment page, I'll think about it and see if I can cook up something.

Posted by: faustaff Aug 10 2013, 05:06 PM

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))"

Posted by: Doc Chaos Aug 13 2013, 06:54 AM

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

You are welcome!

Thank you for the great feedback, much (many?) kudos to you, V0.6a has the errors you spotted corrected.

Posted by: Doc Chaos Aug 13 2013, 09:56 AM

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

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

Posted by: Doc Chaos Aug 22 2013, 08:04 AM

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

Posted by: Chrysalis Nov 24 2013, 07:28 PM

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

Posted by: Doc Chaos Dec 9 2013, 11:59 AM

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



Thank you!

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

Posted by: Doc Chaos Feb 19 2014, 07:36 AM

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.