[nylanfs]

Or Libre Office, if you don't trust Apache

[Davidvs]

Thank you, Charasanya. You were correct. I was not able to make it work until I download Open Office (even though I had Office and Excel already).  But, it works now!

On a side note, it appears that the skills Assessing, Astral Combat, and Arcana are pulling the wrong stats. It looks like they are are pulling from the Magic Stat currently.

One more question... is there a place that prints up the magic spells? I see where to select them, but I didn't see them on the Character Sheet. I'm guessing this is likely something that is still being worked on?

[idiedtrying]

you'r right. still working on a spelltable and  a vehicletable right now. but the bugs u have mentioned should be fixed now. here is the new version.

[idiedtrying]

In this version I finally added a vehicle/drone table. I realized it with dropdowns. Tell me: What do you guys like better dropdowns or autofill per macro like in the rangeweapontable?
The advantage of autofill is, that its auto. But it has a downside too. You, the user, can't easily change the position and size of the table. On my side its far less work to implent those with dropdowns.
The best solution would be too autofill and autoadjust the sizes and positions of all the tables, but that's so much work, that i alone can't realize it. Tell me what u think.

[Insaniac99]

I enjoy your changes (for one I can actually use it, since I have don't have MS Office)  Here are a few of my thoughts:

Biotechnology skill is officially part of the biotech skill group, so when you get around to it if you can update that.

I have some house rules and we use the high life rules in the GM section; I have made the changes I needed to use it, but it would be nice if you could make some of the common house rules like initiation and altered priority sets, that would be really cool.

I tend to prefer dropdown because it shows you all the options, but the fill in the blank is nicer for when you want a value that isn't supported.

[Charasanya]

I tried it out yesterday, mapping out two characters I have been building and was very surprised that everything worked out pretty brilliantly.

Its no Chummer (*sigh*) but so far the best character editor for Shadowrun 5 that I have seen.

It would be nice however, if it was somehow possible for the mods to rename this thread to [SR5] Open Office: Calc Character Builder or if you would start a new one with the next major release, idiedtrying.

[Charasanya]

I noticed that on the character sheet view adept powers seem to be missing. Perhaps they could be added there somehow?

[justkelly]

I think this is my new favorite tool, so thank you.


A couple of things I noticed when building my prime runner troll...


Troll armor (+1) is not included
Qualities with levels are not being adjusted
Bone Lacing adjustments are not included for Body
Unarmed Combat is not a melee option for character sheet
Ranged weapons are not dropped down enabled on character sheet similar to melee - would be a great enhancement.
Nuyen value is errored on character sheet


Thanks for all the effort.

[idiedtrying]

Hey, thank you for your input. As far as I can tell, you are not allowing my marcos to run and therfore you get an error withe the nuyen value. Also the rangedweapontable automatically fills in the weapons bought in the inventory tab, if u use the macros. I explained how to use them in a previous post. As I understand it, bone lacing does only boost your Body value, when making a resist a damage test. I checked the values and it should be fine the way it is. I already added the Troll armor, but will release the new version, when i have more. I will add unarmed combat to the meeletable on the charactersheet and add quality scaling in the near future. I am still working on a spell/adeptpower table. Btw, if there are people under you with spreadsheet skills, who are willing to contribute to this project, let me know.

[Reiper]

Are there any actual excel versions of this still? Open office version isn't playing well and I can't install open office on this laptop (work laptop)

[idiedtrying]

no, not any I know off. I don't even have excel; i am sorry.

[Cronstintein]

Just booted this puppy up and I'm impressed.  This clearly took quite a bit of work, thanks!

[gmoney999]

Yeah this is my current favorite builder.  Makes things sooooooo much easier. 

[idiedtrying]

thank you I like to hear that.

[Brian]

I really enjoy this spreadsheet and I appreciate all of the updates that you've done. Here are a few small things that I've noticed (and remember).

Augmentation database (D in database isn't capitalized)
D44 and D45 are transposed. As a result Dermal Plating doesn't show it's proper essence cost.

Gear Database
G238 - G240 should be "1" so the Skillsoft prices scale with rating.

Orthoskin's bonus to armor doesn't show on the character sheet.
Troll's racial armor doesn't show on the character sheet.