Recent Topics

Ads

[MathHammer] Minmaxing tool

Let's talk about... everything else
User avatar
Rockalypse
Former Staff
Posts: 365

Re: [MathHammer] Veszal's minmaxing tool

Post#51 » Mon Mar 11, 2019 4:36 pm

V.2.3 Update
Added Gunbad Amber Exquisite
Added Gunbad Amber Rough
Added Gunbad Diamond Exquisite
Added Gunbad Diamond Rough
Added Gunbad Emerald Exquisite
Added Gunbad Emerald Rough
Added Gunbad Jet Exquisite
Added Gunbad Jet Rough
Added Gunbad Ruby Exquisite
Added Gunbad Ruby Rough

Ads
User avatar
Rockalypse
Former Staff
Posts: 365

Re: [MathHammer] Veszal's minmaxing tool

Post#52 » Fri Mar 15, 2019 8:44 am

V.2.4 Update
Reworked set piece gathering - from now on you can only pick sets which have picked piece type (if you choose helmet set - you will only see sets with helmets in dropdown list, if you pick jewelry piece - you will only see jewelry in dropdown list).

User avatar
Rockalypse
Former Staff
Posts: 365

Re: [MathHammer] Veszal's minmaxing tool

Post#53 » Sat Mar 23, 2019 2:13 pm

V.2.5 Update
Invader set bonuses updated.

User avatar
Rockalypse
Former Staff
Posts: 365

Re: [MathHammer] Veszal's minmaxing tool

Post#54 » Sat Mar 23, 2019 8:23 pm

Sheet was switched to read only, due to my inability to restrict people from copying cells (was messing up drop down lists for separate pieces, if someone copied helmet to all for example).
If you want to use it - from now on you will need to copy tool to your own Goodle disk, to do that you need to go File -> Make a copy -> select folder on your disk.

User avatar
Rockalypse
Former Staff
Posts: 365

Re: [MathHammer] Veszal's minmaxing tool

Post#55 » Sat Mar 30, 2019 1:57 pm

V.2.5.1 Update
Invader set for Slayer/Choppa updated in accordance with patchnotes 30/03/2019

User avatar
Rockalypse
Former Staff
Posts: 365

Re: [MathHammer] Veszal's minmaxing tool

Post#56 » Mon May 20, 2019 7:36 pm

V.2.6 Update
Added Bloodlord set for all classes.
Added Morale Per Second counter.
Fixed BL sets for BG/IB/SM/BO to show their unmirrored bonuses as it is in game.
Removed class groups, now you again have separate class to pick.

As number of data rows increased from 1k to 2,5k due to last change mentioned, optimization can be a bit off. If any mistakes are found - PM me here.

User avatar
Rockalypse
Former Staff
Posts: 365

Re: [MathHammer] Veszal's minmaxing tool

Post#57 » Mon May 20, 2019 7:42 pm

V.2.6.1 Update
Switched Accessory of Bloodlord to cloak slot.

Ravengaard
Posts: 12

Re: [MathHammer] Veszal's minmaxing tool

Post#58 » Tue May 21, 2019 5:40 am

Noticed an issue in your latest version. The drop down boxes for armor and jewels only select from a finite amount of rows from the data tab.
For instance, A2:A57. This will leave out any selections added past that number.

Ads
User avatar
Rockalypse
Former Staff
Posts: 365

Re: [MathHammer] Veszal's minmaxing tool

Post#59 » Tue May 21, 2019 6:32 am

Ravengaard wrote: Tue May 21, 2019 5:40 am Noticed an issue in your latest version. The drop down boxes for armor and jewels only select from a finite amount of rows from the data tab.
For instance, A2:A57. This will leave out any selections added past that number.
Do you see any errors related to this or can point me to cells in which you see A2:A57?
I am aware how range works and I intentionally made it with numbered ranges not full column selection from V.1.
Right now all armor and jewelry cells use range from 2 to 2568 of related Data column, while jewelry pieces use range from 2 to 103 of Formulas for data validation.

User avatar
Rockalypse
Former Staff
Posts: 365

Re: [MathHammer] Veszal's minmaxing tool

Post#60 » Tue May 28, 2019 12:45 pm

V.2.6.2 Update
Fixed Blordlord set-bouns bug.

Who is online

Users browsing this forum: Frankie, Maples22, PROsiak, siglade and 27 guests