Shadowrun Play > Character creation and critique

[6E] Excel Character Generator

<< < (28/30) > >>

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:

--- Quote from: Tecumseh on ---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!

--- End quote ---
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

Navigation

[0] Message Index

[#] Next page

[*] Previous page

Go to full version