NOTE: Update on page 2 of thread! Link is the same!Hey all,
So I built this chargen spreadsheet for my group. I put a lot of work into it and every week I find more and more little odds and ends of the game that it doesn't handle well, etc. So I thought I would release it publicly and see what you folks could come up with for suggestions/fixes. What I am looking for is more or less suggestions on how to streamline the thing better, and to accommodate anything it is missing/needs as a baseline.
https://dl.dropboxusercontent.com/u/54799709/SR5%20Chargen.xlsx (made with Excel 2010)
It is missing some key features:
- Karma upgrades correctly change your skills, but they do not actually have their costs properly calculated yet. Raising attributes does in fact calculate out its proper karma cost, however.
- For qualities, I haven't done it yet, but I'd like to make a dropdown list just so you don't need the book in front of you. This is a low priority however.
- I am aware that a few of the skills are wrong, due to misinterpretations based on misprints in the book (like Herding, for example).
- The sheet, generally, does not have any methodology for advancement. What I am planning to do is make an additional sheet for data entry on another table that essentially copies all of your existing stuff from chargen, but adds up costs differently without including initial stuff. Or perhaps just a checkbox on the main data entry page.
- All skills automatically include their related attribute in their dice calculations. I plan on making an option to turn this off, but right now that is what it does.
- Most calculations ignore the base attribute and only use the modified version right now. So if you have cyberware that makes you strength 9, that is what gets used to factor into skills...not your base strength.
Any suggestions are welcome. Don't worry about being harsh; I can take criticism well enough, especially considering I knocked this together in about a week and a half!