Dumpshock Forums > Upgraded Character Generator

DamienKnight

Jan 18 2009, 04:00 PM

QUOTE (Noirfatale @ Jan 18 2009, 07:29 AM)

tested!

I dint even get to click a drop down it crashed right after it said for security reason... macro are disabled. then another window pop up wich ask : This file contains link to other files, should they be updated? y/n.

say yes goto crash

say no and... well its working. I am trying a charater. will update if I get another crash.

Edit: okay I opened twice, did lots of drop down choice and it did not crash. This version seems stable if you dont update link to external file...

Anybody know why it does that?

The other version crash on yes and no...

Thanks for looking into it.

Excel posts 'Refresh link to other file' if there is another file linked in a formula, OR if one of the sheets has a space in its name and is referred to by a named range. That is why I have underscores _ in sheet names.

Open Office must have some other condition that causes this prompt accidentally. Probably has to do with named ranges. Ill look into it.

The change that made this version not crash was removing the named range 'Magic' because it shared a name with the Magic sheet.

OO users feel free to use Test 3 for now. I will include this OO fix in the next version.

yokyok

Jan 18 2009, 08:23 PM

Hi,

I just tested the sheet under the following environment :
OpenOffice 3.0
Ubuntu 8.0.4
Asus eeePC 901

And the sheet just crashes my OpenOffice, it happens at least with all beta 9x sheet.

By the way, if someone know how to get some log or trace from OpenOffice on ubuntu, it would help me find some more clue.

Yok

DamienKnight

Jan 19 2009, 12:46 AM

I have been working on the spreadsheet all day while watching Burn Notice and contemplating 'How can my runners be more like Michael Westen'.

"Too many different formats"

If anyone has ever encountered this error, you know the nightmare I am facing. Apparently Excel stores all of its cell formats in Formatting objects, not within the cell object themselves. The cells simply point to the Formatting object. Its a fantastic way to save resources when you have alot of similarly formatted cells, and I dont think there is a better way of doing it.

The issue is, Excel has a built in limit of 4000 Formatting objects. This includes number formats and Font/Shading/Border formats, and conditional formats. I have analyzed the sheet using a number of tools and decided the only way for the sheet to continue to grow without dividing it into multiple sheets is to revamp the formatting. It needs to be more uniform and basic, and without borders. Borders cause alot of unique cell formats, and requires alot of conditional formatting to keep them looking right.

I am going to spend a bit of time reformatting the sheet, and... making it more OO compatible. I have OO available to me for awhile, so I am doing some testing.

I still welcome all suggestions and bug notifications, and will attempt to address everything in its own time.

Thanks for the continued support. Ill keep you updated.

Fyndhal

Jan 19 2009, 11:05 PM

Ugh, I feel your pain. I get the "Too Many Formats" error at work now and again and it's a major hassle. For a while, I tried switching to Excel 2007, since it has a lot more format functionality (Sort by conditional formatting result.../swoon!) but the overall user interface annoyed too many of my users and we had to migrate back to Excel 2003.

Interesting side note on the Macro issue:
I use Excel 2000 at home. Version 9c of your spreadsheet gave me the macro error on opening it. Version 9b did not. This was a head scratcher, since the macros had not changed. Then I remembered that I had saved 9b after doing some editing at work (using excel 2003.) Apparently, saving the file in 2003 made the errors that were appearing in 2000 disappear. Interesting. Not helpful to folks who don't have access to multiple versions of excel, but still interesting.

Tyro

Jan 20 2009, 01:14 AM

Could you change Allergy, Addiction, Prejudice etc. to be editable so we can specify what they're for/to? I like how you did that for certain Adept powers.

Issues I've found with 9c:

