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

Thread: Jewelcrafting summary spreadsheet

Hybrid View

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

    Jewelcrafting summary spreadsheet

    I'm becoming more and more a fan of shared spreadsheets, so I'm giving this one a try with Jewelcrafting. I've put together a sheet that summarizes what I know so far of the new gems, their cuts, and what stats they give with each metal. Feel free to browse or add to it; the sheet is open for everyone to edit.

    http://www.editgrid.com/user/kyroskrane/Jewelcrafting

    The max stats information should be copied from Lucy, EQItems, Magelo, or a similar authenticated source.

    The information for each metal should be taken from in game. In other words, if you don't see the stats in game, please don't post them here. No guesses or assumptions, please. For gems that can be both slot 10 or slot 11 with different cuts, please post the slot 11 cut stats.

    Once the sheet is mostly filled in, I hope to make a JC calculator or assembler of some sort that lets you select a base metal and your preferred gems and cuts, then see what the final stats will look like.

    And remember that since the spreadsheet is shared, any change you make is immediately visible to everyone! Please be careful about deleting cells by accident. If you want to reserve some cells for yourself, you can lock that range of cells and make a note of why you locked it.

    Let me know what you think.
    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
    Expert Trader
    Join Date
    Jan 2003
    Posts
    698
    Surely the stats for Ruby and Sapphire are wrong...right?

    If not, I'll me making some of those pronto.

    Edit: Also, check Fire Emerald. On all three, I think the 100 is probably wrong. Even with the hard caps on Mana Regen, Regen, and DS...
    Last edited by Twistagain; 11-19-2007 at 12:48 PM.

  3. #3
    Database Code Monkey KyrosKrane's Avatar
    Join Date
    Dec 2002
    Posts
    4,431
    The data is copied straight from Lucy. I'm guessing the code that adjusts the stats based on the metal will reduce that appropriately. That's why I asked for in-game data for the metals. If we see that Dwerium offers +100 mana regen, well ... that should be fun.
    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

  4. #4
    Expert Trader
    Join Date
    Jan 2003
    Posts
    698
    I can't access Lucy from work, but:

    I noticed from another thread that Palladium-set gems are 76% of max, and that Dwerium are 100%. If that is the case, and that the percentage is based on the metal and holds true from item-to-item, then it looks like Platinum is around 38%.

    If the regen rates are 10 (instead of 100), then the Palladium value would be 7.6 (rounded to 8?) and Platinum would be 3.8 (rounded to 4?) The 4 for Platinum matches the chart entry.

    Now, the Fire Emerald is a different story...and the DS is 5 for Platinum according to this chart. Odd...

  5. #5
    Apprentice Trader
    Join Date
    Dec 2002
    Posts
    248
    I just set a Square Cut Ruby in a Dwerium Setting, and it gave 7 Mana Regen. I've updated the spreadsheet accordingly.
    Unmei, Coercer, Lanys.

  6. #6
    Database Code Monkey KyrosKrane's Avatar
    Join Date
    Dec 2002
    Posts
    4,431
    Thanks, Unmei, but that info should have been in the Dwerium column. Updated it for you.

    I haven't been able to make round cuts of the following gems, with and without a jeweler's glass. Anyone else able to make these? (It's also very possible that I misread the book and these can't be made as round cuts. I couldn't find the JC book to check the text.)

    Amber
    Bloodstone
    Fire Opal
    Ruby
    Sapphire
    Topaz
    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
    Today I noticed that a significant number of cells had improper data in them, like incorrect gem names or wrong stats. I think these were the result of careless misclicks or typos, rather than vandalism; I'm guessing people don't realize that this spreadsheet is live, and any change they make is immediately saved and visible to everyone. To help prevent us from losing key data, I've locked the gem name, cut, trivial, type, and base stats. If you notice something that needs to be changed among those (especially the missing Harmonagate trivials), please post here and I'll edit it.
    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
    Visitor Marissas's Avatar
    Join Date
    Aug 2007
    Posts
    37
    I cant help but think that the new JC items having NO req/rec was an oversight.

    Then again, with the HUGE gambit change in the culteral augs , I'm not sure what to believe.

    Ive made many things and I keep saying to myself , "this was an oversight, they will crash servers any minute and "fix" it !"

    Was it the intent for such a HUGE increase in stats on player made stuff? We've been asking for something like this for years (highly desirable play made items) pretty much since level 55 and they havnt really done anything this major yet.

    Anyone feel that these big increases are going to be changed drastically ?

    On a side note , I am NOT a fan of the "charmlike" stats on the new JC. I would like to be able to make an item, gem it up, see the stats, then offer it to others.

  9. #9
    Visitor
    Join Date
    Jan 2003
    Posts
    2
    Someone delete all the info on the spreadsheet?
    Kumat Emeraldheart
    Wood Elf Druid
    Xegony
    Magelo:
    http://www.magelo.com/eq_view_profile.html?num=422802

  10. #10
    Database Code Monkey KyrosKrane's Avatar
    Join Date
    Dec 2002
    Posts
    4,431
    Someone renamed the spreadsheet and moved it to a different tab. The info is all still there. If you get a blank screen, look for the little "Jewelcrafting" tab at the bottom and click it.
    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

  11. #11
    Database Knight Delph's Avatar
    Join Date
    Jul 2003
    Posts
    672
    Perhaps I'm missing something, but I do not see any difference in the values of the max 'raw item stats' between:

    • Half Moon & Marquise Cut Harmonagate (AC: 17 STR: 19 DEX: 19 AGI: 19 HP/Mana/END: 200 FR: 19 DR: 19 CR: 19 MR: 19 PR: 19)
    • Pear & Round Cut Taaffeite (AC: 19 STA: 23 CHA: 23 WIS: 23 INT: 23 HP/Mana/END: 250 FR: 23 DR: 23 CR: 23 MR: 23 PR: 23)

    I've found from past experiences that the tighter your plan, the more likely you are to run into something unpredictable.

  12. #12
    Database Knight Delph's Avatar
    Join Date
    Jul 2003
    Posts
    672
    Quote Originally Posted by Delph View Post
    Perhaps I'm missing something, but I do not see any difference in the values of the max 'raw item stats' between:

    • Half Moon & Marquise Cut Harmonagate (AC: 17 STR: 19 DEX: 19 AGI: 19 HP/Mana/END: 200 FR: 19 DR: 19 CR: 19 MR: 19 PR: 19)
    • Pear & Round Cut Taaffeite (AC: 19 STA: 23 CHA: 23 WIS: 23 INT: 23 HP/Mana/END: 250 FR: 23 DR: 23 CR: 23 MR: 23 PR: 23)
    It seems the Harmonagate issue was resolved above, but I just obtained separate confirmation from guildmates that both the Pear and Round Cut Taaffeite give the stats listed above (AC: 19 STA: 23 CHA: 23 WIS: 23 INT: 23 HP/Mana/END: 250 FR: 23 DR: 23 CR: 23 MR: 23 PR: 23) when in Dwerium settings. Oversight or intentional?

    I've found from past experiences that the tighter your plan, the more likely you are to run into something unpredictable.

  13. #13
    Expert Trader
    Join Date
    Jan 2003
    Posts
    971
    I see how it happened.
    In the old system, pear cut taaffeite was 16 sta/int/wis, 8 cha. And round cut was 16 int/wis/cha, 8 sta. In the new system the "half power stat" got bumped up to full power, so they match.

  14. #14
    Visitor
    Join Date
    Nov 2007
    Posts
    7
    i know lots of people refer to this chart .....any chance making this a sticky plz?

    sparkthefire

  15. #15
    Trader
    Join Date
    Dec 2002
    Posts
    401

    Thanks

    I've spent the first two weeks of SoF playing around with smithing and some alchemy, so just now looking at what Zopharr can do with hsi 300JC. All I can say is "wow"! Thanks for starting this spreadasheet, KyrosKrane!

    Zopharr
    Garshok
    95th Dreadlord, Povar-Quellious, 300 Ogre Grand Master Smith, 300 all skills
    (glad the climb to 300 is finally over)

    Zopharr
    95th Priest of Brell, Povar-Quellious, 300 Dwarven Grand Master Smith, 300 all skills
    (holds his 15% smithing trophy in his off hand and pretends to dual-wield - and hopes the Holy Dirt of Brell he's carried for twelve years will have a use in the new expansion)

    Rishathra
    95th Shaman of Inny, Povar-Quellious, 300 Troll Grand Master Smith
    (got so tired of looking for a troll smith for armor that I made one)

    Marzanna
    95th Necromancer, Povar-Quellious, 300 Tinker - Tailor
    (still working on Solder, Spy)

  16. #16
    Visitor
    Join Date
    Nov 2005
    Posts
    30

    Thanks

    Yes thank you.

    Please sticky this

  17. #17
    Database Code Monkey KyrosKrane's Avatar
    Join Date
    Dec 2002
    Posts
    4,431
    Temporarily stickied until we can find a better way to present the information.
    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 Elyssanda's Avatar
    Join Date
    Sep 2003
    Posts
    930
    Kyros? what about the Amethyst and polished quartz from Ldon? they now worthless?

    I don't mean the uncut amethyst... just the one from Nro Ldon

    Alliance Artisan
    Proud owner of Artisan's Prize.

  19. #19
    Database Knight Delph's Avatar
    Join Date
    Jul 2003
    Posts
    672
    Quote Originally Posted by Elyssanda View Post
    Kyros? what about the Amethyst and polished quartz from Ldon? they now worthless?

    I don't mean the uncut amethyst... just the one from Nro Ldon
    Unfortunately I don't know the answer to this question, but there are also Geodes that can be foraged in those same LDoNs with the Polished Quartz and Amethyst and were used in jewelry (trivials above 300 with velium if I remember correctly).

    I've found from past experiences that the tighter your plan, the more likely you are to run into something unpredictable.

  20. #20
    Database Code Monkey KyrosKrane's Avatar
    Join Date
    Dec 2002
    Posts
    4,431
    I honestly don't know. They're not mentioned in the JC book either way, so I assume like blue diamonds and the original jacinths and black sapphires, they're not part of the new system.
    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

  21. #21
    Visitor
    Join Date
    Oct 2007
    Posts
    2
    I see no one has found one that does atk yet, wondering if thereis such a bst, lol.

  22. #22
    Database Code Monkey KyrosKrane's Avatar
    Join Date
    Dec 2002
    Posts
    4,431
    I've used the Calculator I wrote to generate the stats for all the gem and metal combinations. I've uploaded the spreadsheet as read-only to prevent further vandalism. If you notice any errors, please post in this thread and I'll make the corrections.
    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. #23
    Database Code Monkey KyrosKrane's Avatar
    Join Date
    Dec 2002
    Posts
    4,431
    Somewhat to my surprise, the Jewel Crafting spreadsheet has become a Featured Spreadsheet at EditGrid. Go figure.

    Thanks to everyone who contributed info and made the sheet possible.
    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

  24. #24
    Visitor
    Join Date
    Dec 2007
    Posts
    1

    Sapphire listing

    Thanks for the great spreadsheet and gizmonotron. I'm going to use it to see what kind of jewelry I need made for my toons.

    I notice in the spreadsheet called Jewelcratf Augs that the 9th line has "/camp" listed under the stone. It's effect is regeneration 10. I used the gizmonotron to figure out that is suppose to say Sapphire. I just thought you might like to correct that.

    Your work has brought some order into a very confusing field (at least for me). Thanks again for all everyone's hard work.

    Kenanna
    80 Druid
    The Rathe server

  25. #25
    Database Code Monkey KyrosKrane's Avatar
    Join Date
    Dec 2002
    Posts
    4,431
    I'm glad you find the tools useful.

    Quote Originally Posted by Kenanna View Post
    I notice in the spreadsheet called Jewelcratf Augs that the 9th line has "/camp" listed under the stone. It's effect is regeneration 10. I used the gizmonotron to figure out that is suppose to say Sapphire. I just thought you might like to correct that.
    I don't see this on the live spreadsheet, located here:
    http://www.editgrid.com/user/kyroskrane/Jewelcrafting

    Are you sure you're not looking at a local copy that you made on your PC? Honestly it does sound like a mistake I might have made when windowing back and forth between EQ and the spreadsheet, but I just don't see it there.
    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. Research Spreadsheet
    By Xorithra L`Amante in forum Research
    Replies: 40
    Last Post: 02-13-2007, 06:58 PM
  2. Vah Shir Quest and Task information
    By Zunnoab in forum Database Updates Completed
    Replies: 11
    Last Post: 03-10-2005, 07:54 AM
  3. Jewelcrafting Data 200-250
    By Jarroll in forum Jewelcraft
    Replies: 2
    Last Post: 11-12-2004, 08:42 AM
  4. Research Spreadsheet
    By Xorithra L`Amante in forum DenMother's Corner
    Replies: 4
    Last Post: 09-18-2003, 04:49 AM
  5. Replies: 9
    Last Post: 05-16-2003, 12:34 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
  •