[Morionic]

A Grimy Bunyip's Reference Spreadsheets

NEW INCOME, DUNGEONEERING, AND DPS SPREADSHEETS!!
Income/Inputs
Melee DPS Calculator
Melee DPS Input
Ranged DPS Calculator
Ranged DPS Input
Dungeoneering
Dungeoneering Input

Instructions:
click Edit This Page.
change the value to the desired income.
Then save the spreadsheet.
Your income, and all its relevant efficiency values will now be viewable in the other spreadsheets.
The same logic applies to the DPS calculator and the relevant DPS Input spreadsheets

it may take a minute or so, after you save, for the changes to take effect.



Skill Spreadsheets
Construction
Crafting
Farming
Firemaking
Fletching
Herblore
Magic
Prayer
Smithing
Summoning

Other Spreadsheets
Daily Profits
Data Log
GE Price Tracker
Sample Spreadsheet Coding

Incomplete Spreadsheets
Cooking
Slayer
Runecrafting

Instructions and Details

Tick - # of game ticks required perform an individual action

Inv - The set number of actions you perform before you are interrupted by a "Bank" action.
Example: if you smelt gold ores at a furnace, you will have an inventory of 28 gold ores

Bank - Time, in seconds, it takes to bank, click make-x, or any other actions needed in between inventories
Example: the time it takes to run back to the bank from the furnace, deposit your gold bars, withdraw gold ores, then run back to the furnace.

GP/XP - Amount of gp spent or earned per xp gained.

750k/1000k/1500k/2000k Columns
Efficiency Ratio at the given incomes per hour

The DPS calculator spreadsheets run under the following assumptions:
Runescape accuracy is determined by a dice roll system.
Attack and Defense Dice rolls are calculated the same way as our max hit.
When Attack and Defense land equal dice rolls, defense wins.
The Attack and Defense accuracy system was not updated to 10x resolution like max hit was.
The equation for max hit is:
Rounddown(10 + (Str Lvl + Style Bonus)*(Prayer Bonus) + (Str Bonus/8) + (Str Lvl + Style Bonus)*(Prayer Bonus)*(Str Bonus)/64)*(Misc Bonus) + Fero Ring)

Where Misc Bonus is bonus from slayer masks, cwars braces, salve amulet, etc.
And Style bonus is the +3 bonus you get from aggressive, or +1 from controlled.

Special Thanks:
Greenblood for helping me start up these spreadsheets early on.
Sseli for his support in the DPS Calculator project.
Neo/DG Elites for providing data for the dungeoneering spreadsheet.

[kamil1210]

Relly god work!
How can I add your Spreadskeets to my 'google account docs? I dont't want copy your work but only get quick link to it

[D Jay99]

Heh and I thought I was efficient. You certainly put quite a lot of work into this, nicely done

Have these spreadsheet so far told you any surprising things about other training methods being more efficient than the methods most people use (like red salamanders > chins or mage logs > yew logs etc) or do they mostly confirm what we already know?

[Morionic]

kamil1210, on 31 December 2009 - 10:00 AM, said:

Relly god work!
How can I add your Spreadskeets to my 'google account docs? I dont't want copy your work but only get quick link to it

you would need to PM me your gmail account and let me add you to "the team"

D Jay99, on 31 December 2009 - 10:12 AM, said:

Heh and I thought I was efficient. You certainly put quite a lot of work into this, nicely done

Have these spreadsheet so far told you any surprising things about other training methods being more efficient than the methods most people use (like red salamanders > chins or mage logs > yew logs etc) or do they mostly confirm what we already know?

The best training methods are always the ones rarely used
Supply and demand, training methods that are well known are bound to be high in supply, low in demand, and typically inefficient.
My rule of thumb is that commonly used training methods are rarely the most efficient.
But revealing too many of these training methods would be bad I'm sure you can figure a few out from my spreadsheets

For example, lets just say that it's good to think outside the "proverbial herb" when training herblore

[rangeor]

There's some very fascinating info in there... now to see if the G.E. will comply with the rates

[mrpadre]

It's kind of cool to know that Torstol makes 40mil gp per hour. Too bad it probably doesn't sell. Very nice spreadsheets.

[mckinzy5]

making mixes takes forever and i usually accidentally drink a dose

