Excel Character Builder

By Bren_Waynero, in Star Wars: Edge of the Empire RPG

Thank you for the update.

I would love to see the AoR stuff just integrated into this sheet. My hope is that you could have a character that started EotE and then joint the Rebellion. I think that obligation and duty could exist for a character at the same time.

thanks,

Duncan

I would prefer to keep it as one sheet. I see plenty of opportunity to have characters from both systems mixed up in the same campaign, and drawing from the talent trees in both books.

Well, as luck would have it (sorry, not that lucky, it's not done yet) I am working on it. I have the new species in, the addition of Knowledge (Galactic Civil War), and the new careers and specializations. I am working on the new Force powers and the Duty information. And now I need some feedback for layout issues. With the new additions, it looks like I will need to add another sheet for printing off. What I am thinking of doing is leaving page 1 as is (NOTE: I used up the 'other' option under knowledge skills to get Galactic Civil War in there and am working on adding a notation next to the skills dice pool to indicate which pools could be modified due to talents). For page 2, I would like to remove the talents and SA's from the bottom and use the additional space to add the Duty system as well as expand the Obligation and Motivation areas. I was also thinking of expanding the weapons & armor inventory to perhaps allow for attachments/mods to be listed with the appropriate weapon/armor. For page 3, I would change it to be just the Talents and SA's, and add a page 4 for Force powers and additional talents, similar to the current page 3. Thinking toward the future, with FaD there will probably be many more Force powers added, as well as a new mechanic similar to Obligation or Duty. So my spacing may need to change again depending on how this one goes. So, if you users have any additional ideas or recommendations on page layouts, please share them... quickly. the sooner decisions are made, the sooner I can get something out there with all the options. Thanks.

While you are working on it anyway, I figured now might be a good time to ask for the following:

http://www.picpaste.com/pics/Criticals.1377103247.JPG

This is a small modification a couple of us in my group have made in order to track critical injuries a bit better. Since each one is healed differently, we can just mark what type of critical we have and then the medic/PC can choose which one they want to heal. (You could obviously center and clean things up better on your end than my lazy version did) :)

I like that. I may indeed try adding something like that to the layout.

Superb work, and my thanks for adding the Open Office version. Much appreciated!

Edit: It does not appear that custom skill choice under Custom species is currently working; the drop-down menu for bonus skills is blank.

Also, it looks like the starting Skill Ranks for all skills is set at 2. Which is nice, but seems a bit much. :)

Edited by Direach

Here we go...

Version 1.05 is up... SWEotE CharSheet 1.05.xlsx

Now with Age of Rebellion Beta possibilities.

Newest fixes and additions -

Added Species from the AoR Beta, and removed them from the Unofficial Species Menagerie listings.

Added new Careers and Specializations from AoR Beta. This includes skill selections for each, and talent trees.

Added Galactic Civil War (Int) to the skills page and the character sheet. No longer have "other" option under Knowledge skills.

Added Force Powers from AoR Beta.

Added new Motivations from AoR.

Moved Motivations from Obligation-Career tab to it's own tab. Also added dropdown to select type of motivation to limit the specific motivations list to only include appropriate choices.

Added new gear/equipment from AoR Beta.

Added Duty mechanic from AoR to it's own tab.

Changed layout of Char Sheet(s)... Pg 1 now has difficulty sections under the critical injury section to help coordinate injuries by severity. Pg 2 had Duty added, lost multiple lines of Talents/SA's. Pg 3 is now only Talents/SA's. Added pg 4 for a few more talents plus Force Powers. (NOTE: There will be more layout changes, but for now I wanted to get something out there)

Fixed 'Custom' Species option to list skills in bonus selection dropdown.

On Armor & Weapons tab, changed label for weapons from 'Equipped' to 'Carried'... only weapons with a quantity and being carried (choose 'Yes' or 'Built In') will be displayed on the character sheet.

Fixed Encumbrance of weapons to only count what is carried.

Please keep an eye out for the ever present errors. And be aware, I will be updating the layout of the sheets in time. Especially page 2, I made a quick change so that I could get it out this weekend. It works as is, but I know I can do better when I have more time. I will continue to work on it as I get input from you, and as the beta test moves forward and changes are made.

So... happy gaming!

Edited by Bren_Waynero

Thanks yet again for keeping this updated, particularly with the new material.

You, sir, ROCK! Thanks!

Will not allow me to take 1 rank in Vigilance as a Gand for my 4th Career Skill Choice.

No problems with that in your previous program.

Will not allow me to take 1 rank in Vigilance as a Gand for my 4th Career Skill Choice.

No problems with that in your previous program.

If you're getting the 'Your selection is either not a career skill, or you already have four career skills chosen' pop up... This has been an issue from the beginning. The work around is to not hit enter, tab, or arrowing away after marking your last choice, but rather mouse click away to another box. If this doesn't work, you may have a 'space' in one of the boxes... a 'space' counts as a mark. If you need to remove a choice, it needs to be deleted, not just overwritten with a space. Someday maybe I'll figure out a better way to limit selections, but I need the limitations in there to keep PC's legal... so to speak. :)

I just don't recall that being a problem with the other. Thanks for the quick reply though!

I f@&%ing love you Bren.

Just sayin'

this file is a blast. heavy blast from a heavy blaster pistol :D

