test content
What is the Arc Client?
Install Arc

Weapon Reroll Simulator

2

Comments

  • DuNotEat - SanctuaryDuNotEat - 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 CityMoranine - 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 CityRegenbogen - 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 - SanctuaryAngel_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 CityMagicEmpress - 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_1381265973Asterelle - 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 CityMagicEmpress - 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 TearQuinnie - 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 - SanctuaryJaabg - 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 TideChuuBR - 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_1381265973Asterelle - 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 CityMoranine - 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 TideBloodTyrant - 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 - DreamweaverWangZi - 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
  • ovenusarmanioovenusarmanio 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 - DreamweaverWangZi - 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 - DreamweaverWangZi - 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
  • jpablojpablo 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 - SanctuaryFawkser - Sanctuary Posts: 3 Arc User
    edited December 2012
    Please add the r8r Daggers!!
  • Asterelle - Sanctuary_1381265973Asterelle - 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
Sign In or Register to comment.