Jewelcrafting summary spreadsheet

[KyrosKrane]

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.

[Twistagain]

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...

[KyrosKrane]

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.

[Twistagain]

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...

[Unmei]

I just set a Square Cut Ruby in a Dwerium Setting, and it gave 7 Mana Regen. I've updated the spreadsheet accordingly.

[KyrosKrane]

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

[KyrosKrane]

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.

[Marissas]

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.

[Kumat]

Someone delete all the info on the spreadsheet?

[KyrosKrane]

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.

[Delph]

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)

[Delph]

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?

[Bobaten]

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.

[sparkthefire]

i know lots of people refer to this chart .....any chance making this a sticky plz?

sparkthefire

[Zopharr]

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

[Yank]

Yes thank you.

Please sticky this

[KyrosKrane]

Temporarily stickied until we can find a better way to present the information.

[Elyssanda]

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

[Delph]

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).

[KyrosKrane]

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.

[zeddlar]

I see no one has found one that does atk yet, wondering if thereis such a bst, lol.

[KyrosKrane]

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.

[KyrosKrane]

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.

[Kenanna]

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

[KyrosKrane]

I'm glad you find the tools useful.

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.