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
Have fun on your trip Kenad. I think the work you've done is phenomenal!

I've got a suggestion for anyone who is going to work on this while Kenad is away, or Kenad can look at it when he returns:

When you choose the Knowledge skills, they don't reflect properly on the character sheets, both the CS and the Karlauss. I've tried this with 1st lvl Noble and Jedi, and the same thing happens both times, the character sheets just list the Knowledge skills in order from top to bottom. So, if you pick Knowledge (Physical Sciences) it shows up on the Karlauss sheet, because that sheet has 4 Knowledge slots, but not on the CS sheet because that only has 2.

My suggestion is twofold:

1)Fix the character sheets so that they look for the trained Knowledge skills first and list them properly.

2)Make the last Knowledge block on the sheets show what your total bonus is for using any of the Knowledge skills untrained.

eg:

A 1st lvl Noble with 15 Int. and trained in Knowledge (Physical Sciences) would have a char. sheet that has the following entries:

Knowledge Galactic Lore +7 = +2 (Ability Mod) +5 (Trained)
Knowledge Untrained +7 = +2 (Ability Mod)

Or, maybe a better way to do this would be to alter the character sheets slightly so that you only have 1 line for Knowledge skills that reads as follows:

Knowledge Trained Skill +7 = +2 (Ability Mod) +5 (Trained)

If you have at least one Knowledge skill trained. Then you could list the trained Knowledge skill(s) in a space at the bottom of the Skills section, and the untrained skills the player would know to just subtract 5 from the Trained Skill total bonus, if it was necessary to make an untrained knowledge check.

If you don't have any Knowledge skills trained, you could just use the Knowledge Untrained setup as above.

Thoughts? If nothing else, I'd like to see the Knowledge skill section update correctly, but I'm not knowledgeable enough (sry bad pun) with Excel/Visual Basic to do it.
*NM*
Adam,

Thanks again for all the hard work!

Enjoy your travels; we'll try to hold the fort down here for ya!
More bugs:
  • Final defense values are including values from the bonus tab, which are already included in the base defense values, so the bonus is getting added twice into the final value.
  • Racial DR is not being factored into the armor (reflex defense) calculations.
  • Negative mods for low strength are not being applied to melee damage on the attack tab (positive strength mods are).
  • "Unarmed" shows up on the equipment tab as a type of weapon. An empty hand is not equipment, so it should not appear on this tab.
  • Price and weight columns on the equipment tab are center-justified when they should be right-justified so that numeric values align properly.
  • Stat block fails to list all languages when a character has a lot of them.


Thanks for the mention on the Intro tab, Adam!
Making up a Solider 1 with a Dex 16 (+3). Without armor, Ref Defense is 15 (correct). With Battle Armor, Ref Defense is 22. When I take Armored Defense feat, Ref Defense drops to 21.

I believe the Ref Defense should be 21 (10 base +8 armor +2 dex +1 class = 21) with or without the talent. I'm not sure why it's being calc'd as 22 without the talent, however.

Also, I'm not sure the armor tab accounts for Amor Mastery, which improves the Dex max of the armor by 1.
So who here is a Macro Programmer who can take the lead on this for the next 3 weeks?
Heh. I'm actually building my own (and have been working on it since pre-Saga release).

Otherwise, I'd be happy to help out.
Patryn of Elvenshae Want a character sheet for your starship? Download! Discuss!
Heh. I'm actually building my own (and have been working on it since pre-Saga release).

Otherwise, I'd be happy to help out.

Is there anything you have in yours that you can implement here? Can we see yours? Maybe Merging code bases would benefit both?
Force Training requires:

Force Sensitive AND Use the Force trained
I refuse to let this topic drop off page 1!
Can't wait for the next update... would asking for the 'Beast' class to be included so we can use it to generate animals as well be too much to ask?

Thanks for an awesome tool!
Bump for great justice!

Adding my humble thanks for this GRRREEEATTT Gm tool. Love it!
I refuse to let this topic drop off page 1!
Can't wait for the next update... would asking for the 'Beast' class to be included so we can use it to generate animals as well be too much to ask?

Thanks for an awesome tool!

Lol, i'm thinking the same. Everytime i see this post dropping down to the bottom of page 1, i type a message of some sort just to keep it where people can see it.
I would have asked if the Hutt could bookmark it, but its in the "grey" area legaly so i understand if they cant involve themself.
Lol, i'm thinking the same. Everytime i see this post dropping down to the bottom of page 1, i type a message of some sort just to keep it where people can see it.
I would have asked if the Hutt could bookmark it, but its in the "grey" area legaly so i understand if they cant involve themself.

