New Character Creator on the Block

[Bedwyr]

What does "tag" do?

Replying in-thread means it shows up on one's "show new replies" list. Calling it a tag is colloquial. It's usually bad form to simply "tag", so nicer to give some encouragement or feedback.

[Nebfer]

Give LibreOffice a try so you let that 10 year old Excel die ;)  No need to necessarily purchase a new version if you do not use it often which is why I am always turning people on to LibreOffice.

LibreOffice dose not work as well (open office also dose not work)

In both cases it loads and has partial functionality but a lot of stuff dose not work for example in LibreOffice the starting XP drop down tab on the character selection tab has is completely blank, theirs something their but nothing shows up or functions.
Life module selection has items showing up as N/A or also blank
The other pages are full of #N/A entrys

Open office takes forever to load and has the same issues.

I don't know open office. I would assume that it is similar to Excel, but not close enough that it works. However, I don't think $70 a year is that much for all of the office suite.

I am sorry for those of you that don't have excel. I am still working on keeping this up to date with fixes for me to take time out to learn why it isn't working.

I do give permission for anyone that wants to take on the task of converting it to work on open office though.

Thats way to expensive for something I do not use enough to justify the cost of 70$ per year, which is fairly cheap though.

[gigobyte]

Besides the "I can't use it because I do not have Office" does any one have feedback?

[Daryk]

It's very pretty, but I think I'm going to continue fixing my spreadsheet.  When I'm working on a large number of NPCs, it's easier for me to have all the calculations on a single worksheet.  A couple of quick things I noticed:

The starting XP block should have an option for entering any number.  The JumpShip captain I'm using as a stress test of my spreadsheet uses 9,000 XP to start.

The "Optional Creation" selection should be labeled more specifically.  The words "Alternate Starting Allotment" don't exist on page 49, so anyone doing a word search may not catch the reference right away.

I'll try to open it with OpenOffice (or LibreOffice, I forget which one is on my laptop) later today when I'm on the train.

[gigobyte]

Thanks, I appreciate the feedback. I will start looking into this this weekend.

I created an NPC sheet as well, check it out in my signature :) It is real simple.

[Daryk]

LibreOffice 3.5 doesn't like some of the drop down menus (they have the right number of selections, but they're all blank).  It appears to be random whether a menu will work or not, and I have no idea why.  Sorry!

[Daryk]

I just discovered a hole in the higher education implementation in trying to help freakacid with his questions.  It appears to be impossible to select a second "Advanced" field, which is explicitly permitted on page 70 (the third bullet under "Master Schools List"):

The player may not choose more than three Fields in total for a school. (Choosing a second Advanced Field is a viable option for a third Field, as is selecting a Special Training Field.)

Also, on the Attribute Selection sheet there's a spelling error: "Flexible" is incorrectly spelled "Flexable" in both  the "Choice/Flexible XP" block and the footnote for that block.  I also see it's misspelled on the Attribute sheets.  I recommend doing a global find and replace throughout the workbook.

Working through this, I see one critical difference between our spreadsheets.  I tried to program mine to do optimization automatically where yours is manual.  Granted, I'm assuming all the Flex requirements are simply met during optimization (my rationale being that with all those points sloshing around, they're bound to be met), where yours explicitly lists them as reminders for the user the to meet.

If you PM me your e-mail address, I'll send you my current version (which I'll eventually post if I get it fully functioning).  I'm not an interface guy, so it's pretty ugly.  Calan (another poster several years back) gave me some more elegant formulas to use, but I haven't quite wrapped my head around them, so they're only where he put them in.

[freakacid]

one short question:
On my character sheet it says +X to some skills (Solaris night life, Comm. HPG),
Is there a mistake in my char, or what does that mean?
thank you!

[gigobyte]

It means you have points in it, but not the minimum of 20 to make it a +0.

[beachhead1985]

This is great work Gigobyte! Keep it up!

[Deathknight69]

Hey Gigobyte: 1st off: Awesome char gen sheet / prog, Just frakkin' awesome !!!! One thing I noticed is that the user can't build a Republic of The Sphere character ?? Did I miss something ??

[gigobyte]

I only inputted the data from the main rule book, not any of the splat or era books. Sorry. it is not locked so if you would like to take that task up, feel free. Again sorry, but I am not into putting any more data into the sheet just corrections.

[freakacid]

hi!

thank you for the great work. One of my players had a problem: "hww to show weapons in character sheet?",

he selected the weaopn in the sheet, but it did not show up? Any Idea what might be wrong? I dont have the file here, but will be able to get it.

all the best,

[gigobyte]

What weapon, so I can see if I can replicate it...? Thanks.

