Manage thy kingdom: maximizing profit!

Manage thy kingdom

Well this is one of these things I spent quite some time on researching.. I'm not a good guide writer, so please excuse me if something is a bit difficult (I;ll gladly explain it more).

This guide is simply about what the title says: maximizing profits from the ge. Easy enough, or not?

unlike those 1000's of other guides about money making I made this guide especially to be dynamic: runescape is a dynamic environment and the best profitable thing can change to the biggest money drain ina couple of days.

So what I made was an excel sheet:

mtk.zip

mtk.zip

As usual it's a zip file containing an excel sheet..

The important (only 1 for now) is the "main" tab.

In the other tab ("inputprices") you can change the blue fields so they reflect the prices at the ge better. (currently it's the avarage from 20 days at 29-07-08).

Let me quickly explain all important cells:

Generally everything is color coded: light blue fields are fields you should fill in, light green are fields with the results. (and white are fields with some other "halfway-results"). Text in light gray you should ignore: these are important values used for calculations.

Columns S - Y should be ignored at all: changing these will "crash" the sheet probably (as far as something can crash in excel: it will just throw an "#n/a" error).

B2 "time between upgrading rating": this is the number of days you wait before getting your rating back to 100 again C2 shows the "avarage" rating...

E2 "starting money": just the money you put in the case at the start of a "period". F2 shows the money taken each day

H2 "time between gathering": the time you wait before gathering resources (and putting new money back into the case) H4 shows the "minimal ideal ammount": the minimal amount you need to put into the case if you want your workers to keep worker 100% the whole time

J2 "etceteria done": yes or no - K2 shows the amount of workers you have available

B-F 6 "amount of workers": put here the amount of workers into each category (resp. woodcutting, fishing, flax, rare woods and mining are supported atm). C4 will show the total amount of workers you gave a job.. If it's higher than the amount of workers you have availabe it will show a warning: however the calculations don't have any problem with that.

So far the input.. Lost already - Well just open the sheet and play a bit around with the values, shouldn't be too hard? :P

The rest of the sheet is split into 2 parts.. Which are almost the same but have an important difference between them:

Row 8-46 Shows the "daily" results: this contains all avarage daily results.

Row 47-85 Shows the "total" profit you make during the time period (lets say the period is 7 for now).

-For the explaining I use 10 people on flax and the rest 0, and a "rating upgrade time" of 7 days and a gather period of 14 days, unless of course stated otherwise.- I will call the "daily profits" on top simply "dp" and the "total profit"/number of days (so the real daily profit during the time period) "rp".

As you will notice The total profitis most of the time not "same" (or like 7 times as much) as the daily profit at column 8. This is caused by 2 "rounding errors" in the daily results.

The first is easily explained with above setup: DP = 68449.45238 while the RP = 68415.824

There's a (small) gap of 33 gp. This is caused by a "rounding error" in the number of "specials": when calculating the "DP" I simply take the avarage number of specials you get daily (which is around 2.02 when doing 10 flax).

However when you collect resources you can't get "half a resource" so in this case we would've collected 28.29 specials, but only get 28 of them: losing 0.29 special. This error will always lower the amount of money you get (since runescape always rounds down): you should try to find a value such that you loose as little as possible...

Now if we change the gathering time to 10 days we see something different: "RP" is bigger than "DP"! - This is caused by another error: an error in the rating. "DP" simply takes the avarage rating during a "rating round": which is 0.97. However if you update your rating after 7 days the avarage rating at day 10 is slightly higher: 0.973. "RP" takes this also into account, and hence the profit is larger. This problem only occurs if the rate-upgrade-period doesn't fit into the gathering-period. (which isn't the case for 99.9999% of the people I bet). Also will this error always make you "more" profit, the graph at the tab "rating" shows it pretty good: the average rating will drop till the average calculated for "DP" and then go back up, drop again to "DP's" value - go back etc..

