Sign in to follow this  
Followers 0
Bren_Waynero

Excel Character Builder

192 posts in this topic

Fixed both Lightsaber issues.

 

Have begun the clean-up of the data and there is now an updated Obligations-Career sheet.

 

Will look into the gear locations request.

 

Version 1.09a is here.

Share this post


Link to post
Share on other sites

Not sure if someone else is having the problem - but when I go to try and select two starting specialization skills, I keep getting an error when I try to select the 2nd one (it keeps saying I already have two picked or that the skill I'm choosing is not a specialization skill).  (I've tried with two diff specializations under the Smuggler career).

Share this post


Link to post
Share on other sites

Not sure if someone else is having the problem - but when I go to try and select two starting specialization skills, I keep getting an error when I try to select the 2nd one (it keeps saying I already have two picked or that the skill I'm choosing is not a specialization skill).  (I've tried with two diff specializations under the Smuggler career).

 

Fixed. Just download v1.09a again.

Kalan2 likes this

Share this post


Link to post
Share on other sites

 

Not sure if someone else is having the problem - but when I go to try and select two starting specialization skills, I keep getting an error when I try to select the 2nd one (it keeps saying I already have two picked or that the skill I'm choosing is not a specialization skill).  (I've tried with two diff specializations under the Smuggler career).

 

Fixed. Just download v1.09a again.

 

 

You're a star mate :) Takkers!

Share this post


Link to post
Share on other sites

I'm starting to feel like a PITA here. I can see that when one chooses a specialization from a different career, it is throwing out a #VALUE error for XP cost (in this case, I'm trying to create a Smuggler Pilot/Doctor).

Share this post


Link to post
Share on other sites

I'm starting to feel like a PITA here. I can see that when one chooses a specialization from a different career, it is throwing out a #VALUE error for XP cost (in this case, I'm trying to create a Smuggler Pilot/Doctor).

 

Not all all. I am slowing working through all the calculations across all the sheets. There is quite a bit of dependancy between sheets and so if I change one thing it can have unforeseen affects. I welcome all feedback as it is faster than me having to build hundreds of characters to test every possibility.

Share this post


Link to post
Share on other sites

Think the XP issue is fixed. There was a formula that looked at the text, 1st, 2nd, etc. I changed the text because it had a leading space character, not realising that a formula was expecting the space.

 

Again, the file is still version 1.09a.

Kalan2 likes this

Share this post


Link to post
Share on other sites

Hi all,

I am a long time lurker, but after trying out the latest version and finding a few bugs I decided to lend a helping hand.

I have fixed these bugs but I cannot upload my corrected version.

The corrected bugs are:-

Skills page, no career or specialization, generates #N/A's on every skill.

Obligation page, extra obligation granting extra XP and Cash.

Character Sheet 1, Stating that a non FS character has a force rating of 1.

Yours

Simonb1

Share this post


Link to post
Share on other sites

Hi all,

I am a long time lurker, but after trying out the latest version and finding a few bugs I decided to lend a helping hand.

I have fixed these bugs but I cannot upload my corrected version.

The corrected bugs are:-

Skills page, no career or specialization, generates #N/A's on every skill.

Obligation page, extra obligation granting extra XP and Cash.

Character Sheet 1, Stating that a non FS character has a force rating of 1.

Yours

Simonb1

Thanks for the help, although not sure how much it helps if you can't upload anywhere. ;)

 

As I am going through the sheet I am doing 3 things:

 

1. I am changing all ranges to named ranges and adding a lot of named cells (to help identify what is happening)

2. I am creating error trapping to remove the various error messages that appear

3. Removing any redundant data/formulas

 

There is a risk that as I tinker with an existing formula I will upset some linked formula so I expect there to be a few "new" errors, just because of that. I am trying to work methodically now and get all the formulas in a consistent format before I look at implementing the outstanding requests. I have completed 4 sheets and now looking at Talents.

 

After that, it is equipment and I am expecting this to take a bit of sorting through (just so I understand what it going on behind the scenes). Then I can finally look at the actually print sheets.

 

If you see any bugs let me know and I will fix ASAP and upload a new copy.

 

Latest version (1.10a) is here. Note that this is a work in progress version of my clean up exercise.

Edited by Tricky110974

Share this post


Link to post
Share on other sites

The Excel sheet looks awesome but there is not way to add modifications to the armor or guns. And to show the coast.

Edited by TYMONGER

Share this post


Link to post
Share on other sites

I think Claws is missing from the table of talents. When I make a Trandoshan, the Claws talent shows #N/A next to it and it keeps repeating. The Regeneration skill does not even appear, which I am guessing is because of this issue.

Edited by truednd

Share this post


Link to post
Share on other sites

I wanted to first and foremost thank all who have worked on this Sheet.  It is amazing, one of the best for any game I've seen.

 

I did run into a problem and thought I should check if it was somehow on my end, or if I picked up an older copy.  I have ver. 1.10a, and 1.05 (the older just for researching this).

 

I plugged away at making a few test characters, but when I got to the Character sheet portion, the ranks column has a "#REF!" in all the cells.  Also looks like all the math directs to P84, which is Brawn (it is this way in all the fields, even for Int skills and such).  I am using Excel 2007

 

I do see your last post about it being a work in progress, so please don't think I'm trying to give you grief in any way.  Again, you're doing us all a great service.

 

*** Just grabbed ver 1.09a, no issue, so I'll work with that for now.  Thank you. ***

Edited by Scruffy looking nerf herdr

Share this post


Link to post
Share on other sites

I did find some issues with the Sheet.  I grabbed the 1.09a and 1.10a versions and saw the same issue.

 

The first issue is that the Defined Name for equipment_data should be =tables!$DQ$2:$FI$201  Currently it is set to not include all the equipment and that makes errors when adding equipment from Tool Box down in the Gear Tab.

 

The second issue is that Character Sheet pg 1 Tab all the Ranks have a broken #REF.  I just updated them to now point to the E# and that corrected this issue:

Example:

Astrogation (Int) should be =IF(P84="","",Skills!E3)

Ranged - Light (Agi) should be =IF(P84="","",Skills!E28)

 

Still a great sheet and it really helps to allow me to build characters while traveling on the plane (and not having my books around).

Share this post


Link to post
Share on other sites

jyanta

 

    I don't mean to resurrect an old post, but I cannot find in the 1.10a sheet where the defined name for the equipment table is to correct it, Any help would be appreciated.

 

Trevor

Share this post


Link to post
Share on other sites

I'm gonna test both now,,, (being 'old school' using a new, fancy, glittery computer based program is weird when i'm used to a scrap of paper, scribble it all out and commit to PC sheet when happy)

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now
Sign in to follow this  
Followers 0