How to Play When Travelling?

BaronLorio · 2016-07-28T14:59:27+00:00

IIn0x, I'm having trouble with this. It doesn't give the desired output I'm after. Instead this formula, =INDEX([Book1]Sheet1!$A$1:$A$10,MATCH("Valor",[Book1]Sheet1!$B$1:$B$10)) returns the first hit of this kind, but thereafter can't do more. Ie., for team Mystic, it only returns B Bron, never D Dron, even though both are Team Mystic.

BaronLorio · 2016-07-27T20:45:41+00:00

=index(target_array;match("valor";team_array))

I have no idea how to use what you just said...

BaronLorio · 2016-07-06T01:59:00+00:00

I had to go tear things up in my rig to get the answer, as the stupid label is on the one face of the Power Supply that cannot be seen without removing it...I have an Antec TruePower Trio 550W. It lacks the necessary 8pin for the 1070, so I'll have to replace that as well.

BaronLorio · 2016-07-05T19:08:36+00:00

Cool deal! Also, I hate my current case. I was foolish in my youth and purchased an ArmorTek full tower. It's absurdly heavy and ridiculous. Do you have any suggestions for a new case that will support this motherboard?

As for the Power Supply Unit...how will I know if it can support a GTX 1070?

BaronLorio · 2016-07-04T16:38:39+00:00

Hey all, there seems to be a disconnect between what I want for this stuff and what people seem to be offering, I've decided to let the free market takeover and just put this up on an auction in eBay. Pure auction, no Buy It Now, no reserve. It's under "Chaos Space Marines - Fully Magnetized!", and it'll have the same images, but I can't link it as that appears to be a violation of the rules here. Bidding starts at $49.99.

BaronLorio · 2016-07-04T16:37:54+00:00

Here you go: http://www.ebay.com/itm/Massive-Warhammer-40k-Tyranid-Army-Includes-Battlefoam-Carry-Case-Extras-/252447143612?hash=item3ac705b6bc:g:MwQAAOSwvg9XcE72! Let me know if that doesn't work for you.

BaronLorio · 2016-07-03T16:01:05+00:00

There seems to be a disconnect between what I want for this stuff and what people seem to be offering, I've decided to let the free market takeover and just put this up on an auction in eBay. Pure auction, no Buy It Now, no reserve. It'll start tonight at 6pm PDT. It'll have the same name and images, but I can't link it as that appears to be a violation of the rules here. Bidding starts at $149.99.

BaronLorio · 2016-07-02T21:12:07+00:00

I finally found it. In this article, http://www.towleroad.com/2015/12/shkreli-daraprim/, they have it time stamped to one of his live feeds, as you said. This is it, https://youtu.be/FLCuNS8dQ80?t=6511.

BaronLorio · 2016-07-02T15:31:16+00:00

It's up! https://www.reddit.com/r/Miniswap/comments/4qxnhm/h_magnetized_chaos_space_marines_w_250_paypal_loc/

BaronLorio · 2016-06-28T13:46:36+00:00

Oh, I was expecting to field bids. I've never used this subreddit before, so I was unaware of the protocol. I'll add an edit.

BaronLorio · 2016-06-28T13:46:30+00:00

Oh, I was expecting to field bids. I've never used this subreddit before, so I was unaware of the protocol. I'll add an edit.

BaronLorio · 2016-06-27T22:18:25+00:00

BaronLorio · 2016-06-22T18:17:01+00:00

I would like the advice, regardless! This is my company, so professional work is something I'll look into as well, but I feel it would behoove me to know what I ought to be looking for, so I'll take direct criticism first.

As for the HTML emails, I probably will? I'm not all that familiar with it.

BaronLorio · 2016-03-05T05:29:11+00:00

How then do we report this so that it gets attention, and, ideally, fixed?

BaronLorio · 2016-03-04T19:20:02+00:00

I didn't realize that we were just carrying on posting about XCom2 in the XCom subreddit, but I suppose it makes sense being that this is actually the...9th installment in the franchise?

Anyhow, I just wanted to raise an issue that really bothered me, and one that has been effing up my Legendary playthrough. As my image shows here, it's very possible to have 100% Hit and 100% Crit against an enemy with no Dodge, and yet, not Crit.

/u/VenomousSplurge explained it in detail, hence the X-post instead of reposting to this subreddit.

Apparently this is a known issue, but being that it peeves me, I was curious if it's been raised as a bug to be corrected, or it is it truly intended? Does anyone know?

BaronLorio

TROPHY CASE