A truly marvellous upgrade calculator - Ragnarok Online Community Chat - WarpPortal Community Forums

Jump to content


Photo
- - - - -

A truly marvellous upgrade calculator


  • This topic is locked This topic is locked
63 replies to this topic

#1 Mathspy

Mathspy

    Awarded #1 Troll

  • Members
  • 542 posts
  • LocationWonderland
  • Playing:Ragnarok Online

Posted 16 September 2016 - 10:50 PM

Since the hot topic of the forums for the past few days was the new upgrade event and the finally revealed upgrade rates it was time for a new calculator to continue Azzy's legacy
I used to use this calculator whenever I thought of buying/upgrading any item (thanks Azzy <3) but since the rates revealed are quite different from the ones the community have reached with play testing, which Azzy used (namely +6~+9 with Enriched rates) I decided to make a new updated one and include in it some features that some people would appreciate (Mainly working up to +20 instead of +7)
 
Special thanks to my good friend Mike for originally hosting the calculator on crmindexer for over a year <3
https://mathspy.me/iroupgradecalc/
 
DISCLAIMER: Averages.Everything this calculator calculates is pure averages and it compares average vs average to acquire the "better" way of upgrading. You might think "I will always use +7 Certs from 4 to 7 I don't want to lose my item lol" NO. It's okay to lose your item specially if, for example, its price is 3M. You're going to need at LEAST 3 certs which cost each 7M resulting in you needing AT least 21M instead of breaking few 3M items while using ~2.2M Enriched Ores
 
Now the calculator might seem a little more complex than the previous one but it does the same function just includes a little bit more into it, here is a quick how-to-use: (Jump if the calculator seem to already be self-explanatory)
  • Select server if you're not on Chaos (Server should be cached for you after first selection)
  • Fill up all the fields with what YOU consider to be the ore values (whether Elunium or Oridecon depends on what you're upgrading) [if you farm for instance Elunium and you have a storage filled with a million Elunium you're too lazy to sell, then Elunium should efficiently cost NOTHING to you] Alternatively you can keep the Ragi.al button checked and the prices will be auto-imported from Ragi.al
  • In case you are buying Enriched/HD and just want to input the value of KP you're buy with, do that! And you can even use the value of 100 boxes for the HDs, for Enriched its defaulted to value of 50 box (don't buy the 10 boxes or the 5 boxes... they are a scam)
  • Fill up the fields with the certificate/bsb prices (+7 for the specific item type you're going to be upgrading and the general +10 and Blacksmith's Blessing) Alternatively you can keep the Ragi.al button checked and the prices will be auto-imported from Ragi.al
  • The current price of the item, again TO YOU, meaning if you are attempting to upgrade an RTE that's already slotted with 3 Hunter Fly cards, type down the whole value (Value of the RTE + 3 × Value of Hunter Fly card) [If it's an item you farm and lazy to sell and you have hundreds of it should also efficiently have no value]
  • Next, pick the item type from the type dropdown menu, and if it's a level3 weapon you check that one too (otherwise it will be considered a level4 weapon)
  • If the item is a weapon and you have/had a Mastersmith (Must be Job level 70 and with level 10 Upgrade Weapon) for upgrading check that box
  • The next box is for the next week event (I called it special event: I am VERY creative.) which increases the rate for refining with Enriched and changes the rates for refining with HD Brad/Carn, check that box if the event is currently running or if you just want to see how will the prices look like with the event around.
  • If you're planning to use Enriched Hammer (AKA you don't mind waiting Enriched H. OR Enriched H. is already around) check that box. If MRS. Hammer is around AND/OR Generous Hammer check the small box to the right to nullify the zeny cost of upgrading with either of them
  • Finally the calculator support you giving it the current refinement level whether the item +9 and you are trying to find the best way to +10 or a just-brought item at +0 [If you have a +9 item that costs 600M that you want to +10 in the value step write 600M and in this step write 9]
tl;dr, using average market prices
  • Fill up the current price of KP in the smol box
  • Your item's price
  • Pick type of the item and whether events are on or if you have Weapon Upgrade 10 (J70 in past life or current)
  • Your item's current refine
  • Good luck upgrading and reading is fun by the way you are missing out on a LOT
