Don't call it a generator, but...

It's huge. It's kind of slow, but it works, mostly. May I present my character sheet [links below]


I want you to tell me every mistake I've made, and if you're a better programmer than me, why not try and tidy up that code. I stole a few ideas (and parts of images) from other character sheets around here. Thanks to everyone else who made this possible. Now, criticise!


Edit: SagaSheet 1.4


Hey, guys, let me give you the lowdown.

I've been working hard on the sheet over the past few weeks, trying to make it more user-friendly as well as updating it with the new material. I think that I've made big improvements in a lot of areas, but with the big changes are bound to come a whole Huttload of bugs.

Coincidentally, I have exams coming up in the next two weeks. It's strange to think that I started this sheet before starting uni, and these are my third year exams (and if they go well, I get to go to Harvard next year! Laughing). The downside of that is that I won't have time to work on the sheet, which also means that I haven't updated a lot of the little bugs that you guys have mentioned over the past few pages. The upside is that while I'm away, you can delve deeply into the sheet and tear it up, giving me lots of fun new work after I've finished my exams (and the subsequent celebrations).

There isn't import/export support at the moment. I'm considering moving in a whole new direction for that function - importing from the statblock format that the sheet produces. Ambitious, perhaps, but it would hopefully make the sheet a lot more cross-compatible with other products. I'd appreciate your thoughts on this sort of thing.

So, what I'm giving you is edition 1.4, and it is essentially beta. 1.41 (and probably 1.42) will hopefully be more stable (and probably slightly sleeker). I'll leave the link up for the older version.

I hope you guys understand my decision here. I'm doing this out of my own free time, and sometimes that free time just isn't there.

Thanks.

Version 1.31b


Ship Sheet 1.0 Beta

SagaSheet
I noticed that the CL's on the stat blocks is one higher than it should be (A level 5 Jedi is given CL 6).
Hey Kenad, great work on this spread sheet. The only suggestion now is you are still having a bug with all the languages being printed up. Also the Random on the Height and Weight when you look at it seems to go beyond two decimil points with the Karlauss's sheet. That not really need unless you measure everything down to those points.
Well the CrimeLord still does not get a talent every level. I am still not sure where it pulls how many talents each class gets.

Hyperdrive is listed twice in the stat block when it is picked.
Apparently at level 1 it starts to add an extra level to the CL in the Stat Block
the clear Species list button appears right on top of the Racial Abilities box so you cannot read the modifiers.


As Tiree say the Talents are all showing up twice
r6art, can you give me the details that would affect the unarmed damage for your character? Thanks a lot

Specific details follow:

Character is 13th level (Jedi 8/Jedi Knight 5) with all three Martial Arts feats and STR 16. Each Martial Arts feat bumps the damage die up by one step, so d4 for normal (Medium character), d6 for MA I, d8 for MA II and d10 for MA III. Thus his unarmed combat damage should be 1d10+9 (1d10 for MA III, +6 for 13th level, +3 for STR 16). The damage on the generator comes out 1d8+6 when unarmed, or 1d8+10 with Combat Gloves. It seems likely that the STR bonus is not registering on the unarmed damage. For the damage die type, it seems likely that either the base damage starts at d3 (either from a small character or because that was the base damage in RCR) or its not registering the "bump" from MA III.
Kenad Broki,
One little issue with a Wookie Scout and Weapon Proficiency.


A Wookie has a Species trait "Wookies with the Weapon Proficiency (rifles) feat are proficient with the bowcaster."

I took a Wookie Scout who starts with the Weapon Proficiency (rifles) feat but do not have the "Exotic Weapon Proficiency - Bowcaster" listed as a purchased feat on the Feats page of the spreadsheet.

The Feat does show up as "Conditional Bonus Feat: Exotic Weapon Proficiency (bowcasterrifles)" on the "Racial Abilities" field on the Character sheet on the spreadsheet.

One suggestion to help with GM bonuses
As a GM I occasionally hand out an extra feat/talent/ or skill to a new character for a later game tie-in. I also will give an extra eat/talent/ or skill to a player that has completed its destiny.

Is there any way to add an extra field for GM provided bonuses?

Thanks man! This thing rocks!!!
Kenad Broki,
One little issue with a Wookie Scout and Weapon Proficiency.


