Weaponsmith Archive

Ok I am sure there is an easier way to do this, but I'm no excel or math expert. I am putting together a list of the best resources on Chilastra for myself and other WS on my server. This will of course be outdated because the excel file won't be dynamic. Right now it is impossible to see what the best resource is if there is a stat cap and you search using the traditional weights on SWGCraft. I'm not sure how to make it "pull" from SWGCraft like Fooman's tool or whatever so I did this the long way. Anyway, I'm using the beta tool to compare SWGCraft weights and the new system. The tool is found here. This new tool takes into account resource caps when calculating the best resource to use. I started out with some basic common sense approaching my main metals in 50/50 con/oq categories for my ranged weapons which I make the most of. If the CD cap is low, you want more weight on the CD. By trial and error I came up with the following weights which you can search with on SWGCraft to return results sorted & matched very closely up to about the top 10 to the rankings in the new system.

Duralimin Alum 50% con - 50% OQ (SWGCraft 60% / 40%)
Titanium Alum 50% con - 50% OQ (SWGCraft 73% / 27%)
Platinite Copper 50% con - 50% OQ (SWGCraft 52% / 48%)
Iron 50% con - 50% OQ (SWGCraft 67% / 33%)
Plubum Iron 50% con - 50% OQ (SWGCraft 92% / 8%)
Polonium Iron 50% con - 50% OQ (SWGCraft 87% / 13%)
Doonium Iron 50% con - 50% OQ (SWGCraft 70% / 30% )
Kammris Iron 50% con - 50% OQ (SWGCraft 67% / 33%)

I know there is some way to work out a formula to plug in the cap and have it spit out a % but my brain is about fried right now, so I'll let you guys here look over this and let me know what you think. Hopefully SWGCraft will eventually calculate based on the new system but at least for now this way seems to work.

---

Shug Flurry Wrote:
For weapons, if you add the cap of CD the cap for OQ (1000) then do cd/(cd+oq) where cd and oq are the caps for each stat you'll get the % ditribution, 100-x which was what you got gives you the other %

For Kammris for example. cd cap = 500, hence cd/(cd+oq) = 500/(500+1000) = 33%.

---

Thanks to Shug I have compared with my findings (the long hard way) and every single weight I have matches down to about 1% or so when you plug in the Lunariel caps found on the 2nd tab in the tool excel file above.

Duralimin Alum 50% con - 50% OQ (SWGCraft 60% / 40%) | 658/(658+1000) = 60.31% / 39.69%
Titanium Alum 50% con - 50% OQ (SWGCraft 73% / 27%) | 408/(408+1000) = 71.02% / 28.98%
Platinite Copper 50% con - 50% OQ (SWGCraft 52% / 48%) | 961/(961+1000) = 50.99% / 49.01%
Iron 50% con - 50% OQ (SWGCraft 67% / 33%) | 500/(500+1000) = 66.67% / 33.33%
Plubum Iron 50% con - 50% OQ (SWGCraft 92% / 8%) | 82/(82+1000) = 92.42% / 7.58%
Polonium Iron 50% con - 50% OQ (SWGCraft 87% / 13%) | 144/(144+1000) = 87.41% / 12.59%
Doonium Iron 50% con - 50% OQ (SWGCraft 70% / 30% ) | 456/(456+1000) = 68.68% / 31.32%
Kammris Iron 50% con - 50% OQ (SWGCraft 67% / 33%) | 500/(500+1000) = 66.67% / 33.33%

Message Edited by CorenLanra on 05-28-2005 05:48 PM

Message Edited by CorenLanra on 05-28-2005 05:49 PM

excellent idea.. i was trying to work out a way to fix the spreadsheets but i never thought of this!

Ill get on it this afternoon..

A'ru

For weapons, if you add the cap of CD the cap for OQ (1000) then do cd/(cd+oq) where cd and oq are the caps for each stat you'll get the % ditribution, 100-x which was what you got gives you the other %

For Kammris for example. cd cap = 500, hence cd/(cd+oq) = 500/(500+1000) = 33%.

one comment about the tool

Its not correct when it comes to the general stuff like copper and steel

I still need to change ti so the caps reflect the non JTL resources since they are not counted in in the caps

On example is my itaite bicarbatic copper with an SR of 836 which goes 100% on PHs because the game thinks the copper cap on SR is 800 :-)

so you can say for powerhammers that any copper with an SR over 800 is the same as another with an SR over 800

---