[freakacid]

he has two axes, a shotgun and a autopistol

i assume now he just needs to put in the data manually, which he did not realize

[shadowmantis]

issue sovled/figured out, post can be deleted or left

[hive_angel]

I have been using your spreadsheet v6 and v7 to make a variety of advanced NPCs for regular usage with specific pasts so lifepaths matter a lot.

As other have stated in the past, melee as well as small and large ranged weapons do not display on the character sheet. It seems they are not pointing to the correct information thus not displaying correctly on the character sheet.

[GOTHIK]

I have been using your spreadsheet v6 and v7 to make a variety of advanced NPCs for regular usage with specific pasts so lifepaths matter a lot.

As other have stated in the past, melee as well as small and large ranged weapons do not display on the character sheet. It seems they are not pointing to the correct information thus not displaying correctly on the character sheet.

Where can I find V7?  has there been further revision since the last post?

Also .... why does the spreadsheet start out deducting 850 XP before I select anything at all?

Thanks!

[guardiandashi]

Where can I find V7?  has there been further revision since the last post?

Also .... why does the spreadsheet start out deducting 850 XP before I select anything at all?

Thanks!

the 850 xp is the "hidden" cost for being alive, called Universal Fixed Experience Points its on page 52 of atow as the last part of stage 0 (affiliation)
its 100 xp for each attribute, language affiliation primary or secondary, language English 20 xp, and perception 10 xp

[GOTHIK]

the 850 xp is the "hidden" cost for being alive, called Universal Fixed Experience Points its on page 52 of atow as the last part of stage 0 (affiliation)
its 100 xp for each attribute, language affiliation primary or secondary, language English 20 xp, and perception 10 xp

Doh!  Thank you!

[hive_angel]

Actually the character sheet is doing exactly fine on my end now. The problems I was having must have been on a macro or something it needs disabled system. I think it might be doing a few things incorrectly, but otherwise for the majority it is a top notch free fan product.

I got V7 from the creator through an email. I can share, but only if he allows it.

[GOTHIK]

I'm using V6.

I have a few concerns so far that all center around aging the character:

Changing the date of birth on the "Character Selection" page does not seem to affect the "In Game" years or XP on the "Journal" page.  Nor does it seem to affect the Attributes on the "Attributes Selection" page.

Changing the "In Game" years on the "Journal" page does affect the Attributes on the "Attributes Selection" page, but not the XP on the "Journal" page.

In order to have the character's age accurately reflected on the "Character Sheet" page however, only the date of birth on the "Character Selection" page, because if the "In Game" years field is also modified to accurately effect the Attributes on the "Attributes Selection" page, the characters age on the "Character Sheet" page is effectively modified twice.

Additionally, switching to (or from) "Standard Character Creation" and "Alternate Starting Allotment (p. 49 ATOW)" on the "Character Selection" page seems to have no bearing on this either way.

How do I either fix or work around these issues?

Thank you in advance for your help!

[gigobyte]

I'm using V6.

I have a few concerns so far that all center around aging the character:Changing the date of birth on the "Character Selection" page does not seem to affect the "In Game" years or XP on the "Journal" page.  Nor does it seem to affect the Attributes on the "Attributes Selection" page.

I just did a checkup, I have it working on my end. I created a character selected several life paths, all and all...they added up to 19 years old, looked at attributes, then changed the birth year to make the test character 30 years old and significant changed were added. I also added 11 years to the journal to years played and the same changes were present, showing that the total age on both tests were 30 years old.

Changing the "In Game" years on the "Journal" page does affect the Attributes on the "Attributes Selection" page, but not the XP on the "Journal" page.

It wouldn't as I have spoke to several GM's and some like to give out exp for playing some like to give out 100 per year no matter what...all preference.

In order to have the character's age accurately reflected on the "Character Sheet" page however, only the date of birth on the "Character Selection" page, because if the "In Game" years field is also modified to accurately effect the Attributes on the "Attributes Selection" page, the characters age on the "Character Sheet" page is effectively modified twice.

Could you clarify this more...not understanding.

Additionally, switching to (or from) "Standard Character Creation" and "Alternate Starting Allotment (p. 49 ATOW)" on the "Character Selection" page seems to have no bearing on this either way. How do I either fix or work around these issues?

The alternate is extra exp is awarded for character older then "X" amount of years as per the book, and I have it working.

[Hanekem]

Hi, Excelent work with this, could use a bit more explaining, but I understand it is a work in progress.

Anyway, for some reason I am having an issue selecting Small Arms (both small and larger ones), no mater what I choose in the drop down I get nothing but junk in the data fields

EDIT: fixed a bit the text to make the situation more clear.