A Wookie has a Species trait "Wookies with the Weapon Proficiency (rifles) feat are proficient with the bowcaster."

I took a Wookie Scout who starts with the Weapon Proficiency (rifles) feat but do not have the "Exotic Weapon Proficiency - Bowcaster" listed as a purchased feat on the Feats page of the spreadsheet.

The Feat does show up as "Conditional Bonus Feat: Exotic Weapon Proficiency (bowcasterrifles)" on the "Racial Abilities" field on the Character sheet on the spreadsheet.

One suggestion to help with GM bonuses
As a GM I occasionally hand out an extra feat/talent/ or skill to a new character for a later game tie-in. I also will give an extra eat/talent/ or skill to a player that has completed its destiny.

Is there any way to add an extra field for GM provided bonuses?

Thanks man! This thing rocks!!!

Long time listener, first time caller.

I ran into this with my wookiee scout as well. I thought I sent this to Mr. Broki to add to his list of fixes, but I may be mistaken and he may have another idea on how to do it. My solution is a quick-fix deal and it hasn't popped up any other problems (yet). There's probably a better way to go about it, but here's how I fixed it:

On the Feats tab:

Cell D34 changed to: =IF(OR(AND(B34<>"",BAB>=1),AND(B34="Bowcaster",Species="Wookiee",I$90="Yes")),"Yes","No")

Cell D35 changed to: =IF(OR(AND(B35<>"",BAB>=1),AND(B35="Bowcaster",Species="Wookiee",I$90="Yes")),"Yes","No")

Cell H34 changed to: =IF(OR(AND(B34="Bowcaster",Species="Wookiee",I$90="Yes"),LOOKUP('Abilities and Classes'!$E$17,Feats!$L$5:$R$5,$L34:$R34)=2),"Yes","")

Cell H35 changed to: =IF(OR(AND(B35="Bowcaster",Species="Wookiee",I$90="Yes"),LOOKUP('Abilities and Classes'!$E$17,Feats!$L$5:$R$5,$L35:$R35)=2),"Yes","")

You can copy and paste those into the cells, but I would recommend pasting them into the cell by using in the edit field at the top (and deleting the existing function) as opposed to just pasting it in the cell.

These just check to see if the character is a Wookiee, if you have rifle proficiency, and then if you have selected Bowcaster as the actual Exotic Weapon Proficiency from the drop down menu. It'll show up as "Yes" in the starting feat column, which seemed like the easiest place to put it.

No Sig yet!

The Berserker
Oh! I forgot to say this:

Great work on this sheet! It is fantastic! Thanks as well to all of those who have helped Kenad Broki work through the changes and updates!
Great improvements. I like the button that can weed out the non-core species!!!

