Feel free to modify your 'Vehicles_Data' and 'Gear_Data' pages to add customized versions of existing vehicles with the notes/stats changed.

They are modeled after SR3 gun building weapon bases. They are not arbitrary... they are very logical. If you don't like them, don't use them.

Ranges did not factor in Power throw. I modified the range table in 'Gear_Data' to reflect Power Throw. Look for this in the next version.

The Mentor Spirit dropdown is locked.

Uncouth isn't doubling social skill costs.

Cram still isn't listed under Drugs (among other things).

Unlocked Mentor Spirit Dropdown.
Added attribute column to Complete_Active_Skills_Table, then added 'if CHA attr *2, else *1' to active skills cost.
Duplicated Dope and renamed to Cram.

If anyone would like more details on any of the Gear list, please provide specfics (ie, availability, cost, etc)

Also, Added the optional Infection variations from (rc). Added astral projection testing for Astral Init calc (for export in SRSchema_v4, not used in sheet currently).

Several qualities are missing, including (but probably not limited to):
Outdoorsman (rc)
Obscure (uw)
More-than-Metahuman (uw)

Otherwise, love the product. Keep up the good work.
Imp

9j

Make an adept. Pick magic 5

Take the Influence skill group at 4

Go to magic tab and try to take improved ability social skill (Negotiations)

You can't take a single level.

This problem has to do with Text formatted cells from .xml. See my earlier response.

This is fixed in the next version.


Thanks for pointing these out Imp.

Ah thanks... When I enter karma in the karma log it doesn't update the karma earned field.

Is there anything I can do about the constant crashing?

On a related note - I find that this crashes pretty constantly on my old laptop (Windows XP SP2) but runs beautifully on my less old Desktop (Windows Vista). Both are running Open Office.

(It runs even better at work where I can use Office 2007, but work gets in the way.)

Phenomenal project, by the way. Kudos.

The computer Im running is an older laptop, I havcent had a chance to test it out on my home PC yet which is far better than this laptop. I also have a full-blown copy of Office there so I'll test that when I get home

I do not use the program, I do not like the layout. I was simply correcting (by RAW) other poster's assumptions about that rule.

Damien, I'd recommend using the SR4A errata, as obtained here.

