31 replies to this topic

[GernMiester]

jss78, on 21 September 2015 - 03:57 PM, said:

It's not a surprise that you'd only get some map once. You can only start to expect the ratio to be close to 1/9 after a much larger number of games.

But yeah, it's not the best way to set up an event.

By not the best way, you mean it was stupid and showed zero foresight.

I never saw Mining Collective in my small amount of games.

[SkyHammyr]

I didn't see Mining Collective once all weekend.
I'm finally giving up and going to bed as I've got to work tomorrow.

Lots of DCs and Suicides tonight, too.

Pretty frustrated.

[Kiiyor]

Ok, if you have Excel, and want to count your matches, I have a ******* of a formula that extracts each instance of level loading text.

Open Excel, paste the contents of your all your omicron logs from the 18th onwards into column A starting at A2 (I like to leave space for headings)

Your omicron.logs are found here:
c:\Users\(current user)\Saved Games\MechWarrior Online\Logs\LogBackups

Put this formula in B2:

=IFERROR(MID(SUBSTITUTE(A2,"=",""),FIND(" ",SUBSTITUTE(A2,"=",""),FIND("PrepareLevel",SUBSTITUTE(A2,"=",""),1))+1,LEN(SUBSTITUTE(A2,"=",""))-FIND(" ",SUBSTITUTE(A2,"=",""))),"")

And fill it all the way down to the last row of text in column A.

I could probably tidy that formula, but meh, it works.

These are the map names:

islandmetropolis
rivercity
mechfactory
canyonnetwork
tourmalinedesert
causticvalley
terraceswamp
forestcolony
moonbase

Paste those map names somewhere in the sheet, and next to each name, put this:

=COUNTIF(B:B,E2)

Where E2 is the location of the map name. It will then count each instance of your loaded level.

Edited by Kiiyor, 21 September 2015 - 10:23 PM.

[Crosell]

after about 5 hours of grinding and geting manifold 3 times and each time my team got steam rolled. im throwing in the towel. 280 score but hte all or nothing rule.

[MechWarrior3671771]

Kiyor that's funny. I stole all your Forest Colony drops and you stole all my Mining Collective drops

[Kiiyor]

Fenrisulvyn, on 21 September 2015 - 10:33 PM, said:

Kiyor that's funny. I stole all your Forest Colony drops and you stole all my Mining Collective drops

OMG. I was prepared to sacrifice a kitten to get a forest drop.

But nope.

[matchmaker] "Searching... searching.... OH LOOK KIIYOR IT'S COLLECTIVE AGAIN HEY AWESOME A GREAT CHANCE TO INCREASE YOUR SCORE AAAAAAHAHAHAHAHAHAHAHAHA"

[crashlogic]

so her are my numbers:
viridian 11
mining 9
canyon 16
HPG 17
river city 19
forest 18
tourmaline 9
caustic 11
crimson 11
121 games (yes I was sick all weekend-don't judge)
If they came up evenly I should have seen each map 13 times
Clearly the weighting was to River city and forest for me.

But its not just the statistical averages that matter, its time spent looking for one map. I had everything but mining on the 19th, when it showed up five times (river was 9 forest was 8) on the 20th mining showed up 3 times (river was 8) and today mining showed up 3 times (and forest was 6) when all you need is mining having to randomly churn through river or forest 6-8 times (sometimes four in a row) is frustrating and leads to DCs. at least if I had the same eight chances on mining as I did on forest, I would know I could not spam the maps for an advantage.

[masCh]

Kiiyor, on 21 September 2015 - 10:18 PM, said:

Ok, if you have Excel, and want to count your matches, I have a ******* of a formula that extracts each instance of level loading text.

Open Excel, paste the contents of your all your omicron logs from the 18th onwards into column A starting at A2 (I like to leave space for headings)

Your omicron.logs are found here:
c:\Users\(current user)\Saved Games\MechWarrior Online\Logs\LogBackups

Put this formula in B2:

=IFERROR(MID(SUBSTITUTE(A2,"=",""),FIND(" ",SUBSTITUTE(A2,"=",""),FIND("PrepareLevel",SUBSTITUTE(A2,"=",""),1))+1,LEN(SUBSTITUTE(A2,"=",""))-FIND(" ",SUBSTITUTE(A2,"=",""))),"")

And fill it all the way down to the last row of text in column A.

I could probably tidy that formula, but meh, it works.

These are the map names:

islandmetropolis
rivercity
mechfactory
canyonnetwork
tourmalinedesert
causticvalley
terraceswamp
forestcolony
moonbase

Paste those map names somewhere in the sheet, and next to each name, put this:

=COUNTIF(B:B,E2)

Where E2 is the location of the map name. It will then count each instance of your loaded level.

Great, thanks for that! +Rep for you

[Kiiyor]

masCh, on 22 September 2015 - 01:12 AM, said:

Great, thanks for that! +Rep for you

Gah, the formula went nuts with that &quot crap.

Here it is:

=IFERROR(MID(SUBSTITUTE(A2,"=",""),FIND(" ",SUBSTITUTE(A2,"=",""),FIND("PrepareLevel",SUBSTITUTE(A2,"=",""),1))+1,LEN(SUBSTITUTE(A2,"=",""))-FIND(" ",SUBSTITUTE(A2,"=",""))),"")

[Mudhutwarrior]

I know a few long time players who just didn't bother. Many posted that here in the forums.

If you were not aware of how map rotation works in game I can give you a pass .

If you have been playing a while and never thought about how it was going to go down well shame on you.

It was rigged or dumbarsed by PGI from the start. I had more fun on the forums all weekend rather than in game and I think many of you understand why now.

[jss78]

I did some testing yesterday about just how likely are you to be missing a map, although it's got buried way down in the event announcement thread.

I think dropping the required match scores to 200/300 was a decent (if not ideal) stopgap measure, as after 50-100 games you are very likely to have got some attempts at every map.

It all assumes though that for the map selection for each game is an entirely independent one-from-nine random selection. Some of these anecdotes about people getting a map 5 or 6 times in a row are really puzzling.

[masCh]

Yeah unfortunately the 200 score baseline does nothing when average score is 450+/- but you're not getting the map you wanted.. I appreciate the thought PGI but it is not doing some of us any favours.

I can console myself however in the fact that the Tier 1 PlayNow prizes are nothing to shout about anyway.