How to calc TUT volley in Excel

Discussion in 'Strategy' started by CyborgHarpy, Nov 28, 2013.

  1. Hi all, I had always wondered how much actual profit is made when volleying so I made a simple spreadsheet in Excel. Here is how I did it but it can be done other ways.
    First, make sure your rows and columns are big enough to fit the numbers you'll be seeing. I made my rows and columns both 20. Next, I selected the top 4 rows(1-4) all the way to the "Z" column, right clicked, selected the "format cells" then set them to "currency" and put borders around them all.
    Now we are ready for the formulas. I used the second row in the first column(A2) as my starting value. I wanted to see 4 things, the tutor price increase after each hire, the total new tutor price (old price price increase), the individual profit from each hire, and total profit from hire (original purchased price profit). So, here is how I set them up: the top row (row 1) is the price increase after the tutor is hired. We know that the tutor price increases approx. 5% after each hire, so the formula for the first row is: hire price times 5%, my formula was =A2*.05 (my starting value is in the A2 cell). Next, I want to know the total new tutor hire price (original hire price 5%) so I put that value in the next row (row2). The formula I used for this was: A2*.05 A2 (this gave me my new tutor hire price). Third, I want to know my profit from my tutor being hired. We know that we make approx. 1.5809% profit, so I made the 4th row display the individual profit from each hire. The formula I used for the was: A2*.015809. Lastly, I set my third row to display the total profit (my original purchase price profit) the formula I used for this row was: A2*.015809 A2. If you have done it right, it would look like this: in cell A2, you enter a value (this could be the original price you payed for a tutor) let's say you hired a tutor for $100,000,000. In the cell B1, it should display $5,000,000 (this is the price increase from the hiring of the tutor). In cell B2, it should display $105,000,000 (this is the new tutor hire price). In the cell B3, it should display $101,580,900 (this is the total you will get back from your tutor being hired away). Finally, in the cell B4, it should display $1,580,900 (this is your actual profit from the tutor being hired away) now, all you need to do is copy and paste each of these cells along their rows (example copy cell B1 paste into C1) the formulas will adjust to the proper cell. I copied until column Y to leave cells to total the amounts. For column Z, I just used the "autosum" to total all of the cells in each row. All we are really interested in are totals for row 1 (total tutor price increase) and row 4 (total profit). The values won't be EXACTLY the same but it will be close enough for an estimation. Now, if you want to know how much profit you make when volleying a tutor from $1billion to $2billion (or whatever) this will help. If you want to know how much profit you get from longer volleys, you'll need to total the sums and add them up (you can do that by hand if you want) just remember to copy the last value in row 2 and put that number in the first cell in the same row (make sure you paste just the value and not the formula). I hope this makes sense. Happy Volleying!
     
  2. Nice work!
     
  3. Pictures would've done better.
     
  4. Ooohhh god  didn't read it all.. but appreciate the effort you put on making this 
     
  5. I'll add pics some time if it helps
     
  6. Or the actual Excel file if you wish.
     
  7. My head hurts now
     
  8. I typed this up on my phone so it's a little messy
     
  9. Sorry, that's a little big
     
  10. If you can combine it with tut prices as well that would be great
     
  11. Not sure what you mean. The new tutor price will be in the second row. Do you mean optimal tutor price for stats? That's already been explained by many others.
     
  12. Lotta math for a game lol. I think i need an accountant
     
  13. Not sure why the first one didn't resize but you can see the formulas I used for each cell and the general format. Just copy and paste these cells all along each column as far as you want to go (I went to Y) then when you're satisfied that you've got enough "volleys", click in the next cell in rows 1 and 4 (top and bottom rows) and click "autosum" to get the totals.
     
  14. That 3rd pic formula should be: =A2*0.015809 A2
     
  15. Biff mansuch an awesome tutor Helping the community and never asks me for dvs unlike all your HSH friends Great thread bud.
     
  16. Lol thanks Alan