Or even better a switch to specify if the old (Errata 1. or new rules are used.

That could work.

Actually... could it be possible to let the user specify what costs how much to raise? That would be nifty.

You could also add a new dropdown that all other changed data refers to. Label it "Errata Version", and depending on the item determines the fields it's pulling data from. Does it significantly increase the project size and complexity? Yeah, but it's the only way I know off the top of my head to make it perfect for everyone, without having completely separate files (which may be easier).

I'm having some troubles on lifestyle costs. I'm running it in open office 3.0.1 and costs remain at 0 regardless of the number of months, or lifestyle put in, the same occurs with the advanced lifestyle tabs. I put in various values, and it doesn't alter the cost.


I checked the formatting on the cells where you input the months purchased, and the months passed, both had a format of accepting text, so it wouldn't calculate in open office the number of months remaining so it remained at 0. By changing the format to accept numbers it seems to fix the problem. The odd thing is, it seems to only do this on my desktop(Windows XP with open office) while my laptop it works perfectly well on(ubuntu with open office).

I will modify things to allow for errata, but some things can be controlled by the player. Ie. I will update the arrows cost, but may leave Bows with str 9+... you would just have to not select bows that are declared illegal by your Errata loving group.

I got a new laptop yesterday and will be spending alot more time in Open Office, so hopefully I will track down the source of all the crashing. I may choose to stop supporting scripting through Excel... have not decided yet.

I don't know that much about how to make things in excel, so i'm dont know what are causing these but here is what i have discovered so far for version 9j:

-Dracoforms dont count the cost of magic unless they have adept/magician/mystic adept. They should be able to do so without taking those qualities (though why you wouldnt is beyond me...)
-In the gear section, on every second line the quantity box wont accept numbers as the number "is not valid"
-Adept powers will not allow the selection of any multi-level abilities above 1, or even entering 1 in level, stating that they need to <=magic, even if magic is higher than 1.
-Missing negative qualities from unwired: Data Shadow 5BP/Level, max 3 levels. Media Junkie 5BP/Mild, 10BP/Moderate, 20BP/Severe, 30BP/Burnout. Vitual Personality 5BP/Level, max 3 levels.

In 9j, running Excel 2003, I can not add complex forms.

Any number I enter (for either BP or Karma) for the rating of the complex form causes the Complex Form Rating modal dialog to pop up.

This is just the text formatted cell issue.

In the Knowledge Skills section, what do the prefixes AK, BK, IN and SW mean?

Guessing here but they are just a form of grouping.
AK Area Knowledge
BK Background Knowledge
IN Interest
SW Sixth World

Ooo... K. How come the only one of those designations that actually appears in the rulebook (you know, the book you consult while making a character) is Interests?

Look on page 129 of SR4A for a list of the knowledge skill areas.

I don't have my older pdf anymore... so I can't tell you what page for that one, but it's there too

Because they were SR3 designations, that didn't have any mechanic impact, IIRC. The new designations would be more appropriate, as they specify thich attribute is to be used in tests.

There should also be B/R in there somewhere which stands for Build/Repair Skill.

Running the latest version of OpenOffice under Linux, the spreadsheet is a total mess - everything seems to be overlapping.

[img]http://img232.imageshack.us/img232/5996/oooz.th.png[/img]



Kerala is a very nice place to live (my cousin's been there on and off for years and is about to marry some nice Indian girl), but he did mention a few problems, such as an extremely unreliable power grid and minimal telecom. Compared to major centers of industry like Bangalore where you can get better DSL than in most American cities, it's pretty backwards.

I'm also slightly surprised that you have many, many Israeli guns but a complete absence of Israeli language.

I have regular SR4. I won't have SR4A until my copy of the LE arrives in... whenever it arrives. Under regular SR4, knowledge skills are broken down into Street Knowledge, Academic Knowledge, Professional Knowledge, and Interests.

AK is Streetwise
BK is Academic

Sortof.

Ok Im back at home with my regular desktop PC and I tested it out using the absolute latest version of OpenOffice.

Exact same results.

It crashes constantly. I tried it with macros enabled and disabled and no luck. Changing ANYTHING crashes the program instantly and forces you to recover it.

After you recover it, you can change a few things but then randomly it will crash again. Also it crashes after saving and autosaving.

The same set of circumstances has happened on two different computers and I dont know what I could be doing wrong.

What version of the Java runtime do you have? As I recall OO is Java based...

I just updated Java and the same problem is happening

I tried down loading this from the link at the front of the page, and its not working. Is there another link its available from?

Let me start by saying that I love what you have done with this character generator. I appreciat all the hard work that you have put into making this.

I have noticed a few things that don't seem to work (and if I'm wrong I apologize up front)

1) On the gear sheet there is a 'Qty' field but when I try to put anything in that field (beyond the first one) it says "The
Value you entered is not Valid. A user has restricted values that you can enter into this cell."

2) After entering a qty in the above mentioned field, it is not represented on the printable character sheet.

3) When I enter a vehicle on the Vehicle sheet it dose not show up on the printable character sheet.

4) When choosing to make a magic character the spreed sheet accounts for the BP cost of the necicary qualities but
dose not put them on the caracter sheet.

5) When entering a custom weapon, the mods are not shown on the printable caracter sheet.

6) Remaining neuyen is not listed on the printable character sheet.


Please don't think I'm complaining. I jus thought I'd bring this to your attention as I did not see any mention of it anyware.

Also, If I'm doing somting wrong while entering the information that is casuing these problems please let me know.

Lastly, I'm using this in Excel 2007.

1. Import problem , reset column from TEXT to INT
The rest I don't know

I fixed the Qty problem when I accidently found certain cells work fine. I just copied those cells to the problem cells.

