Upgraded Character Generator, Updated Generator Based on work from Autarkis and Blakkie Options

[Dakka Dakka]

In 1f the LMG Ranges are wrong. The sheet shows Assault Rifle Ranges. It should be 0-75m, 76-200m, 201-400m, 401-800m(SR4A p. 151)

The Nemesis LMG has weird range categories ending at 750 m

[Dark Talon]

Awesome spreadsheet, but there are 2 things that really need to be changed to make it Technomancer friendly:

1) When I raise a complex form using Karma after chargen, it does not use my available karma.

2) my Living Persona doesn't show up anywhere on the character sheet. Having a technomancer character sheet would be nice, or else simply have the Living Persona stats feed into the Commlink section.

Otherwise I've been loving the character sheet, it's been a -huge- help building my first technomancer character

[Saytr]

this has helped me build up several characters ranging from street sams to technomancers and adepts you have really put a lot of effort into this program and it shows how much effort and time building it everyone has put into it.

[Saytr]

this has helped me build up several characters ranging from street sams to technomancers and adepts you have really put a lot of effort into this program and it shows how much effort and time building it everyone has put into it.

[Saytr]

this has helped me build up several characters ranging from street sams to technomancers and adepts you have really put a lot of effort into this program and it shows how much effort and time building it everyone has put into it.

[Dakka Dakka]

The Stoner-Ares M202 (SR4A p. 320) is still missing in the weapons section.

The Runner's Companion suggests that the Enemy Quality does not come in multiples of 5. How about you divide the Contacts section in a positive part (Contacts) and a negative one (Enemies), so you an also create an antagonist that is between easy (Connection 1, Incidence 4) and overpowering (Connection 6, incidence 4)?
Manually this already works with negative values, but it would be nice to have a proper heading (Incidence instead of Loyalty) and not have to type the minus sign.

[edit 1]Woops you may want to do it differently since that way you won't keep track of the maximum negative quality BPs.[/edit 1]

[edit 2]Essence as a game stat should be rounded up. On the main sheet it is rounded normally and on CharSheet it isn't rounded at all.[/edit 2]

[DamienKnight]

In 1f the LMG Ranges are wrong. The sheet shows Assault Rifle Ranges. It should be 0-75m, 76-200m, 201-400m, 401-800m(SR4A p. 151)
The Nemesis LMG has weird range categories ending at 750 m

Thanks for pointing that out. It is now fixed in the upcoming version.

this has helped me build up several characters ranging from street sams to technomancers and adepts you have really put a lot of effort into this program and it shows how much effort and time building it everyone has put into it.

I am glad to hear the sheet is being put to good use. You are correct, the comm

The Stoner-Ares M202 (SR4A p. 320) is still missing in the weapons section.

The Runner's Companion suggests that the Enemy Quality does not come in multiples of 5. How about you divide the Contacts section in a positive part (Contacts) and a negative one (Enemies), so you an also create an antagonist that is between easy (Connection 1, Incidence 4) and overpowering (Connection 6, incidence 4)?
Manually this already works with negative values, but it would be nice to have a proper heading (Incidence instead of Loyalty) and not have to type the minus sign.

