NEWS

[6E] Excel Character Generator

  • 106 Replies
  • 16961 Views

Arky

  • *
  • Newb
  • *
  • Posts: 7
« Reply #45 on: <09-15-19/2051:19> »
On the Complex forms portion, Static Veil and Stitches have each other's description. Stitches is supposed to be the form that heals sprites, Static Veil covers Overwatch for sprites or illegal access, they're right next to each other on the list, so it's an easy mistake.

Aria

  • *
  • Ace Runner
  • ****
  • Posts: 2052
« Reply #46 on: <09-16-19/1023:00> »
Link has been updated with the errors corrected and the weapons tab pretty much complete... I can’t be the only one who is questioning the cost of the Ruger 100, or that they forgot to reduce the DV of grenades when they lowered all the other weapons?!? :P
Excel Cha Generators <<CG5.26>> & <<CG6.03>>

Aria

  • *
  • Ace Runner
  • ****
  • Posts: 2052
« Reply #47 on: <09-30-19/0802:08> »
Link has been updated with the cyberware summaries filled in and a tweak to the sheet output to once more show attributes as natural and boosted (rather than just boosted)
Excel Cha Generators <<CG5.26>> & <<CG6.03>>

ZeroSum

  • *
  • Omae
  • ***
  • Posts: 401
« Reply #48 on: <09-30-19/0832:23> »
Minor note: On the Misc Gear sheet, the calculation for nuyen spend in cell G136 is =SUM(G8:G93), but it should be =SUM(G8:G134); it is currently not counting nuyen spent on Formulae, Magical Supplies, Toxins, Drugs, or Instruments.

Personal preference: I added conditional formatting on cells T11-T29 in the "3 Skills" sheet, and cells Q26-Q35, to match your formatting elsewhere of turning the cell Blue when a non-zero value exists. This just makes it easier to see which skills and attributes you've picked and what their ratings are.

Thanks again!

Aria

  • *
  • Ace Runner
  • ****
  • Posts: 2052
« Reply #49 on: <09-30-19/0846:03> »
Thanks for the spot!  And I've tweaked the formatting as suggested :)

Link updated... not far off declaring 6.01 complete... at least until the errata changes a load of things  ::)
Excel Cha Generators <<CG5.26>> & <<CG6.03>>

ZeroSum

  • *
  • Omae
  • ***
  • Posts: 401
« Reply #50 on: <10-02-19/0658:22> »
Found a minor issue with Unarmed Attack Rating calculation on sheet "2 Attributes";
Current formulae is =Q28+Q29+'Cyber & Bio'!C68+'Cyber & Bio'!C69*2+'Cyber & Bio'!C70*3

This does take into account the AR bonus provided by Bone Lacing, but not that provided by Bone Density.
Quote from: SR6 p.291
Your Body attribute is increased by the bone density rating for the purpose of Damage Resistance tests. Your Damage Value and Attack Rating are also changed for unarmed attacks.

I think the formula should be
=Q28+Q29+'Cyber & Bio'!C68+'Cyber & Bio'!C69*2+'Cyber & Bio'!C70*3+'Cyber & Bio'!C217+'Cyber & Bio'!C218*2+'Cyber & Bio'!C219*3+'Cyber & Bio'!C220*4

Would it be possible to add Unarmed DV as a calculated value similar to Attack Rating, as well. This is something that will follow a set pattern (STR/2 + ratings for Bone Lacing/Bone Density, and possibly other factors? I'm reviewing this right now).

EDIT:
Also, on the "Sheet" sheet, the calculations for augmented stats are off by two columns. For example, D13 should be referencing ='2 Attributes'!Q26, but it is referencing ='2 Attributes'!S26.
« Last Edit: <10-02-19/0704:30> by ZeroSum »

Aria

  • *
  • Ace Runner
  • ****
  • Posts: 2052
« Reply #51 on: <10-02-19/0811:52> »
Bone density is +1, +2, +2, +3 to unarmed AR... added to the calculation (+'Cyber & Bio'!C217+'Cyber & Bio'!C218*2+'Cyber & Bio'!C219*2+'Cyber & Bio'!C220*3)

Don't see why I couldn't do unarmed DV too :)

