[X] My Assistant

[Mäx]

ok so i have now got a copy of 8f

and as far as i can tell the first point is free butyou have to buy it

ie if i buy a troll and put 1 in all the stats <this gives me the racial mins> it costs no build points
but if i put 5 in the bod box <which should already be 5 rac md> it gives a bod of 9 and costs 40 bp

still a bit confused but i'll live with it

This program works so that you do not imput the value you want to have in atribute, instead:
you imput 0 or 1 = racial minimum
you imput 2 = racial mimimum+1
you imput 3 = racial mimimum+2
you imput 4 = racial mimimum+3
and so on.

Did that make you any less confused?

[DamienKnight]

ok so i have now got a copy of 8f

and as far as i can tell the first point is free butyou have to buy it

ie if i buy a troll and put 1 in all the stats <this gives me the racial mins> it costs no build points
but if i put 5 in the bod box <which should already be 5 rac md> it gives a bod of 9 and costs 40 bp

still a bit confused but i'll live with it

I suggest examining the total BP spent on attributes listed to the right of your modified attributes. See what the BP it before you change it and observe it after.

Also, the zip method I described is what I usually use, and what I did with 8f.. but I seemed to have uploaded the original unzipped file on accdient. Here is a link to a zipped version of 8f for quicker downloads.

[Blind Guardian]

Awesome work on the character generator, Damien. I've had a lot of fun playing around with the sheet and building characters for fun.

Beta 8c is the most recent version that works properly for me. Version 8d and later have been giving me an error message that says:

"Microsoft Visual Basic
Runtime error 1004
Unable to set the color property of the interior class"

The optional house rules toggles aren't displaying correctly.

I'm also occasionally seeing sporadic bugs in the weapon customization screen, but I haven't been able to make it happen consistently enough that I can identify what the problem is. Occasionally, a modification will display in yellow, even if it's the only modification to the weapon. I've encountered this both with trying to add a gas vent system to an AK-97, and a smartlink to the Ares Light Fire 70. In the aforementioned incident with the Light Fire, the price of the weapon also jumped to over 2000 nuyen, despite the smartlink being the only mod, as if I were paying the price for overmodifying a weapon. Is anyone else experiencing this?

I'm using Microsoft Excel 2000 on windows XP professional, so it may just be an issue with backward compatibility.

[Dakka Dakka]

Awesome work on the character generator, Damien. I've had a lot of fun playing around with the sheet and building characters for fun.

QFT

Beta 8c is the most recent version that works properly for me. Version 8d and later have been giving me an error message that says:

"Microsoft Visual Basic
Runtime error 1004
Unable to set the color property of the interior class"

The optional house rules toggles aren't displaying correctly.

I'm also occasionally seeing sporadic bugs in the weapon customization screen, but I haven't been able to make it happen consistently enough that I can identify what the problem is. Occasionally, a modification will display in yellow, even if it's the only modification to the weapon. I've encountered this both with trying to add a gas vent system to an AK-97, and a smartlink to the Ares Light Fire 70. In the aforementioned incident with the Light Fire, the price of the weapon also jumped to over 2000 nuyen, despite the smartlink being the only mod, as if I were paying the price for overmodifying a weapon. Is anyone else experiencing this?

I'm using Microsoft Excel 2000 on windows XP professional, so it may just be an issue with backward compatibility.

Same problems here, except that they occur in Excel 97 with Windows XP SP3 as well. So it might indeed be an issue with backwards compatibility.

The thing with yellow weapon mods has been around for some time. In the gear table some mods are listed as requiring smartlinks even if they shouldn't. I can't reproduce the increased cost for the Ares Light Fire. It's 2*350Â¥ as it should be.

[laptopscribe]

I just downloaded Beta8f, and I wanted to ask if I am missing something.

