So the gear pages, and their summaries on CharSheet are not intended to be used after character creation? You mean the value of gear is not substacted from the Nuyen cell. At least to me this would be a really cool feature, especially if you add a Nuyen column to the Karma sheet. Then you probably wouldn't need any other record keeping for a character. I'm thinking about the old excel sheet by Harri Tusa here.

I try to turn the Free Contacts rule off, but it screws up the current BP/Karma box.

MR KNIGHT

Fantastic work i love playing with the chargen stuff.



can you(anyone) clear something up for me?

i'm inputting stats and the karma tally is going up by x3 for each one, my book however says it 10 points /point for build from scratch(i'm not maxing any stat ). the way i understand it is that its x3 for in game upgrades. am i doing something wrong or have i missed some errata. the knowledge/ language tally doesn't seem to be working i'm being charged for the points even though some should be accounted for (int+logx3).


another thing ive noticed is that the lifestyle sheet doesn't seem to be linked in, so i can make changes but they don't appear anywhere else.


Cheers Lynch

By default the karma build system (from runner's companion) is enabled. If you want the character creation with the rules of the BBB you have to set Karma_Build_System to FALSE.

Only the net cost and type of the expanded lifestyle can be seen on the CharSheet above the gear.

thank you

i had hoped it was something simple that i had missed. although i think i prefered the cheaper version.


Cheers
LYNCH

On the most recent release, the lifestyles page is linked to both your total money on the Main_Page and your lifestyle on your CharSheet.

The Charsheet simply summarizes your lifestyle data by showing your highest quality lifestyle on it, and how many months are remaining.

Yeah, I'm trying to use this, it looks fantastic, but under Win XP with Open Office 3.1 (I think, just downloaded the latest version), it crashes every time I try and turn off the Free Contacts option. Haven't really gotten any further than that.

May I suggest that the next version of the game use the core book rules as the "defaults"? No free contacts, standard BP, etc, since that's what most people downloading this are going to use?

*edit* Ok, played around again, and it's crashing every time I use any of the drop boxes.

I am using Open Office 3.1 on Vista 64bit and I am unable to reproduce your problem using version 9P, with java 6 update 13. Could you give us the step by step procedure for reproducing your crash?

Run eventvwr.msc and check the application logs for corresponding errors. I would suggest opening the chargen, reproduce the crash, and then open eventvwr.msc. Let us know if you find anything.

Version 9q is complete.

Now includes an Ally_Spirit sheet!
Fixed various minor errors, including the removal of artifact controls which only appeared in Open Office.

Check it out and let me know what you think.

http://www.mediafire.com/?miemjuqglwo



Same here. Java 6.13, Vista, Open office 3.1 -- Made a complete character no crashes.

Does the generator have weapons like rocket launchers in it? I am unable to find them

The cells of the ally sheet are locked.

Good catch Dakka. I fixed that and reuploaded the sheet. If you have a version with locked cells, just goto tools->protection->unprotect sheet if you are in excel 2003.


Nope, seems I left the launch weapons out. I will be sure to add them in the next release. In the mean time, you can add weapons via the Gear_Data sheet. (format->Sheet->Unhide in excel 2003)

Hi

I just updated the chargen, nice enhancements since 9b, thanks a lot.

I recently noticed that grades in cyberparts accessories could not exceed rate 6 whereas cyberlimb strengh upgrade forr example is limited to rate 7

Good job so far

Type-o is gone from the quality list.

Ill type in if I find other bugs!

Due to a glitch in the qualities formulas on the Qualities_Data page. Fixed for the next version.


Removed the dropdown data validation for ratings. Enter any number you like. If it highlights in yellow, the sheet thinks you have exceeded the maximum rating for the item.

Also, I have added two more slots for cyberpart enhancements in the next version.

is there a way to create our own skill groups?

in our game we made search into a skill and we added investigation.

then we got perception, Search, Investigation and intimidation into a groupp called Detective skill group. Also because we felt that piloting ground vehicule was too broad (alowing you to drive bike, car, 18 wheel truck, caterpillar and battle tanks) so we made Piloting ground vehicule into a group instead of a simple skill.

the cost for initiation in magic doesn't seem to ad up in the karma build system.

finally I could not find genetic mods and infusions. any chance we will get them in a future revision?

keep up the good work!

That's fine with me (I already did that) just thought it would be nice tp have it fixed in a next version. I reckon it's not urgent though.

Sure, just type in any skill you want. If it finds the word (Group) in the name, it will treat it as a group.
To add your new skills to the dropdown list, Format->Sheet->Unhide and select the Misc_Data page. You can find the skill list in there. Modify as you wish.

Indeed, it does add up in the Karma system. After you select metamagics etc. you must click an 'x' in the column to denote you have purchased it, which also reveals then next level of initiation.

It could happen!

vision magnification isn't on the cybereyes drop-down menu in cyberparts.

You can type it in though and it works just fine that way.

Great job on this sheet! I love it. It makes my life so much easier.

Could you add an option for money tracking earned + start money vs resources?

Version 9r is now available.

Features:
- Added 2 more slots for cyberlimb upgrades
- Rewrote description of cyberlimb parts in CharSheet to be more efficient
- Rewrote karma attributes cost for characters that are infected after character creation
- Now assumes all karma raises were done prior to infection
- Calculates correctly. May need to manually modify karma via karma_log if character has an attribute reduced to 1. Just test with before/after karma costs
- Does not charge karma for infection. GM may deduct karma to pay off infection as they see fit.
- Added Transgenetic Treatments and other geneware

Check it out and let me know what you think!

Just tried the newest sheet, same thing. And checking in eventvwr.msc, I didn't see any errors that related back to it (Either by type or by timestamp). Like I said, I'm on Windows XP with Service Pack 3, same Java. <shurg> Got no clue whats going on with it.

If anyone has any suggestions on changes I could make that might make the spreadsheet more stable in Open Office on windows XP, I am open to suggestions.

Bull, if you open the sheet, then immediately save it as an Open Office Document, does that help at all?


EDIT:

I have have two experiments for you to try Bull. Download each and see if they crash. If they do, reopen and change them to OO spreadsheets and see if that helps. Let me know how it works.

SR4Chargen_Upgraded_Beta9r-OOtest1.zip
(has all validation removed)

SR4Chargen_Upgraded_Beta9r-OOtest2.zip
(has all images removed)

I'm playing with it now. But just saving it as an Open Office spreadsheet file (.sxc file) seems to have done the trick. I'll check out the other two zip files in a couple.

Hi

Thanks for this new release.

I noticed two things :

• bug : dropboxes for positive qualities contain both positive and negative qualities
• feature request : you can't choose your parangon (tech) whereas you can choose your spirit mentor (mage).

Anyway I love your work

yok

Ok, Damien...

Test 1 has no drop down boxes at all. Test 2 locks up the same as the other.

The only thing that kinda worked so far is saving the file as an Open Office file, and the main page worked fine. But as soon as I switched to the magic page and tried to select myf irst spell (CHaracter is a mage), it locked again.

Wish I knew why it was being such a pain for me.

Also, you're missing the Trust Fund quality, I noticed.

That is not a mistake. The entire qualities list is compatible with positive and negative qualities. If after character creation you pick up a few more flaws (enemies, hunted, etc), you can use your positive quality area to fill in those flaws.

Likewise, you can put positive qualities in the negative qualities area if you like... the separation is cosmetic only. The only reason the Negative area does not show positive qualities is that chopping the positive qualities out of the list was the easiest way for the negative qualities drop down to show negative qualities first.

That is a good point about paragon's. I have never played a technomancer, so it is likely underdeveloped. I will look into adding that in the next version.



Test one is supposed to have no drop down boxes. It is there so that you have a version of the sheet you can use without crashing, you just have to manually enter the options. It is a little more difficult, but still usable.

Test 2 verifies that the images are not the problem.

It is a pain for you because you are using XP and OO. OO works with Vista and this sheet. Sorry about the trouble.

Trust Fund is there... twice. Medium and High. It only appears in your list if you are allowed to pick it, which requires that you have the status (Is_SINner) which is triggered when you select 'Sinner (Criminal)' or 'Sinner (Standard)'.

If you think a quality should be there and it isnt showing up, you can unhide the Qualities_Data page and scan the master list for it. There is a TRUE/FALSE column that has a formula that may cause the quality to be hidden on the Main_Page.

Ahh, I think I was trying to pick Trust Fund before SINner. Heh.

Ok, cool deal. I appreciate the help. Good to know my computer is now in the stone age

Marduc had an idea to provide a method of designating your purchases as before character creation/after character creation. He also added a new sheet specifically for tracking money.

SR4Chargen_Upgraded_Beta9r_Marduc_Money.zip

Please check it out and provide feedback. Does this seem like a necessary upgrade?

In my opinion, tracking purchases after character creation is a pain to do on the sheet, and better to be left to do manually. I provided a 'Nuyen' column to the Karma Log page (feature introduced in 9r) which can be used for tracking +/- Nuyen per run, but I prefer to use the 'Current Nuyen' cell on the Main_Page to manually track $ after creation.

The one thing the new sheet does not address is what happens when gear is lost? What about when you use your grenades, or your car gets blown up? You would have to get the cost of it, then add it as a negative on the money page, then remove the gear from your sheet. As with any spreadsheet solution for gear/wares purchasing tracking, it is going to be more trouble than it is worth. It is easier for me to just keep a running total of money the character has, then add/subtract as I make purchases.

That being said, if the community as a whole likes this change, I will think about integrating it with version 9s. Please let me know what you think.

Thanks for the new sheet Marduc!


edit:
This has given me an idea on how to address karma attribute changes when dealing with post-creation infected characters!

Don't have the Turbo mod for vehicles.

Ok, new sheet has Paragon and Turbocharger now. Its quite nice. Even has a spot to select which Sprite is your bonus sprite, if your Paragon has 2 to choose from.

Any other features the sheet is lacking that I can add for the next version?

When I add Knowledge Skills, it doesn't display them in the right cell until it starts costing BP. And Chatty from Unwired costs 10 BP instead of 5, see the Unwired errata.

Are you saying that it does not show your knowledge skills on the CharSheet until you actually add a rating to them? That is the way it is supposed to work. If that is not what you meant, then please elaborate.

Changed chatty to 10bp, thanks for the tip.


Character Generator 9s is released.

- Added Modular Cyberlimb support
- Added Paragons for Technomancers
- Various Tweaks

Please check out these new features and let me know what you think. Also, please check out the Ally Spirit page... I still have not gotten any feedback about that yet.

Thanks for all the suggestions folks. I believe this will be the Final Beta release of the sheet. It feels very complete and I am ready to take it out of beta.

Turbocharger only takes 1 slot, regardless of the level in the sheet.



EDIT: All these are for the vehicle sheet
Also, turbo doesn't add anything to accel - should add +5/+10 per level
Improved Suspension has the wrong cost - should cost Body x $5k, rather then the flat $80k you have
Ballast Tanks have the wrong cost - Level 1 should be Body x $2k, Level 2 should be Body x $10k
You don't have any of the Amenities listed
Amphibious Operation has the wrong cost - It should be Body x $250 for Level 1 and Body x $1k for Level 2
Body Stabilizer - Cost should be Rating x $3k
Chameleon Coating - Cost should be Body x $1k
Ducted Waterjet - Cost should be Body x $200
ECM - Not listed at all
Electromagnetic Shielding - Cost should be Rating x $2k
Enhanced Image Screens - Cost should be Body x $100

I stopped there, will take it up again soon. Eyes burning. ARG!

Great CharGen but it has still a few small failures but is in all a great help.

Here a few things i noted so far:
- Cultured Bioware (Synaptic Booster etc.) shouldn't be avaiable as Used Bioware as stated on P. 61 in Augmentation.
- Skinlink should be avaiable for all weapons as modification and give not an error when used on pistols and the like (Small beauty correction i guess).
- I'm missing the whole part for Genetic's. Like Genetic Optimization for the attributes.
- SIN's still get a wrong AV. Rating even with House_Rules turned off.
- Autoinjector missing from both Cyberware and Cyberparts Sheets
- Quite a few drugs like Kamikaze and so on are missing (sure who would use it but just trying for the complete list i guess)

I know that's jumping around quite a lot, but i'm writing that from my memory sooo... anyway great Generator so far, i especially like the new 5* Karma Attributes thing that got integrated recently.

What is the correct Availability for fake SIN?

List specifically which drugs are missing, with their cost per dose (or per ten doses or whatever the books have) and their availability, and I will add them in.

Ok,
For the drugs(all per Dose):

Deepweed 8F 400
Jazz 2R 75
Kamikaze 4R 100
Long Haul - 50
Nitro 2R 50
Novacoke 2R 10
Psyche - 200
Zen 4R 5

For the SIN/License:

Fake SIN Rating*3F
Fake License Rating*3F

Noticed something just now:
Under Gear:
Category Vehicle Gear
Neither the Morphing License Plate nor the Spoof Chip have their Prices entered.
1000 for the Plate and 500 for the Chip.
Both probably could be added to the Vehicle Mod Listing as well but they do their Part where they are right now as well.

What I mean is, when you spend points on Knowledge Skills, it doesn't show up in chargen until you're spending BP on them.

True, something seems to be broken in the Free Knowledge Skill Points Math. It add's them internaly but doesn't show the right amount in the table. Worse, when it reaches the Free Points Limit it starts to count the BP and makes it look as if those where the Free Points .
As i said prolly just something wrong with what the table should be showing cause internally it counts correctly.

I just wanted to throw in a quick post thanking you for all the work you've done on this project. I find the sheet very useful.

Hi

Wondering, is there a way to track changes like :

• skill group turning to to normal skills through karma expenditure
• skills turning to skill group through karma expenditure
• skill group > skills > skill group > skills ...

OK, may be this should be fixed, I'll make some tweak and see if I'can submit you some modifications

Thanks, I will update this on the sheet.



The way it displays points is the way Blakkie intended it. I will perhaps change the way it shows the free points, maybe that will help?



Thanks!



There is a cell for modifying the karma that should be added based on breaking up a skill group.

My habit is to put both the group and skill on the sheet, then subtract the cost of the skill per the group.

IE. Firearms 4, Pistols 6

Skillgroup Expand Karma would be: 22 karma

I have not yet found a solution to automate this without adding a whole new sheet for skills (not a good option) or inserting a macro (which only works for excel 2003 users...also a weak solution).

IMHO, after having examined the problem from several angles, manually adjusting your karma seems like the simplest solution.


I am not sure what part of 'That is not a mistake' you misinterpreted, but the qualities area will not be changed... It is perfect in my opinion. Go ahead and send me changes however... I am willing to accept that my genius is fallible.

Don't misunderstand me, I meant having both positive and negative in the negative part

Transgenic treatments have their essence cost reduced by biocompatibility.
The entries for nanocybernetics are the same as for nanoware.
In the calculation of the first mod of the vehicle page is a wrong ref which causes all the rating to be ignored.
All the vehicle mods which are calculated by body times are set for a fixed amount (bod16).
Turbocharger is calculated based on the running accel, not the walking accel.
There is no improved economy.
The cost for off road suspention is now a fixed amount but is supposed to be 25% of base vehicle cost.
Mimic and rocket boosters have no cost.
The cost of allergen Immunization is modified by the allergy which is cured.
The vision and audio enhancements have no rating.

There is no availibility of the vehicle mods.
Modular Cyberlimbs do not cost Essence. --> They should as they are a modification of the normal cyberlimbs

The BP cost of the knowledge skills is of. The sheet takes 1 knowledge skill point = 1 bp, should be 2 bp.

Could you also make a box for selected bonus spirit for the mentor spirit?

And could you add the option for weapon accessoires in the weapon sheet?

The sheet is becoming even more nice with every version

Umm.. yes they do. Look harder. The change-out limbs do not, but the actual modular limb does.

Yeah, you like what I did with Paragons? I should add that for Mentor Spirits.

They can... the column is called 'Mods'.

Yes, the sheet continues to grow and improve, mostly due to input from folks like you!

There are two kind of mods of weapons; the mods listed in arsenal from page 149 are different from accessories.
See page 148 modifications vs Accessories in arsenal.

Can you differentiate between the different mounts i.e. the top mount, the underbarrel mount and the barrel mount.

You can with appropriate modfications. They are listed as 'Lasersight, top mount' etc.

Where is the Complete_Adept_Powers_Table located? I'd like to modify the costs of some of the powers based on the house rules we're using.

Run the macro Developers mode
unhide the data sheets.

In the vehicle sheet,
the weapon mounts don't show the option for visibility/reinforment
And I can't find the drone racks

Can you add vehicle weapons to the vehicle page?