ShugFlurry wrote:
For weapons, if you add the cap of CD the cap for OQ (1000) then do cd/(cd+oq) where cd and oq are the caps for each stat you'll get the % ditribution, 100-x which was what you got gives you the other %

For Kammris for example. cd cap = 500, hence cd/(cd+oq) = 500/(500+1000) = 33%.

---

so explain to me why in some weapons my Arveshium is the better ferrous (867 CD/OQ) and on others my Carbonite steel is the better ferrous (735 CD/OQ). for example, the arveshium is better in a scatter, but the carbonite is better in a dl44 xt.

---

Mor-Dan wrote:

---

ShugFlurry wrote:
For weapons, if you add the cap of CD the cap for OQ (1000) then do cd/(cd+oq) where cd and oq are the caps for each stat you'll get the % ditribution, 100-x which was what you got gives you the other %

For Kammris for example. cd cap = 500, hence cd/(cd+oq) = 500/(500+1000) = 33%.

---

so explain to me why in some weapons my Arveshium is the better ferrous (867 CD/OQ) and on others my Carbonite steel is the better ferrous (735 CD/OQ). for example, the arveshium is better in a scatter, but the carbonite is better in a dl44 xt.

---

It is? /boggle I thought that ferrous would have a cd/oq of 1000/1000, since you can get that with JTL resources. /boggle.

---

Blackmoore wrote:
Stettin, how are you figuring out the Chilastra resources? Does this tool work with some other file? I am not sure how this works. I would be interested in taking a look at the list of resources you come up with for Chilastra though.

---

As I said, trial and error Im pluggin them into the tool and seeing how they rate and adjusting my search weights until they match up. I'm going to take a look at that formula ShugFlurry posted and see if I can get it to match up with the weights I found by trial and error. Once I'm done all the weights should work for _any_ server if you plug in to a SWGCraft Search.


Also,
I did see that the tool doesnt have caps on steel and copper but also he is going off of the Lunariel's cap's so I can't blame him. It is "beta" by the way. I am pretty sure that a dev stated that JTL steel/copper wouldnt affect the natual cap on the normal steel/copper and going by my tool and using my good Erco steel I think that's true.

Message Edited by CorenLanra on 05-28-2005 05:27 PM

Message Edited by CorenLanra on 05-28-2005 05:36 PM

updated the main post, ShugFlurry's formula works for the 50/50 corrections.

I need to test out the 66.6 CON / 33.4 SR for ranged barrels now. Not sure how to calculate with two stats with low caps, Rhodium has 85 con and 565 sr cap.

Message Edited by CorenLanra on 05-28-2005 07:04 PM

Stettin, how are you figuring out the Chilastra resources? Does this tool work with some other file? I am not sure how this works. I would be interested in taking a look at the list of resources you come up with for Chilastra though.

Hmm, plugged in 85cd 565sr Rhodium, got 99.9% when using 66.6cd 33.3sr. Works well

Using this formula

1000/stat cap x weight% = swgcraft%

Where weight% is the schematic % weight and swgcraft% is the % you put into swgcraft find resource tool.

This works since it compensates for a low cap, you can re-arrange the formulae such that weight% = swgcraft% x stat cap/1000.

Using your rhodium example, 1000/85 x 66.6 = 783.52

Since swgcraft only takes 4 digits including decimal places this rounds to 784.

1000/565 x 33.4 = 59.115

Rounds to 59.2.

A 85/565 stat rhodium would have a swgcraft rating of 7.84 x 85 + .592 x 565 = 1000.88 (close enough )

Only tested on Rhodium btw since I'm lazy

hi Stettin,

if i understand well it is kinda impossible to tell the best resorces for the schem slots that needs a generic type or resorce(eg metal with cd66,oq33), cause with the caps u need to test almost all the resorcesfrom all subtype and compare em. as i c it can be easy made by hand for several ones that needs a special resorce but not a generic. so if im right( might not be im just a noob ws ) i can help by programming an algorithm that does the work using the datas from swgcraft, that counts all the exp caps for everythingand tell the best. i just need some help in ws stuffs( that might beu ), cause i suppose i know tons of things incorrect. tough i cannot gurantee that i can make this too fast as i hav bunch of stuides(and playing as well lol ). but at first sight the programming part seems not to be difficult, so if ur inrested let me know.

if u like to contact me my IGN is oru or biu

UI: oh and sry if i missunderstood the whole thing and the whole process is not necessary, furthermore sry for my engish, its not a best i know

Message Edited by Akimaki on 06-03-2005 12:59 AM