So: why still use "DP"? - Well it's faster + easier to make... But besides that point there's a very specific reason: if you want to compare methods to each other (and say: THIS is the best), you should compare it indepentelly from the gather period etc. - So rounding errors thanks to whole resources this shouldn't be there. So, long story short: Use "DP" if you want to compare methods, use "RP" if you want to guess/plan the real amount of money you will make

Now to explain those 2 parts, they're generally the same:

row 9/48 shows the profit you make: the final results you're looking for

row 11/50 shows the total profit you make in each of the different types (normal and special stuff added together).

row 14/53 shows the amount of money going into each type

row 15/54 shows the money you get when selling the non-special resources

row 16/55 shows the profit from non-special resources. (might be even negative)

row 17/56 shows the amount of non-special resources you gain.

row 18-26/57-65 show all non-special resources you gain.

row 29/68 shows the amount of "specials". - 68 also shows the non-rounded amount

row 30/69 shows the yield (and also profit) from these specials.

row 31-46/70-85 show all special resources you gain.

Well that should show everything you'll ever wanted to know about mtk.. But here some review of the values at 29-07-08

Going for a 7 day rerate period giving each resource 5 workes makes:

woodcutting:  33056.76939

normals:  -6844.919786

  specials:  39901.68917

	fishing:  32645.19979

normals:  30973.08168

  specials:  1672.118105

	   flax:  34224.72619

normals:  32593.75

  specials:  1630.976188

  rare wood:  807.6808491

normals:  -2816.257188

  specials:  3623.938037

	 mining:  27948.12773

normals:  26359.17031

  specials:  1588.957424

So as you can see flax at the moment makes the most money. Closely followed by woodcutting and fishing: My set up would be 10 flax, 5 woodcutting. However with woodcutting you depend a lot on the specials (of which I think I have the rates pretty accuratily). So fishing might also be a good alternative. I haven't tested the fishing randoms yet: but I guessed the average "cascet" yields 300 gp...... If it's much more fishing is better, but if it's less woodcutting is definatily better. - Would be kind if someone can give me some help with the randoms here.

Mining might be an option again if coal hits 210+ for a long time too! (again here the specials are not really good guestimates and help is needed).

I hope anyone can take his advantage with this sheet, have fun making money!

Cool, I personally use woodcuttting @ 100% for seeds and mining at 50% for money back. I seem to break even every time and about a 90k profit per day if I were to sell the seeds.

woodcutting, as in maples?

You do know that maples makes you lose money right... like, 46gp in the G.E. and your kingdom makes them for 56.1gp...

U'd only be able to replace your money and gain a profit more than fishing if you got a magic seed every 2 days. Which never happens...

woodcutting, as in maples?

 

You do know that maples makes you lose money right... like, 46gp in the G.E. and your kingdom makes them for 56.1gp...

 

U'd only be able to replace your money and gain a profit more than fishing if you got a magic seed every 2 days. Which never happens...

Did you download the sheet or even read the last few notes?

Of course woodcutting looses money: but with some extensive research I've done (4 months worth of data with 10 people on woodcutting). I've been able to calculate pretty accurately the rate in which you get seeds... And those make up for a lot! (they earn when putting 5 people on woodcutting around 40K a day, so a loss of 8k daily can be easily "removed").

I Collect every 2:nd day because I don't have the patience to wait any longer.

I have 100% on Maples and 50% on flax.

I put in 150k when i collect and i get back all the money as well as double it (I get around 400k from all seeds, flax, and logs)

I make pretty much money without doing anything.

woodcutting, as in maples?

 

You do know that maples makes you lose money right... like, 46gp in the G.E. and your kingdom makes them for 56.1gp...

 

U'd only be able to replace your money and gain a profit more than fishing if you got a magic seed every 2 days. Which never happens...

 

Did you download the sheet or even read the last few notes?

 

 

 

Of course woodcutting looses money: but with some extensive research I've done (4 months worth of data with 10 people on woodcutting). I've been able to calculate pretty accurately the rate in which you get seeds... And those make up for a lot! (they earn when putting 5 people on woodcutting around 40K a day, so a loss of 8k daily can be easily "removed").