Is there a way to disable all AoR options for those of us that aren't using it?

Is there a way to disable all AoR options for those of us that aren't using it?

At this time, no there isn't. I do want to set things up at some point with options of what material to include. EotE, AoR, the GSA's USM, FaD (eventually), etc... But that probably won't happen for awhile. Sorry. Until then, at least the AoR selections is (for the most part) nearer the bottom of the drop down lists, or in the case of Duty has it's own tab. For instance, the species selection shows the EotE choices at the top, followed by the AoR additions, then the USM. Same with the Careers, Motivations, and Force Powers. The new Skill and any additional gear/equipment however are blended in with everything else, to maintain the alphabetical listings.

So awesome. Any chance of an updated open office version?

Minor issue.

The sheet currently has Insight listed as (as of version 1.05):

"Perception and Vigilance become career skills."

This should be Perception and Discipline"

Great game aid and really a time saver.

The gear section as is works great for a “character creation” aid, but for ongoing character development use probably needs some modifications to reflect the gain and loss of items through use (i.e. stimpacks). - maybe an “expended” column with “yes” or “no” with a “# expended” from the total.

Also a way to manually enter a different cost for items to reflect haggling/negotiation, or other market forces than the cost shown in the core book tables.

Maybe the gear list needs to be disassociated with the “available credits” in some way and only used to reflect “gear” in possession. A separate tab can be created to help in gear “purchase” to help figure out total costs etc… (Again with the ability to manually input a different cost per item from the standard purchase cost tables). The total spent could then manually be put in the “character description” tab under a “credits spent” similar to the “credits obtained” already in the tab to reflect actual credits available. This “credits spent” column would be helpful to reflect credits lost through gambling, bribes paid, theft, robbery, etc… The “gear purchase helper” or “shopping list” could then be cleared once one has determined costs of shopping list and purchase is finalized. The character description tab is then updated with the "credits spent" to show available credits.

Anyway, just some thoughts .

So awesome. Any chance of an updated open office version?

Since I wasn't the one able to get it to work, hopefully we could get Sketchpad to give it a go. I will try to find a converter myself, but no promises.

Minor issue.

The sheet currently has Insight listed as (as of version 1.05):

"Perception and Vigilance become career skills."

This should be Perception and Discipline"

Good catch. And it appears that while I had fixed the skill tab to add Discipline when Insight was selected, I forgot to remove the additional benefit from Vigilance. Guess I failed my Vigilance check originally, thanks for the boost die. :) This will be fixed in the next update.

Great game aid and really a time saver.

The gear section as is works great for a “character creation” aid, but for ongoing character development use probably needs some modifications to reflect the gain and loss of items through use (i.e. stimpacks). - maybe an “expended” column with “yes” or “no” with a “# expended” from the total.

Also a way to manually enter a different cost for items to reflect haggling/negotiation, or other market forces than the cost shown in the core book tables.

Maybe the gear list needs to be disassociated with the “available credits” in some way and only used to reflect “gear” in possession. A separate tab can be created to help in gear “purchase” to help figure out total costs etc… (Again with the ability to manually input a different cost per item from the standard purchase cost tables). The total spent could then manually be put in the “character description” tab under a “credits spent” similar to the “credits obtained” already in the tab to reflect actual credits available. This “credits spent” column would be helpful to reflect credits lost through gambling, bribes paid, theft, robbery, etc… The “gear purchase helper” or “shopping list” could then be cleared once one has determined costs of shopping list and purchase is finalized. The character description tab is then updated with the "credits spent" to show available credits.

Anyway, just some thoughts .

Your right... my original thought of changing quantities would also require a constant change in credits acquired. So a quantity used column sounds like an excellent idea.

Cost override... also a good idea, rather than needing to make credit changes on the description tab. I could add a column for that, or just change the looted column to it... looted = cost of 0 anyway. The only downside I foresee right now with my idea for formulating it is if you have already purchased some of an item at one price, and were buying more at a different price, you would need to put the new items on a separate line, otherwise the price override would change the original price as well... unless I also add additional columns for quantities with the price override...

But you already have an idea for fixing that as well. I have some additional ideas as well thanks to your post. I do know that the credits obtained column on the description tab currently does accept negative values to reflect spending. I will work on these ideas and see if we can get a better tracking system in place.

Thanks for the help.

thanks for the builder :)

Edited by Punisher187

Thank you very much for all your work in creating this generator. It is a great help and addition to the community.

So awesome. Any chance of an updated open office version?

Since I wasn't the one able to get it to work, hopefully we could get Sketchpad to give it a go. I will try to find a converter myself, but no promises.

Hiya Gang. I'm trying to get the dang thing to convert, but I'm having some issues. I'll update you once I can figure if it can or can't be done on my end.

So awesome. Any chance of an updated open office version?

Since I wasn't the one able to get it to work, hopefully we could get Sketchpad to give it a go. I will try to find a converter myself, but no promises.

Hiya Gang. I'm trying to get the dang thing to convert, but I'm having some issues. I'll update you once I can figure if it can or can't be done on my end.

I believe this should work:

SWEotE_CharSheet_1.05.ods

Annoyingly it took over 4 hours to open in Open Office before I could convert it !

I'm not actually sure how long it eventually took - 4 hours was the point where I decided to just go to bed, and it was opened in the morning, so for all I know it might have taken nearer 10 hours.