EDIT: something like this i think... (=ROUNDUP(Q29/2,0)+Adepts!C11*'Cyber & Bio'!C68+'Cyber & Bio'!C69+'Cyber & Bio'!C70*2+'Cyber & Bio'!C217+'Cyber & Bio'!C218+'Cyber & Bio'!C219*2+'Cyber & Bio'!C220*2)

I've deliberately not done bonuses to Bod for damage tests only (or other attribute or skill bonuses that are situational), maybe that needs a box somewhere as it's a common enough buff!?

I've fixed the sheet too... sometimes forget that excel changes cells when you copy and paste :P

EDIT 2: Link updated!
« Last Edit: <10-02-19/0822:39> by Aria »
Excel Cha Generators <<CG5.26>> & <<CG6.03>>

ZeroSum

  • *
  • Omae
  • ***
  • Posts: 401
« Reply #52 on: <10-03-19/0526:37> »
Awesome :)

I noticed that the calculation for Initiative is missing one component; attribute augments.

The formula on 2 Attributes Q41 is =N41+P41, but P41 has no formula. Simply adding =P28+P32 to P41 fixes this minor glitch.

Alternatively, calculate this similarly to Astral Initiative in Q43, which uses the Q column directly.

Thanks so much again for all your efforts on this.

Aria

  • *
  • Ace Runner
  • ****
  • Posts: 2052
« Reply #53 on: <10-03-19/0750:46> »
Fixed :)

Also tinkered with the 2 main sheet outputs to better show unarmed damage / AR etc...

Thanks to ZeroSum for all the checking, added your handle to the play testers :)
Excel Cha Generators <<CG5.26>> & <<CG6.03>>

Jimmy_Pvish

  • *
  • Newb
  • *
  • Posts: 75
« Reply #54 on: <10-03-19/0940:35> »
Did the cost of used grade ware got errata?

It's 0.5 of base cost in the book but 0.75 in Excel.

ZeroSum

  • *
  • Omae
  • ***
  • Posts: 401
« Reply #55 on: <10-03-19/1015:07> »
Did the cost of used grade ware got errata?

It's 0.5 of base cost in the book but 0.75 in Excel.
Wow, good catch! I completely missed that one.

Aria

  • *
  • Ace Runner
  • ****
  • Posts: 2052
« Reply #56 on: <10-03-19/1528:56> »
Oops, I think that may be a hangover from SR5, will fix tomorrow :P
Excel Cha Generators <<CG5.26>> & <<CG6.03>>

Aria

  • *
  • Ace Runner
  • ****
  • Posts: 2052
« Reply #57 on: <10-04-19/0359:28> »
Link has been updated again with the fix to the price of Used cyberware grades (until they errata it back to 0.75 anyway :P) ...apologies to anyone who made characters with older versions of the generator, trying to stay on top of glitches  ::)

...and who uses used cyberware anyway?? That's yurrrk  ??? :o ;D. Don’t give the organleggers your cash!
« Last Edit: <10-04-19/0414:28> by Aria »
Excel Cha Generators <<CG5.26>> & <<CG6.03>>

Michael Chandra

  • *
  • Catalyst Demo Team
  • Prime Runner
  • ***
  • Posts: 9477
  • Question-slicing ninja
« Reply #58 on: <10-04-19/0503:50> »
You find used CYBER icky?! Try used BIO!
How am I not part of the forum?? O_O I am both active and angry!

Aria

  • *
  • Ace Runner
  • ****
  • Posts: 2052
« Reply #59 on: <10-04-19/0537:57> »
I’ll pass thanks... although back in the day I played the ‘used’ muscle toner 3 trick to bypass availability caps (along with many others)... usually fluffed it as ‘knock-off’ rather than ‘ripped out’ though :)
Excel Cha Generators <<CG5.26>> & <<CG6.03>>