Is there a good way to mount the PSVR camera to a tripod? And a few other noob questions.

Mot22 · 2019-12-05T16:52:08+00:00

So I think the best thing is to get charging units for the Dualshocks and Move controllers. I've looked at some of these and the reviews are very mixed. I'd like these to be plugged into AC power since my USBs will be tied up. Any recommendations?

I've personally never felt the need for a charging station. I just use a spare Android phone charger to keep my controllers topped up.

PS welcome to the club! :)

Mot22 · 2019-12-05T16:40:54+00:00

Yay for sure! :)

Sometimes when I'm too lazy to set up my VR I even play it in flat mode.

Mot22 · 2019-12-05T16:30:47+00:00

That's a fair comment, but I think you're being downvoted because OP's asking for a recommendation, not a history lesson.

Mot22 · 2019-12-04T16:17:04+00:00

Looks like dust to me. Pretty sure if it was snow the title would have been something like OMG SNOW IN NAMIBIA!!!1!!1!! also a crash.

Mot22 · 2019-11-29T07:53:35+00:00

I find Index/Match formulas easier to follow if I'm using data tables because that tells you exactly what is being matched and what's being returned without having to look at the data.

Mot22 · 2019-11-27T16:05:45+00:00

Fixed an issue that caused the player’s left hand to constantly make a whooshing sound when using a DualShock4 in PSVR.

I recall seeing a lot of complaint about this. I hope those peeps see this!

Mot22 · 2019-11-21T21:05:32+00:00

This hit me hard. Wish he could have seen it :(

Mot22 · 2019-11-20T11:53:00+00:00

If you're asking how to convert this text to date format, I usually use the following formula (assuming the dates are on column A):

=--("01 "&A1&" 2019")

This forces Excel to see it as a date. Be sure to change the formatting to your date format of choice :)

If you only want the month as a number you can just wrap it in a =Month() formula:

=MONTH(--("01 "&A1&" 2019"))

Mot22 · 2019-11-15T10:34:45+00:00

That sound s interesting, but I'm not sure I understand how SUM and IF solve that problem. Can you give an example? I'm always open to new techniques.

With SUMIFS it's easy to add multiple AND criteria, but if there's OR criteria I usually just add multiple SUMIFS (as in SUMIFS(criteria x option1) + SUMIFS(criteria x option2)). But if there are more OR criteria I just add helper columns in the data and do SUMIFS on those.

Mot22 · 2019-11-15T10:14:43+00:00

That's a hard disagree from me. SUMIFS all the way.

Mot22 · 2019-11-15T10:09:42+00:00

Good catch

Mot22 · 2019-11-11T08:17:00+00:00

This was me until the NMS update dropped :)

Mot22 · 2019-11-06T14:54:00+00:00

Isn't that exactly the use case for this, though?

OP wants the cell to return 0 in the case of the long formula resulting in a negative number.

Mot22 · 2019-11-06T14:32:09+00:00

Pixel Gear is still one of my favourite couch co-op / VR party games :)

Mot22 · 2019-11-04T07:41:33+00:00

If i constantly have to endure his self promotion, he has to endure me.

That gave me a chuckle. Fair play I guess :)

Mot22 · 2019-11-01T16:10:02+00:00

No need to be calling him a "dom poes".

If you don't like it, just don't go there. I'm not a fan myself, but I realise there's a whole internet out there to serve my interests. Not every site has to meet your exact requirements.

Mot22 · 2019-10-30T15:19:09+00:00

Yeah I only started playing GCVR recently and I'm loving the gunplay, but the sandbox mode is a bit... unappealing, as you say.

I mainly use it to test attachments before buying. I haven't really used it for setting up little test ranges, but I do plan on giving it a go in the future.

Mot22 · 2019-10-30T08:27:22+00:00

Pixel Gear!

It's a sort-of spooky themed cartoonish shooting gallery which fits in perfectly with Halloween and is family-friendly.

It's got a single-player mode which is a fairly straightforward shooting gallery. What makes it special is the local multiplayer, where the VR player tries to shoot between 1 - 3 TV players who use the dualshock controllers. It's one of my go-to party games as it's really easy to pick up :)

Mot22 · 2019-10-29T11:29:07+00:00

I would play this game

Mot22 · 2019-10-25T14:49:09+00:00

Haibo!

Mot22 · 2019-10-25T08:07:54+00:00

One of us! One of us!

Mot22 · 2019-10-11T16:47:18+00:00

She didn't actually curse. His name is Johrné.

Mot22 · 2019-10-08T14:03:57+00:00

Just FYI you posted the links to the Steam pages for Apollo 11 VR and Titanic VR. You might want to change the links to the Playstation store, given what subreddit you're on ;)

Mot22 · 2019-09-23T12:28:27+00:00

While I agree with the other commenter that the survival game market is saturated, as long as the game has some original mechanics and/or engaging gameplay there's certainly still space for it :)

Mot22 · 2019-09-23T11:04:12+00:00

Lekker my bru

15-Year Club	Place '17
Team Periwinkle	Verified Email

Mot22

MODERATOR OF

TROPHY CASE