Augmentations to the Reaction attribute don't appear to add up properly on the Cyberware_Bioware tab of 9c. I noticed it when using synaptic booster 3 with reaction enhancer 3; the total added to 3, not 6. I believe the RAI is to allow the two together, as the reaction enhancer does not add initiative passes and the move-by-wire system in Augmentation specifically allows reaction enhancers.
Maneuvers aren't costing me any Karma, and when I put an x into the box beside the maneuver entry, said box turns yellow (and still doesn't cost karma).
The Karma cost for the Martial Arts Positive Quality isn't adding to the total Positive Quality points tally in the top frame (where everything is added up).
Exceptional Attribute is adding 2 to the max. for an attribute (I checked all of them) instead of 1. Lucky works fine.
The auto-injector and extra dose capacity for same are missing from the Cyberparts enhancements dropdown.
Armor entries below the third on the Gear tab don't show cost, armor amount, availability or mod limits properly, as they reference the D column instead of the C column.
The Biometric Lock (in the "Commlinks Accessory" category of gear) has a listed cost of 0; that should be 150, as per Unwired 199. Fiberoptic cable should be 5/meter. There are a whole bunch of these; I suppose you're just in the middle of getting the new Gear page fully functional and I should leave you alone.
Ruthenium Polymer Coating is missing from the Armor Mods list, as well as Gel Packs and Radiation Shielding. Arsenal 50. For Radiation Shielding, Auto-Injectors etc., we would need a way to enter Capacity-based armor mods.
When I choose "Hardening R (1-6)" out of the "Electronics Options" category, the cells for both the category name (Electronics Options) and the item name (Hardening R 1-6) turn yellow with red text.
A "Notes" section for Gear would be invaluable for things like "this SIN has my real biometrics" or "this skinlink is for this device".

I'm using Microsoft Office Excel 2003 11.8237.8221 SP3.

Dwight

Jan 20 2009, 08:09 PM

QUOTE (DamienKnight @ Sep 19 2008, 08:04 PM)

And thanks again to Autarkis, Blakkie, Harri Tusa, and others who have created part of this or inspired my work. See the Main_Sheet for credits.

You are welcome.

Wow, nice to see folks still using this and growing it. Ensuring it runs on a variety of Netbooks? Very cool. Using macros runs straight-counter to my initial design goals but this is everyone's baby so I just hope it's doing what you all want and the macro use is worth the drawbacks that come with it.

Marduc

Jan 23 2009, 12:14 PM

It seems a very nice sheet, a lot of options

But the sheet doesn't take the positive quality from cell W39 into the calculation of the total bp for positive qualities ~~the martial art positive quality~~.

~~Also it doesn't seem to add the init passes from synaptic boosters to the main sheet~~

Marduc

Jan 28 2009, 01:57 PM

The meta positive quality dermal deposits doesn't get added to the damage attribute of the body.
where the quality toughness is added.

also the specialty of the language/knowledge skills doesn't seem to be added to the total.

Bobson

Jan 29 2009, 05:29 AM

Rather significant problem with martial arts, I just found out the hard way - easy fix, but important. The limits are one style advantage and two maneuvers per rank of the Martial Arts quality, not the other way around (which is how it is on the sheet). Arsenal p. 156 & 158.

Now I need to go redesign my character :/

GreyBrother

Jan 29 2009, 05:43 AM

Found something.
The Type O Quality doesn't calculate into the Cyberparts Table.

Dakka Dakka

Jan 29 2009, 10:57 AM

QUOTE (GreyBrother @ Jan 29 2009, 06:43 AM)

Found something.
The Type O Quality doesn't calculate into the Cyberparts Table.

That is absolutely correct. It's the cyberparts table. Type O System only works on non-cultured Bioware.

Tyro

Jan 29 2009, 02:55 PM

QUOTE (Dakka Dakka @ Jan 29 2009, 02:57 AM)

That is absolutely correct. It's the cyberparts table. Type O System only works on non-cultured Bioware.

Actually, I'm pretty sure the RAI is that it works on cultured bioware as well. IIRC the RAW are a bit fuzzy on this point.

Dakka Dakka

Jan 29 2009, 03:37 PM

I can only guess what the developpers intended but the wording is very clear. It is said that the essence loss of basic (as in not cultured) bioware is calculated as if it were delta ware.

Tyro

Jan 29 2009, 03:40 PM

QUOTE (Dakka Dakka @ Jan 29 2009, 07:37 AM)

I can only guess what the developpers intended but the wording is very clear. It is said that the essence loss of basic (as in not cultured) bioware is calculated as if it were delta ware.

All right, granted, but by my understanding of how higher-grade bioware works (cultured is a clone of your tissues, but it isn't a perfect one; that's why you can get alpha/beta/deltaware cultured, as per the FAQ on the official site) and considering the extreme cost of the Quality (30 BP or 60 Karma), I would houserule it to work for all bioware.

GreyBrother

Jan 29 2009, 04:01 PM

Whoops, sorry. I overread this part. Then nothing is wrong

InfinityzeN

Jan 29 2009, 07:41 PM

QUOTE (Dakka Dakka @ Jan 29 2009, 10:37 AM)

I can only guess what the developpers intended but the wording is very clear. It is said that the essence loss of basic (as in not cultured) bioware is calculated as if it were delta ware.

Wrong... Cultured is not a grade of Bioware. The grades of Bioware are the same as Cyberware.

Tyro

Jan 29 2009, 07:43 PM

QUOTE (InfinityzeN @ Jan 29 2009, 11:41 AM)

Wrong... Cultured is not a grade of Bioware. The grades of Bioware are the same as Cyberware.

Oh, I see now facepalm

Basic doesn't mean non-cultured in this case, it means non-alpha or greater grade.

Dreadlord

Jan 29 2009, 09:01 PM

The Karma Focus Bonding calculations on Magic tab Cell AD23 are not multiplying correctly. Apparently it has been that way for a while, since Beta7 at least, and still exists on Beta9c.

Counterspelling Foci should be Force * 3, it is showing as Force * 4.
Sustaining Foci should be Force * 2, it is showing as Force * 4.
Banishing Foci should be Force * 3, it is showing as Force * 4.
Binding Foci should be Force * 3, it is showing as Force * 4.
Power Foci should be Force * 8, it is showing as Force * 5.
Weapon Foci Reach 0 should be Force * 3, it is showing as Force * 5.
Weapon Foci Reach 1 should be Force * 4, it is showing as Force * 5.

Toodles!

Warlordtheft

Jan 30 2009, 06:33 PM

Hey, just a question. Why is spanish not listed in the languages? It does not seem to be under a different name like Aztlanter Spanish, Cuban Spanish.

Tyro

Jan 31 2009, 01:47 AM

Mutli-Fuel Engine is costing a flat 32k

instead of the Body x 1,000 it's supposed to in version 9c (Arsenal 138, table at the bottom of the page).

Suncell is costing a flat 16k

instead of Body x 500 (Arsenal 142).

The Anti-Theft System is costing a flat

6400 instead of Body x 200 (Arsenal 133).

Motorcycle Gyro Stabilization is costing a flat

9600 instead of Body x 300 (Arsenal 138).

Dakka Dakka

Jan 31 2009, 09:18 AM

QUOTE (InfinityzeN @ Jan 29 2009, 08:41 PM)

Wrong... Cultured is not a grade of Bioware. The grades of Bioware are the same as Cyberware.

This is correct but has no impact on the rules of the type o system quality.

Basic bioware is a type of bioware, just as headware or bodyware. So the rules say that the reduction applies to the items on the list for basic bioware (bbb p. 338 and augmentation p.171 f.) but not for items on the list for cultured bioware (bbb. p 339 and augmentation p. 172).

yokyok

Jan 31 2009, 01:41 PM

QUOTE (yokyok @ Jan 18 2009, 09:23 PM)

Hi,

I just tested the sheet under the following environment :
OpenOffice 3.0
Ubuntu 8.0.4
Asus eeePC 901