In the drop down menu for Positive Qualities, there is no option for the 5 point quality; Adept. I didn't see anywhere to add it on the Magic tab, and I could not alter my Awakened status. The sheet prompted me to add Adept as a Positive Quality, but I then got a Error 1004 message when it tried to add it.

Is there something I am missing when creating a Physical Adept using the sheet? Any assistance would be appreciated.

Thank you.

[Ryu]

Look on the Main_Sheet, below the field for race.

[laptopscribe]

Look on the Main_Sheet, below the field for race.

Literally right under my nose the whole time.

Thanks.

[DamienKnight]

Literally right under my nose the whole time.

Thanks.

While it is obvious to us Character Generator vets, this may not be obvious to new users. I will add something to the qualities comment that notes the location of magic related qualities.



For freeze pane haters, I am including directions in a comment on how to unfreeze the window. Right now I have these directions:

In MS Excel 2003:
Window->Unfreeze Pane

Could someone post the directions for unfreezing panes in Open Office and any other Spreadsheet programs being used, so I can add the directions to the comment?

[Tyro]

I know it would probably be a long way down the line, but would it be possible to add an option for using FrankTrollman's alternate Matrix rules at some point?

[Fix-it]

nice sheet, nice work. I find it handy to be able to print to pdfs using PDF creator, (which is free). is mighty handy.

btw, a few things:

the "In debt" negative quality is missing a minus sign, as it currently gives you the amount, instead of subtracting from your current (IMG:style_emoticons/default/nuyen.gif)

[laptopscribe]

While it is obvious to us Character Generator vets, this may not be obvious to new users. I will add something to the qualities comment that notes the location of magic related qualities.

The only thing I can think of, is because you labeled it Special, I glossed right over it, and went to Qualities, since Adept is a positive quality. The next place I went was the Magic tab, since it has the character's Awakened status there. Perhaps re-labeling the Special field might be an alternative, as well as a note in the Positive Qualities field as well.

Just my .02

[Cabral]

Been distracted recently. Woot! Thanks for the Christmas Present! (IMG:style_emoticons/default/wink.gif)

So... what is everyones opinion? Should we leave stats the way they are on the sheet, or should we change it so that each point you enter is added, therefore a Human with 5 points on Body will have a 6 body?

How about trying this:

Define a 8 (or more?) row table that populates itself with racial min to max for each attribute (Genetic Optimization and Exceptional Attribute bump the range of scores up from 6 to 8 but Metagenic Improvement improves the base and Max so behaves differently.)

Hide that table somewhere and reference it in a dropdown list (data validation) in the charsheet. That should bypass any confusion because you can then calculate the attributes how you want and the end user just sees "I want my troll to have a 3 Charisma".

[Cabral]

the "In debt" negative quality is missing a minus sign, as it currently gives you the amount, instead of subtracting from your current (IMG:style_emoticons/default/nuyen.gif)

This is correct. In-debt is a negative quality that gives you extra cash but you have to pay it back plus interest.

[Bobson]

Been distracted recently. Woot! Thanks for the Christmas Present! (IMG:style_emoticons/default/wink.gif)



How about trying this:

Define a 8 (or more?) row table that populates itself with racial min to max for each attribute (Genetic Optimization and Exceptional Attribute bump the range of scores up from 6 to 8 but Metagenic Improvement improves the base and Max so behaves differently.)

Hide that table somewhere and reference it in a dropdown list (data validation) in the charsheet. That should bypass any confusion because you can then calculate the attributes how you want and the end user just sees "I want my troll to have a 3 Charisma".

That might get tricky with modifiers for infection, karma purchases, improved attribute, and similar qualities and abilities. It would solve the problem, though.

[DamienKnight]

The only thing I can think of, is because you labeled it Special, I glossed right over it, and went to Qualities, since Adept is a positive quality. The next place I went was the Magic tab, since it has the character's Awakened status there. Perhaps re-labeling the Special field might be an alternative, as well as a note in the Positive Qualities field as well.

