Shipwright Archive
Thread: Shipwright Experimenter spreadsheet
Page 1 of 1
tsxx1
Fri Mar 25, 2005 3:06 am
#1
Here is the shipwright experimentation spreadsheet I built. Select the schematic from the drop-down, enter in the resource data, and it will predict the starting and maximum percentages for any shipwright item.
http://rapidshare.de/files/996356/Shipwright_Experimenter.xls.html
Notes:
- Maximum percentage formula developed independently, but can also be found in the Armorsmith FAQ.
- Starting percentage formula derived by MuttonJedi and sciguyCO on the Chef forum.
- Excel spreadsheet formatted and schematic info entered by me.
- When entering resource data, if the resource does not have a stat, either leave the box blank, or enter a 0 there. Anything else, and the averaging formulas will not work correctly.
- The greyed out columns indicate resource stats that have no bearing on the item's final construction.
- This is a work in progress; schematic data may be incorrect (already found that blaster data was wrong) and formulas may be changed or updated in the future. I'm also toying with the idea of adding in Mailo's stats information, so that the actual stats of the crafted item can be predicted. SandLizard is also attempting to integrate these formulas into his current resource tool.
- The data pages are also portable... If some of you enterprising folks want to enter in schematic information for another profession, feel free. As long as you put the data in the same format, the formulas will still work.
Please let me know how this spreadsheet works foryou!
MrHawat
Sat Mar 26, 2005 5:43 am
#2
Url not working for me. I get to the site and get file not found.
Page 1 of 1