And the sheet just crashes my OpenOffice, it happens at least with all beta 9x sheet.

By the way, if someone know how to get some log or trace from OpenOffice on ubuntu, it would help me find some more clue.

Yok

Hi I made some more testing on Ubuntu 8.10 and a standard PC (thought it's 3 years old) wich has 3 Go of RAM, I'll check if adding some more RAM to the eeePC makes it work or not.

Tyro

Jan 31 2009, 11:35 PM

QUOTE (Dakka Dakka @ Jan 31 2009, 01:18 AM)

This is correct but has no impact on the rules of the type o system quality.

Basic bioware is a type of bioware, just as headware or bodyware. So the rules say that the reduction applies to the items on the list for basic bioware (bbb p. 338 and augmentation p.171 f.) but not for items on the list for cultured bioware (bbb. p 339 and augmentation p. 172).

I'm pretty sure they meant to say "standard", as in not alpha or greater.

Draco18s

Feb 1 2009, 09:12 PM

QUOTE (Tyro @ Jan 31 2009, 06:35 PM)

I'm pretty sure they meant to say "standard", as in not alpha or greater.

Good luck ever figuring that out. I sent WizKids an email back in November about what happens to worn equipment when a drake (or shapshifter) changes forms. A flak jacket on a dragon (or not) makes a huge difference: If the armor is absorbed (as cyberware is mentioned as doing) then you end up with 4/4 Hardened armor (useless). If the armor is destroyed (as per the novels) then you're out a flack jacket and have 4/4 Hard armor. If it stays worn and provides its bonus, that's 14/12 armor: Hardened or not?

(All values assume the drake did not take (Mystic)Adept/Mage and does not have magically enhanced armor--my character is +2/+2 above the noted values)

I should also note that the Critter Power "Mystic Armor" and the Adept Power "Mystic Armor" don't do the same thing. C.P. is astral defense, A.P. is generic bonus armor that applies on both the physical and the astral.

Tyro

Feb 1 2009, 09:16 PM

I would tell a player who wanted his drake to wear armor that he would have to create a unique magical item specifically designed to change form when he did.

Or just commission some drake barding and have your buddies put it on you after you transform

Draco18s

Feb 1 2009, 09:23 PM

I am that player

And as far as I have determined, there are not rules for either.

Tyro

Feb 1 2009, 09:25 PM

Hence "unique"

I seem to remember rules for unique enchantments in Street Magic.

Draco18s

Feb 2 2009, 05:05 AM

*Looks around for it. Tomorrow!*

Yeah, the rules are all fluff "go ahead, do whatever you want as a GM, but make it not overpowering" ("A “Turn Spirit to Guacamole” focus, it may be an aspected enchantment that only works when the planets are in a particular alignment—which will happen again in just 127 years or so.")

There's no rules on players creating them or having them commissioned.

Tyro

Feb 3 2009, 12:47 AM

I just created a character in version Beta 9c who ends up with 1.004 Essence worth of implants. The main page rounds it to 1, giving him an Essence score of 5 instead of 4.996.

De Badd Ass

Feb 5 2009, 11:16 AM

QUOTE (DamienKnight @ Jan 18 2009, 11:00 AM)

Excel posts 'Refresh link to other file' if there is another file linked in a formula, OR if one of the sheets has a space in its name and is referred to by a named range. That is why I have underscores _ in sheet names.

Open Office must have some other condition that causes this prompt accidentally. Probably has to do with named ranges. Ill look into it.

The change that made this version not crash was removing the named range 'Magic' because it shared a name with the Magic sheet.

OO users feel free to use Test 3 for now. I will include this OO fix in the next version.

Actually, there are some external links to some files, It wants:

A sheet called "Ware Lists" in a file called sr4chargenbasebeta7c.xls
A sheet called "Wares_Data" in a file called testing.xls

That last file was located in ".../Temp/Temporary Directory for shadowrun_chargen.zip/"
Not sure, but I think the first file was on your Desktop.

De Badd Ass

Feb 5 2009, 11:28 AM

QUOTE (yokyok @ Jan 18 2009, 03:23 PM)

Hi,

I just tested the sheet under the following environment :
OpenOffice 3.0
Ubuntu 8.0.4
Asus eeePC 901

And the sheet just crashes my OpenOffice, it happens at least with all beta 9x sheet.

By the way, if someone know how to get some log or trace from OpenOffice on ubuntu, it would help me find some more clue.

Yok

I opened the sheet in a VirtualBox PC:

Guest Configuration:
Base Memory 512 MB
Ubuntu 8.10
OpenOffice.org 3.0.1

Host Configuration:
Dual 2.8 GHz Xeon
Base Memory 2.5 GB
CentOS 5.2
VirtualBox 2.1.2

yokyok

Feb 5 2009, 07:58 PM

QUOTE (De Badd Ass @ Feb 5 2009, 12:28 PM)

I opened the sheet in a VirtualBox PC:

Guest Configuration:
Base Memory 512 MB
Ubuntu 8.10
OpenOffice.org 3.0.1

Host Configuration:
Dual 2.8 GHz Xeon
Base Memory 2.5 GB
CentOS 5.2
VirtualBox 2.1.2

I know, I just change the ubuntu distrib yesterday evening (from easypeasy to crunchbang) and it works well with 3.0.1 on my previous configuration it was oo 3, maybe it's the reason or maybe the default install of oo 3 on easy peasy is screwed (it doesn't come with crunchbang, I installed it manually).

anyway, thanks for your efforts.

Now I'll have a copy of my players' sheets with my eee-roleplaying assistant MUWAHWAHWAH (evil laughing).

Yok

Draco18s

Feb 6 2009, 06:57 PM

Oh, I doubt that'll let you do anything so evil as convincing a player he should get hired by a megacorp (aka Deep Cover) to trash their research labs.

Wait. I'm that player.

I am so screwed.

Draco18s

Feb 6 2009, 10:51 PM

Bug in the most recent sheet:

Exceptional Attribute (stat) raises max (stat) by 2, not 1. Core, page 78.

Martial Arts Styles advantages incorrectly gives you 2 advantages per 5 BP quality (you get 1 style quality per 5 BP). Sidebar Arsenel page 156. You've swapped the Maneuvers / Advantages counter boxes, basically.\

Positive Qualities isn't totaling correctly, cell W39 isn't being considered. Actually, AR39 is missing its formula.

FN P93 Praetorr has 1 Recoil Comp noted in the notes, but not in the actual stats.

Cell D12 on Gear sheet ("lifestyle"). The tool-tip note's box is too small.

Lifestyle's sheet, there are two lifestyles: Lifestyle #1 and Lifestyle #1.

Gear listing, category: "Nexus, Pre=Packaged"

Slap Patches -> Stimulant Patch is priced incorrectly at Rating * 125, the correct price is Rating * 25.

Tyro

Feb 9 2009, 02:20 AM

The Prejudiced NQ should be denoted (rc), as it comes from the Runner's Companion.

Brazila

Feb 11 2009, 06:39 AM

If you use the karma build system the cost for bonding foci seems off. If you mark it as bonded with karma it charges you 2 times, and even if you don't the costs seem off, I got a F2 Reach 1 wpn focus should be (3+1)*2 or 8 but it said 10, I got R 3 sust foci should be 6 it said 12.

Draco18s

Feb 12 2009, 03:24 AM

Conditional formatting for the Contacts area (Earned? slot) looks at the group active skills list to see if the box should be yellow if you try to specialize in a group skill.

This conditional formatting should be in the "specialize skill" column.

Found it because I made a personal note about having "specialized" in negotiation part of the Influence skill group due to a mentor spirit (just so I had a record of the +2 dice in the skills section).