The calculator is in no way a final product and I will be upgrading it with your suggestions or if anything new pops up related to upgrading (Looking at you Blacksmith's Blessing)
Please do spam me with your suggestions and/or bug reports and/or questions
 
Thanks for reading and enjoy upgrading!
 
 
Version history:
Spoiler

Edited by Mathspy, 09 February 2018 - 06:54 AM.

  • 11

#2 xsefiroth

xsefiroth

    Amateur Blogger

  • Members
  • 157 posts
  • LocationTH
  • Playing:Ragnarok Online
  • Server:Chaos

Posted 17 September 2016 - 12:45 AM

welldone :p_smile:


  • 0

#3 Nirvanna21

Nirvanna21

    They pay me to post.

  • Members
  • 9553 posts
  • LocationNew Zealand
  • Playing:Ragnarok Online
  • Server:Chaos

Posted 17 September 2016 - 01:11 AM

Good job :D


  • 0

#4 Mathspy

Mathspy

    Awarded #1 Troll

  • Members
  • 542 posts
  • LocationWonderland
  • Playing:Ragnarok Online

Posted 17 September 2016 - 04:02 AM

Thanks guys :3


  • 0

#5 KamiKali

KamiKali

    They pay me to post.

  • Members
  • 5143 posts
  • Playing:Nothing

Posted 17 September 2016 - 08:00 AM

The one on choobs is better.
  • 1

#6 Schitter

Schitter

    Too Legit To Quit

  • Members
  • 1071 posts
  • LocationSwitzerland
  • Playing:Ragnarok Online
  • Server:Valkyrie

Posted 17 September 2016 - 08:06 AM

naw don be sow ichy :(

Good job Mathspy :)


  • 0

#7 Mathspy

Mathspy

    Awarded #1 Troll

  • Members
  • 542 posts
  • LocationWonderland
  • Playing:Ragnarok Online

Posted 17 September 2016 - 08:58 AM

The one on choobs is better.

So I played with the Choobs' one for a while (I didn't know it existed) and I have yet to understand how you're comparing mine to hers... I mean mine is pre-configured with rates according to what Camp revealed past few days and its role is to find for you the best route to getting from +x to +10

Meanwhile I see Choobs' as more of an experimental calculator which if you use several times with different inputs you can come to the conclusion of which route will be best for you

 

naw don be sow ichy :(

Good job Mathspy :)

Thank you ^^


  • 3

#8 Kusanagisama

Kusanagisama

    Too Legit To Quit

  • Members
  • 4243 posts
  • Playing:Ragnarok Online
  • Server:Chaos

Posted 17 September 2016 - 02:01 PM

Best calculator ever! Grats, guys!


  • 0

#9 WarlockFier

WarlockFier

    Too Legit To Quit

  • Members
  • 3395 posts
  • Playing:Nothing
  • Server:Silph Road

Posted 17 September 2016 - 02:08 PM

Thank you and Mike for all your effort to the community. :)


  • 0

#10 PervySageMarty

PervySageMarty

    Too Legit To Quit

  • Members
  • 3956 posts
  • LocationUnderground like a wild potato
  • Playing:Ragnarok Online
  • Server:Chaos

Posted 17 September 2016 - 02:36 PM

I dont think I would use this, I hate looking at percentages, I just think its either gonna work or it wont.

 

Lovely work though, its a good spreadsheet!


  • 0

#11 Nirvanna21

Nirvanna21

    They pay me to post.

  • Members
  • 9553 posts
  • LocationNew Zealand
  • Playing:Ragnarok Online
  • Server:Chaos

Posted 17 September 2016 - 06:04 PM

Thank you and Mike for all your effort to the community. :)

 

I only hosted this, Mathspy did the work.


  • 0

#12 Mathspy

Mathspy

    Awarded #1 Troll

  • Members
  • 542 posts
  • LocationWonderland
  • Playing:Ragnarok Online

Posted 17 September 2016 - 10:56 PM

Best calculator ever! Grats, guys!

Thank you :3

 

Thank you and Mike for all your effort to the community. :)

You're welcome :>

 

I dont think I would use this, I hate looking at percentages, I just think its either gonna work or it wont.

 

Lovely work though, its a good spreadsheet!

There are actually no percentages, you just type in the values and then it will tell you how much zeny you will averagely need to get to +x and how many items you will averagely need to get there as well as "the best route" to get there


  • 0

#13 fuyukikun

fuyukikun

    Disney Prince in Disguise

  • Members
  • 12269 posts
  • LocationIndonesia
  • Playing:Ragnarok Online
  • Server:Chaos, on hiatus

Posted 18 September 2016 - 03:42 AM

always amazed to people who are willing to contribute to community by spending countless hours. some are thankless jobs, and some only received thanks as "reward".
  • 6

#14 ShinobiEX3

ShinobiEX3

    They pay me to post.

  • Members
  • 6862 posts
  • LocationForest
  • Playing:Ragnarok Online

Posted 18 September 2016 - 07:06 AM

I actually like this one over choobs honestly thanks for letting me tinker with this baby mike and mathspy.

 

^.^ now if you ca get the digits for +10 to 20 up and going it would be a blast ^.^


  • 0

#15 Mathspy

Mathspy

    Awarded #1 Troll

  • Members
  • 542 posts
  • LocationWonderland
  • Playing:Ragnarok Online

Posted 18 September 2016 - 07:14 AM

I actually like this one over choobs honestly thanks for letting me tinker with this baby mike and mathspy.

 

^.^ now if you ca get the digits for +10 to 20 up and going it would be a blast ^.^

I actually can add that in 15 minutes tops but thought that it's too easy so people won't need it XD

 

But I mean why not! Will make the price for full item appear with no effort so when you're buying a +12 (or +20 after next week /cough) off another person you know how much money you are actually "wasting" above average


  • 0

#16 ShinobiEX3

ShinobiEX3

    They pay me to post.

  • Members
  • 6862 posts
  • LocationForest
  • Playing:Ragnarok Online

Posted 18 September 2016 - 07:19 AM

sweet Awesome ^.^


  • 0

#17 Shomaye

Shomaye

    Amateur Blogger

  • Members
  • 321 posts
  • Playing:Ragnarok Online
  • Server:Gorilla Poker

Posted 18 September 2016 - 04:10 PM

I like that this recommends the cheapest option without having to guess and check.  That's the only reason to use a calc, really.


  • 0

#18 Mathspy

Mathspy

    Awarded #1 Troll

  • Members
  • 542 posts
  • LocationWonderland
  • Playing:Ragnarok Online

Posted 18 September 2016 - 09:24 PM

I like that this recommends the cheapest option without having to guess and check.  That's the only reason to use a calc, really.

Glad you do!

 

You could also use it when buying an already +9'd item to see how much money you would have saved (averagely) if you bought it +0 and refined it yourself :3


  • 0

#19 Mathspy

Mathspy

    Awarded #1 Troll

  • Members
  • 542 posts
  • LocationWonderland
  • Playing:Ragnarok Online

Posted 19 September 2016 - 12:41 AM

sweet Awesome ^.^

Updated! Now it works up to +20 and from +11~+20 the prices are in a more compact table because otherwise it took too much scrolling and didn't look exactly neat

 

To use the refine rates for next week's event "Special event" should be checked

 

 

Side questions:

1) Does upgrading with HD Brad/Carn need 100,000z per attempt? (Just making sure)

2) If Generous Hammer is around does it affect HD Brad/Carn or only HD Elu/Ori?


  • 1

#20 ShinobiEX3

ShinobiEX3

    They pay me to post.

  • Members
  • 6862 posts
  • LocationForest
  • Playing:Ragnarok Online

Posted 19 September 2016 - 03:33 AM

Updated! Now it works up to +20 and from +11~+20 the prices are in a more compact table because otherwise it took too much scrolling and didn't look exactly neat

 

To use the refine rates for next week's event "Special event" should be checked

 

 

Side questions:

1) Does upgrading with HD Brad/Carn need 100,000z per attempt? (Just making sure) Yes

2) If Generous Hammer is around does it affect HD Brad/Carn or only HD Elu/Ori?  Affects the Brad/Cran as well

 


Edited by ShinobiEX3, 19 September 2016 - 03:34 AM.

  • 1

#21 Saralen

Saralen

    Awarded #1 Troll

  • Members
  • 583 posts
  • Location...
  • Playing:Ragnarok Online
  • Server:Renewal

Posted 19 September 2016 - 05:00 PM


You did a good job, Math. I'm sure it will come in handy when the refine events come.


Edited by Oda, 22 September 2016 - 07:51 AM.

  • 3

#22 Lilp

Lilp

    Awarded #1 Troll

  • Members
  • 542 posts
  • Playing:Ragnarok Online
  • Server:Loki Classic Server

Posted 19 September 2016 - 05:14 PM

Good stuff.


  • 0

#23 Mathspy

Mathspy

    Awarded #1 Troll

  • Members
  • 542 posts
  • LocationWonderland
  • Playing:Ragnarok Online

Posted 19 September 2016 - 11:04 PM

Thanks everybody <3 A LOT ;u;


  • 0

#24 fuyukikun

fuyukikun

    Disney Prince in Disguise

  • Members
  • 12269 posts
  • LocationIndonesia
  • Playing:Ragnarok Online
  • Server:Chaos, on hiatus

Posted 19 September 2016 - 11:32 PM

now i have faith and able to estimate how many zeny i should spend to make my things to go over +12 in first time of my life. Thanks mathspy


  • 0

#25 Mathspy

Mathspy

    Awarded #1 Troll

  • Members
  • 542 posts
  • LocationWonderland
  • Playing:Ragnarok Online

Posted 19 September 2016 - 11:40 PM

now i have faith and able to estimate how many zeny i should spend to make my things to go over +12 in first time of my life. Thanks mathspy

I am really glad to hear that <3

 

Here is my advice though just so you wouldn't feel disappointed

If you try 10 or so items, you will averagely feel unlucky in like 5 and lucky in 5. It's how "luck" truly works out, it's like Akupuff once said a "limited" resource. So don't be disheartened if even your first 8 items are really unlucky because in another day all your items will be lucky and at the VERY end of the run you'll truly have only used "averages"


  • 1




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users