[Eyebeam]

I think one value in your herblore spreadsheet is wrong. Look at the special recover potions. Papayas cost 2k, and super energies 4.1k. So the total cost is 6.1k, resulting in a 30gp/xp ratio. Did you forget to imput something?

EDIT: I just relooked at your extreme potions section. I think that you should include the cost of both the herb and the potions while calculating the gp/xp ratio.

[D Jay99]

eyetouch, on 01 January 2010 - 03:22 PM, said:

I think one value in your herblore spreadsheet is wrong. Look at the special recover potions. Papayas cost 2k, and super energies 4.1k. So the total cost is 6.1k, resulting in a 30gp/xp ratio. Did you forget to imput something?

EDIT: I just relooked at your extreme potions section. I think that you should include the cost of both the herb and the potions while calculating the gp/xp ratio.

He basically takes into account the usefulness of the potion, he even gives them the same value as their normal/super counterparts so they're even value'd a little too low. This might not hold true for super antifires (who will ever need a few k antires?)/special restores though, since those aren't as useful as the other extreme potions.

[Morionic]

D Jay99, on 01 January 2010 - 03:48 PM, said:

eyetouch, on 01 January 2010 - 03:22 PM, said:

I think one value in your herblore spreadsheet is wrong. Look at the special recover potions. Papayas cost 2k, and super energies 4.1k. So the total cost is 6.1k, resulting in a 30gp/xp ratio. Did you forget to imput something?

EDIT: I just relooked at your extreme potions section. I think that you should include the cost of both the herb and the potions while calculating the gp/xp ratio.

He basically takes into account the usefulness of the potion, he even gives them the same value as their normal/super counterparts so they're even value'd a little too low. This might not hold true for super antifires (who will ever need a few k antires?)/special restores though, since those aren't as useful as the other extreme potions.

heh lets just say plain super energy potions weren't so damn expensive when i first coded the extreme potions.
Now that prices have changed, that does look a little silly, I'll change it.

Special restore potions have been set to 0 Gp value, as almost nobody uses them, let alone En Masse.
Super Antifires I won't change. They last 6 minutes a dose, roughly the time I would wait before drinking another dose of super/extreme/overload potion.
Super prayer potion prices have been multiplied by 1.25, a rough estimate of how many more prayer points they will restore assuming lvl 70 ish prayer.
I won't tamper with the other extreme potions for a moment.

Normally my spreadsheets take forever to load. However due to other people looking at the spreadsheets, it seems the load times of the spreadsheets has dropped drastically.
Whooo unexpected side effect =D

[mckinzy5]

make rc and mage pl0x

[FinsToTheLeft]

Hey, these are some great spreadsheets, I especially like the smithing one!

Can you tell me what formula you're using in Google Docs to extract a GE price when it ends in K? I've been using Brainymidget's guide to extracting GE prices to try and figure this out, but I still couldn't get it.

Anyway, its clear you've overcome this problem, could you share your formula?

Thanks!
Fins

[Morionic]

FinsToTheLeft, on 01 January 2010 - 11:55 PM, said:

Hey, these are some great spreadsheets, I especially like the smithing one!

Can you tell me what formula you're using in Google Docs to extract a GE price when it ends in K? I've been using Brainymidget's guide to extracting GE prices to try and figure this out, but I still couldn't get it.

Anyway, its clear you've overcome this problem, could you share your formula?

Thanks!
Fins

how i collect more than 50 item prices in a single spreadsheet:

Quote

=Index(ImportHtml(Concat("http://services.runescape.com/m=itemdb_rs/results.ws?query=",[ITEM NAME/DESCRIPTION]), "table", 2),,)

how to remove K's and M's from data:
Substitute(Substitute([Input], ".",""),"k","00")
similar logic same applies for M's

edit: i recently modified the above equation ^^^

Lets say i use that equation on the value 12.9k gp
It changes the 12.9k number into a 129"00"
note the parenthesis. When performing math on 129"00", it will perform the math properly
129"00"+1 = 12901 (note the parenthesis are removed)
129"00"*2 = 25800 (note the parenthesis are removed)

i believe the equation still treats the "00" as text rather than a number
But addition, multiplication, and other simple math operators convert the strings into numbers beforehand

HOWEVER this does not seem to apply to all functions

