I can post? Finally?

So there I was, bored at work... I was reading the SR4 core book (I just picked it up recently, around a few months ago ) and realized that there was plainly too much math to do for one character that a whole day may be used to make a single character in my gaming group. That's when I decided to make my own character generator.

This was before I discovered the dumpshock forums. This also was when the copy of the generator I had was lacking, IMO, some very critical bits of information for complete noobs (which I was at that time)

Anyhow, I'll post more details when its less morning and more afternoon and I'll upload it on some channel when its less today and more tonight.

Also, are the moderators against yousendit links? (because that's the only thing that pops to mind at the moment )

Since it is now more afternoon (where I'm from that is).

Some details off the top of my head:
- Everything is done purely on Excel.

- No dirty macroes (if I wanted scripting I would have made a learned php and website out of it... which is also a future project. Very distant)
- It's updated till Street Magic till I get working on it for Augmentation (which comes in at the end of the month )

- Its still a work in progress...

- Right now I don't have an auto filled character sheet, but I'm pretty close. It's still in a "WRITE-IT-YARSELF-YA-FILTHY*snipsnipsnip*" version.

- I'll create a yousendit link later tonight (in roughly 5 hours) for anyone who wants to see the work in progress. (Interested parties PM me with their emails or something... bleh, brain no werk!)

- I'd appreciate feedback from the parties I send it to...

I promised a link, so here it is: http://download.yousendit.com/B4D32AC656060D71
Valid for 7 days or 100 downloads, whichever comes first.

I'd appreciate feedback from downloaders.

Edit: Sept 17, 2007

One thing I see right away, please start at the 1 place marker for the attributes instead of the 0 place marker. This means to max out any stat I will be entering a 5 and not a 6 in the points column. It doesn't make sense to have the user fill in the form with 1 when they will have a 1 in the attribute anyways. This way, the number entered in the points column "agrees" with the number in the cost column. If I enter a 4 in the points column I just spent 40BP and see that represented in the cost column. I don't really see any advantage to doing it the way you do it.

More comments will come as I have a chance to look at more of this.

EDIT:
1. I like how you separated the Physical and Mental abilities. Don't really know why, but I like it.
2. The average age, height, and weight are a nice touch.
3. The Skill description tab and Qualities description tabs are amazing. This is very handy, this is a great idea you have here.
4. The active skills tab is well done.
5. Wow, I just noticed all the other tabs in this workbook, dang this thing is exhaustive. You get the award for the most exhaustive chargen ever.

You did a really good job here from what I can tell. I would suggest using Ismo's character dossier if you are going to be having these values inputed into a .PDF. Your chargen and his sheets seem to fit each other rather nicely.

Gotta agree with Eleazar here, this is certainly the most exhaustive SR4 creator to date. Haven't stumbled over any glaring errors yet -- but here are a few smaller, rather cosmetic ones.

For some reason, the Height and Weight boxes keep converting my input into dates (2.25 for Height becomes Feb 25, for example).
Once you put in more than 95 points for attributes, the corresponding field to the right showing BP allotment goes blank (shows ##, to be exact); I suspect the three-digit number is too wide for the field?
The row height for Pilot Exotic Vehicle is off.
"Adept Powers (CC)" always shows "You have too many Powers" in the top cell of the F column.

These are all I could find in my first run-through transferring a char made with Daergann's SR4 CharGen.

@Nychuus: Nice Work. If you need Webspace PM me. Got some Webspace over ...

So you really are planning on doing the Aug thing when it comes in? AWesome. Mostly my group is composed of abject noobs so any tools help greatly.

Nychuus

I like the design of your chargen. The one thing that I have seen that needs to be changed is the Build Points.

On the main tab it is set to a default 400 and it can not be chaged. Our GM has a tendency to change this to 450 or 500 depending on what type of campaign he is running.

Other then that it looks good. I haven't had that much of a chance to play with is due to all my starting chars are at a 450 build.

Thanks

Have you tried the Prime Runner Percentage? That's exactly for such things. You enter a percentage and the BP are scaled accordingly. Granted, it works as a percentage and not an absolute number, but it works.

Oh... I thought that was some sort of house rule kind of thing. I guess I will play with it some more.

Only problems I am having are

A) there is no numerical limit to the number of powers an Adept could have. if a character chose to have 24 .25 point powers he could. ( if its magic rating was 6)

B) no method for initiating a character to raise its magic rating.

Other than that, so far this is the most complete generator out there.

Would like a few common knowledge skills listed. My players always get stumped on what to spend those on.

New release:

http://download.yousendit.com/B4D32AC656060D71

Current to-do list: (in random order)
-Character advancement tab
-Printable character sheets (for both OO and Excel)
-Implement Augmentation
-Open Office version (more stable? so there isn't anymore of those "row height"\"column width" problems.
-Online Version (php powered with printable sheets, waaaaay into the future)
-Common knowledge skill tab (for reference)
-More research into SM:
- Foci for everyone tab(?)

Did I miss anything?

Good news: I got Augmentation early. I'm holding it in my hands right now.

I'mma go make love to it now.

Hey Nychuus, I was just playing around with a sammie concept and found that installing Hydraulic Jacks in Obvious Full Legs takes up the entire capacity when it should, according to my BBB, only take up 1 point of capacity per rating of the Jacks, making 6 in each leg the maximum. Why's that?

ETA: Also, I found that the calculation for BP allotted to Attributes is off -- it considers an input of 6 to be the highest level and correctly deducts 25 points for that last step. Unfortunately, since all Attributes start at 1, you only need to enter a 5 to get to a total of 6.

In short, the Attribute input field stubbornly deducts 10 BP unless you enter a 6, which you never need to, because the total is always 1 higher than the input. Also, the metatypes' different Attribute caps aren't considered in the calculation either.

You see the problem, I'm sure.

Just adding a comment to the previous post... This problem is pretty easily fixed by changing the formula in column I from comparing column B and 6 to column C and column E. So, for example, the updated formula for the Body row (row 6) would be:

Happy to help.

Hey Nychuus,

I've run across a massive breakdown in the quick-fix sheet you sent me, on that makes creating a magic character impossible. For some reason, fields A19 (the one controlling the row handling Magic attribute BP allocation) comes up with an #N/A error (this extends to S1, the hidden field checking for the appropriate Street Magic qualities). I couldn't code Excel if my life depended on it, so I don't know where exactly the error comes from, but I hope it can be fixed.

Other than that, I am exercising Zen-like patience in anticipation of the Augmentation update. Ommm~~~~

Also waiting for the Aug update... and cheering. Feel the Cheers!!! Ny-Chuus NY-CHUUS!!! NY-CHUUS!!

Cheers!

Max

Hey Nych, I know you're working on implementing Aug first and foremost, but I've been playing around with Prime Runners creation and found that it would probably make creating high-level antagonist much easier if the PR% influenced not just the BP, but also the allowed max of points going into gear. It's somewhat silly to be limited to an amount of cyberware equivalent to 50 BP when you're trying to create a top of the line cyberzombie.

Perhaps the Gear BP could be scaled? Parallel to the rule that defines the maximum of Attribute points at 1/2 of a character's total BP, we should be able to put 1/8 of our BP (i.e, 50/400, 75/600, 100/800, etc) into Gear.

Stupid me, this thread has more than one page?! Damit.

Are you ready incorporating Augmentation?

Is there a link that works? Last two I tried from earlier in the thread says expired

Until Nychuus gets around to uploading his newest version, get it here.

Cool! Thanks Eurotroll! And of course, Nychuus!

Yes, I realize that its been around 10 months since I posted anything. So where the hell have I been?

Thank the wonderful people who employed me to bore me into a state where I just sit at my desk and stare at my screen for around 9 hours a day. For me to post anything, much more be on the internet, is an epic feat altogether.

I'm not going to make any excuses... instead I'll direct you to somewhere where almost all the excuses I wanted to use are already conveniently painted.

Yeah, that site is awesome.

I do realize that I still haven't complete Augmentation in my generator (its just two more sections in the Misc gear tab...) there still is the monster that is Arsenal (oh god the sheer amount of GUNS and doodads!!!) and the upcoming and I expect very soon, Unwired. Whatever else they put out may kill me. To date, I have not read, cover to cover, almost all the books.

Anyhow, I've probably been outdated in the character generator business... but this has kept me sane at my dead-end job. So here's the latest upload link:
https://rcpt.yousendit.com/575449742/ab5886...ef463a41fc0cb77

There is a lot of new stuff in there. I'm not going to enumerate, I'll just let you find it. Oh, that reminds me to put in actual Easter eggs into the final thing...

It is 10:30pm now, I'm going to bed to get some sleep for more screen staring tomorrow morning.
(no, quitting is not an option until October 23, 2008...)

Yeah... More updates.

http://rcpt.yousendit.com/578613632/4644ab...5ef499ac1551c4a

Nice work.

Thanks!

I have a question.

I have excel 97 and I'm not getting any drop down boxes on SR4CharForge2.xls.

I can type in Elf and get the elf stats, but I don't get the chance to pick from a list.

Is this an excel version issue?

Is my only option to upgrade?

Thanks

1. Yes. Though I'm pretty sure it would have worked for 97... -_-
2. I think so.
3. Not really, but to steal a line from Augmentation: "Upgrade or die"

Works with Excel 2007.