Please use this thread to provide suggestions and/or feedback to Tony on his Excel character generator.
—
J A C K G R A H A M :: Hooray for Earth!
http://eclipsephase.com :: twitter @jackgraham @faketsr :: Google+Jack Graham
Welcome! These forums will be deactivated by the end of this year. The conversation continues in a new morph over on Discord! Please join us there for a more active conversation and the occasional opportunity to ask developers questions directly! Go to the PS+ Discord Server.
Tony Lee's Excel Character Sheet
Thu, 2009-09-10 09:02
#1
jackgraham
Tony Lee's Excel Character Sheet
1) the Morph page doesn't seem to populate with data at all once you select a morph, and thus doesn't propagate through to the Ego page.
2) Is there anyway to incorporate a lookup for Positive/Negative trait costs?
James Knevitt * jknevitt@gmail.com
eclipsephase.com Forum Moderator
1) The data will populate once you enter a number into the Max Aptitude. I did that to force users to remember to cap their aptitudes. If I didn't add something about this in the HELP tab, I'll put something there.
2) Sorry. There isn't. I left out costs because it's possible to get traits free. I could include a worksheet with the standard costs for traits and other tables if there's demand for it.
-tony
In cases like Incompetent or Black Mark, there is no way to lower your rating, as the form will not accept negative values in certain fields. (or at least, I'm too dense to see how)
The work-around is simply to unprotect the sheet.
Bug or feature; you decide.
Also, sadly, the fields ALL show up as protected in Open Office, and nothing can be edited.
Ego Traits and Hardening sections could both be larger. With +/- 50 points of traits, that could be 10 lines, easily. Granted you probably won't be hardened to more than 9 things, but your list of stressful experiences with 1 or 2 occurrences is probably generally quite long. I understand there is a limit to space on the page, but there could be an auxiliary sheet that tracks the math for your traits, etc without eating up more space on the main page.
Really, really nice work here. Amazing sheet, and tremendously helpful.
I used data validation to allow values of a certain range. I didn't allow negative numbers. I'll change that in the next version. Sorry, you guys are sort of my guinea pigs. I need real world testing so work out the kinks. :)
--------------------------------
I have a caveat about Open Office in the readme. Can Open Office unlock the sheets? If not, I can upload an unlocked version.
--------------------------------
I wish I could've given more space to the ego traits. I wanted everything ego-related to be on 1 sheet and 5 measly lines were all I could afford. :( When I first started, there was a lot less info and 3 pages. It's gotten larger and larger...
I made this for our playtest group to use and it's now morphed into a project for the EP community. I'm happy to take input and work with everyone to have a good character sheet/generator. Can't promise to include every suggestion.
-tony
No apologies necessary. We're glad to be your guinea pigs in exchange for you doing all the hard work. :-)
-----------------------------------
Open Office can unlock the sheet, VERY easily. Tools --->Protect Document--->Uncheck Sheet. No password required, apparently.
Investigating a little more, if I re-protect the sheet in Open Office I can assign a new password, which will then be required to unprotect, but it seems to remove the original MS password automatically. Huh, that doesn't seem right.
Anyway, it's not really a problem, I just wanted you (and anyone without MS) to be aware of it. As it is, the protection is all-or-nothing, either completely unusable or completely unprotected, which makes the sheet a bit fragile for Open Office users.
-------------------------------------
Well, that's why I was suggesting a second sheet to handle overflow, that way it won't effect the fit on the page for people who only have a few entries, but it would allow more room for more complicated characters. As it is, for my sample character I ended up entering all my traits on just two lines, one for positive and one for negative, and entered all the details in a very, very long description, so it's workable.
Impressive.