NEWS

[5R5] Excel Character Builder

  • 116 Replies
  • 85627 Views

hannibalisfun

  • *
  • Newb
  • *
  • Posts: 24
« Reply #90 on: <03-24-14/0212:41> »
I just wanted to say.  I am glad someone ran with my character builder and I like what you have been doing to the sheet idiedtrying.

SunRunner

  • *
  • Chummer
  • **
  • Posts: 238
« Reply #91 on: <03-26-14/0958:57> »
This is awesome thanks for the hard work guys!

TimTurry

  • *
  • Newb
  • *
  • Posts: 72
« Reply #92 on: <03-28-14/1520:57> »
I took the first step.  There is a web site called ZamZar.  I used them to convert the ods file into an excel file.  The result has some functionality, but it is still *broken*.  If someone feels brave enough, it might make a better starting point that a full conversion from ods.

I had to zip the file because the xlsx size was 275K, and we have a 256K max.  Here is the file:
« Last Edit: <03-28-14/1617:13> by TimTurry »

idiedtrying

  • *
  • Newb
  • *
  • Posts: 14
« Reply #93 on: <04-03-14/1657:50> »
So i just fixed a few minor bugs. Here is the new version. Sadly i'm kinda busy right now, so major updates gonna take a while. Btw thank u for all the good feedback.
Thats still an open office version.
« Last Edit: <04-03-14/1659:38> by idiedtrying »

Cronstintein

  • *
  • Chummer
  • **
  • Posts: 120
« Reply #94 on: <04-04-14/1230:13> »
Keep up the good work, still my favorite character builder :)

Emperors Grace

  • *
  • Chummer
  • **
  • Posts: 141
« Reply #95 on: <04-11-14/1328:00> »
I'll have to load open office to see this I guess...

Tassyr

  • *
  • Chummer
  • **
  • Posts: 177
« Reply #96 on: <04-11-14/1342:40> »
New version is up. I fixed markelphoenix and Chrona issues.  Hopefully sometime this week,  I can get a character sheet up and running.

I can't tell if anyone mentioned but the bladed weapons section is completely screwy, on the character sheet summary. You can't select anything there...

Also I'm having issues selecting a lifestyle. It just tells me to select one, even when I do- I get the feeling that's just a placeholder, though.
"There's a reason Johnsons are named what they are. They'll try and fuck you at some point, no doubt about it." -Camulus

idiedtrying

  • *
  • Newb
  • *
  • Posts: 14
« Reply #97 on: <04-14-14/1222:52> »
hey its sound like ur talking about my sheet here. its just works with open office. And u have to allow my macros. I alrdy explained how in one of my posts. Check also, if u got the newest version.
« Last Edit: <04-14-14/1256:41> by idiedtrying »

Cronstintein

  • *
  • Chummer
  • **
  • Posts: 120
« Reply #98 on: <04-14-14/2154:17> »
I think he means because the melee weapons section on the character sheet you have to use the right pull-down menu first, then the left one.  It's opposite from everywhere else.

Ascarin

  • *
  • Newb
  • *
  • Posts: 1
« Reply #99 on: <04-17-14/0216:49> »
Hello im new here and to Shadowrun so im probably being blind here but in either one of the 2 versions i cannot find where the Autosofts for my drones
« Last Edit: <04-17-14/0400:45> by Ascarin »

Tassyr

  • *
  • Chummer
  • **
  • Posts: 177
« Reply #100 on: <04-19-14/0546:21> »
I think he means because the melee weapons section on the character sheet you have to use the right pull-down menu first, then the left one.  It's opposite from everywhere else.

Why on earth is it inverted?
"There's a reason Johnsons are named what they are. They'll try and fuck you at some point, no doubt about it." -Camulus

Senko

  • *
  • Ace Runner
  • ****
  • Posts: 2485
« Reply #101 on: <04-21-14/0343:27> »
@Idiedtrying
There's some stuff I'd like that's not on here (the variable lifestyle modifiers for instance from 4th ed) but I'm not exactly excel savy am I right in thinking I just go to the relevant database and insert the name/value in there then change all the formulas to look a bit further e.g. A1-A9 instead of A1-A8? Another thing I can't figure out is the lifestyles. I go to inventory select category lifestyle and and in item it has some weird formula "Squatter(rat=l.style adjustment (1=norm))" and causes the nearby box to go from choose a lifestyle to roll 2d6 and insert the eyecount in the box which I assume is just mistyped but why are we rolling dice for lifestyle? On another note (yes I am a bit lifestyle focused right now) the lifestyle options don't seem to change any values at all. Would you mind explaining how this is meant to work what is the die count for please?
« Last Edit: <04-21-14/1323:05> by Senko »

idiedtrying

  • *
  • Newb
  • *
  • Posts: 14
« Reply #102 on: <04-21-14/2341:13> »
@senko
when u select a lifestyle the rating accounts for the lifestyle options u chose somwhere else. eg.: u chose a high lifestyle and want it to be extra secure. then u have to adejust the rating of this chosen lifgestyle to 1.2.
(rat=l.style adjustment (1=norm) means that u should select a rating of 1.0 for ur lifestyle, when u chose no additional options for it. The dice i want u to roll are for the extra starting money u get according to ur highest lifestyle.

Senko

  • *
  • Ace Runner
  • ****
  • Posts: 2485
« Reply #103 on: <04-22-14/0054:51> »
Hmnmmm missed that entirely, goes off to look for die roll lifestyles . . . returning briefly to say thank you and i'll adjust that then.

Oh and I've noticed that the wealth calculation keeps returning a #value! result in the inventory calc which mucks everything else up for some reason.

EDIT
Ah that' for the selling of a permanently bought lifestyle if your renting month to month it doesn't apply from what I can see.
« Last Edit: <04-22-14/0105:12> by Senko »

Senko

  • *
  • Ace Runner
  • ****
  • Posts: 2485
« Reply #104 on: <04-26-14/0100:49> »
Hmm your better at this than me then I changed priorities to allow ne to select c, d and e twice (for atreet scum) now whenever I try to close libre office I get an error message about referring to $arg$61 or somethin and need to use task manager to shut it down. Although I'm hoping to force it to put lifestyles and lifestyle options in the fist few purchases as a linked drip down.
« Last Edit: <04-26-14/0102:20> by Senko »