Added Stoner-Ares to 1g, Thanks for bringing that to my attention (again (IMG:style_emoticons/default/smile.gif)

Can you just select the 'Enemy' quality, then add a contact, click the x to mark it as an earned contact, and note in the description/name area that it is an enemy? I would like to create a more detailed contacts page eventually, but for now that seems the best way to address the issue.

Essence as a game stat should be rounded up. On the main sheet it is rounded normally and on CharSheet it isn't rounded at all.

Could you elaborate on this?

[Sengir]

Small bug I just found: Infected characters can get Magic 6 without initiation, accordingly the 5th point costs just 10 BP instead of 25.
Should be capped at five and the fifth point should costs 25 BP

[Dakka Dakka]

Could you elaborate on this?

The modEssence cell of the Main_Sheet shows the rounded value of Base Essence -Essence from 'ware and no decimals. the CharSheet shows the exact value. Forget about the rest I wrote that was just a false extrapolation from the fact that the essence loss is rounded down for the negative dice pool modifier for healing characters with implants. Essence drain uses a threshold that is calculated with the normally rounded Essence. So showing the exact value is a sensible idea.

[Tachi]

Certainly. If you want to help, you do not need mad coding skills. What I really need is specific feedback as to what I need to add to the printable sheets. I know I need weapons and gear. I already have a Magic and Vehicles page. If you have ideas on how I could improve those, or have specific ideas on how I could implement additional pages, it would be a great help.

I have not been able to play much Shadowrun for the last couple of months, so Inspiration is definitely my weakness right now. Give me ideas and I just might be able to put them to life in the sheet.

Hmm... I hand you a tall order, and you hand me a short order right back. Okay, give me some time to put my thoughts in semi-coherent order and I'll get back to you. Do you want a written description of what I'm thinking, or should I make a word/publisher charsheet and put it up on a file host? Keep in mind, I have OCD, it might take a while while I cross referrence, make an outline, a few rough drafts, etc. I rarely do anything half-assed.

[endou_kenji]

Heya, wonderful spreadsheet! (IMG:style_emoticons/default/smile.gif)

I just noticed it's missing the Poor Self Control negative quality from Runner's Companion (page 107).

[Caadium]

Heya, wonderful spreadsheet! (IMG:style_emoticons/default/smile.gif)

I just noticed it's missing the Poor Self Control negative quality from Runner's Companion (page 107).

I think its actually broken down into the specific parts (such as vindictive).

[DamienKnight]

Small bug I just found: Infected characters can get Magic 6 without initiation, accordingly the 5th point costs just 10 BP instead of 25.
Should be capped at five and the fifth point should costs 25 BP

Only infected without essence drain/essence loss are affected by the point of essence lost during the infection process. If you have questions about that, start a thread in the main shadowrun discussion forum and feel free to link us to that thread here.

The modEssence cell of the Main_Sheet shows the rounded value of Base Essence -Essence from 'ware and no decimals. the CharSheet shows the exact value. Forget about the rest I wrote that was just a false extrapolation from the fact that the essence loss is rounded down for the negative dice pool modifier for healing characters with implants. Essence drain uses a threshold that is calculated with the normally rounded Essence. So showing the exact value is a sensible idea.

Ah, I see... the Main Sheet is rounding, which is silly! Thanks for pointing that out. I have now fixed it in 1g.

Hmm... I hand you a tall order, and you hand me a short order right back. Okay, give me some time to put my thoughts in semi-coherent order and I'll get back to you. Do you want a written description of what I'm thinking, or should I make a word/publisher charsheet and put it up on a file host? Keep in mind, I have OCD, it might take a while while I cross referrence, make an outline, a few rough drafts, etc. I rarely do anything half-assed.

If you have ideas on a sheet, I will gladly accept advice... in written word, or drawn up sheet, or whatever you want to use to get your point across. Previously people have pointed me to a sheet with a feature they liked, or listed the specific features they needed in detail, or even wrote an excel mockup of what they were suggesting. Whatever does it for you will be fine.

I suggest submitting your suggestions before spending alot of time fleshing out every detail. I spend a limited amount of time on this sheet, and may not be interested in a suggestion, so you might want to throw the rough draft of your idea at me before you invest alot of time at it.

I think its actually broken down into the specific parts (such as vindictive).

Caadium is correct. I considered originally putting 'Poor Self Control (Vindictive)' as the name for those qualities, but it translated to the CharSheet poorly (too long!).

[Sengir]

Only infected without essence drain/essence loss are affected by the point of essence lost during the infection process.

And those characters (like ghouls) have their magic maximum correctly displayed at 5 but I can still select magic 6, ie. a ghoul with magic 6/5 is possible (IMG:style_emoticons/default/wink.gif)

[Draco18s]

And those characters (like ghouls) have their magic maximum correctly displayed at 5 but I can still select magic 6, ie. a ghoul with magic 6/5 is possible (IMG:style_emoticons/default/wink.gif)

Likewise the sheet doesn't complain if you give an elf 1 charisma!
(You even get the 20 BP for it--or possibly by making it a "3" it incorrectly charges 20 BP--I haven't checked)

[Sengir]

Well, if you enter the numbers manually and not via the dropdown fields you can even have an elf with -10 Charisma ^^
I guess DK sees things similar to the way I write my tools - if somebody wants to enter data freely I won't stop him, but don't expect me to check if that input leads to sane results.

[Caadium]

Likewise the sheet doesn't complain if you give an elf 1 charisma!
(You even get the 20 BP for it--or possibly by making it a "3" it incorrectly charges 20 BP--I haven't checked)

I actually ran into this the other day. I fiddling and making a character and had set Body 2. As I fleshed out the idea, I decided to go ork. When I did this I didn't change the dropdown field since Ork minimum is higher. Over to the right in the calculated field it showed Body 4 (Ork minimum) so I didn't think much of it. However, when all was said and done, my 400 bp character was actually a 420 bp character because my body was calculating at 4, but the 2 in the dropdown was giving me bonus bp.

[DamienKnight]

Well, if you enter the numbers manually and not via the dropdown fields you can even have an elf with -10 Charisma ^^
I guess DK sees things similar to the way I write my tools - if somebody wants to enter data freely I won't stop him, but don't expect me to check if that input leads to sane results.

Well, if I could stop users from putting an invalid value in, AND have a drop down, I would do that. Unfortunately excel/open office only allow a single type of data validation. I could turn on the annoying 'Oh no you di-ent!' popup option on validation to prevent invalid values... but I hate those.

I recommend if you change your race during character creation, double check that the values you have selected are valid.

Oh, and a Ghoul who wants a magic rating of 5 MUST select 6. Infection and essence penalties to magic are applied AFTER you have raised the attribute.

ex. Joe Schmoe mage has 6 magic. He turns ghoul... now his magic is 5. He still had to pay for 6 magic, but now its only 5 because of Ghoul infection.

[Caadium]

Well, if I could stop users from putting an invalid value in, AND have a drop down, I would do that. Unfortunately excel/open office only allow a single type of data validation. I could turn on the annoying 'Oh no you di-ent!' popup option on validation to prevent invalid values... but I hate those.

I recommend if you change your race during character creation, double check that the values you have selected are valid.

Oh, and a Ghoul who wants a magic rating of 5 MUST select 6. Infection and essence penalties to magic are applied AFTER you have raised the attribute.

ex. Joe Schmoe mage has 6 magic. He turns ghoul... now his magic is 5. He still had to pay for 6 magic, but now its only 5 because of Ghoul infection.

Here is a simple solution (using the calculations for body as an example):

cell AU3 currently says:
=IF(bpBody="",0,(bpBody-Base_Body_Min)*10+IF(bpBody=Base_Body_Max,15,0))

What I put in that seems to be working is this:
=IF(bpBody<(Base_Body_Min+1),0,(bpBody-Base_Body_Min)*10+IF(bpBody=Base_Body_Max,15,0))

I don't know if there is a reason that this would pose a problem, and I admit that I did not look at Karmagen to see if this comes up there too. Again, this was just my quick solution, not sure if it helps or if it gets in the way with other calculations, or maybe I'm just missing something. No matter what, just thought I'd share.

[Darquewing]

I just wanted add my two cents in, and say that the Character Generator is awesome, and thus far, is the only thing i've found that helps me (coherently) develop a Shadowrun character =)

One thing I was thinking though, was a printout page that mimics the "character dossier" sheet I saw on one of the other sites. I know that it's huge (like twenty pages), but has room for darn near anything. The only reason I was thinking this, is that with all of the pages filled in, people could just print the pages they really need or want.

[Sengir]

Oh, and a Ghoul who wants a magic rating of 5 MUST select 6. Infection and essence penalties to magic are applied AFTER you have raised the attribute.

ex. Joe Schmoe mage has 6 magic. He turns ghoul... now his magic is 5. He still had to pay for 6 magic, but now its only 5 because of Ghoul infection.

Hrmpf, either I misunderstood the rules for infected or I totally can't get my point across.

So, step-by-step:
1.) New, blank character
2.) Select "Ghoul" from in cell F2 (Infection)
3.) We have a Ghoul with Magic 1, max. Magic 5, Essence 5
4.) Hit the dropdown list in cell O12 (bpMagic).

