Page 3 of 4 FirstFirst 1234 LastLast
Results 51 to 75 of 78

Thread: Jewelcrafting summary spreadsheet

  1. #51
    Database Code Monkey KyrosKrane's Avatar
    Join Date
    Dec 2002
    Posts
    4,431
    I think someone already fixed it, it's showing +13 under Dwerium.
    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. #52
    Expert Trader Elyssanda's Avatar
    Join Date
    Sep 2003
    Posts
    930
    Kyros? Any chance of getting this guide linked on your
    http://www.gamesnet.org/KyrosKrane/
    site?? I have it bookmarked.

    Alliance Artisan
    Proud owner of Artisan's Prize.

  3. #53
    Database Code Monkey KyrosKrane's Avatar
    Join Date
    Dec 2002
    Posts
    4,431
    My site's moved; it's now:

    http://www.kyros.info

    It has the new links there.

    I'll see if I can get a redirect link for the old site to point to the new 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

  4. #54
    Visitor
    Join Date
    Dec 2002
    Posts
    21

    conbine star

    trilion combine star trivial is 267 not 276
    Docc of Bristlebane
    Grand Master Smithing (250)
    Master Pottery (200)
    Master Fletching (200)
    Master Jewelery (200)
    Master Baking (200)
    Master Brewing (200)
    Master Tailoring (165)

  5. #55
    Database Code Monkey KyrosKrane's Avatar
    Join Date
    Dec 2002
    Posts
    4,431
    Fixed it, thanks.
    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. #56
    Visitor
    Join Date
    Nov 2005
    Posts
    30
    Any ideas on how to adjust this for the new level rec nerf?

  7. #57
    Super Moderator Drazzminius's Avatar
    Join Date
    Feb 2005
    Posts
    272

    Spreadsheet Update

    I added a tab to your workbook that is a sheet with two added colums; (1) Recommended Levels for the gems and (2) Solvents required.

    Left a couple of them blank because I couldn't verify the info with what was for sale in the Bazaar and didn't want to post any bad info.
    Mikaal Drazzminius
    Tier'Dal Necromancer
    Rodcet Nife by Birth / Quellious by Merger / Povar by Re-Merger


    Master Artisan
    Necrotalk Admin
    EQ Traders Super Moderator
    EQ Magelo Advisor/Moderator

  8. #58
    Database Code Monkey KyrosKrane's Avatar
    Join Date
    Dec 2002
    Posts
    4,431
    Cool, thanks. I integrated the info into the main 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

  9. #59
    Super Moderator Drazzminius's Avatar
    Join Date
    Feb 2005
    Posts
    272
    You locked the cells for Recommended Level and Solution. Can you unlock them so that I can make the final additions and complete the sheet?

    Thanks and great work!
    Mikaal Drazzminius
    Tier'Dal Necromancer
    Rodcet Nife by Birth / Quellious by Merger / Povar by Re-Merger


    Master Artisan
    Necrotalk Admin
    EQ Traders Super Moderator
    EQ Magelo Advisor/Moderator

  10. #60
    Database Code Monkey KyrosKrane's Avatar
    Join Date
    Dec 2002
    Posts
    4,431
    Those cells shouldn't be locked, as far as I can tell. The cells to the left and right of those columns are locked, which might make it look like these are locked too. Did you try actually editing the cells?

    If it's really locked, I'll try to figure out what's going on, but as far as I can tell, the cells are open.
    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. #61
    Database Code Monkey KyrosKrane's Avatar
    Join Date
    Dec 2002
    Posts
    4,431
    I just made a backup of the gem stats and removed the lock on them. If you notice that any of the gems have changed stats, please update the spreadsheet. I also removed the recommended level column, since none of the gems have that any 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

  12. #62
    Visitor
    Join Date
    Dec 2006
    Posts
    2
    since someone took it upon themselves to destroy the spreedsheet, any chance someone had a backup they wouldn't mind throwing back in there?

  13. #63
    Database Code Monkey KyrosKrane's Avatar
    Join Date
    Dec 2002
    Posts
    4,431
    Well, that was pretty rude of someone.

    I tried to revert back to an older version, but too much had been deleted. I'll recreate the missing cells later. Maybe I can find a way to fill out all the cells at the same time.

    In the meantime, if someone has a semi-complete copy saved, let me know here or email me (kyros@kyros.info) and I'll see about uploading 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

  14. #64
    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

  15. #65
    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

  16. #66
    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

  17. #67
    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

  18. #68
    Visitor
    Join Date
    Nov 2007
    Posts
    3

    Question regarding level restrictions

    Does anyone know where I can find the level restrictions for the various SoF Jewelry sets? Silver Trio, Electrum Trio, Gold Trio, etc.? Also, what about the solo and duo sets? I've checked the spreadsheet and that information isn't there.

  19. #69
    Database Code Monkey KyrosKrane's Avatar
    Join Date
    Dec 2002
    Posts
    4,431
    Ngreth has posted that info here.
    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. #70
    Visitor
    Join Date
    Jul 2008
    Posts
    3
    Half Moon Cut Taafeitte - Just set this in dwerium, and it shows hp/mana/end 242, AC/all other stats 24 as max.... As opposed to 250hp/mana/end and 25 to all others.

  21. #71
    Database Code Monkey KyrosKrane's Avatar
    Join Date
    Dec 2002
    Posts
    4,431
    What level are you?
    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. #72
    Visitor
    Join Date
    Jul 2008
    Posts
    3
    was 68 when posting, the numbers I get were from changing modified to unmodified... these values seem to have changed again now at 69, so looks like my mistake and the modified/unmodified check box doesnt quite work properly /blush.

  23. #73
    Database Code Monkey KyrosKrane's Avatar
    Join Date
    Dec 2002
    Posts
    4,431
    Yeah, the unmodified button just reports the stats produced by the script; and unfortunately the script's stats change based on your level. It's part of the modified recommended level system used by JC. You have to be at or over the recommended level to get the actual max stats for an item.
    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. #74
    Visitor
    Join Date
    May 2003
    Posts
    5

    Lightbulb Comments and Suggestions!

    First let me express how beatific I am over this spreadsheet! I love it! I truly do! Thanks to all to have made it, contributed to it and sweated blood over it and their jeweler's kit. My gratitude and appreciation go out to you all.

    Now I have a suggestion that I hope you all will agree makes the spreadsheet a bit easier to use. A twink really, nothing major. When I go to look up the stats for a stone under a metal I have to keep scrolling back and forth. I do know from previous experience with old spreadsheets that certain rows/columns can be frozen in place. Would you consider the following please, freeze Columns A Base Name, Column C Gem Cut and possibly Column E Slot Type so that when we scroll the metal up the Gem Name, Gem Cut and Slot Type are present as we look at the stats we would get. I believe this would make this spreadsheet much more useful.
    My Tradeskillers
    Qaewenya & Sunbird
    Cazic-thule
    Aalinaryya, Cassandrairis, Robbyyn & Senarya
    The Rathe

  25. #75
    Database Code Monkey KyrosKrane's Avatar
    Join Date
    Dec 2002
    Posts
    4,431
    The spreadsheet is again open for (limited) editing. The Temporite column is available, for those who wish to fill it in.

    I also took the opportunity to rearrange the columns as Cassandra suggested.
    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, 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
  •