So I'm looking at the "Advancement" tab, at B824...

The formula points to C174, which is the "First-Aid" skill rating.

1) What does First-Aid have to do with Complex Forms?

2) I can't find anything in the source books about getting Free Complex Forms, so am I missing something?

3) The Karma sum in C824 doesn't seem to actually add the Karma for Complex Forms, only adds Submersion and a blank cell with nothing in it.


So I think C824 should be =SUM(D801:D823) , unless there is something with the "Free" listed in B824 that I don't know about.

I sent my changes to Jamz on Sunday, I hope he puts them on the server for you to download.

Also, Karma spent on Technomancer parts are not added to total Karma Costs, so I think cell D28 should be "=D824+J813" instead of "0".

Hello,

so I didn't hear anything from Jamz.

I made the Changes KeyMasterOfGozer found and fixed a bug by the essece calculating.

Shadowrun_4th_Edition_Character_Creator_v2.0.4.zip

Please test the translation and report me bugs.

To select the Language go to the translation tab and pick the language you want to use.
if there ist no entry in the columb of the chosen language always the englich columb is used.

Edit: fixed the link

I'm not sure if I am missing something or if this is just an omission that has been overlooked for quite a while, but there is no Milspec armor from Arsenal in the gear section?

WOW ... cool that this is project is still alive and people are taking care about updates (thought it was already zombified when I found this).

First ... I should apologize for not looking in here for more than a year ... I am really sorry!

@Jamz: Nice ... !


[GERMAN]
TwistedMind, Grüße aus dem RheinRuhrMegaplex
[/GERMAN]

This sounds like a real great idea but also like a hole bunch of work and time to invest. How did you done the replacement and generation of the translation list, I assume some kind of macro copying all values to the translation tab leaving only a =TEXT reference in the source cell?

I already started again working a bit on the sheet ... so far I took care of the following items:

- Changed Costs for Attributes from fixed to variable value, enter cost per point in field "Atrib. BP Cost"
- Adjusted/Aligned some general Formatting (Still something to correct)
- Corrected Issue with free BP for Contacts generating general BP if not used
- Corrected Issue with (free) Knowledge Skill BP Calculation
- Slight re-design on round char function, free points are not forcing total value below 0 or above BP max anymore (beauty correction)
- Corrections / Adjustments on Macros as not all field where reseted correctly on a clear
- People asked for a page showing essentials for Magic and Combat on one page, so I made it. Not yet 100% satisfied with it, suggestions please!
- Extended Comlink Modification, Mods are now shown on charsheet while auto calculation Still missing.

Regretfully I worked with the last version of Jamz, so the translation function is missing ... anyway I will share my version when I am completed and finished with some testing.

In regards to the translation function ... I briefly checked if there is an easy way to combine both version but it doesn't look so. In addition I'm not quite sure how far I would be able to extend or just maintain the sheet with the translation function included as it makes it really confusing (while it is already confusing without ). Do you think there is a way to apply the translation (maybe via your macro) version for version hard coded or something like that after changes have been made? We still could use the same translation list.

@Jamz, TwistedMind and all working on this sheet in the past or those with plans for the future ... want to help, have ideas or request
ICQ: 86378870
MSN: Dark7even@o-t-d.de
... these are my IM details ... contact me, and maybe we could combine our affords?

I can't seem to get the sheet to work properly with excel 07. I click the button to finish and advance a character but absolutely nothing happens as a result. What am I doing wrong?

Okay, as promised I spent a bit a time on this ... and it got me on the hook again

Did you enabled macros? If not or you're uncertain ... check:
---------
1. Click the Microsoft Office Button image (top left), and then click Excel Options.
2. Click Trust Center, click Trust Center Settings, and then click Macro Settings.
3. Verify that: ""Disable all macros with notification"" or ""Enable all macros "" is chosen"
---------

