Give Feedback
0 of 0
About this mod
A simple Excel spreadsheet that calculates the total value and weight of an amount of crafting components. A great way for modders for value their weapon or armor mods quickly, easily, and intelligently.
- Permissions and credits
Crafting Component Calculators
This is a simple Microsoft Excel spreadsheet that will take an amount specified of several base components at once and calculate their total value and weight separately. This can be used if you, like me, want to make a new weapon or armor mod that is valued the same as the component parts involved in it's construction or have a good base number to work with for the weight of a new craftable item you're putting into the game.
Instructions:
Open the spreadsheet "Crafting Calculators"
Find the component (listed on the left) that you want to start with
Enter an amount of that component you want to calculate in the bold-bordered "Amount" column
The amount you entered will be multiplied to create the associated values for "Group Value" and "Group Weight"
Find an other component you would like to calculate and enter it's amount in it's associated "Amount" cell
The red "Total Value" and "Total Weight" numbers at the top will add up the value and weight of all components
The amounts you entered will also be added together into the the "Total Amount" category
Optionally, there is space at the bottom of the list of components for manually entering items not on the list
All you need to enter is the "Value" "Weight" and "Amount" of a custom item to add it to the totals at the top
If you need more custom items, you can use highlight the last custom item row and use the Fill Handle to create more rows
I made this spreadsheet for myself to help me figure out a good value to apply to the misc version of some weapon mods.
I figured I might as well improve it a bit and put it on here for anyone to use.
I hope someone gets some use out it, thank you for looking!
This is a simple Microsoft Excel spreadsheet that will take an amount specified of several base components at once and calculate their total value and weight separately. This can be used if you, like me, want to make a new weapon or armor mod that is valued the same as the component parts involved in it's construction or have a good base number to work with for the weight of a new craftable item you're putting into the game.
Instructions:
Open the spreadsheet "Crafting Calculators"
Find the component (listed on the left) that you want to start with
Enter an amount of that component you want to calculate in the bold-bordered "Amount" column
The amount you entered will be multiplied to create the associated values for "Group Value" and "Group Weight"
Find an other component you would like to calculate and enter it's amount in it's associated "Amount" cell
The red "Total Value" and "Total Weight" numbers at the top will add up the value and weight of all components
The amounts you entered will also be added together into the the "Total Amount" category
Optionally, there is space at the bottom of the list of components for manually entering items not on the list
All you need to enter is the "Value" "Weight" and "Amount" of a custom item to add it to the totals at the top
If you need more custom items, you can use highlight the last custom item row and use the Fill Handle to create more rows
I made this spreadsheet for myself to help me figure out a good value to apply to the misc version of some weapon mods.
I figured I might as well improve it a bit and put it on here for anyone to use.
I hope someone gets some use out it, thank you for looking!