That looks right to me. Leaving fields blank is equivalent to putting a 1 in them (not a 0). So by putting a 2 in each one, you bump each attribute up by one.

0 or 1 in the box are the free point. ever point after this raises from the base. It easyest to see this with a human but its just the way the system has been for ever vreson before even DamienKnight took it up.

to relate to the quat you posted:


'Purchase Attributes
As mentioned in Game Concepts, normal attributes range
between 1 and 6. A character’s metatype may adjust the maximums
higher or lower. Augmentation (either through technology
or magic) can allow a character to exceed their metatype
maximum to a certain point.
All characters start with the minimum attributes as noted for
their metatype on the Metatype Attribute Table. Characters also
start with a value of 6 in Essence, 1 in Edge (2 for humans), and a
value of 0 in Magic and Resonance. Initiative is a derived value and
is not calculated until after attribute values have been finalized.'

basically excel counts 0 or no entry as a 1

Yes but he's working with a dwarf. Putting 2 in the body box should give a 4, not a 3.

I don't have the sheet handy, but it should go something like this.

Vlookup the minimum and maximum stats from the Racetable for the selected race, add any qualities or powers that improve/lessen this to the max/min values.

Add the value in the box(es) to the minimum stat, if the result is greater than the racial maximum, flag it red.

Compare the calculated stat to the max, multiply the value entered in the box for the stat by 10, if the calculated stat is equal to the modified racial maximum, add an additional 15 (since the 10 is already in the multiplication... we just add 15 to cost out the full 25).

Merry X-Mas! Here is version 8e.

A handful of minor fixes, and alot of cosmetic tweaking. Enjoy!

happy holidays guys,

got a question for ya, I think I found another odd bug. I was working on a mage char when I noticed an issue, It seems that every stat I have that moves from 4 to 5 costs me 10 bp, but on logic when it moves from 4 to 5 it costs 25 bp. I was wondering if any one other then me was having this issue?



Thanks again,

Merry Christmas to you too.

Did you use an Ork? For Orks and other races with 5 as maximum for Logic. The fith and las point costs 25 BP. That is correct according to RAW.

No it shouldn't, 0&1 are the racial minimum(2 in this case) 2 is min+1 (3 he cot) to get 4 you have put 3 in there(for the dwarf)

It's just what I wanted!

With this one i get a visual basic runtime error '1004' everytime i change do anythink in the main page.
On the posite side i really like this new look much more then the last one.

It would be nice if you could add comlink modifcations and program packages from Unwired into the hacking page.

I noticed recently that the FN P93 Praetor is misspelled as Paetor in every version I checked, including the newest. Just FYI

Whoo hoo! Thanks! Something to do over the work holiday.

I just found a #REF error on the CharSheet page. On the 2nd sheet, in the header line of th Cyber/Bio box, the 2nd half is giving a #REF. In sheet 1 this is the section that lists essence. I simply copied the formula for this cell on sheet 1 to sheet 2 to fix it.

Good catch Tyro. Fixed in version 8f.

It is probably related to the VB script that is redirecting to the data page. Corrected 'Sheet1' references in the Main_Sheet VB code in version 8f.

I have not spent hardly anytime with the Unwired book, but I agree big time that program packages need to be implemented.

Not bad. Fixed that, along with the broken Languages in the 2nd sheet.

About all of this Stats raising on the main sheet. A 1 is assumed, and redundant when you enter it. Its not until you put 2 in that it actually raises the attribute. While this may be widely accepted, it is not mandatory. We can have the sheet work whatever way we want to.

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?

Thanks


I like it as-is, myself.

Seems I broke the cyberparts headings conditional formatting in version 8e. I didnt not want to release anything else untio 9, but it seems 8f is necessary.

Added a development mode for unprotecting, unhiding stuff. Try it out with Ctrl+Shift+D if you are running Excel 2003 w/ scripting enabled.

Stilling wanting to hear everyone's opinion about stats.

Hmmm every time i try to change the race i get some error which sends me to the following line when i debug:
Set Active_Skill_List_Range = ThisWorkbook.Names("Active_Skills_List").RefersToRange

Runtimeerror 1004

When reporting a script related bug, I will need to know what spreadsheet program you are using (ie. excel 2003, or excel 2007, or Open Office, etc), and which version of the sheet you testing.

Greybrother, I assume you are testing version 8f. Starting in 8e many of the lists in the data pages are now defined dynamically, using OFFSET and COUNTA to make sure all skills are included in the list, even if a user has manually added values to the list. This works great in excel 2003, I am not so sure about anything else.

If you are using excel 2003 with 8f, this should work properly (I just verified it on my system). If you are on a newer excel, its possible there is a problem with using dynamic ranges in the macros. You should try disabling macros. If you want to use the control box (requires macros enabled) but are having problem with the other scripts, you can always disable the macro in the Main_Sheet's code, called 'Worksheet_Change'. This is the culprit in your case.

The sheet is enhanced by scripts, but does not require them to be functional.

I also get that same error, the same i got with 8e too. And I'm using excel 2003, so don't no whats going on there.

