Page 1 of 2 12 LastLast
Results 1 to 25 of 50

Thread: Artisan Charm Stats Calculator

  1. #1
    Database Code Monkey KyrosKrane's Avatar
    Join Date
    Dec 2002
    Posts
    4,431

    Artisan Charm Stats Calculator

    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

  2. #2
    Visitor
    Join Date
    Feb 2005
    Posts
    13
    Excellent job..thanks!!!

  3. #3
    Master Trader Aldier's Avatar
    Join Date
    Feb 2006
    Posts
    1,520
    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

  4. #4
    Database Code Monkey KyrosKrane's Avatar
    Join Date
    Dec 2002
    Posts
    4,431
    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

  5. #5
    Master Trader Aldier's Avatar
    Join Date
    Feb 2006
    Posts
    1,520
    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

  6. #6
    Database Code Monkey KyrosKrane's Avatar
    Join Date
    Dec 2002
    Posts
    4,431
    Quote Originally Posted by Aldier View Post
    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.
    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

  7. #7
    Database Code Monkey KyrosKrane's Avatar
    Join Date
    Dec 2002
    Posts
    4,431
    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

  8. #8
    Master Trader Aldier's Avatar
    Join Date
    Feb 2006
    Posts
    1,520
    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

  9. #9
    Database Code Monkey KyrosKrane's Avatar
    Join Date
    Dec 2002
    Posts
    4,431
    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

  10. #10
    Expert Trader Elfdruidess's Avatar
    Join Date
    Dec 2002
    Posts
    739
    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.

  11. #11
    Database Code Monkey KyrosKrane's Avatar
    Join Date
    Dec 2002
    Posts
    4,431
    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

  12. #12
    Expert Trader Elfdruidess's Avatar
    Join Date
    Dec 2002
    Posts
    739
    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

  13. #13
    Database Code Monkey KyrosKrane's Avatar
    Join Date
    Dec 2002
    Posts
    4,431
    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

  14. #14
    Expert Trader Elfdruidess's Avatar
    Join Date
    Dec 2002
    Posts
    739
    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.

  15. #15
    Database Code Monkey KyrosKrane's Avatar
    Join Date
    Dec 2002
    Posts
    4,431
    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

  16. #16
    Database Code Monkey KyrosKrane's Avatar
    Join Date
    Dec 2002
    Posts
    4,431
    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

  17. #17
    Database Code Monkey KyrosKrane's Avatar
    Join Date
    Dec 2002
    Posts
    4,431
    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

  18. #18
    Expert Trader Elfdruidess's Avatar
    Join Date
    Dec 2002
    Posts
    739
    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?

  19. #19
    Database Code Monkey KyrosKrane's Avatar
    Join Date
    Dec 2002
    Posts
    4,431
    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

  20. #20
    Expert Trader
    Join Date
    Jan 2003
    Posts
    971
    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).

  21. #21
    House Ogre
    SOE-DEV
    Ngreth Thergn's Avatar
    Join Date
    Jul 2003
    Posts
    6,484
    Quote Originally Posted by KyrosKrane View Post
    OK, now that's just plain wierd. I guess the charm script handles the recommended level calculation as well.
    yes it does charm scripts stomp all over the recommended level calculations... so... I had to estimate it within the charm script. (I actually made another script that other people can call in case they want to do the same)
    Quote Originally Posted by Bobaten View Post
    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).
    yup
    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

  22. #22
    Expert Trader Elfdruidess's Avatar
    Join Date
    Dec 2002
    Posts
    739
    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.

  23. #23
    Apprentice Trader
    Join Date
    Apr 2006
    Posts
    186
    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

  24. #24
    Webmaster of Samanna.net Samanna's Avatar
    Join Date
    Feb 2006
    Posts
    5
    So... my Alchemy prowess doesn't contribute to this thing at all? =/

  25. #25
    Database Code Monkey KyrosKrane's Avatar
    Join Date
    Dec 2002
    Posts
    4,431
    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

Similar Threads

  1. Artisan Charm Stats at 1400, 1450, 1500?
    By whyan in forum Quests Requiring Trade Skills
    Replies: 7
    Last Post: 10-19-2006, 03:10 PM
  2. Artisan Charm - Journeyman stats?
    By Evram2 in forum General Trade Skill Discussion
    Replies: 22
    Last Post: 10-05-2006, 02:11 PM
  3. Master Artisan Charm
    By Lokase in forum Database Updates Completed
    Replies: 4
    Last Post: 09-27-2006, 08:05 PM
  4. Cultural Charms!!
    By kingpolly in forum Primal Scream Room
    Replies: 14
    Last Post: 08-15-2005, 10:04 AM
  5. Blue Diamond armors - current state and shortcomings
    By Kaysha Soulsinger in forum General Trade Skill Discussion
    Replies: 20
    Last Post: 04-26-2003, 02:08 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •