Register
Results 1 to 10 of 10
  1. #1
    Gissa's Avatar
    Posts
    1,306
    Reputation
    46
    Tagged in
    498 Posts
    Add to this user's reputation

    Calculating my absolute floor

    I will start by saying I LOVE the spreadsheet for the shuffle! I'm using it constantly now I have one question though, is there a way to use the spreadsheet to figure out exactly HOW low I can go on my gem prices before I start to lose money? I don't see how I would do this.... If the spreadsheet can't do it, is there another way? I'm too tired when I get home from work (where I crunch numbers all day as a purchase-price analyst ugh) to think it through from scratch.... What do you guys do? I wan't to start posting low to see where my competitor's floors are, but I want to stay profitable (even if its small profit)

    Thanks for any help that can be given

  2. #2
    I would think since you're talking specifically about gem prices, manually change the value of uncut rares gems to 0g (or perhaps the 3.75g vendor price) and play around with uncommon gem prices while keeping watch on the gold per hour.

    If I'm right, which I hardly ever am, it would make uncut rare gems pure profit.

    Looking at it from a non spreadsheet perspective, you can put them on the AH for
    average selling price of uncut gem+ 5 gold profit + 5% (for AH fee)
    I'm talking about 10-15 cuts at a time in case your competitors buy you out.

  3. #3
    Namssob's Avatar
    Posts
    1,485
    Reputation
    123
    Blog Entries
    1
    Tagged in
    454 Posts
    Add to this user's reputation
    Yes, and no.

    No - there is no built-in reverse analysis to give you the final price for ore.
    Yes - it doesn't take long to just start typing in fake numbers, lower and lower, until you see your profit hit "0". That's what I did to find my floor.
    How To: Create And Sell Profession Kits ---- MoP Shuffle Flowchart ---- Article: A Case For Dual Gathering
    "Never underestimate the sheer amount of derp the majority of WOW's playerbase possesses." -- Belrandir
    "They could have offered me free ERPing in Goldshire with real women over Skype for the next year and I would have passed." -- Zerohour
    "Scissors are OP. Rock is fine." --Paper

  4. #4
    Quote Originally Posted by Gissa View Post
    I will start by saying I LOVE the spreadsheet for the shuffle! I'm using it constantly now I have one question though, is there a way to use the spreadsheet to figure out exactly HOW low I can go on my gem prices before I start to lose money? I don't see how I would do this.... If the spreadsheet can't do it, is there another way? I'm too tired when I get home from work (where I crunch numbers all day as a purchase-price analyst ugh) to think it through from scratch.... What do you guys do? I wan't to start posting low to see where my competitor's floors are, but I want to stay profitable (even if its small profit)

    Thanks for any help that can be given
    I am new to these forums, so forgive my ignorance, but what spreadsheet are you referring to? I personally have developed my own that I use and I would be interested to see how it compares to the one you are referring to.

  5. #5
    Wanamaker's Avatar
    Posts
    375
    Reputation
    15
    Blog Entries
    24
    Tagged in
    139 Posts
    Add to this user's reputation
    Quote Originally Posted by Armethious View Post
    I am new to these forums, so forgive my ignorance, but what spreadsheet are you referring to? I personally have developed my own that I use and I would be interested to see how it compares to the one you are referring to.
    http://consortium.stormspire.net/pro...et-masses.html
    Nothing comes merely by thinking about it.

  6. #6
    Gissa's Avatar
    Posts
    1,306
    Reputation
    46
    Tagged in
    498 Posts
    Add to this user's reputation
    Quote Originally Posted by Namssob View Post
    Yes, and no.

    No - there is no built-in reverse analysis to give you the final price for ore.
    Yes - it doesn't take long to just start typing in fake numbers, lower and lower, until you see your profit hit "0". That's what I did to find my floor.
    Are you guys talking about typing in on the prices tab or directly on the shuffle tab? And I want to know what my floor is for my rare cut gems, if I'm buying ore at 70g/stack. So I would do what, just plug in fake numbers of what I'd guess I'd do and see when my profit hits 0? It seems like it would'nt work out well that way since all the rare gems have different price levels (the infernos, ember, and crap ones like dream emeralds) plus all the uncommons that I'm either selling raw or shuffling into enchanting mats.... it's making my head hurt just thinking about it >.<

  7. #7
    Isn't this something the spreadsheet shows already?

  8. #8
    Gissa's Avatar
    Posts
    1,306
    Reputation
    46
    Tagged in
    498 Posts
    Add to this user's reputation
    Quote Originally Posted by Atterana View Post
    Isn't this something the spreadsheet shows already?
    If it does, I haven't learned it yet. From what I see on the spreadsheet (I will admit I'm new to using it), I see the set prices they gems are currently going for on the AH, which is coming from the price tab with data downloaded from TUJ, and I simply type in the price of the ore, and it tells me if the ore is profitable to buy. But what I'm trying to figure out is the opposite, if I buy the ore at a set price, how low can I go on the gems before I break even or lose money.

  9. #9
    Hmm...with that kind of approach, what I usually do is just do a quick look on Auctionator to see what the uncut gem is selling for and try to sell cut gems for a profit over that.

    Rare gems most of the time are a freebie because the main product of the shuffle is enchant mats or meta gems so technically there ISNT a low floor on them, but I can see how it's a matter of perspective.

  10. #10
    It's very hard for a person that doesnt speak english and that's never used excel before to understand what you mean with

    "7 - Highlight all the populated columns and Copy them to the clipboard.

    8 - Highlight all the populated columns in the "Prices" worksheet of this file and paste the new information in. The spreadsheet will now update."

    Could someone please explain those steps for me? :/

 

 

Similar Threads

  1. Calculating Inflation
    By Kathroman in forum Archive (General)
    Replies: 23
    Last Post: October 4th, 2011, 01:36 AM
  2. _Auctioning (v0.3.3Beta): Set absolute max price?
    By NotYetCapped in forum General TradeSkillMaster Discussion
    Replies: 3
    Last Post: August 3rd, 2011, 05:49 PM
  3. Vendor Floor pricing
    By Thorzek in forum Archive (Auction House)
    Replies: 67
    Last Post: February 8th, 2011, 01:56 PM