for example

Max(129"00",130) will yield 130, not 12900. It will claim 130 to be greater than 129"00"
SO my equation has since been modified to:

Quote

RoundDown(Substitute(Substitute(Substitute([Input], ".",""),"k","00"),"m","00000")*1.000001,0)

the multiplication by 1.000001 removes the "parenthesis", essentially converting the entire entry into a pure number. Round down negates any effects caused by the 1.000001
I will use this function from now on, but It will be a while until i convert all my equations into what i need
I will also be using the Transpose() function to spiff up my spreadsheets and make them a little more compact
once again, alot of work ahead of me

Magic spreadsheet will be under way.
Rc spreadsheet seems a little pointless for me right now, but sure I'll make one eventually. I have other spreadsheets i'd much rather make though

[FinsToTheLeft]

Thanks, that helps greatly!


One question regarding your herblore chart, for potions using coconut milk, is that included in the formula? I didn't see vials of coconut milk in the data pulled from the GE.

Thanks, Fins


Edit: Another question, do you take into account time to get SC hammers in your smithing spreadsheet? I couldn't tell.

[Morionic]

FinsToTheLeft, on 03 January 2010 - 10:42 PM, said:

Thanks, that helps greatly!


One question regarding your herblore chart, for potions using coconut milk, is that included in the formula? I didn't see vials of coconut milk in the data pulled from the GE.

Thanks, Fins


Edit: Another question, do you take into account time to get SC hammers in your smithing spreadsheet? I couldn't tell.

yes, i assume that 720 seconds are needed per SC tool, but i can modify that at any time
I recently actually found an error with my SC tool calculations, was missing a 2 in my equations >_< lol
as for the coconut milk, good call, I'll fix that right now

[FinsToTheLeft]

Morionic, on 04 January 2010 - 03:51 AM, said:

FinsToTheLeft, on 03 January 2010 - 10:42 PM, said:

Thanks, that helps greatly!


One question regarding your herblore chart, for potions using coconut milk, is that included in the formula? I didn't see vials of coconut milk in the data pulled from the GE.

Thanks, Fins


Edit: Another question, do you take into account time to get SC hammers in your smithing spreadsheet? I couldn't tell.

yes, i assume that 720 seconds are needed per SC tool, but i can modify that at any time
I recently actually found an error with my SC tool calculations, was missing a 2 in my equations >_< lol
as for the coconut milk, good call, I'll fix that right now

720 seconds is 12 minutes per Proto-tool. An SC game takes 20 minutes, plus about 3 minutes between games, and you can get a maximum of 26 points (but more likely you'll get 20-23). So figuring that it takes about one minute to get one SC point, you'll need more like 1200 seconds to get an SC tool.

[Morionic]

FinsToTheLeft, on 04 January 2010 - 06:50 AM, said:

720 seconds is 12 minutes per Proto-tool. An SC game takes 20 minutes, plus about 3 minutes between games, and you can get a maximum of 26 points (but more likely you'll get 20-23). So figuring that it takes about one minute to get one SC point, you'll need more like 1200 seconds to get an SC tool.

unless you use a SC clan chat

[qeltar]

These seem like very useful resource sheets (though it's tough to see everything without the formulas.)

I should warn you, though, that I am pretty sure the method you are using to grab large numbers of GE prices at once is against Jagex's terms of service.

[mckinzy5]

d hide bodies with sc tools is off as the "spd" number for all of them is "?"

[Morionic]

qeltar, on 04 January 2010 - 07:58 PM, said:

These seem like very useful resource sheets (though it's tough to see everything without the formulas.)

I should warn you, though, that I am pretty sure the method you are using to grab large numbers of GE prices at once is against Jagex's terms of service.

o.O sounds scary
I'll take a closer look at the terms of service.
I'm using almost exactly the same formula as Brainymidgets though Literally the only change I made was to remove a single digit "2" from it.
Is his formula breaking the rules too? Or is the simple fact that i am extracting too many numbers at once against the rules?

mckinzy5, on 04 January 2010 - 08:37 PM, said:

d hide bodies with sc tools is off as the "spd" number for all of them is "?"

because i dont know what the speed of making dhide bodies with sc tools is right now
I'd rather put a "?" there and do research later than put up an incorrect value