I spoke with TwistedMind and when he gets a bit more time we will try to add an improved version of the translation function, first we need to fix some issues but before we start spending a lot of time on adding this functionality and creating the translation tables ... are there people really interested on a translation (mainly to German)?

@Mods: could you modify the thread description to make it reflect the current status "v2.2.0"? -Thanks

@Jamz: Feel free to upload the updated version on shadowrun.nerps.net. In the mean time, what about the ODS version you uploaded. I can't get it to work, is there anything special I need to consider? It would be great if we can make this sheet available in other formats as well, regretfully Excel 2003 is as good as impossible (at last for me).

@All: Again, I would be very glad to receive feedback may it be postive or negative . Feel free to yell at me !

Okay here we go ... but please note that I changed really a lot (not every change is visible) and this version is only tested by 97% ... it is just too much for me (and my actual group) to make it a 100% in such a short time. But I promise all issues reported will be fixed as soon as possible!!!

---------
DOWNLOAD:
For actual version please see my latest post!

---------
Change Log:

• Changed Costs for Attributes from fixed to variable value, enter cost per point in field "Atrib. BP Cost"
• Adjusted/Aligned some general Formatting (Still something to correct)
• Corrected Issue with free BP for Contacts generating general BP if not used
• Corrected Issue with (free) Knowledge Skill BP Calculation
• Slight re-design on round char function, free points are not forcing total value below 0 or above BP max anymore (beauty correction). Counting only for Knowledge Skills!!!
• Corrections / Adjustments on Macros as not all field where resetted or copied correctly
• People asked for a page showing essentials for Magic and Combat on one page, so I made it. I am not yet 100% satisfied with it ... suggestions please!
• Extended Commlink Modification, Mods are now shown on char sheet while auto calculation Still missing.
• re-design/make over of the Build and Advancement page. Now it has a much more logical structure (this was pain!)
• Added quick links and moved the modifications and color changer to the end of the sheet
• "Clean-Up of tables page. This is the beginning of a complete (but necessary) engine makeover ... Including but not only:
  
  1. Outsourcing of all source table to individual pages (DONE), this will make it a lot easier to extend the source list without impacting calculation.
  2. Consolidation and Streamlining of all calculation on a single ""calc-sheet"" sheet (STARTED)
  3. Removing unnecessary hardcoded values for dynamic calculation (STARTED)
  4. Creation of a master calculation Matrix covering all 'major' values (Attributes, Skills) (PLANNED)"

Corrected wealth calculation. There where some issues on dividing NY spent during BUIL and on ADVANCMENT

Fixed NY calculation issue when customs weapons is enabled

Corrected issues with Vehicle and Drone Modifications

Added a page featuring the primary vehicle/drone in a more illustrational way. I use this to prepare handouts for my group … I know this is not perfect and somehow ridiculous. I would be glad to receive feedback how to improve this page. Don't wonder I left the comments and remarks from my last Drone in english, you can/must adjust these details as required.

Started a how to and remarks section … not sure what to add … ideas?

the translation funktion is very nice...
and
yes, many people are waiting for a german version


In Version 2.2.0
Buggsreport after 10 min overview

*in the section "Eyeware" is no entry posible...

*no "ware" is immediately add in the aug. total attributes ...after finishing it works...

*In dept quality doesnt funktion normaly, it adds max only 5000 Ny...

these errors wasn´t in the earlyer version...


at this time, i think this version is to buggy ...
nothing funktion normaly ...
the 2.0.4 version is more usefull because you can generate a complete charakter...

@THalionus:

Thanks for your feedback

German? Okay know we are at 7 people requesting this


Correct, the named range was lost during near-term changes shortly before I uploaded v2.2.0 - Need to be more careful, hopefully we don't have the same issue with other named rages will verify in details tomorrow.

Yes, that is true but not really a bug as this wasn't working ever before (as far as I know). Never then less a good point I need to think about how to add this best.

Correct, the formula became invalid during move of the quality list to a dedicated page.


