237 replies to this topic

[Duncan Jr Fischer]

I wonder.. You surely must have screenshots from the same matches by different people.. Can't imagine, how are you not getting lost in all this stuff..)

[Kiiyor]

Duncan Jr Fischer, on 27 September 2014 - 09:55 PM, said:

I wonder.. You surely must have screenshots from the same matches by different people.. Can't imagine, how are you not getting lost in all this stuff..)

=IF(@playerName="Kiiyor","OH **** I'M HERE", "COUNT IT")

I also have a list of contributors, and a cross check to make sure they aren't in each other's matches.

[Tkhaw]

I have got more coming up!

Will send when I hit 200 matches

*Really tried to be unbiased here by including everything I went through...*

Missed a few due to me rage quitting over noob team

[Kiiyor]

Tkhaw, on 28 September 2014 - 02:37 AM, said:

I have got more coming up!

Will send when I hit 200 matches

*Really tried to be unbiased here by including everything I went through...*

Missed a few due to me rage quitting over noob team

You have to stick it out!

Actually, don't. I've stayed until the end of every single match I've played, and I very much believe i'm damaging fillings with the force generated when I grind my teeth.

Also, i'm about ready to upload some new numbers, but I've hit a snag. I've got 2 excel workbooks; one for the existing data, and one mammoth thing with the new data. My machine can't handle having both open at the same time! Time to get creative with some .csv conversions, or maybe power pivot.

[Tkhaw]

Kiiyor, on 28 September 2014 - 03:19 AM, said:

You have to stick it out!

Actually, don't. I've stayed until the end of every single match I've played, and I very much believe i'm damaging fillings with the force generated when I grind my teeth.

Also, i'm about ready to upload some new numbers, but I've hit a snag. I've got 2 excel workbooks; one for the existing data, and one mammoth thing with the new data. My machine can't handle having both open at the same time! Time to get creative with some .csv conversions, or maybe power pivot.

**** just got real!

[Duncan Jr Fischer]

Yeah, for the sake of science I stopped quitting on death. Anyway, it's usually not that far from the end of match, but sometimes it is)) Another reason is that I still need those damn modules stuck in the current mech)

[LORD ORION]

AWS-8R probably needs special attention as it is highly variable in performance looking at stats.

It depends heavily on team composition and skill. eg: 3 enemy ecm vs 0 enemy ecm and on a team with a screening wall of strong players or surrounded with a blob of ******** potatoes screaming like lil' ******* under a table in a restauraunt gun fight)

It can easily score 1000+ damage in one match doing jack **** ([behind a mountain, took 0 dmg] lob, lob, lob, lob, lob, lob [accidentally killed 6 enemy mechs by last hitting while they were getting shot to pieces by teammates]), yet still be held to less than 200 dmg on another while doing everything right to secure a team win....Frantially breaking ecm with TAG, spotting enemies for planning (probably has BAP and Sensor range), absorbing a crap ton of incoming fire so the team can advance while the enemy is distracted, keeping enemy mechs pinned under cover with never-ending LRM spam, all while intentionally avoiding going for kills (instead aims to maim targets that get caught in the open and then move on to pin next target)

I dunno if I have an specific recomendations off the top of my head other than take high damage wins with a grain of salt as an AWS-8R being a signficant contributor to the match.

[Mystere]

aniviron, on 27 September 2014 - 09:38 PM, said:

EDIT: My evil plan to skew the stats for the KFX-D continues apace!

The data is now tainted! The analysis is now useless! It's time to call it a day and just rest.








...

[Jeb]

might be time to toss the data into a database if your having issues with excel? Even using Access might be good enough, although I would probably go with postgresql or mariadb since Access will run into performance issues a lot sooner then either of those (and those two are free)

[stjobe]

Jeb, on 28 September 2014 - 12:22 PM, said:

might be time to toss the data into a database if your having issues with excel?

