Results 1 to 14 of 14
  1. #1
    Private

    CoreCoins User


    Reputation
    21
    Join Date
    Mar 2010
    Posts
    14
    CoreCoins
    1000

    Trade Feedbacks

    Status
    n/a
    Positive
    0 (0%)
    Negative
    0 (0%)

    Spread Sheet - Prospecting - Jewelcrafting - Disenchanting



    Donate to Remove Ads, Get ShoutBawx - Elite Forum Access
    Spread Sheet - Prospecting - Jewelcrafting - Disenchanting

    Calculates profit from,
    Propecting
    Jewelcrafting
    Disenchanting

    Works well if you have any of the above professions, preferably 2.

    Remenber is is all about theoretical so do not count on it to be correct if your only doing 10 stacks.
    100+ stacks you can sorta count on it.

    Link is: excells.net

    More spreadsheets and gold guides to come in future!
    Happy Cataclysm!
    Excells!

    UPDATED 1/3/11
    Same download link, much better calculations!

    UPDATED 1/7/11
    Fixed Link
    Have Fun!
    Last edited by excellqwerty; 01-06-2011 at 06:03 PM. Reason: Updated

  2. #2
    Member
    Reputation
    1
    Join Date
    Feb 2008
    Location
    Edmonton, AB, CA
    Posts
    12
    CoreCoins
    0

    Trade Feedbacks

    Status
    n/a
    Positive
    0 (0%)
    Negative
    0 (0%)
    Hey man, this spreadsheet will be very helpful, but I noticed a mistake. You listed the drop chance for rare gems the same on both Obsidium and Elementium Ore. You have them both at a 1.2% chance to drop a rare gem. The actual drop rate for rare gems on Elementium Ore (according to Wowhead) is 4%.

    As a result, this is causing lower profit numbers appearing for prospecting Elementium Ore than what they would be in reality.

    It would be great if you could tell me how to edit your spreadsheet so I can get some real numbers. If that's impossible, then a fix would be awesome.

    +rep for potential

  3. #3
    Master Sergeant
    Reputation
    9
    Join Date
    May 2010
    Posts
    107
    CoreCoins
    0

    Trade Feedbacks

    Status
    n/a
    Positive
    0 (0%)
    Negative
    0 (0%)
    Did you create this in Office 2010 because when I try to open it in my older version of Microsoft Excel 2003 it converts it so I can open it but I can't actually edit the values.

  4. #4
    Contributor
    Reputation
    154
    Join Date
    Jun 2008
    Posts
    228
    CoreCoins
    41

    Trade Feedbacks

    Status
    Superior trader
    Positive
    6 (100%)
    Negative
    0 (0%)
    I suspect your data for prospecting is wrong. Your spreadsheet tries to compensate for multiple drops by multiplying the value times 1.5, when infact the multiple drop rates are already factored into the percentages. This is why wowhead's prospecting percentages add up to more than 100%.

    Using the default values with 10 set to everything. For Obsidium ore, The amount per prospect should read 2.4 for the green gems and 1.2 on the blue gems.

    Edit: Also the disenchanting is way way off.

    Read here how to calculate it properly: http://wow-pro.com/wiki/disenchanting_profit
    Last edited by wootpeng; 12-28-2010 at 07:33 AM.

  5. #5
    Member
    Reputation
    1
    Join Date
    Jan 2009
    Posts
    32
    CoreCoins
    0

    Trade Feedbacks

    Status
    n/a
    Positive
    0 (0%)
    Negative
    0 (0%)
    Thanks! +rep

  6. #6
    Private

    CoreCoins User


    Reputation
    21
    Join Date
    Mar 2010
    Posts
    14
    CoreCoins
    1000

    Trade Feedbacks

    Status
    n/a
    Positive
    0 (0%)
    Negative
    0 (0%)

    Updated

    Updated: See main post.

  7. #7
    Knight-Lieutenant DK1989's Avatar
    Reputation
    34
    Join Date
    Nov 2010
    Location
    Florida
    Posts
    321
    CoreCoins
    1

    Trade Feedbacks

    Status
    n/a
    Positive
    0 (0%)
    Negative
    0 (0%)
    Link broken. Redirects you to the homepage.

  8. #8
    Private

    CoreCoins User


    Reputation
    21
    Join Date
    Mar 2010
    Posts
    14
    CoreCoins
    1000

    Trade Feedbacks

    Status
    n/a
    Positive
    0 (0%)
    Negative
    0 (0%)
    Quote Originally Posted by DK1989 View Post
    Link broken. Redirects you to the homepage.
    Fixed link for you.

  9. #9
    Banned
    Reputation
    1
    Join Date
    May 2009
    Posts
    11
    CoreCoins
    1

    Trade Feedbacks

    Status
    n/a
    Positive
    0 (0%)
    Negative
    0 (0%)
    Looks nice! Finally I know when to sell my elementium and when its better to prospect Thanks a lot!

  10. #10
    Knight-Lieutenant DK1989's Avatar
    Reputation
    34
    Join Date
    Nov 2010
    Location
    Florida
    Posts
    321
    CoreCoins
    1

    Trade Feedbacks

    Status
    n/a
    Positive
    0 (0%)
    Negative
    0 (0%)
    Quote Originally Posted by excellqwerty View Post
    Fixed link for you.
    Thank you much

    Quote Originally Posted by jkuzhn View Post
    Looks nice! Finally I know when to sell my elementium and when its better to prospect Thanks a lot!
    Yea same here I've been selling the ore flat out but now its starting to get too bad since people are flooding the AH and its time to get the JC back out lol

  11. #11
    Member
    Reputation
    2
    Join Date
    Apr 2009
    Posts
    44
    CoreCoins
    0

    Trade Feedbacks

    Status
    n/a
    Positive
    0 (0%)
    Negative
    0 (0%)
    Wow dude alott of work put into this site and this specific spreadsheet! I use all of them thanks man! +rep if i can

  12. #12
    Private

    CoreCoins User


    Reputation
    21
    Join Date
    Mar 2010
    Posts
    14
    CoreCoins
    1000

    Trade Feedbacks

    Status
    n/a
    Positive
    0 (0%)
    Negative
    0 (0%)
    Thanks guys for your positive feedback
    Love it!

  13. #13
    Bor
    Bor is offline
    New User
    Reputation
    1
    Join Date
    Jan 2011
    Posts
    1
    CoreCoins
    0

    Trade Feedbacks

    Status
    n/a
    Positive
    0 (0%)
    Negative
    0 (0%)
    Apologies for being a complete nub here, but I am having difficulties with opening the spreadsheet correctly in Excel. (I am not such a hero with XML sheets) When I open the [content_types] file in excel I get the question "How to open the file" a) as XML table b) as read only workbook c) use xml source taskpane.

    With all these options I just get the programming info of the calculations etc in the sheet, not the pretty looking sheet as it is intended.

    Could one of you please be so kind to give me a bit of guidance on how to open it correctly.

  14. #14
    Contributor

    CoreCoins User

    Nekan's Avatar
    Reputation
    108
    Join Date
    Feb 2009
    Posts
    279
    CoreCoins
    255

    Trade Feedbacks

    Status
    Superior trader
    Positive
    1 (100%)
    Negative
    0 (0%)
    To open .xlsx files you need to have Excel 2007 or newer, if you have 2003 you will need to download FileFormatConverters from Microsoft website, just google it.

 

 

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
All times are GMT -4. The time now is 10:26 AM. Powered by vBulletin® Version 4.2.0
Copyright © 2014 vBulletin Solutions, Inc. All rights reserved. Digital Point modules: Sphinx-based search