Excellent job..thanks!!!
I made a calculator that helps you figure out the stats of your Artisan Charm, based on your level and skill. The formula is as close as I can get without looking at the game code -- which means it could be off by a point or two here or there. If you spot any discrepancies, please post here or email me using the link on the page.
Edit:
I've moved the calculator to the EQTC site. The new link is:
http://www.eqtraders.com/calculators...r=130100000000
Or, from the main site, click Calculator in the left hand menu, then Charm Stats.
Last edited by KyrosKrane; 04-15-2007 at 03:49 PM.
Sir KyrosKrane Sylvanblade
Master Artisan (300 + GM Trophy in all) of Luclin (Veeshan)
Master Fisherman (200) and possibly Drunk (2xx + 20%), not sober enough to tell!
Lightbringer, Redeemer, and Valiant servant of Erollisi Marr
Excellent job..thanks!!!
What should I do if I am getting different results than what your calculator shows?
I did a run of combines in the guild hall and my charm did not seem to increase in power when I got skillups. I tried zoning and have done more combinations since then. It seems like my charm just did not register a series of skillups and is showing lower stats than what I should be having.
Shawlweaver Sphynx on Cazic Thule
Master Artisan Aldier on Cazic Thule
I should state, first and foremost, that the calculations are just my best guess. I don't have a magical pipeline to Sony's offices. =) I just read the boards a lot, and put together some info Ngreth posted in a couple of different places. There's also a few assumptions in there about how and when rounding is done that will cause the occasional difference between estimated and in-game results.
The best way to help me make it more accurate is to post character's level, each of your skill levels (remember, don't include a mod like a geerlok or trophy), and the stats you see on your trophy. Just listing AC=X, stats=Y, saves=Z, HP=W is fine (obviously substituting the actual values for X, Y, Z, and W). I'll see if I can use those to refine the estimate.
Last edited by KyrosKrane; 11-23-2006 at 12:06 AM.
Sir KyrosKrane Sylvanblade
Master Artisan (300 + GM Trophy in all) of Luclin (Veeshan)
Master Fisherman (200) and possibly Drunk (2xx + 20%), not sober enough to tell!
Lightbringer, Redeemer, and Valiant servant of Erollisi Marr
I am curious as to how you calculated your stats.
I thought it was a linear progression as you increased in skill.
At 75, Baking = 300, Brewing = 300, Fletching = 300, Jewelrycraft = 291, Pottery= 289, Blacksmithing = 228, Tailoring = 202
stats in game are:
25ac, 21stats, 193hp/mana/end, 17saves
Calculator shows should be:
25ac, 21stats, 194hp/mana/end, 17saves
However, if I followed the math correctly in the other thread:
Calculate total tradeskill points earned in 7 base tradeskills. Divide by 7 to get average tradeskill. Divide by 300 to get %age of max stats that should be applied to charm. Multiply by max value of any stat of the charm to gain value that should be applied.
With my case, my total is 1910. My average is 272. My %age of max should be 90%. Therefore, I should show 90% of max stat (225hp) or 202hp.
Shawlweaver Sphynx on Cazic Thule
Master Artisan Aldier on Cazic Thule
This is incorrect. Ngreth said the actual formula is (sum (TS - 100) / 1400), where TS is each tradeskill. People interpreted this to mean ((sum(TS) - 700) / 1400), but that doesn't work. An example from the other thread showed that the TS-100 bit caps at 0; effectively, if your skill is 99 or less, that step calculates a zero, not a negative number. So, hypothetical example:
Skill = 300 --> use 200 for the calculation
Skill = 250 --> use 150 for the calculation
Skill = 150 --> use 50 for the calculation
Skill = 100 --> use 0 for the calculation
Skill = 50 --> use 0 for the calculation (not -50)
The 1hp difference is due to rounding somewhere; once I get a few more examples, I'll dive back in and see where it's going wonky.
Sir KyrosKrane Sylvanblade
Master Artisan (300 + GM Trophy in all) of Luclin (Veeshan)
Master Fisherman (200) and possibly Drunk (2xx + 20%), not sober enough to tell!
Lightbringer, Redeemer, and Valiant servant of Erollisi Marr
For the programmatically inclined, the Javascript code that does all the heavy lifting is here:
http://www.gamesnet.org/KyrosKrane/T...CharmScript.js
Sir KyrosKrane Sylvanblade
Master Artisan (300 + GM Trophy in all) of Luclin (Veeshan)
Master Fisherman (200) and possibly Drunk (2xx + 20%), not sober enough to tell!
Lightbringer, Redeemer, and Valiant servant of Erollisi Marr
A lot of the numbers I listed for averages and percentages were rounded down. It is possible 1 of the calculations in the sequence does not round off before the next step.
Shawlweaver Sphynx on Cazic Thule
Master Artisan Aldier on Cazic Thule
I tweaked the calculation script based on some advice I got. It now appears to return exact results, although there's always the chance I got it wrong and it could still be off by a point here or there. Essentially, I'd forgotten to truncate the calculation in one spot.
Last edited by KyrosKrane; 11-23-2006 at 06:16 PM.
Sir KyrosKrane Sylvanblade
Master Artisan (300 + GM Trophy in all) of Luclin (Veeshan)
Master Fisherman (200) and possibly Drunk (2xx + 20%), not sober enough to tell!
Lightbringer, Redeemer, and Valiant servant of Erollisi Marr
Skill: 300 x 7
At lvl 65: what calculator shows is correct
At lvl 66: HP/Mana/End = 211 (calculator shows 212) .. other stats correct
Thanks so much for the calculator. I was using Lucy to check the projected stats for lvl 66 when I was lvl 65. I thought Lucy will be correct, since for me, it should just be a rec lvl change. But Lucy's standard formula for rec lvl gives 1 point extra to AC, stats, HP/mana and saves for lvl 66. Your calculator got everything correct except for HP/mana.
Bleh, looks like I missed another spot where the game rounds. I tweaked it yet again. Please double check it and let me know if I got it right this time. =)
Sir KyrosKrane Sylvanblade
Master Artisan (300 + GM Trophy in all) of Luclin (Veeshan)
Master Fisherman (200) and possibly Drunk (2xx + 20%), not sober enough to tell!
Lightbringer, Redeemer, and Valiant servant of Erollisi Marr
Got a new test case for you .
Char lvl: 56
Skill: 200, 200, 262, 286, 300, 300, 300
Calculator: 19 / 16 / 147 / 12
My Actual: 19 / 16 / 146 / 13
Hmm. This one is a little odd. I've run out of places to truncate the calculation. =)
Could you please list the full stats for the charm too? The ones you listed are affected by the recommended level. I'm not sure if the problem is in calculating the base stats for the charm or in applying the recommended level.
Sir KyrosKrane Sylvanblade
Master Artisan (300 + GM Trophy in all) of Luclin (Veeshan)
Master Fisherman (200) and possibly Drunk (2xx + 20%), not sober enough to tell!
Lightbringer, Redeemer, and Valiant servant of Erollisi Marr
But the Artisan Charm only shows one set of stats (for both my lvl 66 and lvl 56), i.e. no numbers in red and no numbers in brackets.
OK, now that's just plain wierd. I guess the charm script handles the recommended level calculation as well.
I'll poke around some more.
Sir KyrosKrane Sylvanblade
Master Artisan (300 + GM Trophy in all) of Luclin (Veeshan)
Master Fisherman (200) and possibly Drunk (2xx + 20%), not sober enough to tell!
Lightbringer, Redeemer, and Valiant servant of Erollisi Marr
I removed the red text and fiddled with the calculation again. It now matches the three test cases reported so far.
Sir KyrosKrane Sylvanblade
Master Artisan (300 + GM Trophy in all) of Luclin (Veeshan)
Master Fisherman (200) and possibly Drunk (2xx + 20%), not sober enough to tell!
Lightbringer, Redeemer, and Valiant servant of Erollisi Marr
If it's possible, could you please post the in-game stats for level 65 and 66, with 300x7? I'm not sure I've got it entirely right just yet.
Sir KyrosKrane Sylvanblade
Master Artisan (300 + GM Trophy in all) of Luclin (Veeshan)
Master Fisherman (200) and possibly Drunk (2xx + 20%), not sober enough to tell!
Lightbringer, Redeemer, and Valiant servant of Erollisi Marr
The calculator for 300x7 at lvl 66 is now correct. I didn't do a screenshot at lvl 65 so unfortunately I cannot re-confirm.
The calculator for my lvl 56's case is now correct as well.
Perhaps "no red numbers and no numbers in brackets" was the clue you needed?
OK, just so I don't lose the info again. =) At 66, 300x7, AC=28, stats = 23, hp = 211, saves = 18.
The "no red text" part was a big clue. I had been assuming that the charm would first determine the base power (as if the user were level 70), then apply the recommended level like any other item. That would be two calculations. Since it doesn't show red text, that meant the recommended level calculation was being handled as part of the base power. That in turn means there's only one calculation. Based on that, I tried a couple of different options for calculations and rounding before I hit on the current one.
Sir KyrosKrane Sylvanblade
Master Artisan (300 + GM Trophy in all) of Luclin (Veeshan)
Master Fisherman (200) and possibly Drunk (2xx + 20%), not sober enough to tell!
Lightbringer, Redeemer, and Valiant servant of Erollisi Marr
Recommended levels have never actually worked on other charms or charm augments. Ngreth said he specifically coded player level into the charm calculation so it would work (which I suppose means if recommended levels on charms ever actually gets fixed, the artisan charm will need to be changed so it doesn't get a double whammy).
Ngreth Thergn
Ngreth nice Ogre. Ngreth not eat you. Well.... Ngreth not eat you if you still wiggle!
Grandmaster Smith 250
Master Tailor 200
Ogres not dumb - we not lose entire city to froggies
The calculator proves one thing. For those who are only raising skills to maximize the usefulness of the charm, skilling up to:
Fletching 282 (all store bought)
Jewelry 282 (all store bought)
Pottery 300 (store bought except for Magic Clay and easy subcombines)
Smithing 262 (up to Steppes Ore if Sickles is too much subcombines)
Tailoring 252 (before it gets hard)
Baking 300 (this one is either 200 or 300, not too much of an in-between)
Brewing 300 (store bought except for Enchanted Gold)
at lvl 70 will already give you 27 AC / 22 Stats / 204 HP Mana / 18 saves. This is only 3 AC / 3 Stats / 21 HP Mana / 2 saves less than max. PLing to 300x7 is no longer cost/time effective from this point onwards.
For example, pushing onwards with JC from 282 to 300 is only gonna give you 5 more HP / mana (less than 5 if you're not 300 in all other 6 skills already). In fact, if you stop at Mino Hero Brew (248) for Brewing, you're only gonna lose 9 HP / Mana (less than 9 if you're not 300 in all other 6 skills already).
There are those who argue that the last 18 points for every skill should show more of a jump in the Charm stats to reflect the cost/time spent.
I see it the other way. The way the Charm stats are calculated now discourages those who only want the Charm (and don't care about tradeskills) to stop PLing the last points. This will leave tradeskills back in the hands of tradeskillers and soften the after-effects to the tradeskill market as seen after Aid Grimel.
You'll still spend that 150-200k to raise JC from 282 to 300 if you're a tradeskiller. But I don't think you'll do it for 5 HP / Mana. And that's the way it should be. This design hopes to separate the tradeskillers from the non-tradeskillers. A tradeskiller shouldn't need the Charm's jump in stats to encourage him to push forward.
Last edited by Elfdruidess; 11-26-2006 at 01:49 PM.
Any chance there is one of these for the normal single tradeskill charms?
Don't have enough cash to buy all the ingredients for numerous attempts (might go ahead and grab 1 combine worth if i can afford later on but thats all :P)
so, wanna know if making one of the single ones would be worth it..
Ddemons Ddemise
200 Fletching
200 Brewing
201 Tailoring
198 Baking
100 Jewelcraft
100 Pottery
152 Smithing
So... my Alchemy prowess doesn't contribute to this thing at all? =/
Not the Artisan Charm, no. That one is just for the seven unrestricted tradeskills. I believe there is a dedicated Alchemy Charm, though. The final stats will be lower, of course, since it's only one tradeskill, but it's also far easier to get and max.
Sir KyrosKrane Sylvanblade
Master Artisan (300 + GM Trophy in all) of Luclin (Veeshan)
Master Fisherman (200) and possibly Drunk (2xx + 20%), not sober enough to tell!
Lightbringer, Redeemer, and Valiant servant of Erollisi Marr