NEWS

[6E] Excel Character Generator

  • 149 Replies
  • 60300 Views

Aria

  • *
  • Ace Runner
  • ****
  • Posts: 2199
« 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> v28

Tecumseh

  • *
  • Prime Runner
  • *****
  • Posts: 3933
« 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: 3933
« 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: 2199
« 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> v28

Aria

  • *
  • Ace Runner
  • ****
  • Posts: 2199
« 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> v28

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: 2199
« 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> v28

Aria

  • *
  • Ace Runner
  • ****
  • Posts: 2199
« 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> v28

Aria

  • *
  • Ace Runner
  • ****
  • Posts: 2199
« Reply #143 on: <06-08-22/0953:08> »
Links have been updated with the metavarients, changelings, non-metahumans (although not infected yet) and some house rules from Sixth World Companion
Excel Cha Generators <<CG5.26>> & <CG6.xx> v28

Aria

  • *
  • Ace Runner
  • ****
  • Posts: 2199
« Reply #144 on: <06-15-22/0826:33> »
Links have been updated with Lifestyle and Contacts rules from SWC... unless there's massive demand I'm not going to bother with Infected for now as that's a big chunk of work that will only benefit a small few.  Will get round to it eventually of course...

A
Excel Cha Generators <<CG5.26>> & <CG6.xx> v28

Hobbes

  • *
  • Catalyst Demo Team
  • Prime Runner
  • ***
  • Posts: 3020
« Reply #145 on: <07-03-22/1700:36> »
There is not a Mark Up on Equipment Summary tab for Kali-Ani Collective, should be 30% on clothing / Armor for the Shiva Arms 3. 

Aria

  • *
  • Ace Runner
  • ****
  • Posts: 2199
« Reply #146 on: <07-03-22/1804:14> »
There is not a Mark Up on Equipment Summary tab for Kali-Ani Collective, should be 30% on clothing / Armor for the Shiva Arms 3.
Thanks!  I will get that added in to the next issue!
Excel Cha Generators <<CG5.26>> & <CG6.xx> v28

Hobbes

  • *
  • Catalyst Demo Team
  • Prime Runner
  • ***
  • Posts: 3020
« Reply #147 on: <07-04-22/0947:28> »
Martial Arts Karma costs are not calculating correctly.  Additional Techniques don't seem to be increasing costs by 5 each.  And cell G395 on '4 Qualities & MA' tab seems to be doubling the total from G387 same tab.  G395 Should probably be =SUM(G389:G394)   

G385 doesn't seem to like the value from Cell F3 on the 'MA Tech & Edge' Tab.  I think the Additional Techniques value is getting SUM'd multiple times.  Cell C386 on '4 Qualities & MA' tab should probably be =SUM(C352:C384)?

Could be that I angered the Machine Spirit with my tinkering, but those are the corrections I made to get the correct karma totals. 

Edit:  Cell G385 on '4 Qualities & MAs' Tab I used =ABS('MA Tech & Edge'!H3). 



« Last Edit: <07-04-22/0952:13> by Hobbes »

Aria

  • *
  • Ace Runner
  • ****
  • Posts: 2199
« Reply #148 on: <07-04-22/1846:43> »
Martial Arts Karma costs are not calculating correctly.  Additional Techniques don't seem to be increasing costs by 5 each.  And cell G395 on '4 Qualities & MA' tab seems to be doubling the total from G387 same tab.  G395 Should probably be =SUM(G389:G394)   

G385 doesn't seem to like the value from Cell F3 on the 'MA Tech & Edge' Tab.  I think the Additional Techniques value is getting SUM'd multiple times.  Cell C386 on '4 Qualities & MA' tab should probably be =SUM(C352:C384)?

Could be that I angered the Machine Spirit with my tinkering, but those are the corrections I made to get the correct karma totals. 

Edit:  Cell G385 on '4 Qualities & MAs' Tab I used =ABS('MA Tech & Edge'!H3).
I'll tweak the additional techniques select box to a yellow cell to try and make it clearer you put the number in there you want... I think that does it then
Excel Cha Generators <<CG5.26>> & <CG6.xx> v28

Hobbes

  • *
  • Catalyst Demo Team
  • Prime Runner
  • ***
  • Posts: 3020
« Reply #149 on: <07-04-22/2133:26> »
+1

Thanks!