- The possible range is 1-6, although RC p. 77 says the max. Magic for uninitiated Infected is 5
- The fifth point does not cost 25 BP as the maximum point for every quality should cost

[DamienKnight]

Here is a simple solution (using the calculations for body as an example):

cell AU3 currently says:
=IF(bpBody="",0,(bpBody-Base_Body_Min)*10+IF(bpBody=Base_Body_Max,15,0))

What I put in that seems to be working is this:
=IF(bpBody<(Base_Body_Min+1),0,(bpBody-Base_Body_Min)*10+IF(bpBody=Base_Body_Max,15,0))

I don't know if there is a reason that this would pose a problem, and I admit that I did not look at Karmagen to see if this comes up there too. Again, this was just my quick solution, not sure if it helps or if it gets in the way with other calculations, or maybe I'm just missing something. No matter what, just thought I'd share.

Formulas should not be coded to hide invalid selections on your sheet. They should only handle the correct values. If someone has selected an attribute below their minimum, then the area where they entered the invalid attribute should highlight the error... the final attributes an attribute costs should show incorrect values, or even #N/A. I do not want to conceal invalid values.... they must be brought to your attention and corrected!

So I will be adding conditional formatting to the attribute data entry cells which will highlight invalid values. Thanks for bringing this problem to my attention Caadium.

