pulli23 Posted January 11, 2011 Share Posted January 11, 2011 Well I'm just uploading this file for the general public to use. I wanted to write a full-fledged guide to manage thy kingdom someday, but I don't have the time anymore for that. So apart from this small inpost explanation of the spreadsheet this is provided to anyone "as is". Download mtk2.xls from Host-AMirror Rapidshare (slow + wait time) This is an efficiency calculator for manage thy kingdom. The specific distributions for each material and all special items is all done by personal emperical research - though I can say it is fairly accurate (over 3 years of data).AdvantagesThe advantage of this sheet is that it will "automatically" (or well almost: at click of a button and after waiting like 10 seconds) update all prices from the ge. So it will never get outdated (though as it is an offline tool, be sure to update it yourself before withdrawing items from mtk). It calculates the average daily profit you will make, with a given number of days between "topping up" your kingdom. The drawback of this is that it works with macros (as macros are needed to open a query with the runescape server and request the data). So to use it fully you'll have to enable macros (at least for this file). Furthermore it can also "exactly" calculate the profit you will make when withdrawing after an "X" amount of days. - It takes into account that "X" isn't always a multitude of the days between popping up your kingdom, and also rounds (down) the number of specials/items you get. UsageWhen using macros the only thing one has to edit the "main" tab.. And only the light blue fields. (And click the "update" button regularly).When not using macros, you have to input the prices from the ge manually: this should be done in the "values" tab.That's all there is to use it, I think most cells are self explanatory. Take your advantage with it,pulli23 First they came to fishingand I didn't speak out because I wasn't fishing Then they came to the yewsand I didn't speak out because I didn't cut yews Then they came for the oresand I didn't speak out because I didn't collect ores Then they came for meand there was no one left to speak out for me. Link to comment Share on other sites More sharing options...
Atom Smash40 Posted January 12, 2011 Share Posted January 12, 2011 Interesting, rep up Will definitely use once I get situated again and start using MTK as a viable source of income. ~ 3,072nd to 99 Mining on August 30th, 2009 ~~ 112,084th to 99 Magic on April 16th, 2011 ~~ 131,681st to 99 Crafting on March 29, 2019 ~~ 178,385th to 99 Prayer on April 2, 2019 ~~ 234,921st to 99 Defence on May 9, 2019 ~~ 173,480th to 99 Herblore on June 21, 2019 ~~ 155,160th to 99 Smithing on July 16, 2019 ~ Link to comment Share on other sites More sharing options...
brainymidget Posted January 20, 2011 Share Posted January 20, 2011 Very nice, I was working on one of these a while back but never finished it. I gathered a lot of information on nests but never got the calculator part done.If you want any of the info, I have it all in a Google Docs spreadsheet. https://spreadsheets.google.com/pub?key=0As3LX0otza6IclVoWDNCNDNTc2NmODlQUWJDczhlaXc&hl=en&output=htmlAll of the prices are auto-updated every hour. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now