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 .

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).

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.

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!

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).

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.

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 .

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

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.

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

When will you have the races from Suns of Fortune added?

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.

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. ***

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).

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

I suspect that most everyone abandoned this method, and have gone to using OggDude’s Character Generator.

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)