Menu
News
All News
Dungeons & Dragons
Level Up: Advanced 5th Edition
Pathfinder
Starfinder
Warhammer
2d20 System
Year Zero Engine
Industry News
Reviews
Dragon Reflections
White Dwarf Reflections
Columns
Weekly Digests
Weekly News Digest
Freebies, Sales & Bundles
RPG Print News
RPG Crowdfunding News
Game Content
ENterplanetary DimENsions
Mythological Figures
Opinion
Worlds of Design
Peregrine's Nest
RPG Evolution
Other Columns
From the Freelancing Frontline
Monster ENcyclopedia
WotC/TSR Alumni Look Back
4 Hours w/RSD (Ryan Dancey)
The Road to 3E (Jonathan Tweet)
Greenwood's Realms (Ed Greenwood)
Drawmij's TSR (Jim Ward)
Community
Forums & Topics
Forum List
Latest Posts
Forum list
*Dungeons & Dragons
Level Up: Advanced 5th Edition
D&D Older Editions
*TTRPGs General
*Pathfinder & Starfinder
EN Publishing
*Geek Talk & Media
Search forums
Chat/Discord
Resources
Wiki
Pages
Latest activity
Media
New media
New comments
Search media
Downloads
Latest reviews
Search resources
EN Publishing
Store
EN5ider
Adventures in ZEITGEIST
Awfully Cheerful Engine
What's OLD is NEW
Judge Dredd & The Worlds Of 2000AD
War of the Burning Sky
Level Up: Advanced 5E
Events & Releases
Upcoming Events
Private Events
Featured Events
Socials!
EN Publishing
Twitter
BlueSky
Facebook
Instagram
EN World
BlueSky
YouTube
Facebook
Twitter
Twitch
Podcast
Features
Top 5 RPGs Compiled Charts 2004-Present
Adventure Game Industry Market Research Summary (RPGs) V1.0
Ryan Dancey: Acquiring TSR
Q&A With Gary Gygax
D&D Rules FAQs
TSR, WotC, & Paizo: A Comparative History
D&D Pronunciation Guide
Million Dollar TTRPG Kickstarters
Tabletop RPG Podcast Hall of Fame
Eric Noah's Unofficial D&D 3rd Edition News
D&D in the Mainstream
D&D & RPG History
About Morrus
Log in
Register
What's new
Search
Search
Search titles only
By:
Forums & Topics
Forum List
Latest Posts
Forum list
*Dungeons & Dragons
Level Up: Advanced 5th Edition
D&D Older Editions
*TTRPGs General
*Pathfinder & Starfinder
EN Publishing
*Geek Talk & Media
Search forums
Chat/Discord
Menu
Log in
Register
Install the app
Install
Community
General Tabletop Discussion
EN Publishing
Working on a Spreadsheet Character Generator
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser
.
Reply to thread
Message
<blockquote data-quote="Nimmo" data-source="post: 6295580" data-attributes="member: 6671446"><p>Update 07/05/2014:</p><p></p><p><u><a href="http://goo.gl/WAkWl1" target="_blank">DOWNLOAD THE LATEST VERSION HERE</a> (Link hasn't changed, just pasting it up here for easy access)</u></p><p><u></u></p><p>Just completed another wee bit of the character sheet and whilst I have not yet completed adding all of the careers I have decided to come back to that later (as I expect that they will change anyway when the new playtest document comes out) and added the derived stats section and also managed to give the player a chance to choose an age-related trait. I am aware that the character sheet doesn't look particularly pretty at the moment but I will get to that when I have completed the rest of the basic functionality.</p><p></p><p>I am also going to share the list of things I want to do, but don't quite know how to do yet, if you have any ideas or suggestions on how to carry out these tasks then please do get in touch and let me know. Either by a reply to this thread, a PM or even an email directly to me.</p><p></p><p>ToDo:</p><p>Handle career abilities</p><p>Deal with bonuses to various attributes based on skills in careers</p><p>Add items granted by careers</p><p>Handle Weapons, Armour, Items and their various qualities</p><p></p><p>ToDo (but don't know how):</p><p>Enforce pre-requisites for careers</p><p>Enforce Skill limits based on tiers</p><p>Handle repeatable careers which have options/attributes that change when repeated (Such as taking Gambler twice)</p><p>Handle character progression with new ranks in skills, increases in attributes etc</p><p>Track XP spent and calculate costs of options for progression</p><p></p><p>That's probably enough for now.</p><p>Let's all hope that the last day of the kickstarter is a very profitable one!</p><p></p><p></edit></p><p></p><p>Update: 06/05/2014:</p><p></p><p>I figured that since this thread was having quite a few updates and there are a few links floating around that I would add a "DOWNLOAD LATEST VERSION HERE" link at the top, so here goes:</p><p><u><a href="http://goo.gl/WAkWl1" target="_blank">DOWNLOAD THE LATEST VERSION HERE</a></u></p><p>(This link will point at the latest version of the spreadsheet which will update minutes after I save it thanks to the wonders of cloud technology)</p><p></p><p>Also just to make things a little easier for everyone, I will make it clear here that this character generator is being made using Libreoffice (which should be 100% compatible with Open Office since they are both much the same package) and will likely not work with Excel. I moved over to Libreoffice from Excel as it seemed that more people had an interest in a tool being made for a free spreadsheet package than a potentially expensive and OS-dependent one.</p><p></p><p>If you look at the Documentation sheet, which is the first worksheet in the spreadsheet you should see that there are some simple instructions on how to use it and also a little list of what I've added on different dates.</p><p></p><p>As things stand it allows you to select your race, skills and careers totalling up attributes and such. I will be adding the derived stats once I have finished adding the careers to the careers table. (Which I might tweak further as I have just had an idea on how to make it easier for me to work with) then move onto handling skills and everything else after that. This evening or tomorrow I am going to write out a list of things I intend to do and know how to do, things I want to do, but haven't decided how I will do (including what I can't currently figure out) and post that up here as well.</p><p></p><p></edit></p><p></p><p></p><p>I had noticed that there was a character generator built in Excel that had been created and after getting bored today I decided to take a stab at making one myself.</p><p></p><p>Currently it is far from complete and only allows you to select your race and starter profession. My intention is to add as much automation as possible so that there is little to no manual typing in except choosing your name and that sort of thing.</p><p></p><p>[ATTACH]61462[/ATTACH]</p><p></p><p>Over the next couple of days I will try to add some formal documentation.</p><p>For now, go to the Background sheet, type in your character's name and then you can start using drop-down boxes to select your race and starter profession. If you choose a human there is a section to the right which says "Human Attribute Bonus" and you can use a dropdown box to select which attribute you wish to boost and it should all be reflected on the character sheet on the front.</p></blockquote><p></p>
[QUOTE="Nimmo, post: 6295580, member: 6671446"] Update 07/05/2014: [U][URL="http://goo.gl/WAkWl1"]DOWNLOAD THE LATEST VERSION HERE[/URL] (Link hasn't changed, just pasting it up here for easy access) [/U] Just completed another wee bit of the character sheet and whilst I have not yet completed adding all of the careers I have decided to come back to that later (as I expect that they will change anyway when the new playtest document comes out) and added the derived stats section and also managed to give the player a chance to choose an age-related trait. I am aware that the character sheet doesn't look particularly pretty at the moment but I will get to that when I have completed the rest of the basic functionality. I am also going to share the list of things I want to do, but don't quite know how to do yet, if you have any ideas or suggestions on how to carry out these tasks then please do get in touch and let me know. Either by a reply to this thread, a PM or even an email directly to me. ToDo: Handle career abilities Deal with bonuses to various attributes based on skills in careers Add items granted by careers Handle Weapons, Armour, Items and their various qualities ToDo (but don't know how): Enforce pre-requisites for careers Enforce Skill limits based on tiers Handle repeatable careers which have options/attributes that change when repeated (Such as taking Gambler twice) Handle character progression with new ranks in skills, increases in attributes etc Track XP spent and calculate costs of options for progression That's probably enough for now. Let's all hope that the last day of the kickstarter is a very profitable one! </edit> Update: 06/05/2014: I figured that since this thread was having quite a few updates and there are a few links floating around that I would add a "DOWNLOAD LATEST VERSION HERE" link at the top, so here goes: [U][URL="http://goo.gl/WAkWl1"]DOWNLOAD THE LATEST VERSION HERE[/URL][/U] (This link will point at the latest version of the spreadsheet which will update minutes after I save it thanks to the wonders of cloud technology) Also just to make things a little easier for everyone, I will make it clear here that this character generator is being made using Libreoffice (which should be 100% compatible with Open Office since they are both much the same package) and will likely not work with Excel. I moved over to Libreoffice from Excel as it seemed that more people had an interest in a tool being made for a free spreadsheet package than a potentially expensive and OS-dependent one. If you look at the Documentation sheet, which is the first worksheet in the spreadsheet you should see that there are some simple instructions on how to use it and also a little list of what I've added on different dates. As things stand it allows you to select your race, skills and careers totalling up attributes and such. I will be adding the derived stats once I have finished adding the careers to the careers table. (Which I might tweak further as I have just had an idea on how to make it easier for me to work with) then move onto handling skills and everything else after that. This evening or tomorrow I am going to write out a list of things I intend to do and know how to do, things I want to do, but haven't decided how I will do (including what I can't currently figure out) and post that up here as well. </edit> I had noticed that there was a character generator built in Excel that had been created and after getting bored today I decided to take a stab at making one myself. Currently it is far from complete and only allows you to select your race and starter profession. My intention is to add as much automation as possible so that there is little to no manual typing in except choosing your name and that sort of thing. [ATTACH]61462._xfImport[/ATTACH] Over the next couple of days I will try to add some formal documentation. For now, go to the Background sheet, type in your character's name and then you can start using drop-down boxes to select your race and starter profession. If you choose a human there is a section to the right which says "Human Attribute Bonus" and you can use a dropdown box to select which attribute you wish to boost and it should all be reflected on the character sheet on the front. [/QUOTE]
Insert quotes…
Verification
Post reply
Community
General Tabletop Discussion
EN Publishing
Working on a Spreadsheet Character Generator
Top