Page 1 of 4 1234 LastLast
Results 1 to 25 of 76

Thread: Jewelcrafting summary spreadsheet

  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 01: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
    Hobbyist
    Join Date
    Dec 2005
    Posts
    134
    Quote Originally Posted by KyrosKrane View Post
    I haven't been able to make round cuts of the following gems, with and without a jeweler's glass.
    The book seems to imply that all vendor-bought gems can be round cut, but then goes on and gives a list. None of those gems are on the list. I can at least confirm that I was not able to round cut Amber.
    Your brain has performed an illegal operation and will now shut down...

  8. #8
    Baking Queen
    Join Date
    Oct 2002
    Posts
    1,299
    Quote Originally Posted by KyrosKrane View Post
    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

    Ruby is Square-cut, with Jewelers Glass required in the combine.

    Can't recall about the others off the top of my head.
    Angelsyn Whitewings, Cleric of Tunare for 66! Seasons.
    Grandmistress Smith - 300, Grandmistress Tailor - 300, Potter - 300, Jeweler - 300, Brewer - 200, Baker - 200, Fletcher - 200, Fisherwoman - 169
    Keyne Falconer, Paladin of Erollisi Marr for 66 Seasons.
    Grandmistress Baker - 300, Grandmistress Blacksmith - 300, Potter - 200, Brewer - 139, Tailor - 91

  9. #9
    Expert Trader
    Join Date
    Dec 2006
    Posts
    569
    I can confirm fire emerald in slot 11 dwerium item gets +13 DS


    EDIT: opal fire emerald is +13 DS, I didn't check for round fire emerald so no idea yet if it's same or not. If it is not the same, someone will have to adjust the spread sheet and insert an extra line for separate round fire emerald and oval fire emerald.
    Last edited by Unapuma; 11-20-2007 at 09:50 AM.

    Grolyn Blacknife
    Beastlord
     T:7
     M:0
     T:6
     M:1
     T:6
     M:0
    Fletching:
    284
     T:7
     M:0
     T:6
     M:0
     T:7
     M:2
    Zira Blacknife
    Shaman
     T:7
     M:0
    Maelin Starpyre
    Vazaelle
    Reiseraa
    Necro
    Research:
    102

  10. #10
    House Ogre
    SOE-DEV
    Ngreth Thergn's Avatar
    Join Date
    Jul 2003
    Posts
    6,448
    Currently there are 4 scripts.

    One that is used on the majority of items.

    One that is used for the DS item.

    One that is used for the two regen items.

    One that is used for the worn effect items.

    Each of these act a bit differently according to what they are put in (to give the resultant stats we want) and is what the DS and Regen GEMS have such huge values.
    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

  11. #11
    Database Code Monkey KyrosKrane's Avatar
    Join Date
    Dec 2002
    Posts
    4,431
    Things to check when I have time (or if someone beats me to it):

    Round Cut Fire Emerald
    Round Cut Star Ruby

    Those are the last two listed on the sheet as having two possible cuts. If those can't be round cut, then it means each vendor-sold gem has exactly one cut, which can produce either a type 10/11 or a type 11 only aug. If that's the case, it simplifies the spreadsheet a bunch.
    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
    Join Date
    Feb 2006
    Posts
    729
    Quote Originally Posted by KyrosKrane View Post
    Things to check when I have time (or if someone beats me to it):

    Round Cut Fire Emerald
    Round Cut Star Ruby

    Those are the last two listed on the sheet as having two possible cuts. If those can't be round cut, then it means each vendor-sold gem has exactly one cut, which can produce either a type 10/11 or a type 11 only aug. If that's the case, it simplifies the spreadsheet a bunch.

    All of the store bought and dropped gems have only the single cut as listed. (This does not include Staurolite, Prestidigitase, Harmonagate, Taaffeite, which all can be cut to any of the 7 cuts)


    Round Cut Tool + Gem (combine in a JC Kit)
    Each has the stat listed.
    All can fit type 10 and type 11.


    Round Cut Malachite: svP
    Round Cut Lapis Lazuli: svD
    Round Cut Cat's Eye Agate: svM
    Round Cut Hematite: svF
    Round Cut Torquoise: svC
    Round Cut Carnelian: STR
    Round Cut Onyx: DEX
    Round Cut Jasper: AGI
    Round Cut Wolf's Eye Agate: WIS
    Round Cut Jade: INT
    Round Cut Star Rose Quartz: CHA
    Round Cut Periodot: AC
    Round Cut Opal: HP
    Round Cut Emerald: mana/end

    (Pearl uses the same recipe, but the name is not Round Cut)
    Small Shaped Pearl: STA



    Round Cut Tool + Gem + Eye Glass (combine in a JC Kit)
    Each has the stat/ listed.
    All can fit only in a type 11.


    Half Moon Cut Goshenite: Str/Sta/Wis
    Marquise Cut Alexandrite: Str. Sta/Int
    Oval Cut Demantoid: Str/Sta/Chr
    Oval Cut Fire Opal: Enduring Breath
    Oval Cut Fire Emerald: Damage Shield
    Pear Cut Rubellite: Str/Sta/Int/Wis/Agi/Dex/Chr
    Pear Cut Star Ruby: Faerune
    Round Cut Jacinth: Str/Sta/Dex
    Round Cut Morganite: Str/Sta/Agi
    Square Cut Ruby: Mana Regen
    Square Cut Black Sapphire: SvM/SvF/SvC/SvP/SvD
    Trilion Cut Amber: Ultravision
    Trilion Cut Amethyst: SvM/SvF/SvC
    Trilion Cut Bloodstone: Heat Sight
    Trilion Combine Star: SvM/SvD/SvP
    Trilion Cut Sapphire: Hp Regen
    Trilion Cut Topaz: Shadow Sight



    I have not had time to play with Nihilite. I am still working on getting enough combines to tier to on Raw Pale Nihilite, before I try combines on the other types, but I am getting close. Updates to follow.



    Gorse

  13. #13
    Expert Trader
    Join Date
    Feb 2006
    Posts
    729
    Quote Originally Posted by KyrosKrane View Post
    Things to check when I have time (or if someone beats me to it):

    Round Cut Fire Emerald
    Round Cut Star Ruby

    Those are the last two listed on the sheet as having two possible cuts. If those can't be round cut, then it means each vendor-sold gem has exactly one cut, which can produce either a type 10/11 or a type 11 only aug. If that's the case, it simplifies the spreadsheet a bunch.

    Oval Cut Fire Emerald: Damage Shield
    Pear Cut Star Ruby: Faerune


    Note: Star Ruby is 68pp and change on vendor, trivial 188. Silver bar to make a Silver Solo ring is a few gold, trivial 18. For less than 70pp you can now make Faerune rings!! WOOT. I'm making them for everyone in the guild when the servers come back up.



    Gorse

  14. #14
    Database Code Monkey KyrosKrane's Avatar
    Join Date
    Dec 2002
    Posts
    4,431
    Heh, make a silver trio ring and let your guildies get something in the other two slots. Shouldn't be much harder or more expensive.
    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. #15
    Expert Trader
    Join Date
    Feb 2006
    Posts
    729
    The bagged Faerune ring is situational item mostly to keep from drowning, until their spirit tracker cloak evolves, but yes, I'll give them the trio ring and let them decide.

    It was really just to state the point, Faerune, any level, under 70pp = happy players.



    Gorse

  16. #16
    Database Code Monkey KyrosKrane's Avatar
    Join Date
    Dec 2002
    Posts
    4,431
    I just updated the spreadsheet to eliminate some redundant columns. Now that we know that each gem can only be cut to one slot configuration, it eliminates a lot of the redundancies in the spreadsheet and makes for a cleaner, more intuitive layout.
    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
    Visitor
    Join Date
    Nov 2007
    Posts
    7
    i would like to say a BIG "thank u" to u KyrosKrane for getting this spreadsheet up and running so quickly.Thank u to all those who have added their 2 cents as well.I am sure many of us appreciate all the hard work involved in organising things and truly do think ur gods !!!....hehehehe Keep up the good work.....

    Sparkthefire

    (PS Could we add a trivial column to the spreadsheet at all?)
    Last edited by sparkthefire; 11-20-2007 at 05:11 PM. Reason: added more

  18. #18
    Database Code Monkey KyrosKrane's Avatar
    Join Date
    Dec 2002
    Posts
    4,431
    Thanks for the appreciation. I just want to emphasize that it's a community effort. I just set up the sheet; most of it got filled "by magic" as community members pitched in with the missing info.

    And sure, the trivial column makes sense. I'll add it now.
    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

  19. #19
    Expert Trader
    Join Date
    Dec 2006
    Posts
    569
    I'll go add in taaffeite and staurolite trivls as I've done them all.

    EDIT: that leaves most of cut harmongate and a half moon cut presti left to find trival
    Last edited by Unapuma; 11-20-2007 at 11:14 PM.

    Grolyn Blacknife
    Beastlord
     T:7
     M:0
     T:6
     M:1
     T:6
     M:0
    Fletching:
    284
     T:7
     M:0
     T:6
     M:0
     T:7
     M:2
    Zira Blacknife
    Shaman
     T:7
     M:0
    Maelin Starpyre
    Vazaelle
    Reiseraa
    Necro
    Research:
    102

  20. #20
    Apprentice Trader
    Join Date
    Dec 2002
    Posts
    248
    Ooops. Heh. Yeah. Clearly, I was not paying full attention.

    That said... does indigo Nihilite actually change from Mana to HPs when going from Velium to Palladium, or is that a typo?
    Unmei, Coercer, Lanys.

  21. #21
    Database Code Monkey KyrosKrane's Avatar
    Join Date
    Dec 2002
    Posts
    4,431
    I'm willing to believe that one's a typo. Fixed 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

  22. #22
    Contributor
    Join Date
    Feb 2003
    Posts
    53
    The Square Cut Ruby provides Mana Regen 7 when set in a Dwerium item.

    Not bad at all.
    Eidolon Faer
    Enchanter of the 81st Confusion, Brell Serilis / Cazic Thule
    Member of Veteran Crew

  23. #23
    Database Code Monkey KyrosKrane's Avatar
    Join Date
    Dec 2002
    Posts
    4,431
    Whoa, that's a fun ring. 100hp/mana and 7 mana regen. Low level casters would flip for 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

  24. #24
    Expert Trader
    Join Date
    Dec 2006
    Posts
    569
    Defiantly and with no level limit, a level 1 caster can probably solo kreshin in Gloomingdeep mine with a full set of dwerium trio gears and gems.

    Grolyn Blacknife
    Beastlord
     T:7
     M:0
     T:6
     M:1
     T:6
     M:0
    Fletching:
    284
     T:7
     M:0
     T:6
     M:0
     T:7
     M:2
    Zira Blacknife
    Shaman
     T:7
     M:0
    Maelin Starpyre
    Vazaelle
    Reiseraa
    Necro
    Research:
    102

  25. #25
    Apprentice Trader
    Join Date
    Dec 2002
    Posts
    168
    Wouldnt let me save changes. Shimmering Nihilite is AC 10 HP/MANA/END 250 in Dwerium.
    Kekenewah Silverfire: 82 High Elf Wizard: Drinal Server salvage 3
    300 Jeweler (plus 15%) & JM3, 300 Smith w/ SM3 (plus 15%), 248 brewer (plus 5%), 300 tailor (plus 15% & TM3), 200 baker, 217 Pottery (plus 5%), 200 Fisherman, 300 spell research w/ AT3 (plus 15%)
    Kekema: 81 gnome magician 250 fletcher (plus 5%), 215 tinkerer (plus 5%)
    Kekero: 65 dwarf rogue 300 make poison (plus 12%)
    Keketrol: 74 troll shaman 300 alchemist w/ AM3 (plus 15%) salvage 3
    Kekecha: 75 Erudite enchanter 122 smith (plus 5%)
    Kekenebog: 59 Ogre warrior 203 blacksmith (plus 5%)
    Kekera: 62 halfling ranger: 189 blacksmith (plus 5%)
    Keneken: 75 dark elf necro: 112 tailor (plus 5%)
    Keke 70 High Elf wizard on Mayong 300 plus 12% research with AT3

Similar Threads

  1. Research Spreadsheet
    By Xorithra L`Amante in forum Spell Research
    Replies: 40
    Last Post: 02-13-2007, 07:58 PM
  2. Vah Shir Quest and Task information
    By Zunnoab in forum Database Updates Completed
    Replies: 11
    Last Post: 03-10-2005, 08:54 AM
  3. Jewelcrafting Data 200-250
    By Jarroll in forum Jewelcraft
    Replies: 2
    Last Post: 11-12-2004, 09:42 AM
  4. Research Spreadsheet
    By Xorithra L`Amante in forum DenMother's Corner
    Replies: 4
    Last Post: 09-18-2003, 05:49 AM
  5. Replies: 9
    Last Post: 05-16-2003, 01: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
  •