What do you mean with nothing? Except for the Eyeware issue I don't agreee that this version is really "buggy". Me and my group already generated and advanced multiple chars with version without issues. But of course, especially at this point, I can't guarantee that there are no further "major" bugs, so usage is at own risk but especially therefore testing by usage is much appreciated as this is the only way to get it finally free of even the smallest issue.

-----------
I already took care of point one and two ... I will share these fixes tomorrow with all, If somebody finds something else in the mean time just let me know and I will try to correct it as well for tomorrow.

i spend only a few minutes on the sheet and found 3 new major mistakes.... so i lost the interesst ....
and generate my new charakter on the 2.0.4 exelsheet...

the old version was a good one, why did you change the variation of the order?

Just wanted to let you know that there won't be an update today. I am really sorry but during adding some fixes and performing general cleaning and streamlining I found an issue making the Technomancer output currently unusable, I would like to fix this and do a bit testing before uploading v2.2.1.


@Thalionus:
Look like you got the right touch for finding bugs , you should continue doing so. In regards to the order the old one was OK but not very reasonable/self explaining so I decided to devide everything into two main sections:;
1. Stuff that is bought with points
2. Stuff that is bought with money
And within these two main sections I grouped everything that is connected and set in an order that matches the rule books order a bite more. I think people worked with older version could feel a bit uncompfertable but for people using this sheet the first time it will be a lot easier to use (I hope )


@All:
v2.2.1 - Actual Status:
--------------

• Fixed beauty issue with Melee Weapon listing (Thx to DerHühne)
• Fixed issue with named range caused that no Eyeware was available to chose (Thx to Thalionus)
• Fixed issue that "In debt" wasn't working anymore (Thx to Thalionus)
• Fixed issue that "Tough as Nails III" wasn't working (Thx to Michael)
• Done a work over for the Matrix & Commlink output sheet/section. In addition there are now two versions
  1. Classic - Vehicle & Matrix - Completely SR4A compliant
  2. Based on HR - Vehicle & Matrix (HR) - Program Usage HR: Skill+Stribute as DP and Program as hit cap., similar to Spellcasting (Magic+Spellcasting with power as hit cap.)
• Done the same as above for Technomancer (Note: If using HR also for TM, threading would still provide additional dices and raises the cap. That would be based on complex form level)

-------------


v2.3+ - Plannings
--------------

• Build an output sheet centering on the details required for Adepts and/or Mystic Adepts
• Update the the QuickSheet Output page
• Create all output pages new from the beginning (Currently I am testing here, but uncertain if I will proceed). This would:
  1. Lower sheet reaction and calculation time
  2. Improve scalability
  3. Would solve the Excel 2003 issue (as it would lower the total amount of unique cell formats)
• More people then expected liked the Illustrational sheet for the primary vehicle and submitted suggestions how to improve this, I will take care of this and add a flexible box/section where you can add a more details like a description and an explanation (e.g. special ruling)
• Due to the positive feedback (above) I will create a similar output sheet for weapons
• Improve "Drones & Vehicles" output page
• Improve "Combat & Magic" output page

--------------

please let me know if I should concentrate on a specific item.

Currently I don't know if I will get the time to work on this during the next two days but on Thursday (we got public holiday in DE) I should get some time to take care of some above.

Can we get a different download link than this "ul.to"? When I click on those links to download, the URL says the file is unavailable and the site is trying to get me to buy a premium account to find out where the file went. Maybe use a decent (TOTALLY FREE) site like anyhub.net or filebeam.com. Thanks!

Your wish is my command.

Question to everyone ... I would like to present this sheet not only as Excel 2007 version but also as Open Office (ODS) document, therefore I am a looking for an expert on this who could help me a bit. Because I tried multiple times but I always lost something essential.

And now as promised here is the updated version

v2.2.1. - Changes:

• Fixed beauty issue with Melee Weapon listing (Thx to DerHühne)
• Fixed issue with named range caused that no Eyeware was available to chose (Thx to Thalionus)
• Fixed issue that "In debt" wasn't working anymore (Thx to Thalionus)
• Fixed issue that "Tough as Nails III" wasn't working (Thx to Michael)
• Done a work over for the Matrix & Commlink output sheet/section. In addition there are now two versions
  1. Classic - Vehicle & Matrix - Completely SR4A compliant
  2. Based on HR - Vehicle & Matrix (HR) - Program Usage HR: Skill+Stribute as DP and Program as hit cap., similar to Spellcasting (Magic+Spellcasting with power as hit cap.)
• Done the same as above for Technomancer (Note: If using HR also for TM, threading would still provides additional dices and raises the cap. That is based on complex form level)
• Fixed issue with magic Attribute display for Mystical Adepts (Thx to Sarah)
• Re-design of NY & Karma page, now you can print it as well.
• Added an illustrational output page for Weapons, same as for Vehicles
• Created dedicated start page as well as a history page covering all "documented" changes to this sheet (as far as I could go back)

v2.2.1. - Download:
1.5 MB RAR - Excel 2007
http://www.mediafire.com/?enmgktznmdy

1.5 MB ZIP - Excel 2007
http://www.mediafire.com/?nztwqtbizmd

Looks good! Thanks!

I am sorry but it doesn't looks that good ... the sheet above (EDIT:just exchanged links) had again the same issue with Eyewares ... but finally I know where this issue is coming from ... It was caused by some scripts I am using for testing ... will be fixed in a few minutes.

--------------------
EDIT: And done

v2.2.1. - Download:
1.5 MB RAR - Excel 2007
http://www.mediafire.com/?enmgktznmdy

1.5 MB ZIP - Excel 2007
http://www.mediafire.com/?nztwqtbizmd

ok, i´ve try againe...

i select Reaction Enhancer (Rating 3)...

and

i scroll to the attributs... total aug attribut doesnt change...

i select the finish button and on char sheet doesnt change the reaction attribut....

i ve try it with the Muscle Toner II, and cerebral booster I,too




the easies tries dosent work...
why should i use this 2.2.1 version, i can get a paper&pen an calculate it self...


pls forget your changes... and work on the 2.04 version

Okay I don't what you are doing but something is wrong all of the wares above a working pretty fine (some of them are currently used within my group!). Maybe you can send me a copy of your char so I can take a look what is wrong here.


-------
EDIT:

Just received confirmation from a frind of mine testing v2.2.1, he wasn't able to reconstruct the problem above as well. So currently there is no confirmed issue known with v.2.2.1

Would be great if some other people could confirm if the Cyber- and Bioware like:
Reaction Enhancer (Rating 3)
Muscle Toner II
Cerebral Booster I
are or aren't working for them.

thanks

Dude, the guy is doing this work for free. How about you don't cop an attitude, and instead try to be constructive.

Thanks for the updates. As I've stated earlier in this thread, this is my favorite sheet by far.

Robert (aka Spanner)

There's a major issue with this new revision: knowledge skills are taking away from BP! I have 21 free KP but after I spent them I noticed they were taken from BP as well. I think it's because of the new formula in cell G240 (TotalSkillCost).

Typos:
"ACTVIE SKILL" should be "ACTIVE SKILL" (B117)
"RANGEL WEAPONS TOTAL" should be "RANGED WEAPONS TOTAL" (B495)
"RANGED WEAPONS & AMMONITION" should be "RANGED WEAPONS & AMMUNITION" (B468)
"COMLINK & PROGRAMS" should be "COMMLINK & PROGRAMS" (two "m"s) (B701)
"COMLINK & PROGRAMS TOTAL" should be "COMMLINK & PROGRAMS TOTAL" (B770)

Otherwise, so far it looks good, but I'm not cool with losing 21 BP.

Oh, yes you're absolutely right ... to be honest I didn't get the formulas for this by "Jamz" 100%, just walked this thru and now I see it there is indeed a issue with KP and BP calculation. Already corrected this for next release, I will finish some other tweaks and changes (e.g. there are some minor issues with Vehicle display) before uploading the updated version on Sunday. I will correct the typos as well.

Thanks!

In the mean time ... as a work around for this issue you can modify the BP spent too much in the BP breakdown!

Has anyone tried this with Excel10(beta)? I'm stuck with options of Excel 2003, 2010-beta, or OpenOffice, none of which work with this sheet (but I think we knew that already for '03 and OO). I wanted to check to see if others have run into this issue or if the problem is all user error because I would have thought MS would have done a better job of making macros compatible... or at least not crash the app. Or is that expecting too much of them?

Anyway awesome chargen from the few times I've seen it on computers of those that have '07.

You are right ... the version I shared before is not compatible with Excel 2010, it makes excel crash on all PCs (1x XP, 2x Windows 7) I tried. Seems to be caused bye an issue with the binary file support of 2010. I played a bit around It looks like when I export the sheet as .xlsm (Macro enabled 07 sheet) it is working fine. For the future I will share this as .xlsb and .xlsm hopefully this is working for everyone.

Here is a short status where we are with version 2.2.2 - Updated

• Done a makeover for the Vehicle output, fixed some minor issues there and improved general display
• Consolidated both (Normal and House-ruled) versions of the "Vehicle & Matrix" page and the "TM & Matrix" page. You can now toggle between Normal and HR display on the advancement page.
• Fixed issue with Knowledge skills causing excessive BP cost (Thx to Monster)
• Corrected multiple typos (Thx to Monster)
• Fixed a lot minor issues with the "Drones & Vehicles" page and aligned it with the new design of Vehicle output
• Foci Types where missing - corrected
• Fixed issues with "Combat & Magic" page, I would no call this ready to use
• Done some general fixing of minor issues

I will test a bit more and maybe upload it today, latest tomorrow.

Here we go ... just finished testing of v2.2.2. As my SR round for to day was cancelled I did a bit more then originally planned. Can't see excel anymore for today

v2.2.2 - Changes:

• Done a makeover for the Vehicle output, fixed some minor issues there and improved general display
• Consolidated both (Normal and House-ruled) versions of the "Vehicle & Matrix" page and the "TM & Matrix" page. You can now toggle between Normal and HR display on the advancement page.
• Fixed issue with Knowledge skills causing excessive BP cost (Thx to Monster)
• Corrected multiple typos (Thx to Monster)
• Fixed a lot minor issues with the "Drones & Vehicles" page and aligned it with the new design of Vehicle output
• Foci Types where missing - corrected
• Fixed issues with "Combat & Magic" page, I would no call this ready to use
• Done some general fixing of minor issues
• Slight makeover for the Martial Arts display
• Added "Medcare & Drugs" section including output function on Advanced combat page
• Added function to toggel display between "Martial Arts", "Medcare & Drug" and both.
• Improved support for Shapeshifters, corrected issue with missing Magic values here.

Download v2.2.2

All Versions available as ZIP and RAR here:
Download (MediaFire)
Each archive contains the sheet as .xlsb and .xlsm


Planned so far for future versions:

• Build an output sheet centering on the details required for Adepts and/or Mystic Adepts
• Update the the QuickSheet Output page
• Create all output pages new from the beginning (Currently I am testing here, but uncertain if I will proceed). This would:
  1. Lower sheet reaction and calculation time
  2. Improve scalability
  3. Would solve the Excel 2003 issue (as it would lower the total amount of unique cell formats)
