Page 2 of 5 FirstFirst 12345 LastLast
Results 26 to 50 of 105

Thread: Jewelcrafting calculator

  1. #26
    Apprentice Trader thomenthechanter's Avatar
    Join Date
    Oct 2007
    Posts
    164
    Perhaps just set the values to zero, so if they appear in the scrape-n-paste output as zero, there's no great hullaballoo?

  2. #27
    Database Code Monkey KyrosKrane's Avatar
    Join Date
    Dec 2002
    Posts
    4,431
    Good idea. I uploaded the zero change, but I still want to look for a more elegant solution.
    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

  3. #28
    Visitor
    Join Date
    Dec 2006
    Posts
    19
    Sticky?
    Noshadow Cast 85 Human Paladin
    Test Server
    300 Brewing
    205 Fletching
    300 Baking
    300 Smithing
    200 Fishing
    300 Jewlcraft
    200 Pottery
    200 Tailering

  4. #29
    Apprentice Trader MareeTP's Avatar
    Join Date
    Aug 2006
    Posts
    193
    Please sticky. This is wonderful.
    Silmare - Fu World Order - Bristlebane
    Master Artisan ~ Master Researcher (Hybrid)
    Master Tinker ~ Master Alchemist ~ Master Researcher(Caster) ~ Master Poisoncrafter

  5. #30
    Database Code Monkey KyrosKrane's Avatar
    Join Date
    Dec 2002
    Posts
    4,431
    I fixed the issue with the display causing zero stats to show when you copy it. Now it's worth a sticky.
    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

  6. #31
    Visitor
    Join Date
    Oct 2007
    Posts
    8
    This a great tool. Thanks so very much for the time and effort.

  7. #32
    Visitor
    Join Date
    Jan 2008
    Posts
    1
    awesome applet

  8. #33
    Visitor
    Join Date
    Nov 2005
    Posts
    30
    Are you going to upgrade this to account for the level nerfs that killed this as usefull gear?

  9. #34
    Database Code Monkey KyrosKrane's Avatar
    Join Date
    Dec 2002
    Posts
    4,431
    Heh. While I don't agree with the pessimism about the usefulness of the gear, I do plan on updating the calculator. However, that depends greatly on figuring out the algorithm used to calculate the new stats. Right now, I don't have enough data to figure that out. Once I do, I'll update the calculator.

    I'll try to remember to put up a warning on the page saying the calculator doesn't account for the new recommended levels.
    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. #35
    Contributor
    Join Date
    Dec 2002
    Posts
    68
    Lvl 53 wizard
    All items are Dwerium with Round Cut Opal/Emerald, plus one of the rec level gems.

    lvl 75 recommended gear -
    Ear - Trillion Cut Taaffeite - 1ac, 88hp/mana/end, 1 stats/resist
    Ear - Round Cut Taaffeite - same #s (different stats obviously)
    Face - Marquiesse Cut Taaffeite - same

    Lvl 70 recommended gear -
    Neck - Half-Moon Cut Harmonagate - 1ac, 91hp/mana/end, 1 stats/resist

    Lvl 65 recommended gear -
    Fingers - Round Cut Prestidigitase - 5ac, 149hp/mana/end, 6 stats/resist
    Fingers - Pear Cut Prestidigitase - same stats
    Wrist - Oval Cut Prestidigitase - same stats


    Hope that helps your computations.
    Quellious Server
    Jhavon, Erudite Tailor (300)
    Kitira, Dark Elf Brewer (269), JCr (286)
    Tardpol, Froglok Smith (242)

  11. #36
    Contributor
    Join Date
    Dec 2002
    Posts
    58
    Quote Originally Posted by KyrosKrane View Post
    Heh. While I don't agree with the pessimism about the usefulness of the gear, I do plan on updating the calculator. However, that depends greatly on figuring out the algorithm used to calculate the new stats. Right now, I don't have enough data to figure that out. Once I do, I'll update the calculator.

    I'll try to remember to put up a warning on the page saying the calculator doesn't account for the new recommended levels.
    Ngreth posted the formulas.
    Re:recomended change to jewelry crafting

    =========================
    Neebat wrote:


    Based on the spread sheet's values, I believe the formula is obvious.

    For any level over the recommended level, each stat is Stat * Metal.
    For any level below the recommended level, each stat is calculated using the normal recommended level formula.
    stat = Round(Base * Level / Recommend Level)

    The trick is, the Base varies.
    1 level below the recommend level, the Base is Stat * Metal * 99%
    2 levels below the recommend level, the Base is Stat * Metal * 97%
    3 levels below the recommend level, the Base is Stat * Metal * 95%
    4 levels below the recommend level, the Base is Stat * Metal * 90%
    5 levels below the recommend level, the Base is Stat * Metal * 85%
    6 levels below the recommend level, the Base is Stat * Metal * 75%
    7 levels below the recommend level, the Base is Stat * Metal * 65%
    8 levels below the recommend level, the Base is Stat * Metal * 50%
    9 levels below the recommend level, the Base is Stat * Metal * 35%
    10 or more levels below the recommend level, the Base is Stat * Metal * 15%

    The metals of course are:
    Dwerium: 100% Rec: 70
    Paladium: 80% Rec: 60
    Velium: 60% Rec: 50
    Platinum: 40% Rec: 35
    Gold: 30% Rec: 20
    Electrum: 20% Rec: 1
    Silver: 10% Rec: 1

    Here's an alternative proposal. It matches recommended levels for the 5 levels below the recommended level, then decays smoothly.

    Quote Originally Posted by Ngreth
    Neebat has the basics of the formula correct.

    it works by:

    (Metal Adjust * Internal Adjust) * level / recommended level

    The part in the parentheses is done by the script, the part outside done by basic item code.

    For those doing the math or wanting to try and do a worksheet or webform (KyrosKrane FTW! )

    INT (Metal * Internal / 100)

    is what is passed to code.

    That percentage when used on the stats is also cast to an INT (Truncated).

    then the recommended level code of min(level , recommended level)/recommended level is ROUNDED not cast to an int like the rest.

    The "internal" adjustment is a look-up table.
    Level Diff - Mod
    0 - 100
    1 - 99
    2 - 97
    3 - 95
    4 - 90
    5 - 85
    6 - 75
    7 - 65
    8 - 50
    9 - 35
    10 - 15

  12. #37
    Database Code Monkey KyrosKrane's Avatar
    Join Date
    Dec 2002
    Posts
    4,431
    OK, I just got done coding and uploading the first pass at these changes. I haven't verified these against in-game examples yet, though, so take them with a grain of salt.

    All feedback would be appreciated, especially instances where the calculator is wrong. Right now, it's showing ZERO stats with some gems in silver and other low metals. That intuitively feels wrong, but I don't have any in-game data to verify it. The numbers for high end metals look roughly right. I'll see if I can tweak it over the next few days.
    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

  13. #38
    Database Code Monkey KyrosKrane's Avatar
    Join Date
    Dec 2002
    Posts
    4,431
    Nope, I was wrong. The calculator is currently WAY off on some augs. I'm missing a calculation somewhere.
    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. #39
    Database Code Monkey KyrosKrane's Avatar
    Join Date
    Dec 2002
    Posts
    4,431
    OK, you know what? It really helps if I don't try to make the new formula match stats from three months ago.

    That aside, I think it's pretty accurate now. Beta 2 is now posted. Again, if you notice any bugs, please post here and I'll see what I can fix.
    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

  15. #40
    Visitor
    Join Date
    Apr 2006
    Posts
    6

    Possible Error

    Hopefully I can explain this properly:

    Platinum Trio at lvl 35
    Fire Emerald (Oval)
    Opal (Round)
    Peridot (Round)

    Displays properly according to ingame stats: 4ac / 60hp / 5ds

    When you change the dropdown box from Platinum to Velium Trio for lvl 35 with the same gems the calculator displays: [0ac] / 10hp / 1ds.

    I have not verified in game; however, I believe it should display 1ac / 10hp / 1ds. Something appears to be wrong with the ac calculation or display.

    Edit: Actually Velium Trio seems to be completely borked. I just changed the Slot 11 to Sapphire (Trillion) and the calculator displays [0ac] / 10hp / [0hp regen]. I believe it should display 1ac / 10hp / 1hp regen.
    Last edited by firescue17; 03-02-2008 at 01:02 PM. Reason: Additional Info

  16. #41
    Database Code Monkey KyrosKrane's Avatar
    Join Date
    Dec 2002
    Posts
    4,431
    Looks like I'm rounding down somewhere where I should be rounding up or rounding naturally. I'll try to remember to poke at it later.
    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. #42
    House Ogre
    SOE-DEV
    Ngreth Thergn's Avatar
    Join Date
    Jul 2003
    Posts
    6,486
    the code based recommended level (not the script based) rounds naturally if that helps ya.
    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

  18. #43
    Visitor
    Join Date
    Apr 2006
    Posts
    6

    More Inconsistencies

    To preface, I think this is a great tool and don't want to appear annoying
    Below are verified in-game stats.

    Platinum Trio at lvl 45
    Fire Emerald (Oval)
    Opal (Round)
    Peridot (Round)

    In-game Stats: 5ac / 76hp / 6ds
    Calculator Stats: 4ac / 60hp / 5ds

    ---------------------------------

    Velium Trio at lvl 45
    Fire Emerald (Oval)
    Opal (Round)
    Peridot (Round)

    In-game Stats: 4ac / 68hp / 5ds
    Calculator Stats: 5ac / 69hp / 6ds

    It's been awhile since I made a new character, but I'll keep matching for upgrades as I level.

    Thanks for the great work!

  19. #44
    Database Code Monkey KyrosKrane's Avatar
    Join Date
    Dec 2002
    Posts
    4,431
    Quote Originally Posted by firescue17 View Post
    Platinum Trio at lvl 45
    Fire Emerald (Oval)
    Opal (Round)
    Peridot (Round)

    In-game Stats: 5ac / 76hp / 6ds
    Calculator Stats: 4ac / 60hp / 5ds
    I'm not sure how the stats for platinum you quoted are possible. Platinum only provides a max of 40% of the gem's power. Since the opal is the only hp gem in the combo you listed, 40% x 150hp = 60hp max. How is it giving 76hp? Could you please double check that one?

    I'm working on tweaking the other calculations, but so far, I haven't found anything that jumps out at me as wrong.
    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. #45
    Visitor
    Join Date
    Mar 2008
    Posts
    1

    discrepancies on stats compared to in-game

    I got one lvl 22 toon in Quellious. He wears 2 Dwerium rings, I know , they both gift. Both equipped with Shimmering Nihilite, Opal, and Emerald. According to the calc, stats are 1 AC, 19 H/M/E. While in-game those are only 8 H/M/E.
    BTW the calc is very very handy and accurate on all other toons with so many diff. configurations.

  21. #46
    Database Code Monkey KyrosKrane's Avatar
    Join Date
    Dec 2002
    Posts
    4,431
    I've made a few tweaks to the calculator (not yet posted), but I still can't get it to match some of these reported examples. The calculator version I have does match Ngreth's spreadsheet exactly, for a 350hp gem in all metal types at all levels that I've tested, which is all the silver, electrum, gold, and platinum levels (yes, I actually typed in every single one), plus most of the values for the other three metals (my hands got tired). I just can't make this example match, though:

    Dwerium Trio Ring
    Shimmering Nihilite: AC 10, +250hp/mana/end
    Emerald: +150mana/end
    Opal: +150hp
    Total: AC 10, +400 hp / mana / end

    Player level: 22
    Rec. Level: 70
    Metal power: 100
    Internal level modifier: 15

    Gem modifier: 100 * 15 / 100 / 100 = 0.15 (this is what the script multiplies the gem stats by, then rounds down.)

    Script-modified stats:
    Shimmering Nihilite : 250hp * 0.15 = 37.5 = 37 after rounding down
    Emerald/Opal: 150 * 0.15 = 22.5 = 22 after rounding down
    Total: AC 0, 59 hp / mana / end

    Apply normal recommended levels:
    59 * 22(player level) / 70(rec level) = 18.54 = 19 after rounding normally.

    So the calculator says the final stats should be 19hp/mana/end, yet the report pegs it at 8 in game.

    How can this value be? Clearly there's a mistake somewhere, and it's not a small one. I'm kinda stumped, so if anyone has any ideas, I'd be happy to listen.
    Last edited by KyrosKrane; 03-07-2008 at 04:40 PM. Reason: Fixed shimmering nihilite -- it's 250hp, not 150hp
    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

  22. #47
    Database Code Monkey KyrosKrane's Avatar
    Join Date
    Dec 2002
    Posts
    4,431
    Beta 3 is now posted with a few additional tweaks. It seems to still have some problems with very low level characters, but as I noted above, it does match every single instance I checked of a 350hp gem in all metal bases, based on Ngreth's spreadsheet.
    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

  23. #48
    Visitor
    Join Date
    Apr 2006
    Posts
    6
    Quote Originally Posted by KyrosKrane View Post
    I'm not sure how the stats for platinum you quoted are possible. Platinum only provides a max of 40% of the gem's power. Since the opal is the only hp gem in the combo you listed, 40% x 150hp = 60hp max. How is it giving 76hp? Could you please double check that one?

    I'm working on tweaking the other calculations, but so far, I haven't found anything that jumps out at me as wrong.
    I dunno either.

    That's what it said. I zoned and logged and looked at it 3 or 4 times.

    Unfortunately, I've leveled past that at this point. I suppose it's possible the eror isn't with the calculator, but I don't want to be one of those people
    Last edited by firescue17; 03-08-2008 at 02:02 PM. Reason: Spelling

  24. #49
    SOE Tradeskill Correspondent
    Join Date
    Sep 2003
    Posts
    1,174
    Quote Originally Posted by KyrosKrane View Post
    Mostly for fun, I put together an assembler or calculator of sorts, to show what finished jewelery of various types would look like. It's still in testing, but it seems to work so far. I've checked it most with Mozilla 2.0 and IE6, so I'm not sure if it works on other browsers.

    Any feedback or bug reports would be appreciated. Once all the kinks are worked out, I hope to add it to the EQTC site.

    http://www.kyros.info/Tradeskills/JC-Calc/

    That's the most awesomest thing KK. Thanks.

    Used it today to figure out when I should switch from platinum to velium. I was going to change at level 39, but the stat loss is HUGE. Was able to see that the best time to switch is level 45 and I'll have no loss of stats, and a slight gain in some.





  25. #50
    Database Code Monkey KyrosKrane's Avatar
    Join Date
    Dec 2002
    Posts
    4,431
    Quote Originally Posted by firescue17 View Post
    I dunno either.

    That's what it said. I zoned and logged and looked at it 3 or 4 times.

    Unfortunately, I've leveled past that at this point. I suppose it's possible the eror isn't with the calculator, but I don't want to be one of those people
    I asked a friend to verify it in game. He's level 45, and I gave him the exact same items you had. His stats were exactly as the calculator predicted, AC: 4 HP: 60 Damage Shield: 5. I'm going to write off your experience as a random fluke, some weird transient bug that happened to be to your benefit.
    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. Question on the advanced calculator...
    By tatanka7th in forum DenMother's Corner
    Replies: 8
    Last Post: 06-09-2006, 09:15 AM
  2. The calculator appears to be incorrect
    By Leana in forum General Trade Skill Discussion
    Replies: 31
    Last Post: 07-31-2005, 07:46 PM
  3. Calculator Update
    By candle2 in forum DenMother's Corner
    Replies: 6
    Last Post: 02-18-2005, 06:25 PM
  4. Yet another skill-up and cost calculator
    By KyrosKrane in forum General Trade Skill Discussion
    Replies: 0
    Last Post: 04-28-2004, 08:10 AM

Posting Permissions

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