Found the formula to calculate the upgrade cost with!

AdminShade April 10 2006 3:47 PM EDT

Source file of which I made the calculations: Source CBstuff.nl

I have this data in an excel file (or any other spreadsheet for the open source users among us)

The first thing I did is divided the blacksmith cost of a point by the blacksmith cost of a point before the other, in formula:

Based on blacksmith costs of +1 (2133), +2 (2366) and +3 (2625):

2366 / 2133
2625 / 2366
and so on...

I averaged the outcome of all these calculations and this got me the following number:

Average: 1,109201905
Standard deviation of those points: 5,81533E-05 (0,0000581533)

Then I made a formula which looks like the following:

Y = 2133 * X ^ ( the + of the armor)

in which X = the just calculated average of the divisions

With this I can now calculate any and every single upgrade price of the MCM.
This formula applies to all armors and possibly all weapons also.

I still need to find a way to make a total NW calculation from this, perhaps someone here has an idea on how to do that by using a generic calculation.

in general:

a NW of a MCM +2 is: $37,999

the formula would be ($33,500 + ( 2133 * (1.109202 ^ 1 )) + ( 2133 * (1.109202 ^ 2 ))

and for +3 it would be that + ( 2133 * (1.109202 ^ 3 ))

as you see this formula could get pretty long when being used for a pair of +200 Displacement Boots...

is there an easier way for this?

bartjan April 10 2006 4:04 PM EDT

Déjà vu.

Wasn't it BadAsh that did research on this, and found the very same formulas?

stabilo [Lonesome fighter] April 10 2006 4:37 PM EDT

good work Shade!

AdminShade April 10 2006 4:42 PM EDT

perhaps he did, but I have no record of his formulas.

and yes, i knew badash already had them figured out, but we now have some new items with different formulas.

I want to make an armor calculator just like stump had, but alas i'm not well at making such programs...

stabilo [Lonesome fighter] April 10 2006 4:56 PM EDT

What kind of scripting do you wanna use? perl or php? .. it might be possible to do it with javascript as well ..

stabilo [Lonesome fighter] April 10 2006 5:27 PM EDT

Try this, just copy and paste into somefile.html and open within your browser ;-)

-------- cut --------

<html>
<head>
<script type="text/javascript">
<!--
function getUpgradeCost(base, magic, offset, range) {

        var insert_html = '';
        for( var i = 1; i <= (offset + range); i++)
        {
                base += magic * Math.pow(1.109201905, i);
                if( i >= offset)
                {
                        insert_html += '+' + i + ' ' + (Math.round(base) + 1) + '<br>';
                }
        }
        window._content.document.getElementById("cb-upgrade-list").innerHTML = insert_html;

}
//-->
</script>
</head>
<body>
<form name="Formular" action="">
<input type="button" value="MCM" onclick="getUpgradeCost(33500, 2133, 0, 50)">
<input type="button" value="xxx" onclick="getUpgradeCost(23500, 133, 20, 30)">
<input type="button" value="yyy" onclick="getUpgradeCost(13500, 5133, 0, 100)">
<input type="button" value="zzz" onclick="getUpgradeCost(53500, 3133, 0, 200)">
</form>
<div id="cb-upgrade-list"></div>
</body>
</html>

------------ end cut ----------

BootyGod April 10 2006 5:28 PM EDT

/me applauds bartjan for deflating someone's achievements again. Bravo bartjan =D. lol j/k you know I love ya ;)