Edit:
Trustworth is two qualities: one 5 pointer, one 20 pointer.

betterwatchit

Feb 13 2009, 01:14 PM

Don't forget to use the errata. For example: Chatty from Unwired is worth 10 points instead of 5.

Fyndhal

Feb 13 2009, 11:09 PM

QUOTE (Draco18s @ Feb 6 2009, 02:51 PM)

Bug in the most recent sheet:

Exceptional Attribute (stat) raises max (stat) by 2, not 1. Core, page 78.

This is because it is being calculated in two places. Once in the cell itself, and once in the hidden Attributes sheet. Note that even though it lists it being increased by two, if you try to purchase it at the +2 value, it chokes. I discovered this while trying to add Genetic Optimization to the sheet (I gave up; I didn't have the time needed to reverse engineer all the math being done.)

Nigel

Feb 15 2009, 10:58 AM

I'm not seeing it on the first post - what is current compatibility with OpenOffice? I don't have the cash to buy Excel, and I prefer the UI of OOO.

Great tool, though. I've seen this go through a lot of changes, and I am a big fan.

Krrayn

Feb 15 2009, 07:00 PM

Great work on this! I love it!

Very interested to see how AI works out in future versions. For now, I'm just getting familiar with the sheet by inputting existing characters.

One thing I noticed missing under Cybereyes component selection is the Eye Light System (augmentation p 37). Just a minor thing.

Thanks for all your hard work!

Nigel

Feb 18 2009, 11:09 AM

I downloaded this on a friend's PC (he has Excel 2007) and quite a few qualities from Unwired seem to be missing. Just the ones that I remember off the top of my head are Media Junkie and Virtual Personality. Any chance of adding these in the next version?

EDIT: Also, the new sprites introduced in UW are missing. Tank, Paladin, etc. I haven't noticed anything else, though I haven't looked that far through it.

Marvelous Marvin

Feb 22 2009, 12:59 PM

QUOTE (DamienKnight @ Sep 19 2008, 12:04 PM)

I am a big fan of the Character Generator spreadsheet created by Autarkis, and updated by blakkie. My SR group started using this sheet, and I began making small revisions. After awhile it turned into a bit of a pet project and the spreadsheet has come a long way. Since releasing the beta to Dumpshock we have reviewed and upgraded this sheet through seven major versions and its looking great!

I use Open office, and every time i atempt to change the true to false the thing crashes.

Best I can figure is that you have links to pages not with in the spread sheet and that is causing the sheet to malfunction.

InfinityzeN

Feb 22 2009, 04:27 PM

Try scrolling all the way over to the right as far as you can. There are check blocks there.

DamienKnight

Mar 16 2009, 03:48 PM

Version 9g is now available.

This version was created to address the excel 2003 issue of maximum styles used. The sheet received a style makeover, removing many borders to reduce unique cell styles, and changing some coloring to compensate for removal of vertical borders.

Also, the borders that do remain are no longer lightweight borders (show up as full weight in Open Office) but instead grey borders, so they translate to Open Office better.

Many requested fixes from the last couple months have been completely ignored in this version. I am simply proposing a new style, and want to get the communities approval of the cosmetic makeover before I continue developing fixes for the sheet.

As always, I look forward to your feedback.

GreyBrother

Mar 16 2009, 06:57 PM

Looks quite good to me, but in my humble opinion: Some borders wouldn't hurt. I really like the colors of the technomancer and magic tab

my (and my TMs) favourite color.

DMFubar

Mar 16 2009, 07:03 PM

Personally, I prefer the borders, just makes it easier to notice which line is which quickly. That being said, it is also just as easy for me to go in and add borders myself if I feel they are really needed.

Honestly, I am just glad to see you are still working on this DK, this is my favorite spreadsheet for character creation overall, and I like how it is constantly being improved upon. Do you have any intentions of looking over the anniversary edition of the book to make changes, or leave it at the eariler edition of the books?

Thanks again for all the hard work!

DamienKnight

Mar 16 2009, 07:13 PM

QUOTE (GreyBrother @ Mar 16 2009, 01:57 PM)

Looks quite good to me, but in my humble opinion: Some borders wouldn't hurt. I really like the colors of the technomancer and magic tab

my (and my TMs) favourite color.

While more borders would improve the appearance, it is not possible in Excel.

What I primarily need is a vote on 'Pass' or 'Fail' for this style, and if 'Fail', a reason the layout just doesn't do it for you.

If anyone wants to understand the issue and perhaps try and help, read below.

Boring explanation below:

[ Spoiler ]

Long story short, consistently using borders throughout the sheet is not an option. The current appearance makeover is not one of choice or preference, but of necessity. If someone has an idea for a style that looks better and does not create so many excess styles in excel 2003, please PM me a link where I can download a sample sheet with your new format and I will consider it. Requirements are:

1. Allows for multiple side by side columns (vertical borders or alternating backgrounds seem like a must for this).
2. Distinct highlighting of data entry points.
3. Must be consistent throughout the workbook.
4. Has to look good.

You can download the demo tool from this website to get a style count. It shows about half of your styles, so its not 100% useful, but is a good measure to compare one format against another. The chargen sheet had roughly 1800 registered styles according to this tool when Excel was hitting the 4000 limit.

http://xlsgenreduction.arstdesign.com/index_en.html

DamienKnight

Mar 16 2009, 09:43 PM

QUOTE (Tyro @ Feb 2 2009, 06:47 PM)

I just created a character in version Beta 9c who ends up with 1.004 Essence worth of implants. The main page rounds it to 1, giving him an Essence score of 5 instead of 4.996.

This is simply the spreadsheets number format for the Essence cell. It is set to '2 decimal places', which forced rounding. I have changed it to 'general' format for the next version (9h), which will show as many decimal places as necessary. Good catch Tyro.

QUOTE (Krrayn @ Feb 15 2009, 01:00 PM)

One thing I noticed missing under Cybereyes component selection is the Eye Light System (augmentation p 37).

Excellent observation. Added as a cyereye enhancement and a stand alone enhancement. Look for it in 9h.

QUOTE (DMFubar @ Mar 16 2009, 01:03 PM)

Honestly, I am just glad to see you are still working on this DK, this is my favorite spreadsheet for character creation overall, and I like how it is constantly being improved upon. Do you have any intentions of looking over the anniversary edition of the book to make changes, or leave it at the eariler edition of the books?

Yes, I am still alive. I have ignored the sheet for a good while. Mainly I was put off by the style 4000+ issue in excel, and spent a long time trying different formatting changes to resolve the issue. What I ended up with was terrible (looked like a checkers board) and I was frustrated enough to put it aside for awhile.

I finally got a little inspiration and redid the sheet. I dont think its beautiful, but I think it works and I am excited about working on the sheet again. I would love to get it out of Beta and into a stable version that everyone can use.

So... anyone have any ideas for a good Name I could give the sheet once it is out of beta? 'SR4Chargen_Upgraded' is a fine name for a beta, but I want something sexier for the final version.

Tyro

Mar 16 2009, 09:49 PM

QUOTE (DamienKnight @ Mar 16 2009, 02:43 PM)

This is simply the spreadsheets number format for the Essence cell. It is set to '2 decimal places', which forced rounding. I have upped it to 3 decimal places for the next version (9h).

Many thanks; I hate having to do Essence calculations by hand!

[Edit:] Any word on incorporating the new (and massive!) erratra from the Anniversary Edition?

[Edit 2:] Exceptional Attribute is still adding +2 to the max instead of 1, as of 9g.

[Edit 3:] Availabilities over 12 are getting highlighted as illegal even with Black Market Pipeline: Wares. This did not happen in 9c; I don't have any of the versions between those 2. I'm also not getting the Nuyen cost reduction; the BMP doesn't seem to be working at all