Shadowrun Play > Character creation and critique
[6E] Excel Character Generator
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