Author Topic: Crafting Calculator spreadsheet  (Read 4404 times)

UnLimiTeD

  • Tchortist
  • ****
  • Posts: 489
  • Karma: +27/-1
    • View Profile
Crafting Calculator spreadsheet
« on: October 22, 2020, 03:47:08 pm »
I've created an excel spreadsheet to help with planning character equipment.
Currently, it can calculate stats for body armour, footwear, metal helmets and balaclavas, and list most of their stats (excluding statics like the tabi melee discount, and leather attribute bonuses).
I might, at some point, add other headwear and unique items for comparison.

To my knowledge, it requires at least Excel 2013 or compatible.
Some stat progressions, notably bison leather and steel armour, are still inaccurate. Do tell if you find other mistakes.  :)

How to use:
Unfold the equipment section you want to calculate. See the attached example.png for an example view at the headgear section.
Select a type of equipment in the box marked by the pink 1 in the example.
Now, the boxes at 2 will have drop-down menus from which you can pick the materials you want to use.
Lastly, at number 3, you can select the quality of the selected components.
Now, the resulting stats of the equipment should be displayed near 4, within the teal box.
Do not edit the white background cells, I just forgot to change their colour.  :D

New version added: 23/10/2020

Mega link for not-logged-in viewers:
https://mega.nz/file/FZhA3CZL#-zG7yuTGRi0uE_TkcMCI4vb1D0PJgHYyhZXklCG1z8k
« Last Edit: October 23, 2020, 08:58:07 pm by UnLimiTeD »
First person to give Styg Karma.

I hereby declare that I love the oddity system and am in favour of shop and carry limits.

HulkOSaurus

  • Tchortist
  • ****
  • Posts: 314
  • Karma: +47/-32
    • View Profile
Re: Crafting Calculator spreadsheet
« Reply #1 on: October 22, 2020, 09:48:18 pm »
It's nice to have such tools, although I don't think I can work with it at all.

Using just stock Excel with Windows 10.

TheAverageGortsby

  • Faceless
  • *****
  • Posts: 820
  • Karma: +196/-40
    • View Profile
Re: Crafting Calculator spreadsheet
« Reply #2 on: October 22, 2020, 10:21:48 pm »
Cool.  Thanks for taking the time to make and share this.

UnLimiTeD

  • Tchortist
  • ****
  • Posts: 489
  • Karma: +27/-1
    • View Profile
Re: Crafting Calculator spreadsheet
« Reply #3 on: October 23, 2020, 06:35:19 pm »
Glad someone finds it useful.  :)
I have added an example picture to clarify it working.
The next version will have mouse-over commentary and more clearly mark which cells allow valid input.

I have uploaded a new version that fixes several bugs and contains an explanation (for the 3 people who downloaded it so far).
« Last Edit: October 23, 2020, 07:50:42 pm by UnLimiTeD »
First person to give Styg Karma.

I hereby declare that I love the oddity system and am in favour of shop and carry limits.