Whoops Sorry.
I used Excel 2003 and it comes under 8e and 8f

Hello, I am new to this Game, New to these forumns and obviously new to this Character Creation Tool. I have done a Search of this Topic and did not find anyone else who posted this same problem, if I overlooked a post somehow I apologize. I am posting in regards to an error I get when I try to open this Excel sheet.

Some information, I am running Windows XP Pro SP2, MS Office 2003 with SP3 installed. I have gone into Excell Tools Drop Down seletected Options, then moved to the Security Tab, then clicked the Macro Security Button and selected the Radio Button option to set it to Low. I am trying to open file SR4Chargen_Upgraded_Beta8f.xls

When I open this file I get a Microsoft Visual Basic pop-up error box. It has a yellow Triangle with a Black ! in it and next to that is the following error message:

Error accessing file. Network connection may have been lost.

Below this error message it has two butons, an Ok button and a Help Button. Clicking help open the MS Excel Help page but it does not have any specific information the seems pertinent to this error. Clicking Ok brings up another Pop-up error box.

This second pop-up is labeled as Microsoft Excel and has a White Text Bubble with a blue i in it and next to that is the following error message:

Excel found unreadable content in 'SR4Chargen_Upgraded_Beta8f.xls'. Do you want to recover the contents of this workbook? If you trust the source of this workbook, click Yes.

Below this error it has two buttons, a Yes button and a No Button. I click on Yes and it opens the Excel Spreadsheet and puts a third Pop-up on the screen.

This third pop-up is labeled Repairs to 'SR4Chargen_Upgraded_Beta8f.xls' and below this It has a yellow Triangle with a Black ! in it and next to that is the following error message:

Errors were detected in 'SR4Chargen_Upgraded_Beta8f.xls,' but Microsoft Office Excel was able to open the file by making the repairs listed below. Save the file to make these repairs permanent.

It then has a two item list below this message as follows:

Lost Visual Basic Project.
Lost ActiveX controls.

Then below this list it has a line that says:

Click to view log file listing repairs: D:\TEMP\repair01196_01.txt

The file name portion of that is a blue link and below this is only a Close button.

When I click on the link to the .txt file it brings up a document that contains the following:

Microsoft Office Excel File Repair Log

Errors were detected in file 'E:\Role Playing Documents\Shadowrun Resources\SR4Chargen_Upgraded_Beta8f.xls'
The following is a list of repairs:

Lost Visual Basic project.
Lost ActiveX controls.


Any information you could provide on this would be most appreciated. After I close this box it seems to allow me to access the sheet but I have no idea what goodies I am missing out on because of this problem. Also I have Installed Office 2007 and tried it but this did not resolve the issue as it did basically the same thing in Office 2007 except it was even worse and the sheet was pretty much totally non-functional after that. I then uninstalled Office 2007 and reinstalled Office 2003 and re-applied the Office 2003 SP3 and it was still doing the same thing. I had my brother try it on his computer and it did the same thing on his computer as well, but both of our computers are using the same OS Image and the same version of Excel so if it is something in the OS or the version of Excel then that would be the same on both systems. Thank you in advance for any assistance on this.

GrimDarkKnight

have you tryed with office sp1 or 2 yet.
Also I assume you've tryed redown loading the file. If your using it off the net directly that could be the cause.

I think your spot on Dumori. The problem grimdarknight is having is likely related to a corrupt download, or a corruption caused when extracting from the zip. Redownload the file, then fully extract it before opening the spreadsheet (dont used the cached version your zip program creates as a preview).

I zipped the file using 7zip, using the ZIP format, with a Normal Compression Level and a 'Deflate' compression method. This is a pretty tame compression, and is not prone to errors, but things can get hairy when downloading.

The spreadsheet was developed in excel 2003 sp 2.

Odd, I must be getting the wrong file somehow. I am following the Link from DamienKnight's Sig and it is taking me to http://www.mediafire.com/?h3mxxsjvzmw and the file is downloaded uncompressed from there. It is listed as SR4Chargen_Upgraded_Beta8f.xls on that site and is 1.56 MB in size. As far as I can tell it is not compressed in any way unless the filename was changed to .xls or something.

If there is another location to download it from please let me know and I will get it from there. I have tried re-downloading the one from Mediafire a few times all with the same results.

Thank you,

GrimDarkKnight

Ammended, Odd, I just tried re-downloading it again, and this time it worked. I even got a different file size, the ones I had downloaded before all came to 1.57 MB and this one was small at only 1.56 MB, not sure whats up with that but it seems to be working now.

Thank you.

if i was doing it on paper and i bought 2 points i'd get 4

bod 2 +2 bp = bod 4

so i still don't get it

1 has to be the min because you cant have a stat of 0

so i'm still confused
thanks for the help

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?

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.

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.

QFT


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.

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.

Look on the Main_Sheet, below the field for race.

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?

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?

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

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

Been distracted recently. Woot! Thanks for the Christmas Present!



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".

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

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

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.


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.



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!

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.

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.

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

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

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

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

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

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

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.

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.

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. 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!

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 Really like the sheet over all. great work!