Jump to content

[Tool] Ranged Tank Calculator


Rock Hard

Recommended Posts

Just a veeery quick spreadsheet I made to help tanks plan their melee stats on the fly...

 

Might save someone else a few mins

 

https://docs.google.com/spreadsheet/ccc?key=0AnfAiF9hFm9udFJhMFFidUFiek1IZE1td2tESFppZlE#gid=0

 

 

 

Could anybody tell me the combat equation? Trying to make a quick calc for tanks to tell us the max [ATT+STR] they can get at any given combat/range level and still stay range based?

 

I know you can fiddle with normal combat calcs to work it out but i'm lazy and feel like making a tool :P

 

'Rock Hard' boss pure - 60/60 Attack | 99/99 Range | 1/1 Defence | 44/44 Prayer | 99/99 Strength | 99/99 Mage - level 79 combat EOC

 

## '07 Server ## "Best Runescape update ever: Removing 6 years of updates."

 

Rock_Hard.png

 

"Warning: If you are reading this then this warning is for you. Every word you read of this useless fine print is another second off your life. Don't you have other things to do? Is your life so empty that you honestly can't think of a better way to spend these moments? Or are you so impressed with authority that you give respect and credence to all that claim it? Do you read everything you're supposed to read? Do you think every thing you're supposed to think? Buy what you're told to want? Get out of your apartment. Meet a member of the opposite sex. Stop the excessive shopping and masturbation. Quit your job. Start a fight. Prove you're alive. If you don't claim your humanity you will become a statistic. You have been warned- Tyler"

Link to comment
Share on other sites

 

Thanks, I googled straight after I made the post and found it. Duh :P

 

http://forum.tip.it/topic/199687-runescape-formulas-revealed/ is interesting too.

'Rock Hard' boss pure - 60/60 Attack | 99/99 Range | 1/1 Defence | 44/44 Prayer | 99/99 Strength | 99/99 Mage - level 79 combat EOC

 

## '07 Server ## "Best Runescape update ever: Removing 6 years of updates."

 

Rock_Hard.png

 

"Warning: If you are reading this then this warning is for you. Every word you read of this useless fine print is another second off your life. Don't you have other things to do? Is your life so empty that you honestly can't think of a better way to spend these moments? Or are you so impressed with authority that you give respect and credence to all that claim it? Do you read everything you're supposed to read? Do you think every thing you're supposed to think? Buy what you're told to want? Get out of your apartment. Meet a member of the opposite sex. Stop the excessive shopping and masturbation. Quit your job. Start a fight. Prove you're alive. If you don't claim your humanity you will become a statistic. You have been warned- Tyler"

Link to comment
Share on other sites

You probably will want to set a protect range on all cells except Ranged level, because otherwise people can edit or delete your other cells. Select all cells you want to protect, right click, and click "Name and Protect range".

 

Also for the levels you'll probably want to round down. So do =FLOOR(formula, 1)

  • Like 1
Link to comment
Share on other sites

Thanks I didn't know you could do that :thumbup:

'Rock Hard' boss pure - 60/60 Attack | 99/99 Range | 1/1 Defence | 44/44 Prayer | 99/99 Strength | 99/99 Mage - level 79 combat EOC

 

## '07 Server ## "Best Runescape update ever: Removing 6 years of updates."

 

Rock_Hard.png

 

"Warning: If you are reading this then this warning is for you. Every word you read of this useless fine print is another second off your life. Don't you have other things to do? Is your life so empty that you honestly can't think of a better way to spend these moments? Or are you so impressed with authority that you give respect and credence to all that claim it? Do you read everything you're supposed to read? Do you think every thing you're supposed to think? Buy what you're told to want? Get out of your apartment. Meet a member of the opposite sex. Stop the excessive shopping and masturbation. Quit your job. Start a fight. Prove you're alive. If you don't claim your humanity you will become a statistic. You have been warned- Tyler"

Link to comment
Share on other sites

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.