Special is a bit generic a label. I felt like Magic doesnt really fit because you can choose necromancer there. Internally the selection is named 'Magic_Type' because that makes sense to me.

For now I have slapped a comment on the 'Qualities' header that directs users to the special and infection areas. I think i will also put a comment on the Magic tab.

If anyone can think up a better label for 'Special' I will change it.

Thanks for the feedback laptopscribe.

This is correct. In-debt is a negative quality that gives you extra cash but you have to pay it back plus interest.

That was my original understanding of this quality. I am going with Cabral on this. If you are still convinced otherwise Fix-it, post a quote w/ page reference from the book and we will discuss it. If it turns out to be an ambiguously defined quality I will make an optional switch for it.

Been distracted recently. Woot! Thanks for the Christmas Present! (IMG:style_emoticons/default/wink.gif)

How about trying this:

Define a 8 (or more?) row table that populates itself with racial min to max for each attribute (Genetic Optimization and Exceptional Attribute bump the range of scores up from 6 to 8 but Metagenic Improvement improves the base and Max so behaves differently.)

Hide that table somewhere and reference it in a dropdown list (data validation) in the charsheet. That should bypass any confusion because you can then calculate the attributes how you want and the end user just sees "I want my troll to have a 3 Charisma".

I am already calculating in races, infection, and qualities, so creating a dynamic table should be a cinch. Using a dropdown is so obvious, and yet it never occurred to me. So simple... and so perfect. I will work on this for 9. Good job Cabral, you get a gold star!

[Fix-it]

nm. that is how it works. I was just confused that something would give you bp AND money without an immediate drawback. obviously that comes later.

[Draco18s]

So... what is everyones opinion? Should we leave stats the way they are on the sheet, or should we change it so that each point you enter is added, therefore a Human with 5 points on Body will have a 6 body?

The way that would make most sense, and be clear in all cases would be that whatever number you enter is what the stat IS (i.e. the way it is now for humans). So if I have a human and I put a 3 for body, I get a 3 and if I put a 3 for a dwarf I still get a 3, but at fewer build points.

"I want a X in STAT" method. It'd be obvious to all users how it's working.

The alternative is a "This is how much I want to RAISE the stat" (i.e. your second suggestion: a human with 5 in body has 6 body).

In Debt is an awesome neg quality. My physical adept spent 0 point on cash, got everything he needed from the 15k loan. The "downside" is that your monthly lifestyle costs go up by Y250 a month per 5 points of the quality.

[GreyBrother]

Something occured to me: Should the lower essence of the Infected react with their first Magic point? (8f, Excel2003)

[Ryu]

Adding "+If(Is_Infected;1;0)" to Main_Sheet.Q12 should do the trick, working around an addition to the Race Data sheet.

[betterwatchit]

Here's one for you: When I buy cybereyes or ears, it doesn't add the cost up for mods in version 8F!

[GreyBrother]

Thanks Ryu, it worked (although i got an error but it was due my using of the german Version which only knows "WENN")

[wind_in_the_ston...]

Could someone post the directions for unfreezing panes in Open Office and any other Spreadsheet programs being used, so I can add the directions to the comment?

For OpenOffice:
Window > Freeze (to uncheck the option)

[imrtlcomp]

For freeze pane haters, I am including directions in a comment on how to unfreeze the window. Right now I have these directions:

In MS Excel 2003:
Window->Unfreeze Pane

Could someone post the directions for unfreezing panes in Open Office and any other Spreadsheet programs being used, so I can add the directions to the comment?

In Excel 2007
Click the Review Tab
Click Unprotect Sheet
Click on View Tab
Click on the freeze panes drop down
Click on Unfreeze panes.
If you want to go back to Review Tab and Click Protect Sheet button and click on okay for the defaults

[wind_in_the_ston...]

Overall, it looks pretty good. I made an Excel-based generator a while back, but this one beats mine by a lot.

