Excel Character Builder

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

Can we get the custom race options to:

Add a second skill? Several custom races have two skills that are added to the character

Additionally is there a way we can get "racial abilities" added (like a custom box to add these?)

I am trying to use Arkanian Offshoot as my example from the http://www.google.com/url?sa=t&rct=j&q=&esrc=s&source=web&cd=1&ved=0CC8QFjAA&url=http%3A%2F%2Fwww.d20radio.com%2Fcontent%2FEOTE_species_menagerie.pdf&ei=8nDtUar2IdH8yAHly4HwCg&usg=AFQjCNGadEYVoGMFrqaDtaTErIN353SMrg&sig2=eQYFSDd_hElrtxKKqxpnNQ&bvm=bv.49478099,d.aWc&cad=rja

PDF

I just want to say it in the words of Darth Vader:

Impressive... most impressive

Another point to make... Can we please have specialties listed on the character sheet? It makes it really difficult as a DM to look at a PC's sheet and understand where the XP was spent or what trees they have available... anything. (Additionally it is much easier to understand a PC if I see Assassin or Gadgeteer vs Bounty Hunter).

I only wish that it worked in Open Office. :(

Hi, great product!

1) I don't know if this has been covered before, could you add bonus dice to the dice pool display on Char Sheet 1. For example, as a Rodian Bounty Hunter (Assassin) with 'Stalker', there should 1 x Bonus Die per rank in Stalker for Coordination and Stealth Checks. If this was on Char Page 1 it would help a lot in remembering.

2) Also, I would like the ability to have 20 obligation with the second lot of 10 obligation split 5/5.

i.e. for a group of 5 players, standard 10 obligation applies. In addition to this, I have agreed with the GM to take another 10 obligation.

5 of this extra 10 obligation will give my character the benefit of $1500 starting credits;

5 of this extra 10 obligation will give my character the benefit of an extra 10 XP.

This essentially means that I have 3 Obligations, where two of them are actually the same type. I don't think there is any limit on how many obligations you can have, just the extent on how much obligation points it takes up (i.e how serious the obligation).

I note that Coordination was a specialty skill for assassins and now appears to not be. Is this right? I'm looking at the week 11 updates and people's errata posts and don't know if this was intentional in the char sheet.

Thanks once again.

Regards

1) I could probably add an additional small box to where a '+' could show up to help remind a player they have some extra bonus. It will take up a bit more space, but I will look into it.

2) I have it set up so that you can get various options from total extra obligation taken, but it only tracks up to two different specific obligations. If your starting Obligation is 10, it should allow you to take up to 10 additional obligation, with a bonus of either +10 XP, + 2500 credits, or +5 XP & +1000 credits. How you divvy up the obligation is up to you. The sheet will let you take a second obligation, and you can assign how much of your starting total goes toward that one. If you want to split your total over more, say 10 to original, 5 to a second, and 5 to a third, I would suggest assigning both the second and third totals to the second one, and just handwriting in details on a printout of the sheet.

That has been an issue since day one. Usually it can be solved simply by using your mouse to click away from your entry rather than hitting enter. I'm not sure why it does this. If that doesn't work, then the cause is probably a 'space' entered in a line, the spreadsheet counts a space as an entry. When you need to clear an entry, be sure to 'delete' it rather than using the space bar to overwrite it. Hopefully that helps.

Gah! Can't believe I forgot that. Now with the Mod slots for the items is there a reason those drop downs are blank?

Also any Defense skill from armor is not showing up on the character sheet. The defense rating on the Armor & Weapons tab shows correctly.

If you're talking about the ranged/melee defense, it won't show up on the sheet unless you have both a positive quantity of said armor and it must be equipped. It looks to be working for me, unless there is a particular combo that you've found that's broken.

Can we get the custom race options to:

Add a second skill? Several custom races have two skills that are added to the character

Additionally is there a way we can get "racial abilities" added (like a custom box to add these?)

I am trying to use Arkanian Offshoot as my example from the http://www.google.com/url?sa=t&rct=j&q=&esrc=s&source=web&cd=1&ved=0CC8QFjAA&url=http%3A%2F%2Fwww.d20radio.com%2Fcontent%2FEOTE_species_menagerie.pdf&ei=8nDtUar2IdH8yAHly4HwCg&usg=AFQjCNGadEYVoGMFrqaDtaTErIN353SMrg&sig2=eQYFSDd_hElrtxKKqxpnNQ&bvm=bv.49478099,d.aWc&cad=rja