A few more issues noticed:

  • I noticed that every character I make has a tens digit added to the attack bonus in the weapons section. This tens digit is a 0 (+10, +20, +30, etc)until the Weapon Focus if added, then it becomes a 1 (+11, +21, +31, ect).
  • Did you mean for credits to be calculated for each class? Every character I've made has 20,000 credits and it doesn't recalculate it as you buy stuff. Didn't know if this was intentional or not.
  • Blaster rifle is listed twice in the weapons pulldown menu (Its #34 and #35)
  • I think someone else mentioned the +1 to all CLs.


I think that's all I noticed. Keep up the awesome work. You're doing a great service to us all!! :D
--BK--
  • Blaster rifle is listed twice in the weapons pulldown menu (Its #34 and #35)

This ones no mistake one denotes that the rifle has a retractable stock and is more expensive the other has no stock and is cheaper.
This ones no mistake one denotes that the rifle has a retractable stock and is more expensive the other has no stock and is cheaper.

Ah! My bad. Thx!! :D
--BK--
well the fist web enhancement is out, so if you could please add this.Saga Edition Web Enhancement 1
Yes, keep up the good work and updates. It is much appreciated!
By the way, mine is working now. It was a combo of alcohol and not using Excel for a while. Silly me.
Updated to v1.4, which has been a pretty smooth leap as far as I can tell, but there are bound to be issues. Tear her apart!

I've yet to incorporate the GM bonuses, I'm afraid, but I might be able to get it done before Monday, when I'm away for a long time, and someone else might have to take the reins. Anyway, get cracking! Tell me how those stat blocks and character sheets are faring!
Kenad Broki,
You can't leave now! We need you too much!!!


The Wookie Scout is still not starting with the BowCaster Exotic Weapon Proficiency. It does show that it is a species trait but the character does not gain any benefit in any other fields.

The_Berserker had a very simple solution that I have tested and works great. I quoted it here for reference. If you do copy and paste the code it has some extra spaces that the Wizards of the Coast Forum keeps putting in the text (ie: "Bowc aster" and "Y es" and "Wook iee")

Those need to be removed to work correctly. I've edited his quote to include the CODE command to keep all the text together.

Long time listener, first time caller.

I ran into this with my wookiee scout as well. I thought I sent this to Mr. Broki to add to his list of fixes, but I may be mistaken and he may have another idea on how to do it. My solution is a quick-fix deal and it hasn't popped up any other problems (yet). There's probably a better way to go about it, but here's how I fixed it:

On the Feats tab:

Cell D34 changed to: =IF(OR(AND(B34&lt;&gt;"",BAB&gt;=1),AND(B34="Bowcaster",Species="Wookiee",I$90="Yes")),"Yes","No")
Cell D35 changed to: =IF(OR(AND(B35&lt;&gt;"",BAB&gt;=1),AND(B35="Bowcaster",Species="Wookiee",I$90="Yes")),"Yes","No")
Cell H34 changed to: =IF(OR(AND(B34="Bowcaster",Species="Wookiee",I$90="Yes"),LOOKUP('Abilities and Classes'!$E$17,Feats!$L$5:$R$5,$L34:$R34 )=2),"Yes","")
Cell H35 changed to: =IF(OR(AND(B35="Bowcaster",Species="Wookiee",I$90="Yes"),LOOKUP('Abilities and Classes'!$E$17,Feats!$L$5:$R$5,$L35:$R35 )=2),"Yes","")
You can copy and paste those into the cells, but I would recommend pasting them into the cell by using in the edit field at the top (and deleting the existing function) as opposed to just pasting it in the cell.

These just check to see if the character is a Wookiee, if you have rifle proficiency, and then if you have selected Bowcaster as the actual Exotic Weapon Proficiency from the drop down menu. It'll show up as "Yes" in the starting feat column, which seemed like the easiest place to put it.

Love the addition of the MasterCraft checkboxes. And the mastercrafted armor Any Chance of getting some MasterCraft pulldown boxes on weapons too? Maybe a pulldown with the new Web Enhancements:

Improved Accuracy (+1 attack)
Improved Damage (+2 Damage)
Selective Fire (Converts an Autofire only weapon to have Single shot OR a Single Shot only to have an Autofire mode.)


Kenad Broki, You're great!!!!
Alright, I'll post a mini-update. The only problem is the +1 BAB requirement.

The reason I'm not applying Berserker's code is that it is too specific to Wookiees. It doesn't give the Yuuzhan Vong their exotic weapon proficiency, for example. There's a very simple fix, I just noticed, and it shall be done. Maybe you'll even get those GM bonuses, who knows? ;)

Edit: Oh, and the Tech Specialist weapon mods are there, just scroll down a little
Sweet! Thanks for the updates so quickly!

And no sweat on my fix, it was strictly a patch until the programmer could attend to it! I'm okay with functions, but it took me an entire day to figure out where in the macros the number of weapons was coded!

Keep up the great work and I'll keep trying to reverse engineer the thing!
Last night I multi-classed a soldier into a noble. When given the choice to choose my "free" Noble feet I didn't have the prereqs for Linguist. However, I couldn't clear the dialogue without choosing the feet anyway and it gave me the benefits of the feat. I'm not sure if this is actually a glitch, though. I may have just screwed something up. :D
--BK--
I figured that you were entitled to gain that feat if you ever gained the prereqs, but if you actually got the extra languages, then I'll check into that :O
The Scoundrel Spacer talent is listed as Hyperdrive, in the sheet. Should be Hyperdriven (per pg 47). CL was still being calculated as 1 higher, for me.

Did the sheet used to remove points from Use the Force skill for having cybernetic equipment? I thought it did, but it doesn't any more.
I figured that you were entitled to gain that feat if you ever gained the prereqs, but if you actually got the extra languages, then I'll check into that :O

That is exactly how it works. You can get feats you aren't qualified for, and can't use. But if you ever do qualify WHAM you get it. Funky way of doing business... but that is how I interpret it from some of the other comments based on the WizO's and Designers. It's what makes the higher level characters easy to create.
Updated to v1.145

Have fun!
Well the only problem I'm getting is on the GM bonus page is under the talents i get a run-time error '424' object required
All I can say is wow, this just keeps getting better with every iteration.

Just downloaded the newest version 1.145, and found one thing with the nonheroic levels, looks like the Nonheroic class still provides 2 ability increases, but should only give 1 every fourth level.

Thanks for all this work.
I was wondering how that worked with multiclassing, to be honest. Is it only the class that you are taking at 4th level that determines the number of ability point increases you gain?

Graybacca, I'll check that out in the morning. It's getting late here
I'm converting this character to Saga using the spreadsheet and I can't figure out where the Double Attack combat action is coming from.

Low-level Damsel CL 1
Medium Human scout 1
Force 5; Dark Side 0
Init +2; Senses Perception +5
Languages Basic

Defenses Ref 15 (flat-footed 13), Fort 12, Will 11
hp 24; Threshold 12

6 squares
Ranged blaster pistol, hold-out +2 (3d4+0)
Base Atk +0; Grp +2
Atk Options Double Attack
Special Actions Dodge

Abilities Str 8, Dex 14, Con 10, Int 14, Wis 11, Cha 15
Talents Improved Stealth
Feats Dodge, Mobility, WP (pistols, rifles, simple)
Skills Climb +4, Endurance +5, Jump +4, Perception +5, Ride +7, Stealth +7, Survival +5, Swim +4
Possessions blaster pistol, hold-out, comlink, short-range, energy cell (x3)

This character shouldn't even be qualified for this feat and it keeps popping up under Atk Options. Am I missing something, or is this an error in the sheet?
--BK--
Noticed a slight problem with the Scout Class. It appears that it allows you to take as many scout talents as you want, even though you have already chosen them.
Yeah, I just caught that one as well. It was looking for Scoundrel talents :O
Seem like Double Attack is an error, I get it as well...
one more thing you should add to the Character Sheet is droid creation!

Great work btw, and im honored to be mentioned on the sheet
one more thing you should add to the Character Sheet is droid creation!

Great work btw, and im honored to be mentioned on the sheet

Droids are listed as a race.
Ah, sorry, my mistake
Another talent Error found in the Brawler Talent tree.
In sqaure H138 this:
=IF($F$133>0;HVIS($J$136>0;"Yes";"No");"No")
Should be:
=IF($F$133>0;HVIS($J$137>0;"Yes";"No");"No")
When I took "Force Power Adept" it greyed out the Force Adept section, and I couldn't take any more talents. It also didn't take away the talent for that level from the top, so I could still spend another talent.
This is a GREAT tool.

Bugs:
  • All species, unless otherwise noted, also get Basic as a free language. I noticed the bug with Miraluka.
  • The Karlauss first page doubles the value of the Dex ability mod when displaying in the box on the Ref defense line.
  • The weight of the components in a Utility Belt should already included in the belt's 4.0kg weight.
  • Price of the Utility Belt is coming up as -445. And it's displaying the cost of the components. The cost should be 500 and the components should list no cost.
  • The random generator for weights gives absurd values for human females. The lowest value I've seen is 89kg.
Well, I was going to add Custom Weapons and perhaps even Llaunay's character sheet into the mix as a big hurrah before I left for Cornwall tomorrow morning, but I was foolish enough not to save a few hours work and now I'm all grumpy. So I'll give you what I've got, and hopefully I'll make it better in two or three weeks when I come back before flitting off to Turkey.

If anyone wants to take on the role of bughunter while I'm away, feel free, I won't be offended if someone uploads an improved version of the sheet, as long as I'm given credit for the framework.

Be good while I'm gone!

Adam
Hey Have A nice trip


Also when you select the talent on the GM bonus page they dont show on the Stat block.
Have a great trip and thanks for all the hard work!!!
Awesome job on this one mate. Be Safe in Turkey and may the Force be with you.