Armorsmith Archive
Thread: For Those of you Well-Versed in Excel, Armor Crafting Spreadsheet
Page 1 of 1
Baciacca
Sun Nov 28, 2004 5:39 pm
#1
I made up this Armor Crafting spreadsheet designed to give you the exact numbers for weighted averages on resources and the expiremental max percentages that could be reached with a given set of resources. I uploaded it to our website here
It's not quite perfected as I don't know a whole lot about Excel, but this was the best I could do. I'm hoping that someone who knows more about Excel could take this a bit farther. I'd like to be able to put in resource stats and have that tell you the actual stats you could get on the armor assuming you maxed out a line. If you have a hard time interpretting the output, let me know. For the layers and advanced segments, it was obvious what resource amounts to put in. For the actual composite armor, I used resources amounts for a composite chest plate.
I'm really just looking for feedback and someone who might be able to improve on this. I would love to have a spreadsheet where I could just input the resouce numbers and then have output for all the possibilities those resources could produce for composite armor. I figure something like this would be useful for a lot of other armorsmiths as well.
zaphb
Sun Nov 28, 2004 10:57 pm
#2
before you get too much into this Id like to point over to the swgcraft forums
http://swgcraft.com/forum/showthread.php?t=10294
http://swgcraft.com/forum/showthread.php?t=10294
Pyrewolf
Mon Nov 29, 2004 2:46 am
#3
amazingly accurate, but not perfect! i did something stupid recently by making a full run of 6000 blast layers without "reality-checking" the resists i could hit on a pair of gloves first. i was a bit distraught to find my base came out 1% lower than as little helper predicted. fortunately, it's only just barely off and if i switch to a different beyrllius (and wooly on the chest) i can take back that 1%.
Doro1138
Mon Nov 29, 2004 10:05 am
#4
The last time I tried to get that thing off of swgcraft, it wasn't working and so I couldn't get it. It was down for a while, I'll definitely check both of the ones mentionedhere though.
Baciacca
Mon Nov 29, 2004 12:26 pm
#6
that spreadsheet pwns mine. I'd suggest downloading it instead.
Asir_SWG
Mon Nov 29, 2004 1:58 pm
#7
zaphb wrote:
before you get too much into this Id like to point over to the swgcraft forums
http://swgcraft.com/forum/showthread.php?t=10294
I use AS little helper v0.4 all the time, and found it to me amazingly accurate with its predictions
Doro1138
Mon Nov 29, 2004 4:59 pm
#8
sweet, finally downloaded it. Thanks.
Message Edited by Doro1138 on 11-29-2004 05:15 PM
UmmonPrime
Tue Nov 30, 2004 1:01 am
#9
Your's does give the exp %, which I like. Just wish it had what the % is on the armor itself.
I tried it. It works
Page 1 of 1