As a first test, I just entered the character I made last week. I figured it would be a good test, since it was a cybered ghoul adept. I don't know if any of these issues have been mentioned before, but here's what I found:

The nuyen costs for cyberpart accessories are not added in to the total. It took me a while to find the second worksheet for cyberparts. Can you put a flag in to direct me there? Or add the cyber eyes and whatnot to the list, and we can go elsewhere to pick accessories? Also, where in the BBB does it say how the availability changes for Alphaware?

My magic was reduced by 1 right off the bat, as if my reduced ghoulish essence reduced my magic. I don't believe that this is a correct interpretation of the rules (if it was intended function). It only reduces your maximum essence (and therefore Magic), and doesn't bring your magic attribute down. RC p.77 says Starting Infected characters start with Essence 5 and Magic 1 during character generation. The Infected may increase their Magic attribute with BP or Karma as any other attribute to a maximum of 5 (+ initiate grade).

Counterstrike adept ability is supposed to have ratings. I don't believe Attribute Boost has a maximum rating.

Reaction gains one point, between the Main_Sheet and the CharSheet. Oops, no it doesn't. That's my synaptic booster. (IMG:style_emoticons/default/wink.gif)

Several of the pull-down menus didn't work in OpenOffice. Not sure if this is an error with my version of OO, functionality that hasn't been updated yet, or just a glitch.

It's not calculating the damage code for unarmed correctly. It seems to be adding 1, for being a ghoul, but not changing it to P. It also seems to be halving the bonus for Critical Strike. And doesn't add the AP bonus for Penetrating strike.

In the pull-down list for skills and groups, Disguise is listed under both the Stealth group and by itself (not a big deal, I know).

Why is the TRUE/FALSE column (AF, Main_Sheet) green, when there are no pull-downs?

I would much prefer seeing the min and max for attributes, and entering the rating that I want. Putting the BPs in is not very intuitive. Once you've calculated the mins and maxes, it's not very difficult to make that range appear in a pull-down. That was one of the better qualities of my own spreadsheet - but I never attempted to add the infected.

Also, in my version, I use my karma log to keep track of expenditures. It keeps both a total earned and a current total. I have another similar sheet for nuyen.

It would be nice to have a condition monitor for comms, wouldn't it? (not sure - don't play hackers much)

I like that the ghouls' abilities are added in the qualities section. I was a little annoyed that I couldn't add them in the qualities list, until I saw that part of the CharSheet. (IMG:style_emoticons/default/smile.gif)

I would really like to see the linked attributes on the skills lists. I don't need to see the build point cost for qualities.

I don't see Essence on the CharSheet anywhere. Unless I just missed it... since Edge has its own area (I like the circles to fill in), could you put Essence where Edge is, in the upper left box?

On the Main_Sheet, in the legend box, it displays (in white text) whatever's in cell W21.

In the ranged weapon section on the CharSheet, could you left-justify the ammo column? I like to keep track of shots in that space. The mods column in the armor box on the CharSheet seems to be in bold. Where does the Notes or Description field appear on the CharSheet? I suppose it would be too much to ask to have pull-downs for buying ammo? I'm a little surprised that improvised weapons are on the gear pull-downs, because they're, you know, improvised. (IMG:style_emoticons/default/wink.gif) Btw, "Range Weapons" should be "Ranged Weapons" (nit pick).

Where do you choose lifestyle? No matter what I do, it displays Street on the CharSheet, and won't let me change anything on the Lifestyles sheet.

I'd like to see Mystic Armor added to the armor box on the CharSheet.


Wow, this got really long. Sorry about that! (IMG:style_emoticons/default/wink.gif)

[Cadmus]

Its not really important, but I thought I would kick it out for sake of being compleat, I noticed the gear section is missing a lot of weapons, As well the armor section is missinng things like gel packs ect, can be easly added in manualy but was just one of those minor little nothings you stare at (IMG:style_emoticons/default/smile.gif) Really like the sheet over all. great work!