Weapon Reroll Simulator

2

Comments

  • DuNotEat - Sanctuary
    DuNotEat - Sanctuary Posts: 1 Arc User
    edited September 2012
    Please click one of the Quick Reply icons in the posts above to activate Quick Reply.
  • Moranine - Lost City
    Moranine - Lost City Posts: 319 Arc User
    edited September 2012
    I'm about 90% sure that this tool is incorrect. With 20 rerolls I got 2 3x interval, 4 2x interval and 3 x1 interval.

    You might want to check the odds because this has to be way off.
    [SIGPIC][/SIGPIC]
  • Regenbogen - Lost City
    Regenbogen - Lost City Posts: 1,559 Arc User
    edited September 2012
    10th roll: 2x-0.05int max., phys.atk +130

    b:surrender
    i am waiting for you my little flagcarriers b:kiss
  • Nowitsawn - Heavens Tear
    Nowitsawn - Heavens Tear Posts: 4,864 Arc User
    edited September 2012
    I'm about 90% sure that this tool is incorrect. With 20 rerolls I got 2 3x interval, 4 2x interval and 3 x1 interval.

    You might want to check the odds because this has to be way off.

    Zoho's RNG might be to blame here, or you just have ridiculous luck.

    Also, which weapon was it? I'll double check the rates for it.

    After testing 500 rolls on daggers, and with only counting the first line, I got 13 x -0.05 int. I only got 2x -0.05 once. Seems within an acceptable margin to me. So I'd like to know which weapon you were simulating so I can see if there are any faults there.

    If there are none then I'd be willing to bet there are some people that would like their rerolling done by you b:quiet
    [SIGPIC][/SIGPIC]
  • _TENSHl_ - Sanctuary
    _TENSHl_ - Sanctuary Posts: 33 Arc User
    edited September 2012
    http://imageshack.us/photo/my-images/255/dibujoqrl.jpg/

    I know.. the magic sucks.
    I like this toy ty :3
  • Angel_Spawn - Sanctuary
    Angel_Spawn - Sanctuary Posts: 3,034 Arc User
    edited September 2012
    ☆Traceless Dimension (1 Socket(s))
    Claws
    Lv.16
    Attack Rate(Atks/sec) 1.43
    Range 2.50
    Physical Attack 785-1063
    Durability 200/200

    Requisite Lv.100
    Requisite Strength 150
    Requisite Dexterity 188
    HP +350
    Interval Between Hits -0.05 seconds
    Interval Between Hits -0.05 seconds
    Atk. Level +40
    price 144.120

    Rest your tired eyes now,
    For you've all the time you need.
    To ponder the universe's wonders,
    To lay amongst the reeds.


    Rolls: 2
    Essence of Offense 2
    Basic Badge 40



    Daggers also with 3rd roll 2x int and 1 attack level lol, b:shocked
  • MagicEmpress - Lost City
    MagicEmpress - Lost City Posts: 795 Arc User
    edited September 2012
    omg on my 2nd roll for NV 3 sin daggers I got -.05 int +18 vit +18 dex and +40 att lvls

    Now if only in the real game this happens... b:thanks
  • Asterelle - Sanctuary_1381265973
    Asterelle - Sanctuary_1381265973 Posts: 7,881 Arc User
    edited September 2012
    Thanks, but I have no idea what AJAX even is b:chuckle

    What I did basically works like this:

    Every time you press the ''Roll!'' button it generates a random number in the second sheet between 0 and 1 (5 decimals) with the RAND() command.

    Then the cells with the blue stats have a formula that basically works like this:

    If the cell contains a number between 0.00000 and 0.05000, then output is ''Interval Between Hits -0.05 seconds''
    If not, then if the cell contains a number between 0.05000 and 0.15000, then output is ''HP +350'' etc etc.

    It's a b*tch to do manually, but it works. Once I have a single weapon of a certain type (nirvana, r8r, morai...) done it's just a matter of changing numbers around to do the rest.

    I'll just have to figure out how to do the stats for R8R because I'm not making a line for every point of P.def between 150 and 450...

    I just saw the macro code :O
    I hope you have a script that autogenerates that... it looks painful.
    [SIGPIC][/SIGPIC]
    Refining Simulator - aster.ohmydays.net/pw/refiningsimulator.html (don't use IE)
    Genie Calculator - aster.ohmydays.net/pw/geniecalculator.html - (don't use IE)
    Socket Calculator - aster.ohmydays.net/pw/socketcalculator.html
  • MagicEmpress - Lost City
    MagicEmpress - Lost City Posts: 795 Arc User
    edited September 2012
    omg on my 2nd roll for NV 3 sin daggers I got -.05 int +18 vit +18 dex and +40 att lvls

    Now if only in the real game this happens... b:thanks

    And 126 rolls later:

    -0.5
    +30% accuracy
    -0.5
    +40 att lvl

    Wow if I get one -.05 with goods stats I'm keeping it.
    Way too hard to get double interval. b:surrender
  • Quinnie - Heavens Tear
    Quinnie - Heavens Tear Posts: 314 Arc User
    edited September 2012
    20 tries i had 3x -0.05

    21th try -0.05 -0.05 +19 dex ^^ wish it was real


    100 tries gave me 11 x -int lol




    for claws/fist i seem hax o.o b:shocked

    ☆Traceless Dimension (1 Socket(s))
    Claws
    Lv.16
    Attack Rate(Atks/sec) 1.43
    Range 2.50
    Physical Attack 785-1063
    Durability 200/200

    Requisite Lv.100
    Requisite Strength 150
    Requisite Dexterity 188
    Interval Between Hits -0.05 seconds
    Interval Between Hits -0.05 seconds
    Interval Between Hits -0.05 seconds
    Atk. Level +40
    price 144.120

    Rest your tired eyes now,
    For you've all the time you need.
    To ponder the universe's wonders,
    To lay amongst the reeds.

    Rolls: 10


    had also 2x -0.05 and 1x -0.05 -0.05


    wish i had this luck for my own weapons.. but usually i get that luck for others..
    [SIGPIC][/SIGPIC]
  • Nowitsawn - Heavens Tear
    Nowitsawn - Heavens Tear Posts: 4,864 Arc User
    edited September 2012
    I just saw the macro code :O
    I hope you have a script that autogenerates that... it looks painful.

    If you look at it in one line it gets rather confusing, yeah. That's why I make them in notepad like this:
    =IF(Werkblad2.B14<=0.05; ""Maximum Physical Attack +106""
    ; IF(Werkblad2.B14<=0.10; ""Maximum Physical Attack +130""
    ; IF(Werkblad2.B14<=0.15; ""Interval Between Hits -0.05 seconds""
    ; IF(Werkblad2.B14<=0.24; ""Range +1""
    ; IF(Werkblad2.B14<=0.34; ""HP +350""
    ; IF(Werkblad2.B14<=0.39; ""Strength +18""
    ; IF(Werkblad2.B14<=0.44; ""Strength +19""
    ; IF(Werkblad2.B14<=0.49; ""Dexterity +18""
    ; IF(Werkblad2.B14<=0.54; ""Dexterity +19""
    ; IF(Werkblad2.B14<=0.59; ""Magic +18""
    ; IF(Werkblad2.B14<=0.64; ""Magic +19""
    ; IF(Werkblad2.B14<=0.69; ""Vitality + 18""
    ; IF(Werkblad2.B14<=0.74; ""Vitality + 19""
    ; IF(Werkblad2.B14<=0.835; ""Critical Hit Rate +1%""
    ; IF(Werkblad2.B14<=0.84; ""Critical Hit Rate +2%""
    ; IF(Werkblad2.B14<=0.88; ""Accuracy +30%""
    ; IF(Werkblad2.B14<=0.97; ""Atk. Level +1""
    ; IF(Werkblad2.B14<=0.98; ""Atk. Level +2""
    ; IF(Werkblad2.B14<=0.99; ""Atk. Level +3""
    ; IF(Werkblad2.B14<=1.00; ""Def. Level +2""))))))))))))))))))))
    

    Just a matter of copy+paste and using the search & replace function in notepad.
    [SIGPIC][/SIGPIC]
  • Nowitsawn - Heavens Tear
    Nowitsawn - Heavens Tear Posts: 4,864 Arc User
    edited September 2012
    Just a heads up that I'm working on it right now, so it might open at the second sheet (which is what I'm working on). You just need to switch to the first sheet at the bottom left corner.

    (also, the Hone button does nothing yet)

    I'm yet another step closer to implementing R8R weapons, since I finally figured out how to put a random number into a string of text (which is also selected at random). This way it's also possible to simulate the Hone process.
    [SIGPIC][/SIGPIC]
  • Jaabg - Sanctuary
    Jaabg - Sanctuary Posts: 2,256 Arc User
    edited September 2012
    Quick question, had slight difficulty getting the idea

    IF(Werkblad2.B14<=0.10; ""Maximum Physical Attack +130""
    IF(Werkblad2.B14<=0.15; ""Interval Between Hits -0.05 seconds""
    IF(Werkblad2.B14<=0.24; ""Range +1""

    If Werkblad2.B14 is less than or equal to 0.15, you will get Interval Between Hits -0.05 seconds, if Werkblad2.B14 is less than or equal to 0.1 you get Maximum Physical Attack +130? Right?

    How do you ensure that the lower numbers do not over lap?

    Let's say you get 0.16, that means no int. If you get 0.12, you can get int but no max attack. If you get 0.8 you can get either max attack or int?

    If these things are defined later in the macro, disregard this post b:sad. If not, take a sample and do greater than .1, greater than .15, so each value is bound in a specific range without any overlap. That might reduce the number of int people are getting.

    At present it seems that lower values include the bigger sets, isolating the values so they are mutually exclusive, was what i was thinking. Unless you did that already.
  • ChuuBR - Raging Tide
    ChuuBR - Raging Tide Posts: 35 Arc User
    edited September 2012
    soulsphere is the same rate of magic items?
  • Nowitsawn - Heavens Tear
    Nowitsawn - Heavens Tear Posts: 4,864 Arc User
    edited September 2012
    Quick question, had slight difficulty getting the idea

    IF(Werkblad2.B14<=0.10; ""Maximum Physical Attack +130""
    IF(Werkblad2.B14<=0.15; ""Interval Between Hits -0.05 seconds""
    IF(Werkblad2.B14<=0.24; ""Range +1""

    If Werkblad2.B14 is less than or equal to 0.15, you will get Interval Between Hits -0.05 seconds, if Werkblad2.B14 is less than or equal to 0.1 you get Maximum Physical Attack +130? Right?

    How do you ensure that the lower numbers do not over lap?

    Let's say you get 0.16, that means no int. If you get 0.12, you can get int but no max attack. If you get 0.8 you can get either max attack or int?

    If these things are defined later in the macro, disregard this post b:sad. If not, take a sample and do greater than .1, greater than .15, so each value is bound in a specific range without any overlap. That might reduce the number of int people are getting.

    At present it seems that lower values include the bigger sets, isolating the values so they are mutually exclusive, was what i was thinking. Unless you did that already.

    Well, basically it works like this:

    The "<=" means smaller than, or equal to.

    If you roll a 0.09, it is smaller than 0.10, so you will get Max. Phys. Attk.
    If you roll a 0.10, it is equal to 0.10, so you will get Max. Phys. Attk.
    If you roll a 0.11, it is larger than 0.10, so it skips the Max. Phys. Attk. and looks if the tested number will fit the next IF() on the list, which is -int, and so on.

    So they don't really overlap. It would probably give error messages up the wazoo if they did b:chuckle

    P.S. You can test this yourself on the second sheet (Werkblad2). You can put in your own number into the ''Socket X Roll'' cells without breaking anything.
    soulsphere is the same rate of magic items?

    Yes, it is. Thanks for the reminder, should add a notice for that.
    [SIGPIC][/SIGPIC]
  • Asterelle - Sanctuary_1381265973
    Asterelle - Sanctuary_1381265973 Posts: 7,881 Arc User
    edited September 2012
    I think ideally you want to just have a plain table of stats + their chances + value range and have a single formula that is able to use that table.

    That way you won't have to rewrite that big formula for every gear you want to support, you just have to change the table.
    [SIGPIC][/SIGPIC]
    Refining Simulator - aster.ohmydays.net/pw/refiningsimulator.html (don't use IE)
    Genie Calculator - aster.ohmydays.net/pw/geniecalculator.html - (don't use IE)
    Socket Calculator - aster.ohmydays.net/pw/socketcalculator.html
  • Nowitsawn - Heavens Tear
    Nowitsawn - Heavens Tear Posts: 4,864 Arc User
    edited September 2012
    I think ideally you want to just have a plain table of stats + their chances + value range and have a single formula that is able to use that table.

    That way you won't have to rewrite that big formula for every gear you want to support, you just have to change the table.

    Well, it's a little too late to change it around like that...

    Rewriting it for different weaponry really isn't that hard, though. It takes like 2 minutes per weapon.
    I was just stuck at the Hone function since it requires a string to be merged with the contents of a cell, and I wasn't quite sure how to do that. But I found that out (and it was actually laughably simple...), so the rest of the R8R table should be smooth sailing.
    [SIGPIC][/SIGPIC]
  • Nowitsawn - Heavens Tear
    Nowitsawn - Heavens Tear Posts: 4,864 Arc User
    edited September 2012
    Well, R8R is fairly close to completion now (the R8R magic sword button works now, though the blue stats don't). I'll finish it tomorrow.

    In the meantime, I'd like to hear about some results of S3 Nirvana rolls to see if the rates work in a realistic manner.
    [SIGPIC][/SIGPIC]
  • Nowitsawn - Heavens Tear
    Nowitsawn - Heavens Tear Posts: 4,864 Arc User
    edited September 2012
    Update:

    R8R Magic Sword is now functional (also counts as: Glaive/Wand/Sphere). The Pataka has slightly different rates and will follow some other time.
    [SIGPIC][/SIGPIC]
  • Moranine - Lost City
    Moranine - Lost City Posts: 319 Arc User
    edited September 2012
    Zoho's RNG might be to blame here, or you just have ridiculous luck.

    Also, which weapon was it? I'll double check the rates for it.

    After testing 500 rolls on daggers, and with only counting the first line, I got 13 x -0.05 int. I only got 2x -0.05 once. Seems within an acceptable margin to me. So I'd like to know which weapon you were simulating so I can see if there are any faults there.

    If there are none then I'd be willing to bet there are some people that would like their rerolling done by you b:quiet
    Traceless Dimension
    [SIGPIC][/SIGPIC]
  • BloodTyrant - Raging Tide
    BloodTyrant - Raging Tide Posts: 581 Arc User
    edited September 2012

    ☆Traceless Dimension (2 Socket(s))
    Claws
    Lv.16
    Attack Rate(Atks/sec) 1.43
    Range 2.50
    Physical Attack 785-1063
    Durability 200/200

    Requisite Lv.100
    Requisite Strength 150
    Requisite Dexterity 188
    Maximum Physical Attack +130
    Interval Between Hits -0.05 seconds
    Interval Between Hits -0.05 seconds
    Atk. Level +40
    price 144.120

    Rest your tired eyes now,
    For you've all the time you need.
    To ponder the universe's wonders,
    To lay amongst the reeds.


    Rolls: 113
    Essence of Offense 113
    Basic Badge 3390


    took me only 113 rerolls, im sooo going for this b:dirty
  • Nowitsawn - Heavens Tear
    Nowitsawn - Heavens Tear Posts: 4,864 Arc User
    edited September 2012
    Traceless Dimension

    Nope, don't see any errors in the code there. Unable to replicate it myself, either.

    I guess you just got really lucky there.

    ☆Traceless Dimension (2 Socket(s))
    Claws
    Lv.16
    Attack Rate(Atks/sec) 1.43
    Range 2.50
    Physical Attack 785-1063
    Durability 200/200

    Requisite Lv.100
    Requisite Strength 150
    Requisite Dexterity 188
    Maximum Physical Attack +130
    Interval Between Hits -0.05 seconds
    Interval Between Hits -0.05 seconds
    Atk. Level +40
    price 144.120

    Rest your tired eyes now,
    For you've all the time you need.
    To ponder the universe's wonders,
    To lay amongst the reeds.


    Rolls: 113
    Essence of Offense 113
    Basic Badge 3390


    took me only 113 rerolls, im sooo going for this b:dirty

    113 rerolls is still 377 full warsong runs, think about that for a minute b:chuckle

    Also fixed the Basic Badges, it's actually 20 per roll, not 30.
    [SIGPIC][/SIGPIC]
  • Nowitsawn - Heavens Tear
    Nowitsawn - Heavens Tear Posts: 4,864 Arc User
    edited November 2012
    Will begin adding more weapons shortly. Any requests for a particular weapon/armor set in the meantime?
    [SIGPIC][/SIGPIC]
  • WangZi - Dreamweaver
    WangZi - Dreamweaver Posts: 279 Arc User
    edited November 2012
    I rolled Traceless Dimension about 800 times, saw interval -0.05 countless times, and saw double interval -0.05 about 10 times

    Best stats that I saw were double interval with attack level +3 (there were multiple times when it was double interval with str +19) and only once where it was double interval + a bad stat such as mp.
    [SIGPIC][/SIGPIC]

    Sig made by Dorset b:victoryb:thanks
  • ovenusarmanio
    ovenusarmanio Posts: 6,695 Community Moderator
    edited November 2012
    gonna sticky this in the crafting nook. Again, would hate for it to be lost.

    kritty%20sig_zpsp0y7ttsb.png
    Thanks to MikoTenshi for the Avi and Kritty for the Signature.
    Get the Forums Enhancement Extension!
  • WangZi - Dreamweaver
    WangZi - Dreamweaver Posts: 279 Arc User
    edited November 2012
    I don't know about you guys, but I just tested the daggers, and in 100 rolls, I got 12 times with -0.05 int. Got the first one after 4 rolls and the 2nd one after another 4 rolls, and pretty nice stats too such as dex+19 with max attack +106. Guess it really does depend upon luck b:laugh
    [SIGPIC][/SIGPIC]

    Sig made by Dorset b:victoryb:thanks
  • WangZi - Dreamweaver
    WangZi - Dreamweaver Posts: 279 Arc User
    edited November 2012
    And after about a thousand rolls... it can be done! (like anyone's gonna roll over a 1000 times though) b:laugh

    http://i533.photobucket.com/albums/ee338/ZelthE/TracelessDimension3xInt.png
    [SIGPIC][/SIGPIC]

    Sig made by Dorset b:victoryb:thanks
  • jpablo
    jpablo Posts: 26 Arc User
    edited November 2012
    ☆Netherworld Guidance (1 Socket(s))
    Daggers
    Lv.16
    Attack Rate(Atks/sec) 1.25
    Range 2.50
    Physical Attack 754-1131
    Durability 200/200
    Requisite Class Assassin
    Requisite Lv.100
    Requisite Strength 54
    Requisite Dexterity 302
    Interval Between Hits -0.05 seconds
    Interval Between Hits -0.05 seconds
    Critical Hit Rate +1%
    Atk. Level +40
    price 144.120

    Dream a dream, of a life so new,
    One brimming with potential,
    Of starting again, leaving all behind,
    Only happiness is essential.


    Rolls: 1
    Essence of Offense 1
    Basic Badge 20



    c ☆Jaden Emperor's Defiance (1 Socket(s))
    Bow
    Lv.16
    Attack Rate(Atks/sec) 0.67
    Range 20.00
    Physical Attack 1298-2410
    Durability 200/200

    Requisite Lv.100
    Requisite Strength 52
    Requisite Dexterity 287
    Dexterity +18
    Physical Attack +100
    Interval Between Hits -0.05 seconds
    Atk. Level +40
    price 144.120

    We run until we can no more,
    We cross the desert's edge,
    Looking out across the dunes,
    I've now fulfilled my pledge.


    Rolls: 2
    Essence of Offense 2
    Basic Badge 40
  • Fawkser - Sanctuary
    Fawkser - Sanctuary Posts: 3 Arc User
    edited December 2012
    Please add the r8r Daggers!!
  • Asterelle - Sanctuary_1381265973
    Asterelle - Sanctuary_1381265973 Posts: 7,881 Arc User
    edited December 2012
    Add R9 third cast weapons!
    [SIGPIC][/SIGPIC]
    Refining Simulator - aster.ohmydays.net/pw/refiningsimulator.html (don't use IE)
    Genie Calculator - aster.ohmydays.net/pw/geniecalculator.html - (don't use IE)
    Socket Calculator - aster.ohmydays.net/pw/socketcalculator.html