Seconded on the database; you really need one (although I perfectly understand starting out with something familiar, it sounds like it's time to use something explicitly designed for this kind of number-crunching).

Disclaimer: I hate Excel with a passion; I believe 90%+ of companies would see a major productivity, data quality, and workflow increase if they just un-installed Excel on all their computers. I've never seen a program misapplied in so many ways as the humble spreadsheet...

[FitzSimmons]

This is in the middle of a Venn diagram of things I love, and it was pure joy in the reading.

Thank you, Kiiyor, you made my day.

[Pht]

... I guess the chasing of the snark it is for kiiyor.

Even if you didn't agree with my last post in this thread, I had expected at least some comment about what appears to be a functional, if not actual, lack of a non-ethereal goal for all the math.

I find this sort of surprising, given kiiyor's obvious willingness to put in serious effort...

Or perhaps you did address this and I missed it?

Edited by Pht, 28 September 2014 - 02:55 PM.

[Foxfire kadrpg]

PGI has said they are hiring.

[Ultimax]

Kiiyor, on 28 September 2014 - 03:19 AM, said:

You have to stick it out!

Actually, don't. I've stayed until the end of every single match I've played, and I very much believe i'm damaging fillings with the force generated when I grind my teeth.

Also, i'm about ready to upload some new numbers, but I've hit a snag. I've got 2 excel workbooks; one for the existing data, and one mammoth thing with the new data. My machine can't handle having both open at the same time! Time to get creative with some .csv conversions, or maybe power pivot.

I have no idea if it would actually help, but you might try making a copy and then uploading to google sheets or a similar cloud based solution.

[Kiiyor]

Ultimatum X, on 28 September 2014 - 04:59 PM, said:

I have no idea if it would actually help, but you might try making a copy and then uploading to google sheets or a similar cloud based solution.

It may, but it's the calculation time that's killer.

I've got a solution, being that the data is now split over 10 or so workbooks. Total calculation time is about 5 minutes, versus 12 minutes when it was all in one book.

I've got some old code around somewhere that writes to an SQL database, so maybe I just need to emulate one locally and go down that route.

Sorry for the delay folks, but hopefully all will be posted soon - I just needed a few hours to release some pent up Excel related fury, and traded it for some trying to unlock efficiencies on the Warhawk fury. I even ran an LRM boat for a couple of drops, but ended up feeling dirty.

I'm rebuilding things a little to make things easier on Excel for the moment. SOON™

[Ultimax]

Kiiyor, on 28 September 2014 - 05:25 PM, said:

Sorry for the delay folks, but hopefully all will be posted soon - I just needed a few hours to release some pent up Excel related fury

Kiiyor, on 28 September 2014 - 05:25 PM, said:

and traded it for some trying to unlock efficiencies on the Warhawk fury. I even ran an LRM boat for a couple of drops, but ended up feeling dirty.

The LRM-hawk played aggressively can be amazing in PUG matches, but you should definitely give my build a go.

I prefer Seismic, Radar Dep, CERMLAS Range Mod & CGauss CD Mod.


It runs fairly cool and can fall back on the Gauss alone when you start to run too hot.

You can actually fire the Gauss + CLPLs together indefinitely.

That's a 38 point sub-alpha that is unlikely to overheat outside of the hottest maps in the hottest locations.


You don't have a shield side, but that's not really viable on Warhawks.

On the other hand, you don't suffer "RT syndrome" like most WHk builds do - your opponents can remove either torso and you will still have a 25 point alpha left - with a 50 point alpha you can pump out very frequently.


It's not a brawler, it's not a sniper. It plays as a mid range fire support build that is very good at surgically removing targets and sustained fire.

Edited by Ultimatum X, 28 September 2014 - 05:53 PM.

[The Driver]

nom nom nom!

[Mister Blastman]

Nuts. Just nuts. Thanks.

[Kain Demos]

Kageru Ikazuchi, on 09 September 2014 - 11:58 PM, said:

Those would be the poor guys who got left behind by their team and ganked from behind by a one or two smart lights. Happens fairly often on River City.

That has happened to me a lot and it actually happened to me again over the weekend in a match Kiyor was in and in my lance. Basically the light pushed through and just acted as a spotter so I got LRM'd to death by 4-5 boats back in the city under cover.

Pretty sure it was my first "0 damage" match ever.

Honestly I'm to the point now to where if its a Skirmish and everyone just high tails it for the opposite bank then I'm just going to stand my ground at the spawn and do what I can before I die.

It sure beats trying to follow everyone and getting killed in the middle of the water.

Edited by Kain Thul, 29 September 2014 - 08:42 AM.

[Wolf Clearwater]

Great job OP, that must have taken a huge amount of time. Thanks for all the effort, I hope PGI and the community can put it to good use overall.

As far as the trailing pages of arguments afterward:

Insert random half-formed argument here.....