PDF

I will let you in on a secret, I am slowly working on adding the menagerie to the builder. If you look on some of the hidden tabs you can see I have done some initial work, it's just not done yet. Until I finish all that, I could try setting up an option for 'two career skills' that will allow you to choose extra (similar to how the droid works).

Regarding racial abilities, you could put 'Determination' as one of the SA's. Unfortunately it will mess up the talent/SA listings on page 2 & 3, unless you add details to the 'Raw Data' tab... and change some other stuff. Kind of hard to explain the details of the changes in a short response... especially since I'm long winded and wordy in my responses.

Another point to make... Can we please have specialties listed on the character sheet? It makes it really difficult as a DM to look at a PC's sheet and understand where the XP was spent or what trees they have available... anything. (Additionally it is much easier to understand a PC if I see Assassin or Gadgeteer vs Bounty Hunter).

Looking at my page layouts, my best options are making the picture box shorter and add a couple spots between the name/species/career and the SWEotE logo... or on page 2 I could reduce the Companions & Contacts area and have the specializations show up there. Anyone have a preference or other suggestions?

Can we get the custom race options to:

Add a second skill? Several custom races have two skills that are added to the character

Additionally is there a way we can get "racial abilities" added (like a custom box to add these?)

I am trying to use Arkanian Offshoot as my example from the http://www.google.com/url?sa=t&rct=j&q=&esrc=s&source=web&cd=1&ved=0CC8QFjAA&url=http%3A%2F%2Fwww.d20radio.com%2Fcontent%2FEOTE_species_menagerie.pdf&ei=8nDtUar2IdH8yAHly4HwCg&usg=AFQjCNGadEYVoGMFrqaDtaTErIN353SMrg&sig2=eQYFSDd_hElrtxKKqxpnNQ&bvm=bv.49478099,d.aWc&cad=rja

PDF

I will let you in on a secret, I am slowly working on adding the menagerie to the builder. If you look on some of the hidden tabs you can see I have done some initial work, it's just not done yet. Until I finish all that, I could try setting up an option for 'two career skills' that will allow you to choose extra (similar to how the droid works).

Regarding racial abilities, you could put 'Determination' as one of the SA's. Unfortunately it will mess up the talent/SA listings on page 2 & 3, unless you add details to the 'Raw Data' tab... and change some other stuff. Kind of hard to explain the details of the changes in a short response... especially since I'm long winded and wordy in my responses.

Another point to make... Can we please have specialties listed on the character sheet? It makes it really difficult as a DM to look at a PC's sheet and understand where the XP was spent or what trees they have available... anything. (Additionally it is much easier to understand a PC if I see Assassin or Gadgeteer vs Bounty Hunter).

Looking at my page layouts, my best options are making the picture box shorter and add a couple spots between the name/species/career and the SWEotE logo... or on page 2 I could reduce the Companions & Contacts area and have the specializations show up there. Anyone have a preference or other suggestions?

Thank you for the reply on all of this :)

For the Menagerie, that is awesome and I totally appreciate it :) The extra Skill akin to droids is a great way to handle it potentially, although of course... the menagerie itself is even better.

I have been adding custom abilities to the "Other" section of page 2, although editing the data sheet itself doesn't look too horrible.

For specializations, I think Page 2 is the better way to go, it can just be a list of specializations right down the center column above Companions and Contacts. Companions and Contacts could even potentially move to page 3 but I think Page 2 works ok honestly.

I tried to find info on this and maybe I might have looked over this:

There is an additional blank page that prints out with the Character Sheet Page 1. I have tried a few things to get rid of it as I would like to print out the first 2 character sheets on both sides of the paper (without having to manually do so as my printer has this function). Is there a reason why this additional blank page is added to the printing of this sheet?

If this sounded too confusing, here is the break down of what I am doing:

I select Char Sheet Pg 1 to print

I select to print

My selections are "All" for Print Range and "Active Sheets" for Print What

(At this point, only "Char Sheet pg 1" will print)

I select Preview

The result is that there are 2 pages that will print: Char Sheet pg 1 and an additional blank sheet. If I add Char Sheet pg 2 to the selection, then the following will print in this order:

Char Sheet pg 1 > Blank > Char Sheet pg 2

