[Aria]

The Dropbox link has been updated with the latest version of my SR6 excel generator, includes the Kechibi Code

<SR Dropbox>

[Tecumseh]

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]

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.

[Aria]

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!

[Aria]

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

[markelphoenix]

Aria, any plans to add point buy / Companion source material?

[Aria]

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

[Aria]

Links in the first post have been updated to Point Buy and general qualities from Sixth World Companion, enjoy!

[Aria]

Links have been updated with the metavarients, changelings, non-metahumans (although not infected yet) and some house rules from Sixth World Companion

[Aria]

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

[Hobbes]

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]

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!

[Hobbes]

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). 

[Aria]

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

[Hobbes]

+1

Thanks!