Yes, i read the entire thing. I just don't trust it because i've done my own calculations. ;)

Anyways, i can't open the spread sheet, my winzip evaluation thing ran out.

Fishing does better, because it gets tons of gems and half keys aren't uncommon. Maybe as frequent as magic seeds you get from Maples.

EDIT: Could you make the spreadsheet .rar? :-#

woodcutting, as in maples?

 

You do know that maples makes you lose money right... like, 46gp in the G.E. and your kingdom makes them for 56.1gp...

 

U'd only be able to replace your money and gain a profit more than fishing if you got a magic seed every 2 days. Which never happens...

 

Did you download the sheet or even read the last few notes?

 

 

 

Of course woodcutting looses money: but with some extensive research I've done (4 months worth of data with 10 people on woodcutting). I've been able to calculate pretty accurately the rate in which you get seeds... And those make up for a lot! (they earn when putting 5 people on woodcutting around 40K a day, so a loss of 8k daily can be easily "removed").

 

Yes, i read the entire thing. I just don't trust it because i've done my own calculations. ;)

 

Anyways, i can't open the spread sheet, my winzip evaluation thing ran out.

 

Fishing does better, because it gets tons of gems and half keys aren't uncommon. Maybe as frequent as magic seeds you get from Maples.

 

EDIT: Could you make the spreadsheet .rar? :-#

wow: I was being rude there :shame: .. Sorry just so many times I see people answering to my suggestions/tutorials who obviously not read it that I'm just so easily annoyed.

hmm yeah, you might be right. - Didn't really check everything you could collect with fishing very well.. (from others I heard it was neglectable, so I put an avarage of 300 gp each special).

My own experience (I did a 10flax/5fishing for the last 2 weeks) has been a bit better indeed: I'm currently researching the fishing, expecting results in 2 months.

rarred version

7z-ed version

Anyways: in the columns under priceinput sheet you can change the behaviour: for example change M,N and O row 4 and 5 to:

casket 300 0.5

halfkeyloop 8000 0.05

boot 300 0.2

gloves 250 0.2

clue 0 0.05

and dragging column P down would indeed make fishing better.

I would love to get a better view of the rewards on fishing! (and also mining: make some guesses there too based on very little data/2nd hand information)

It seems the summation for the totals in daily and total aren't set to the correct column. Cell C9 has sum(B11:K11) which doesn't include the data for mining, likewise for cell C48 - sum(B50:K50). Overall I have to say lovely work you've done. :thumbsup:

I'm lost O_O most of the mtk.xml tells me

err:508

@gumby: I made a mistake in my code? - thanks for posting the bug!

@stargazer: I don't get what you're saying (it's not an xml file): the (clickable) link should bring you to a zip file, which contains the excel spreadsheet. (the upload site I use requires files to be compressed to be uploaded)

I put 100% on Maples and 50% on Teak/Mahogany. The seeds will easily make me profit every time.

Manage thy kingdom

 

I haven't tested the fishing randoms yet: but I guessed the average "cascet" yields 300 gp...... If it's much more fishing is better, but if it's less woodcutting is definatily better. - Would be kind if someone can give me some help with the randoms here.

 

Sell the caskets without opening them; currently they're worth about 1900 each

@pulli23, i have retrieved the *.zip but when i opened the *.xml file it shows a mass of err:508

@pulli23, i have retrieved the *.zip but when i opened the *.xml file it shows a mass of err:508

huh, strange, because there should be an .xls (excel spreadsheet) inside the zip not a xml file! Do you have excel/an open source variant (which allows for multi-tabs) installed? - What program you opened it with (and what version: it gives an error -though a different 1 than yours- when trying to open with excel 97 or lower). Btw I tried it myself now: it works good, there are supposedly no external links anywhere in the sheets.

@snertzred: that's a usefull advice.. And at these prices fishing certainly is more profitable, it even "beats" flax!

*starts to wonder who in their right mind buys caskets*