Crazy, I just noticed that the plus sign doesn't show on my original post! Well, you can see the formulas I used anyway.
I'll cook up a plausible scenario to demonstrate the benefits of this spreadsheet. Too often I hear buyers complaining that DV prices for SH items are too high. Say you have a nice ale or ugly squash that you would like to make 3B profit on. Say you have a max of 4B money (because you're a low stat player). Using this spreadsheet, you can easily calculate that volleying a 1B tut to 4B will net you 1B in profit. Do that for 3 tuts and you have 3B profit! Wait wait says the high stat buyer, if I volley with the seller, I'm stuck with 12B in useless tuts! Well, if you dump those three, you lose nearly 5B...BUT, you ALSO made at least 2.5B through volleys. That means dear friends, that the high stat player bought his or her lovely item for ONLY 2.5B give or take! Not the 10 B I've been seeing buyers moan and groan about. 2.5B is NOTHING to you high staters; you make that much or more in just one easy Counter Culture (during the 3x parties).
Lol, sorry! Just trying to demonstrate the benefits of the system. It benefits both buyer and seller as it shows you EXACTLY how much a seller will profit and show much it will really cost a buyer.
I thought I should update this thread as I found a FATAL flaw with my first spreadsheet. The total profit at the end of the formula string is actually for both volleyer's, not just yourself. so easiest thing to do is divide that number by 2 in order to get a rough average of your actual profit. Some day, when I can register on the BB on a PC, I'll attach a copy of my latest spreadsheet. It's got several helpful tricks that would take entirely too long to explain.
Honestly, if you're not at least somewhat familiar with Excel, this won't help you at all, but most people have Excel and never realize because it's part of MS Office. The first pic I posted on page 2 was somehow deleted but the other pics still show. I can post more pics if it will help clarify. Or, you could just go by the assumption that: A buyers NET cost will be 3 times the sellers profit, as long as the buyer is the volley partner. If not, NET cost will be 4 times the sellers profit. For example: Say someone wants to sell an item for 1 billion profit. The buyer can safely assume that, as long as they volley with the seller, it will ultimately cost them 3 billion. 2billion profit will cost 6 billion, and on and on....
way too complicated. Just take the current price of the tutor then multiply it by .0835 and it will give you the amount you need to have out to rehire.
This isn't "complicated" but it requires more math than a simple multiplication (which is wrong by the way, tutor price goes up 5% not 8%) this spreadsheet to to calculate profit(and loss) from drop volley. I just did a comparison yesterday and it's very accurate. I was only off $5 million at a $2 billion profit. I think I may tweak the profit formula a little bit. Instead of 1.5809%, I might try it at 1.58%