[DamienKnight]

Hrmpf, either I misunderstood the rules for infected or I totally can't get my point across.

So, step-by-step:
1.) New, blank character
2.) Select "Ghoul" from in cell F2 (Infection)
3.) We have a Ghoul with Magic 1, max. Magic 5, Essence 5
4.) Hit the dropdown list in cell O12 (bpMagic).

- The possible range is 1-6, although RC p. 77 says the max. Magic for uninitiated Infected is 5
- The fifth point does not cost 25 BP as the maximum point for every quality should cost

Ah, the sheet is calculating for New Infection (Post Character Creation Infection) only, which is to say, it is simply affected by essence loss.

To fix this, in version 1g I added a racial modifier to Magic for all characters who were infected at character creation. I applaud your persistence Sengir. Beat me with the facts long enough and I will eventually see it (IMG:style_emoticons/default/smile.gif)

[Caadium]

Formulas should not be coded to hide invalid selections on your sheet. They should only handle the correct values. If someone has selected an attribute below their minimum, then the area where they entered the invalid attribute should highlight the error... the final attributes an attribute costs should show incorrect values, or even #N/A. I do not want to conceal invalid values.... they must be brought to your attention and corrected!

So I will be adding conditional formatting to the attribute data entry cells which will highlight invalid values. Thanks for bringing this problem to my attention Caadium.

Thats a much better idea actually. Give the stat entry cells conditional formatting that turns them yellow (as all the other warnings on the sheet) to let the player know that something is amiss.

Oddly enough, when I was looking at the conditional formatting for those cells, it would appear that you already did this for karmagen characters.

[Udoshi]

Noticed some bugs: some guns don't seem to charge properly for internal Smartgun mods. Essence calculator appears to be broken.

Costs for some EPE's are off, like qualia any reakt. 40k, instead of what they oughta be.

edit: noticed on v1e. not sure if its been changed yet.