NEWS

[6E] Excel Character Generator

  • 142 Replies
  • 54229 Views

Aria

  • *
  • Ace Runner
  • ****
  • Posts: 2188
« Reply #135 on: <01-21-22/1237:15> »
The Dropbox link has been updated with the latest version of my SR6 excel generator, includes the Kechibi Code

<SR Dropbox>
Excel Cha Generators <<CG5.26>> & <CG6.xx> v24

Tecumseh

  • *
  • Prime Runner
  • *****
  • Posts: 3932
« Reply #136 on: <04-11-22/1823:48> »
Still using this so thanks for your efforts on it.

Found a couple bugs on the "Equip Summary" tab.

First issue: Cells F112 and F114 are empty. They should have the same equation as F110.

Second issue: if you select "High" then no value will populate in the equations in column F. The problem is that the drop-down values for High in D110/D112/D114 include a space after the word High (so "High ") so they don't make a match with the lookups in Y110/Y112/Y114 that are looking for the word without a space ("High"). So either add a space to column Y or subtract the space from the drop-downs in column D. The other Lifestyle levels work as intended.

Thanks again for your work!

Tecumseh

  • *
  • Prime Runner
  • *****
  • Posts: 3932
« Reply #137 on: <04-12-22/1530:47> »
Another:

On 4 Qualities & MAs, cell G281 is summing starting at G243 instead of G275. This means that means it is counting some of the Martial Arts, and thus double-counting some of the things that are already represented in G273.

Changing G281 to =SUM(G275:G280) will fix it.

----

Sheet CLR cell AN35 is not in sync with 2 Attributes cell Q54. The latter is correct because it takes into account more than just Strength and Reaction.
« Last Edit: <04-12-22/1627:42> by Tecumseh »

Aria

  • *
  • Ace Runner
  • ****
  • Posts: 2188
« Reply #138 on: <04-18-22/1643:36> »
Still using this so thanks for your efforts on it.

Found a couple bugs on the "Equip Summary" tab.

First issue: Cells F112 and F114 are empty. They should have the same equation as F110.

Second issue: if you select "High" then no value will populate in the equations in column F. The problem is that the drop-down values for High in D110/D112/D114 include a space after the word High (so "High ") so they don't make a match with the lookups in Y110/Y112/Y114 that are looking for the word without a space ("High"). So either add a space to column Y or subtract the space from the drop-downs in column D. The other Lifestyle levels work as intended.

Thanks again for your work!
Thanks for the proof reading!  I am trying to get the next version out with Lofwyr's Legions and Emerald City so I will pick up these too!
Excel Cha Generators <<CG5.26>> & <CG6.xx> v24

Aria

  • *
  • Ace Runner
  • ****
  • Posts: 2188
« Reply #139 on: <04-19-22/1533:03> »
Link has been updated to version .25

Here's a Google Drive link if anyone is struggling with Dropbox: https://docs.google.com/spreadsheets/d/1Dtg8kb9izi6MxzJn-y-lOjfzM5YF9Uo9/edit?usp=sharing&ouid=114130415901116153183&rtpof=true&sd=true
Excel Cha Generators <<CG5.26>> & <CG6.xx> v24

markelphoenix

  • *
  • Omae
  • ***
  • Posts: 596
« Reply #140 on: <05-16-22/2348:05> »
Aria, any plans to add point buy / Companion source material?

Aria

  • *
  • Ace Runner
  • ****
  • Posts: 2188
« Reply #141 on: <05-17-22/0240:41> »
Iíve added point buy, just trying to get the general qualities in too and then I will re-issue, extra metavarients etc will follow later
Excel Cha Generators <<CG5.26>> & <CG6.xx> v24

Aria

  • *
  • Ace Runner
  • ****
  • Posts: 2188
« Reply #142 on: <05-17-22/1237:42> »
Links in the first post have been updated to Point Buy and general qualities from Sixth World Companion, enjoy!
Excel Cha Generators <<CG5.26>> & <CG6.xx> v24