Metal Dragon Profit Calculator (V 1.1 NOW OUT!)

Need Requests for New Calculators to Make!

Feedback is appreciated- and without it, i wouldn't have made V1.1

Thank you for pointing out some big problems with the Calculator, it should be completely operational now!

This Calculator uses Excel to Calculate the Monster Drops, So if you don't have Excel, seek for a possible Trial here

Metal Dragon Calculator Version 1.0

Metal Dragon Calculator Version 1.1

[hide=Reademe (included in pack)]

100kill and 1000kill Metal dragon profit calculators are made by Hatebringer,

and should not be distributed, unless it is in the original .rar package.

Original download site:

Created December 02, 2007

Files included should be as follows:

100kill Metal dragon profit calculator-MadebyHatebringer excel spreadsheet

1000kill Metal dragon profit calculator-MadebyHatebringer excel spreadsheet

Readme.txt file

How to use

________________________________________________________

First, you should set up, and get ready to kill some metal dragons.

Remeber that this calculator only works using Magic slaying, although it can

be used to simply track your kills, although it will not subtract any costs

used, like prayer pots or super sets, but does track anti fires used, and runes

spent added into calculation.

Now, to use the calculator, locate the TYPE heading, and type in what kind of dragon

you are killing, then after killing, type in the drop you recieve in the DROP

catergory. After this, locate the AMOUNT catergory directly to the left of the

drop, and enter how many you recieved. This is more so for the multiples (bolts,

runes etc.) but for the calculations to be complete, you must enter how many

for everything you get. So for example, if you get a Draconic Visage, you would

put a 1 in the amount column, and for runes, like bloods, you would put exactly

how many you recieved.

Here is a small example

# | Type | Drop | Amount | Value of Drop |

__________________________________________

12 iron coins 3000 3000

It is very important to not enter anything into the "Value of Drop" column, as this

will mess up the calculations. I have locked the cells in this column for this

reason.

After you have killed how every many dragons you wish, head to the very bottom of the

spreadsheet. There you will find a small section that is for the amount of chaos

or death runes you used. enter the numbers in, and place a 0 if you used none

of the shown runes.

There is also a section for you to add how many Antifire doses you used.

Be careful that this is made for the doses used, not actual pots, because some people

may use 4 dose pots, and others may use 3 dose pots.

After that, its pretty easy. Your profit will be shown on the bottom section

and you can gloat how much money you made in a trip

=)

VERSION HISTORY

________________________________________________________

V 1.0

Original Version. Most basic of the current Versions.

V 1.1

-In version 1.0, There was a major bug where the calculator in the 1000 kill log

was not calculating past Row 103, and was simply due to a missing 0 in the equation.

-Another change was made to the bottom of the 1000 log to make it more similar to its

counterpart 100 log.

-Changes were made to the Total drop sheet to make pictures blend with background.

-Added (small) comments to the dragons on the Total Drop sheet.

-Added a link to Tip.it/Runescape thread about the calculators. So you can easily check for

newer versions if available.

-Slightly widened some columns as some data was getting out of the cells, and blending with other cells

which could get in the way.

F.A.Q

_________________________________________________________

1. I can't type anythign in a particular cell. How come?

A. Some cells are made so you cannot change the formulas. if you are experienced

enough will excel to know what you are doing, go to Tools>Protection>Un-protect sheet

to allow you to enter information in a cell. Use at your own risk.

2. A cell that should be open is locked! Whats going on?

A. As this is my first version, there may be a few bugs, or changes that can be made

To un-lock, go to Tools>Protection>Un-protect sheet, then click on the cell(s)

that should not be locked, and go to Format>cells, and click on the tab "protection"

Uncheck the box, and then go back to Tools>Protection>protect sheet.

3. X could be better if it was like this.

A. Then Please! tell me about it! I need all the feedback i can get about my calculators

to make them as great as possible.

As well as this, please inform me of any glitches that you may have by Pm'ing me on

Tip.it/runescape. My username, as you guessed, is Hatebringer.

Credits

____________________________________________________________

I'd like to thank Tip.it for the drop list and pictures used in my calculator,

and my Brother for helping me to research prices on the forums, GE, and W2.

Thank you for Downloading, and post you opinions on my thread on tip.it

[/hide]

I've tested it already, and it seems to work just fine.

It included an edit-able price list for every, and all drops, and includes pictures and an entire drop list of everything each type of metal dragon drops.

[hide=Examples of calculator]

here is the main page, where you enter your drops, and how many

Here is a picture showing the updated "total drops" Sheet

[/hide]

Notice that i did not include Bronze dragons into this, as most people only kill the iron and Steel ones, but if people really feel strongly that I should add it in, then i will add in the drops from Bronze dragons as well.

Another note that this calculator is made for only metal dragon slaying using death or chaos rune based killing, although i originally wanted to make a ranging part as well, but the chance of bolts/arrows being picked up, destroyed during combat etc. made a large part for error, and lots more information needed to be entered.

This may be an obvious thing, but for multiples, such as runes and arrows, you must enter the singular form of the drop (i.e. Blood rune) but then enter the amount on the Amount column. It is also necessary to enter the amount of other items besides stackables. So if you received a dragon Plate legs drop, you would need to enter a 1 in the amount column for the equation to go through.

In the .zip file, you will find a 100 dragon log as well as a 1000 dragon log, so if you are just doing a small trip, or going for 99 magic using steels and irons, then you can easily trace your profit/loss and your progress.

A readme is also included in the file if you didn't read all this, or want a slightly more detailed instructions or a F.A.Q

Also, as this is the first version of my calc, there may be bugs or glitches with some calculations, and if you find any, please inform me my Pm'ing me (Hatebringer) on the Tip.it forums.

here is the link for the latest version:

http://rapidshare.com/files/73910556/Me ... n_Calc.zip

Hope you Enjoy :

Nice.. Too bad i don't have Excel nor do many people so you could have atleast added that to your post.

This isn't a guide though, wrong forum.

Nice.. Too bad i don't have/use Excel.

 

 

 

This isn't a guide though, wrong forum.

hm really? where should it go then? I thought it would go either here or general discussion.

EDIT: well its been reported, so hopefully the mods know where it goes.

hm really? where should it go then? I thought it would go either here or general discussion.

Probably this sticky.

Changed a few of the cells that should have been locked, so now it should only allow data to be entered in the cells made for data.

This is actually pretty good. I dont go to the Metal Dragons much, but this would work very good.

I like that you can update the prices :)

Its a ok chart...but then again, if you had a calculator you can find all of this, but very nice indeed

Well V 1.1 is finished, all the glitches in 1.0 are fixed as i can see, So hopefully even more people will use it than V1.0

Some big problems included were in the 1000 kill log which only added up to kill 103, as well as the ending profit section being to far to the right.

Some other small changes were added, and you can read them all in the Reademe included in the calculator, or I now added it into my main post.

Enjoy :

Just got back from vacation, so I will try to change anything I can.

i love these kinds of clalcs

10/10