It isn't grey... It doesn't infringe on copyright, it doesn't quote text from the books in significant portions... and Wizards employees have said excel sheets are not a problem in their eyes, regardless of legal standing.
We all know how strict Lucas is on his copyrights. WotC once made a Dark Side Villain generator, and Lucas was not happy about it. (Didnt lead to any legal actions). So i was only saying that i wouldnt ask the Administrators of these boards to involve themselves in even a XL sheet. Even though it is Legal, Lucas would not be happy about it.
We all know how strict Lucas is on his copyrights. WotC once made a Dark Side Villain generator, and Lucas was not happy about it. (Didnt lead to any legal actions). So i was only saying that i wouldnt ask the Administrators of these boards to involve themselves in even a XL sheet. Even though it is Legal, Lucas would not be happy about it.

Didn't realize that...

geez
I really like this, but I don't have Excel at home. Does anybody else use OpenOffice Calc (equivalent to Excel) and have success with this? Everything looks okay, but none of the calculations, menus, and other crunchy bits actually function.

If someone could point me in the right direction, I'd appreciate it.

~Elsidar
Elsidar:
Couldn't get it to work with OpenOffice.


Kenad Broki:
I've noticed that the Devorian species traits don't seem to work, nor does the worksheet recognize GM awarded bonuses on the character sheet.

Great job on this, again!
It's already drawn up a LOT of stuff for use in my game!
If only it could do Beasts as well... hint,hint. ;)
The droid sheet REQUIRES that a Tech Specialist did something, as far as I could tell. I put a new value, none, into the drop down menu.
Can we see yours?

Absolutely! As soon as it's a little more polished, anyway ...

Maybe Merging code bases would benefit both?

Probably not. We seem to do things in a different-enough fashion that I'd end up rewriting just about anything I was going to port over, and likewise.

I think it'll be better to just have two alternatives, and the crowds can pick which they like the best. :D
Patryn of Elvenshae Want a character sheet for your starship? Download! Discuss!
This forum is awesome! The tone and respect in all of the replies is exactly what it should be like. The world would be a better place if more people could get along and communicate on this level!

Kenad, thanks for doing the work and thanks even more for being so open to constructive criticism!

After playing with it a little I really like it, although I am far from having explored the depth.

I did notice that under the 'bonus' section you don't have the ability scores available. I'm thinking primarily of the destiny completion bonuses which could be reflected by simply adding the abilities into that page.

Thanks again!
Waiting on the next version...
Probably not comming a new "Edition" in a while, because Kenad Broki has left for 2 - 3 weeks.
Probably not comming a new "Edition" in a while, because Kenad Broki has left for 2 - 3 weeks.

I know... just not wanting the thread to fall off page 1 in the meantime. The best way to show appreciation for effort like this is to keep it where everyone can see it.
Not sure if this has been asked, but is it supposed to go through a bunch of loads saying that it's converting metafile? I'm not sure if it has anything to do with the fact that I'm using the Microsoft Office software for my Mac, but I don't really see why that would matter much.
I know... just not wanting the thread to fall off page 1 in the meantime. The best way to show appreciation for effort like this is to keep it where everyone can see it.

Actually that is probably not the best thing to do for right now. The best thing is to subscribe to the thread... That way you never will lose it, even if it is 10 pages deep.

Now there is a problem with the Linguist Feat. It appears to be referencing species data from the Feat above, and does not provide accurate accountability for Noble as the first starting class.

I'll provide an update on the code in a little bit.
Actually that is probably not the best thing to do for right now. The best thing is to subscribe to the thread... That way you never will lose it, even if it is 10 pages deep.

Now there is a problem with the Linguist Feat. It appears to be referencing species data from the Feat above, and does not provide accurate accountability for Noble as the first starting class.

I'll provide an update on the code in a little bit.

Tiree, sorry to steal your thunder! I saw this last night and got around it by typing a "1" into the box on the right. Works if you don't save it (possibly deleting the functions in the cell). Here's the permanent solution I've come up with:

Feats tab, Cell I47

=IF(SUM(F47:G47,Bonus!J45,IF(AND(G47="Multi",D47="Yes"),1,0),IF(AND(G47="Species",D47="Yes"),1,0),IF(AND(H47="Yes",D47="yes"),1,0))>0,"Yes","No")
Feats tab, Cell J47

