Weapon Reroll Simulator

DuNotEat - Sanctuary · September 2012

Please click one of the Quick Reply icons in the posts above to activate Quick Reply.

Moranine - Lost City · 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.

Regenbogen - Lost City · September 2012

10th roll: 2x-0.05int max., phys.atk +130

b:surrender

Nowitsawn - Heavens Tear · September 2012

Moranine - Lost City wrote: »

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

_TENSHl_ - Sanctuary · September 2012

http://imageshack.us/photo/my-images/255/dibujoqrl.jpg/

I know.. the magic sucks.
I like this toy ty

Angel_Spawn - Sanctuary · 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 · 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 · September 2012

Nowitsawn - Heavens Tear wrote: »

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.

MagicEmpress - Lost City · September 2012

MagicEmpress - Lost City wrote: »

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 · 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..

Nowitsawn - Heavens Tear · September 2012

Asterelle - Sanctuary wrote: »

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.

Nowitsawn - Heavens Tear · 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.

Jaabg - Sanctuary · 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 · September 2012

soulsphere is the same rate of magic items?

Nowitsawn - Heavens Tear · September 2012

Jaabg - Sanctuary wrote: »

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.

ChuuBR - Raging Tide wrote: »

soulsphere is the same rate of magic items?

Yes, it is. Thanks for the reminder, should add a notice for that.

Asterelle - Sanctuary_1381265973 · 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.

Nowitsawn - Heavens Tear · September 2012

Asterelle - Sanctuary wrote: »

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.

Nowitsawn - Heavens Tear · 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.

Nowitsawn - Heavens Tear · 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.

Moranine - Lost City · September 2012

Nowitsawn - Heavens Tear wrote: »

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

BloodTyrant - Raging Tide · 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 · September 2012

Moranine - Lost City wrote: »

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.

BloodTyrant - Raging Tide wrote: »

☆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.

Nowitsawn - Heavens Tear · November 2012

Will begin adding more weapons shortly. Any requests for a particular weapon/armor set in the meantime?

WangZi - Dreamweaver · 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.

ovenusarmanio · November 2012

gonna sticky this in the crafting nook. Again, would hate for it to be lost.

WangZi - Dreamweaver · 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

WangZi - Dreamweaver · 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

jpablo · 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 · December 2012

Please add the r8r Daggers!!

Asterelle - Sanctuary_1381265973 · December 2012

Add R9 third cast weapons!

Weapon Reroll Simulator

Comments

Categories