I think most of the issues I saw were already covered. I've hacked the stats using the data sheet quite a bit to account for the missing features (e.g. Feral Strength, encumbrance modifiers), but the defense calculations aren't overridable that I've found. Had to overwrite the cell with hard-coded values.

Great sheet... made creating a character a breeze... only thing I've noticed is that on the character sheet pages the Specializations don't show up... I added mine to the Description field.

I only wish that it worked in Open Office. :(

It kind of does. I've ran it through OO's xls converter and you can use it, but there are a few problems. The formula for skills seems to break, for example.

truednd: If you're in a country outside of america, you will likely have a different paper size format, like A4. You need to set the paper size to your preferred paper and then tell excel in the print options to shrink to size. Otherwise it defaults to the longer 'letter' style which may carry some of the chat sheets over to a second page of A4 or whatever.

truednd: If you're in a country outside of america, you will likely have a different paper size format, like A4. You need to set the paper size to your preferred paper and then tell excel in the print options to shrink to size. Otherwise it defaults to the longer 'letter' style which may carry some of the chat sheets over to a second page of A4 or whatever.

Thanks for the tip. I am inside the US and it only happens with the Char Sheet pg 1 and never with Char Sheet pg 2. I am not in a position to double check this right now, but the standard letter size is normally always used. I will check this as soon as I can and let you know how things go.

I tried to find info on this and maybe I might have looked over this:

There is an additional blank page that prints out with the Character Sheet Page 1. I have tried a few things to get rid of it as I would like to print out the first 2 character sheets on both sides of the paper (without having to manually do so as my printer has this function). Is there a reason why this additional blank page is added to the printing of this sheet?

If this sounded too confusing, here is the break down of what I am doing:

I select Char Sheet Pg 1 to print

I select to print

My selections are "All" for Print Range and "Active Sheets" for Print What

(At this point, only "Char Sheet pg 1" will print)

I select Preview

The result is that there are 2 pages that will print: Char Sheet pg 1 and an additional blank sheet. If I add Char Sheet pg 2 to the selection, then the following will print in this order:

Char Sheet pg 1 > Blank > Char Sheet pg 2

I will double check my settings. I know there are columns that are hidden on the character sheet pages, If I haven't properly hidden everything, I think that could be throwing things off.

I think most of the issues I saw were already covered. I've hacked the stats using the data sheet quite a bit to account for the missing features (e.g. Feral Strength, encumbrance modifiers), but the defense calculations aren't overridable that I've found. Had to overwrite the cell with hard-coded values.

I know I have yet to get notations in for all the talents, but I thought I had encumbrance (and Cumbersome quality) working correctly. Is there a particular item/combo you can tell me that isn't working as you think it should? Same with the defense... I thought I had that one nailed down... or are these altered values a result of talents?

Great sheet... made creating a character a breeze... only thing I've noticed is that on the character sheet pages the Specializations don't show up... I added mine to the Description field.

I am working on adding them to page 2. Above the Companions & Contacts area.

I haven't looked at the most recent version of the character sheet, but is 1-click printing an option? If I recall correctly, you need to print each page individually, which is kind of a drag.

Despite my whine, this is an awesome resource. Thanks!

You can print the entire workbook, and just select pages 38-40 I believe.

I was playing around with this today, and noticed a couple items that contrasted with the core rulebook. Dunno if they've already been mentioned, but they're in the v1.01 release.

Holdout Blasters - these actually have 1 hard point, enabling them to accept a single weapon attachment.

Backpacks - they now reduce a character's Encumbrance value by 4.

Also, the corebook gives an option for blaster carbines and blaster pistols (except heavy pistols) to be purchased as "Stun only," which cuts the cost in half but restricts the weapon to just dealing Stun damage. I don't think it forces the range to be reduced to Short the way a Stun Setting does though.

Thanks for looking in to this, Bren. I just checked my paper quality and it is set to the right letter size. Let me know if you have any additional things you think I could try to get around this from my end. Also, if anyone has any other suggested settings I am all ears.

TrueDND: In Office/Excel 2010 File->Print->Custom Scaling->'Fit Sheet on One Page' ... then click on 'Show Print Preview' and see how it looks.

You can also do File->Print->Custom Margins->'Narrow' and see if that helps

TrueDND: In Office/Excel 2010 File->Print->Custom Scaling->'Fit Sheet on One Page' ... then click on 'Show Print Preview' and see how it looks.

You can also do File->Print->Custom Margins->'Narrow' and see if that helps

Unfortunately I have Office 2007 and those options are not available to me in any fashion, even under Properties and Advanced. Maybe I just need to finally buy the newest Office version.

I was playing around with this today, and noticed a couple items that contrasted with the core rulebook. Dunno if they've already been mentioned, but they're in the v1.01 release.

Holdout Blasters - these actually have 1 hard point, enabling them to accept a single weapon attachment.

Backpacks - they now reduce a character's Encumbrance value by 4.

Also, the corebook gives an option for blaster carbines and blaster pistols (except heavy pistols) to be purchased as "Stun only," which cuts the cost in half but restricts the weapon to just dealing Stun damage. I don't think it forces the range to be reduced to Short the way a Stun Setting does though.

Well, it seems I messed up the HP settings when I added the Tinkerer option... it will be fixed in the next version.

I missed the change to backpacks. Good catch.

Stun only versions... I think I could add those easily enough, but I will probably hold out until we can get a confirmation on the range. My gut reaction is that they should all be hit with the short range limitation. Even though the line 'Stun beams may only be used at short range, no matter what the weapon's normal range is.' is mentioned related to the stun setting of weapons, I think the stun only would still fit this description.

Thanks for looking in to this, Bren. I just checked my paper quality and it is set to the right letter size. Let me know if you have any additional things you think I could try to get around this from my end. Also, if anyone has any other suggested settings I am all ears.

I did go back and check things. I found nothing out of order. I reprinted a page for myself and it printed normally. My next suggestion, although I can't be sure it will work since I don't have 2007 anymore and don't remember what all features/option it had, would be to try going to page layout and adjusting margins, as well as going to a page break preview (under 'view' in 2013) and see if it will let you adjust where the page break is... so hopefully you could create your own dimensions to be printed on a page.

I know I have yet to get notations in for all the talents, but I thought I had encumbrance (and Cumbersome quality) working correctly. Is there a particular item/combo you can tell me that isn't working as you think it should? Same with the defense... I thought I had that one nailed down... or are these altered values a result of talents?

Sorry, missed your reply. I'll see if I can pull together some steps to replicate the mistakes I saw.

Thank you all for your help, as I was able to figure it out. I tried all of your suggestions but they didn't seem to help in 2007. However, I finally noticed the option "Print Area" on under Page Layout. Looks like I missed this a bunch of times but using this feature is what fixed my issue.

Once again, thank you all for your help. I really appreciate how brilliant and helpful this community is.

Thank you all for your help, as I was able to figure it out. I tried all of your suggestions but they didn't seem to help in 2007. However, I finally noticed the option "Print Area" on under Page Layout. Looks like I missed this a bunch of times but using this feature is what fixed my issue.

Once again, thank you all for your help. I really appreciate how brilliant and helpful this community is.

I'm glad you were able to solve it. And this community is pretty great at being helpful.

Hi, awesome sheet. You're pretty much an excel God. I attempted to modify the sheet myself but got totally lost so I'm here with a request.

Can you have the Force Sensitive Talents - Uncanny Senses and Uncanny Reactions - actually update the dice pool for their respective skills? Perhaps to the side in the blank space? I have a light blue pen and draw the squares myself, but judging from the dedication present in this sheet; you're very detail oriented like me.

Version 1.02 is up. SWEotE CharSheet 1.02.xlsx

New additions/changes include...

Added Species from the Unofficial Species Menagerie. Special thanks goes out to those who put in the work to get us all that material.

Gear must now be carried (or built in) to show up on the sheet.

Backpacks now reduce encumbrance by 4.

Gand with lungs and the Defel now get their exclusive items (Ammonia Respirator or Protective Goggles) automatically for free. These items can still be purchased on the gear tab for other possible uses.

Specializations now appear on Page 2.

Obligation & Motivation details can be entered on the Obligation-Motivation-Career tab once an Obligation/Motivation has been selected. These details will then appear on the sheet.

Added boxes to the Character Description tab where you can add both 'Companion & Contact' info as well as 'Asset & Resources' info that will then appear on the sheet.

Fixed a calculation error on armor & weapon hard points.

Fixed a Defense calculation error (related to Armor Master and Armor Master (Improved)). NOTE: The benefit of these talents will not show up under the armor itself on the armor & weapons tab, as the armor is not improved by the talent, but it should calculate correctly on the sheet.

Still planning on adding some sort of notations that appear near skills when you have a talent that can modify the dice pool for that skill.

Edited by Bren_Waynero