Armorsmith Archive

Thread: For Those of you Well-Versed in Excel, Armor Crafting Spreadsheet

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.




G u a a r r
Jedi Guardian
(ggggggggggg9WXnnln[[[[nnnn}}}}nlnnWX9ggggggggggg)
..Forever Guiding and Last Correspondent of the Jedi Profession ..


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



Iono Aldo - Master Entertainer
Estei Finai - Noobish Smuggler
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%.



LYTHO TIRIUS_________________
12-Point Master Armorsmith | (Retired)

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.



Doro - Member of the RPG Blood Guard led by Night Rouge
Master Armor Smith (RIS Certified), Master Swordsman, 4-0-1-3 Merchant, 4-0-4-4 Artisan
Come visit my vendors in Cadracet on Talus and in Crimson Valley on Naboo at 7359 -6456.

"A fool perceives the truth to encompass his reality."
zaphb
Mon Nov 29, 2004 11:27 am
#5

If you cant get it

drop me a PM and Ill mail it to you



Iono Aldo - Master Entertainer
Estei Finai - Noobish Smuggler
Baciacca
Mon Nov 29, 2004 12:26 pm
#6

that spreadsheet pwns mine. I'd suggest downloading it instead.




G u a a r r
Jedi Guardian
(ggggggggggg9WXnnln[[[[nnnn}}}}nlnnWX9ggggggggggg)
..Forever Guiding and Last Correspondent of the Jedi Profession ..


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




ERHAMSTERHAMSTERHAMSTERHA
MSTERHAMSTERHAMSTERHAMSTE
RHAMSTERHAMSTERHAMSTERHAM
STERHAMSTERHAMSTERHAMSTER
HAMSTERHAMSTERHAMSTERHAMS
TERHAMSTERHAMSTERHAMSTERH
AMSTERHAMSTERHAMSTERHAMST
ERHAMSTERHAMSTERHAMSTERHA

MSTERHAMSTERHAMSTERHAMSTE

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



Doro - Member of the RPG Blood Guard led by Night Rouge
Master Armor Smith (RIS Certified), Master Swordsman, 4-0-1-3 Merchant, 4-0-4-4 Artisan
Come visit my vendors in Cadracet on Talus and in Crimson Valley on Naboo at 7359 -6456.

"A fool perceives the truth to encompass his reality."
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



Elood- Trader - Retired AS/SW

Elood'- Jedi- I know, I suck. Bite me

Dark Sword, Naboo 6932 2054 Loots


Page 1 of 1
Previous Next