=IF(I47="Yes",SUM(F47:G47,Bonus!J45,IF(AND(G47="Multi",D47="Yes"),1,0),IF(AND(G47="Species",D47="Yes"),1,0),IF(AND(H47="yes",D47="yes"),1,0)),0)
Now that I'm aware of the whole CODE thing, maybe these won't get extra spaces added. Again you can copy and paste, but directly into the cell's edit bar to ensure it's in there correctly.

If I honked it, somebody lemme know!
No skin off my nose. Your code is what I did also - it works for me.
Here's something i noticed when doing a custom ship, no matter what i type for price new and used on the Custom Tab this is what comes up in the stat block Cost Not available for sale (unique) and it say in the little pop up box it say if Not available type NA if only available used type Used.
Hey, I was wondering if there was a way to add on the character sheet/ Print out a note on the character. I would like to be able as a GM to add notes. Another suggestion is for cross class skills. I know that it not in the book but I would like an option if I house rule it so that I don't have a ton of cross classes unless it part of the character concept. Thanks for all great work all and testing.:P
Ok, I've got zero Visual Basic training (it's actually taken me a few days to reverse engineer the code and figure out what it means), but I've done some tweaks to version 1.146 as follows:

Abilities and Classes

  • Changed cell K27 to report the amount of xp needed for the next level, not the minimum amount of xp needed for the current level (I thought this info was more helpful).
  • Added an IF statement to cell M26 that will give a "Level Up!" statement when the amount of xp the character has in cell K26 is equal to or greater than the amount of xp needed for the next level.


Languages
  • Expanded out Column I so that you can see the Read/Write column!!


Equipment
  • Added a Clear Equipment button to clear out all cells that do not have a "None" value in them and clear out the Mastercraft checkboxes. (the cells with "None" in them are controlled from the Armor and Attacks, sheets).


Stat Block
  • Edited Class reported so that the first letter is capitalized (Medium Human noble 1 is now reported as Medium Human Noble 1. Works for all classes).
  • Languages now report whether they are Speak Only or Read/Write Only, as chosen on the Languages page.


CS and Karlauss
  • Languages now report whether they are Speak Only as (S) or Read/Write Only as (R/W)


Here's a link to 1.146 that I updated:

1.146 Tweaked

Not sure where Kenad stopped in the bugs reported, but I can try to work on some of them. Without any VBasic training though it's taking me forever to actually figure out the coding. The changes I made were actually fairly simple, once I found where the code was to put them in lol. I can try working on the other bugs, if y'all can help me figure out what set of bugs 1.146 fixed.

Vel
[*]Languages now report whether they are Speak Only or Read/Write Only, as chosen on the Languages page.[/list]

CS and Karlauss
  • Languages now report whether they are Speak Only as (S) or Read/Write Only as (R/W)



Vel

ALL languages will be speak/read/write. When you learn a language you can do all three (unlike in RCR where you had to spend multiple points to learn to speak AND read/write.)
Fun, friendly community specializing in play by post games for every system and free from gaming. Come check us out. Star Wars: Dawn of Defiance campaign
I don't know if anyone has covered this or if it has been put into the 'fix' queue, but I couldn't make any Huge or large droids. It came up when I was fussing around to make an opponent for my game...

-R
Per the errata, Jedi should have Jump and Mechanics as class skills.

Easy fix - put a 1 in cell I14 and I22 on the Skills tab to enable this.
we need to put together a list of fixes and requests and status. Perhaps someone can make a web page that can be maintained.
we need to put together a list of fixes and requests and status. Perhaps someone can make a web page that can be maintained.

I'll see what I can do over the weekend about this. It will only be temporary till Kenad Broki gets back.
I've siphoned a page from my company site to host my SMS stuff (another thread). I'll be happy to post a bug/fix list there as well in the interim.

[HTML]www.estateplanningent.com/berserker.html[/HTML]

I'll also be happy to let someone else host it if they really want to.
I only have the following to say...

Impressive. Most impressive. :P ;) :D
When 900 years old you become, look as good, you will not, hmmm?
Has anyone found his line of code for Jedi Skills? If so what Module and what line do I have to change to bring it in line with the Errant?

Never Mind I found the section. on the Skill sheet got to the I column and put a one next to the skill for it to be a class skill. Then number will no show up. Each column after that will be another class till you get to N for non heroic characters.
ALL languages will be speak/read/write. When you learn a language you can do all three (unlike in RCR where you had to spend multiple points to learn to speak AND read/write.)

Thanks Alicia, I had missed that.
I went through and compiled a bug list for Kenad Broki. It can be found here: http://nullfactor.net/msgbrds/