• More people then expected liked the Illustrational sheet for the primary vehicle and submitted suggestions how to improve this, I will take care of this and add a flexible box/section where you can add a more details like a description and an explanation (e.g. special ruling) - Currently I suggest just using the comment or attachment section!
• Improve "Drones & Vehicles" output page, already done a lot but I am not yet 100% satisfied
• Extension of the program section, will come along with an additional work thru of "Unwired"
• Adding a clean way/function to break out skills from a group (or combine single skills to a group).
• Work thru of the "Unwired" sourcebook, just saw some stuff that is still missing
• Improve Technomancer Support, including submersion display on output pages

As usual all issues reported will be verified and fixed as soon as possible!

Thanks for updating this sheet so frequently. Good job!

Thanks, you're welcome ... I think after not looking after this for more then a year I just have to make some amends

Here is what I just updated (not much), will be shared again by Sunday EOD:

v2.2.3 - Status:

• Fixed issues with Initiation (Ordeal wasn't available for selection)
• Fixed issue with Electronic Warfare based programs when Hacking HR was activated
• Added new color presets to chose

A few things I find lacking in this sheet are:
1. Animal Handling skills from Running Wild
2. Missing weapons from the core book and Arsenal (e.g., Ranger Arms SM-4, Walther MA-2100)
Keep up the great work.

Hello,

I'm new to these forums and returning to SR after several years. Was trying to use these great spreadsheets to create my character and noticed some things missing. For negative qualities, Albinism from the Runners companion was missing, and also for Skills didn't see Arcana listed either.

Thanks!

You know, nobody has mentioned that Nanoware is missing completely from this sheet. I add mine manually to the cyber/bio section, but I thought I should mention it.

Robert (aka Spanner)

Not having gone through the entire 179 or so posts in this thread: Is this sheet SR4A compatible?

Yes. If there are issues, they're subtle.

Sweet! Thanks for the quick response.

Is there a way (either automagically or manually) to add my Mentor Spirit bonuses to the calculated pools? For example, Dragonslayer gives +2 to Combat Spells and +2 to one social skill. Is there anywhere I can put that so it's reflected in the output sheets?

Or, for that matter, to specify a specific Mentor Spirit? All I can find is the general Quality.

Also, in Weapon Modifications, adding an internal Smartgun system triples the cost of the weapon. SR4A 322 says it doubles the cost of the weapon.

I'm using Open Office. The zip file has two files in it, a .xlsb and .xlsm what's the difference between them?
I noticed that the negative quality Virtual Personality is missing, and wanted to add it, but can't seem to figure out where the data is stored.
I found the references the drop downs use, NegQualityList and NegQualityTable, but when I go to the cell locations they all appear empty. Are there hidden sheets or cells or something?
I've also noticed that buying just 1 point in a knowledge skill on the advancement sheet costs 1 karma, it should cost 2.
How does one buy a nexi, or multiple comlinks?

Ok, so I figured out where the data is, in the hidden sheets.
I've noticed some errors, which I'm going to list here and what the fix is.
On the Advanced sheet for the knowledge skills it's not bringing forward the ratings from the build sheet.

Change rating cells to:

=IF($Build.C212<>"";$Build.C212;"")

the referenced cell will need to change for each subsequent cell in the build sheet.

To make the Karma cost show up correctly you will need to change the Karma cells as well to:

=IF(C214<>""; ((VLOOKUP(C214;$callculations_and_skills.$A$149:$D$169;2)-VLOOKUP($Build.C210;$callculations_and_skills.$A$149:$D$169;2)))+IF(D214<>$Build.D210;1;0);"")

again with all the cells changing sequentially for each row.

The cost of buying a new knowledge skills is off by 1 as it costs 2 Karma for the first point in any knowledge skill.
Change the Karma cells to:

=((VLOOKUP(J214;$callculations_and_skills.$A$149:$D$169;2)))+IF(K214<>"";1;0)+IF(J214>0;1)

again with all the cells changing sequentially for each row.


Is there a way to define a technomancers Stream and or network? I've not noticed this yet.

Sorry, but why an .xlsm and an .xlsb files?
What are the differences between the 2 files?

And what's the meaning of "Hacking HR for TM"?