Event Optimizer (Incomplete)

[rapsoid]

(08-27-2015, 05:33 PM)Void Wrote: Now this optimizer is not fully done, but it has a lot of useful information/data if anyone wants to use it. Copy it/Download it...I don't care. Just don't go around saying it's yours; otherwise, I will have to throat-punch you.  



https://docs.google.com/spreadsheets/d/1...1179251141

The is the way it looks to me, i don't know how to make it like yours,  i put the link down there sorry don't know how to put pictures on this forum.


resim gönder   
http://postimg.org/image/tnfo8sht3/

[Muriko]

There are tabs at the bottom left of the screen.

[Muriko]

(08-29-2015, 04:14 AM)Kaotik Wrote:

(08-29-2015, 03:50 AM)Muriko Wrote: Attack speed calculation seems wrong, it should be recalculated based on base speed.

Code:

=((($B$18/'Alien Event Data'!AJ2/(1-T15))+($D$18*3/'Alien Event Data'!AK2/(1-T15))+($F$18/'Alien Event Data'!AL2/(1-T15))+($B$21*2/'Alien Event Data'!AM2/(1-T15))+($D$21*1.3/'Alien Event Data'!AN2/(1-T15))+($F$21*3/'Alien Event Data'!AO2/(1-T15))))

Where are you inputting this?  I've noticed that if I add one to attack speed, it's always the green one after that.

It's the "New DPS" for attack speed. You can check it because if you add one to any of the values, your current DPS should change to the old "New DPS".

It should also be noted that in the latest version, someone messed up the Bazooker Attack Speed, so you also have to correct for that.

[max192]

(08-29-2015, 04:15 AM)rapsoid Wrote:

(08-27-2015, 05:33 PM)Void Wrote: Now this optimizer is not fully done, but it has a lot of useful information/data if anyone wants to use it. Copy it/Download it...I don't care. Just don't go around saying it's yours; otherwise, I will have to throat-punch you.  



https://docs.google.com/spreadsheets/d/1...1179251141

The is the way it looks to me, i don't know how to make it like yours,  i put the link down there sorry don't know how to put pictures on this forum.


resim gönder   
http://postimg.org/image/tnfo8sht3/

You need to press the "Alien Event + Optimizer" tab on the bottom left.

[Aar118]

Also, I added a few level 25 builds for anyone who needs. Most of us have already beat it, but not everyone

[Goty]

You guys need to take in mind that Sniper, Pyro and Bazooker can hot multiple mobs.

[Muriko]

(09-06-2015, 10:19 AM)Goty Wrote: You guys need to take in mind that Sniper, Pyro and Bazooker can hot multiple mobs.

His calculator does take that into account with damage multipliers. But I am in the camp that the pierce is irrelevant because there is always 1 big guy at the end and all that will matter in determining if you can beat the level or not is the single target damage.

[Goty]

Of course is not irrelevant, and of course there's a big guy that's why there must be a balance between single mob damage and group mob damage, i've made some changes and is working better

[Aar118]

@Goty - I already had weights on it, which I'm also done doing anything with this google sheet.