And, yeah, I want to reiterate to the creators that this spreadsheet is OMG! helpfull and incredible, and, being the father of a 13 year old girl, I can't stand the whole "OMG" thing. So, yeah, I'm sure I speak for the players that have downloaded your creation, this rocks.

But why settle for "rocks" when you can ask for perfection, right? (Das funnee, ya?)

The printable character sheet is more of a proof-of-concept for me than an actual complete character sheet. Some of the most popular character sheet .pdf have more than a dozen pages. I am not adverse to programming that many pages of selectable output, but it has taken a backseat to actually fixing things.

I am hoping to create formatted character sheets which are a separate file from the character generator, but which use spreadsheet references to grab data from it's named cells.

That would accomplish 2 things:

Loading 14 less pages when you are focusing on building your char, and 20 something less pages when you are printing.

Modularity that would allow other spreadsheets to be used by the printable character sheets.

I believe I have developed about as many 'new' features as I would like in the sheet (except maybe Free Spirits , so it is definitely time to refocus on formatted printing.

First though, I need to make the spreadsheet work better in Open Office. To that goal, I am moving my developement to a OO only box (my new laptop, w00t) and may be dropping scripting support completely, since scripts are not compatible across different spreadsheet programs, and never work in the online spreadsheet programs like google docs etc.

Unfortunately this also means removing the Optional Rules Controls which everyone seems to love. Option rules would be controlled solely by the true/false switches, which are located behind the controls.

I can script in OO Basic, but again, it will not be compatible with other apps. Currently I am unaware of how to embed both vbscript and OOBasic scripts in the same spreadsheet. It sounds like even if it worked it would be buggy.

Is losing scripts worth getting better Open Office support? I am beginning to think it may be, but would like to hear the communities opinion.

Personally, I would love a OO version; then again I don't own MS Office at home - I don't want to pay that kind of money for Excel and I don't like pirating software. I also haven't been playing SR long enough to worry about the optional rules.

So, I'm biased.

So my opinion is "YAY", but I realise that I might not exactly be representative here.

Even WITH the crashing on my laptop, I adore this application. The idea of separate character sheets that pull data from the character creator is giving me a warm tickley feeling.

I think having both an OO version and Office version (or, possibly, a drop-down box that you select either OO or Office in) would be ideal; that way, the Office users could have all their scripts and OO users could have full functionality. This may not be possible, so I think the best compromise would be to give OO users full functionality while losing a few scripts.

Not to encourage masochism, but does excel support javascripting?

So far, for me, macros and scripting have NEVER worked and cause more grief than is warranted. I LIKE the idea that we could have kewl stuff happening around the sheet, but in practice the macros have NEVER worked on any of my computers, whether running Open Office or Excel. I have tried to use macros at work as well, and have NEVER gotten them to work satisfactorily. Even within one company, people are running different versions of Excel on different kinds of computers, and it is giant pain in the behind.

Call me a Luddite, but if it don't work, go back to basics!

I understand what you are saying, but I hope you find as much irony in this as I do.
A Luddite wouldn't be on the forums

Is there any way to increase the stability while using Open Office?

http://forums.dumpshock.com/index.php?show...st&p=795186




Great work, DK. I used this to make some characters for a con scenario couple of months ago. Don't remember if I thanked you then, so thanking you now. Thanks.

A small thing, "Spanish" is missing from the list of Languages.

Its working well for me now, I just yanked my friend's copy of Office 07

Hey is the technomancer abilities spreadsheet working?

Also does it have the option for complex forms being treated like spells (pg39 unwired)?

Damien, demanding ain't I?

Hmmm how do I do the following.

I want to buy a Ruger Thunderbolt with the ¥400 Internal Smartlink.

If I take a Ruger T-bolt and customize it and put in the Smartlink the price goes up to 1500 instead of the 1150.

If I just buy it off the shelf, how do I add the smartlink to it for just ¥400?

moddife the price manuley like i have been.

I suppose by unprotecting the cell and typing it in?

At least I hope that's what you mean.