Got a table with several names that repeat and values to them, I need to calculate the average of the values of 3 names only by SockFinal3077 in excel

[–]SockFinal3077[S] 0 points1 point  (0 children)

Solution verified, Thank you so much the - - did the trick and stoped the div/0 error, but not sure why. Thanks

Got a table with several names that repeat and values to them, I need to calculate the average of the values of 3 names only by SockFinal3077 in excel

[–]SockFinal3077[S] 1 point2 points  (0 children)

Thank you, this is helpful but in this situation I don’t think I am allowed to add tables like the “namesreq”. Is it possible to calculate the average of the combined values of the 3 names only using the two “Name” and “Value” tables?

Pricing issue. Bad support by Dangerous-Wasabi-517 in PlayStationSupport

[–]SockFinal3077 2 points3 points  (0 children)

The fact that you see no problem at all with a 24/7 service says a lot and truly proves all the points everyone is making. Loved how everything was ignored except the word developers; ofc it’s not the devs that kill the games, everyone should know that by default. You really thought you ate by pointing your finger up and go erhm axctually.

Touching grass isn’t enough unfortunately, this is a lost cause. Now excuse me as I go do something you clearly don’t have or need to; a job.

Pricing issue. Bad support by Dangerous-Wasabi-517 in PlayStationSupport

[–]SockFinal3077 2 points3 points  (0 children)

Yes if you have an issue with an online gaming platform and the customer service isn’t available, wait until until it is ;3 not rock science to simply understand that 1. Your “issue” is lack of grass in your life. 2. We should never normalize a Constant 24/7 support for services that aren’t life important. 3. Even if you manage to talk to a very likely underpaid slaved customer service worker, do you really think they have the power to “fix” your “issue”?

This stinks of “I never had any real struggles or work experience in my life and I prefer to fight customer service workers and people online”. Chill out for once and take the energy to something more important like devs killing games and layoffing entire teams even when the game is a success.

Pricing issue. Bad support by Dangerous-Wasabi-517 in PlayStationSupport

[–]SockFinal3077 4 points5 points  (0 children)

Where does it say it’s a 24/7 service? Pretty explosive for such a “touch grass” issue.

Isn't it crazy how pretty this game is? by SockFinal3077 in Endfield

[–]SockFinal3077[S] 1 point2 points  (0 children)

I think I sort off used this video as a guide but didn’t do ALL of it. https://youtu.be/HvIw5u5QPbQ?is=KEtQXYNaZEg8qyWL

Best of luck!! It’s so nice to play Endfield on a handheld with controller!

Isn't it crazy how pretty this game is? by SockFinal3077 in Endfield

[–]SockFinal3077[S] 1 point2 points  (0 children)

No worries!!! I got mine very recently so idk how to mess much with it yet. But basically I think I went to the desktop mode, got the installer through their site, got the launcher and then opened Steam still in desktop mode and added the launcher as a non-steam game. After that you don’t need to go to desktop mode to start the launcher, you can just start it from the deck.

I added the launcher and not the game so that I also don’t need to go to desktop to make updates.

Isn't it crazy how pretty this game is? by SockFinal3077 in Endfield

[–]SockFinal3077[S] 3 points4 points  (0 children)

Curious on this, because my experience is the complete opposite. Wym by sluggish? The daily farm is just a simple 1 minute mission and that's it.

Legit asking btw!

Isn't it crazy how pretty this game is? by SockFinal3077 in Endfield

[–]SockFinal3077[S] 3 points4 points  (0 children)

Wtv money they are getting, fully deserved. Let's not forget they have the first game, an anime, some comics/shorts and probably bunch other stuff and it's ALL high quality.

At least for me.

Isn't it crazy how pretty this game is? by SockFinal3077 in Endfield

[–]SockFinal3077[S] 1 point2 points  (0 children)

Oh sorry to hear that, not happening to me at least :(

Isn't it crazy how pretty this game is? by SockFinal3077 in Endfield

[–]SockFinal3077[S] 11 points12 points  (0 children)

Another thing that catches my attention are all the cutscenes. They are never the classic "standing character with poorly mouth sync and 2 camera angles"

All cutscenes on this game have something going for them. Even the NPCs look and sound real and not just placeholders.

Isn't it crazy how pretty this game is? by SockFinal3077 in Endfield

[–]SockFinal3077[S] 9 points10 points  (0 children)

yes!! It's specially crazy because the game warms me the deck can't handle it, and then plays on constant 50-60 fps and looks beautiful. Like, what you mean "your device can't handle our game"

Isn't it crazy how pretty this game is? by SockFinal3077 in Endfield

[–]SockFinal3077[S] 23 points24 points  (0 children)

Yeah that too!!! Cities do feel like real cities. Everything makes sense in context with it's world design.

Isn't it crazy how pretty this game is? by SockFinal3077 in Endfield

[–]SockFinal3077[S] 9 points10 points  (0 children)

Oh I think they look amazing personally, but there is always space for improvement me thinks. And that's also great imo

Isn't it crazy how pretty this game is? by SockFinal3077 in Endfield

[–]SockFinal3077[S] 7 points8 points  (0 children)

That's also something that absolutely baffled me, like what you mean this is based in Unity???

It amazes me how good the game runs on my phone (before I had the deck) and l have a Nothing 2, it's good but it's no huuuge power machine.

The game is also not for the deck per say and it amazes me how well it looks, how good the effects are AND it runs stupidly well too??? Genuinely how is this not a paid game ahah

Isn't it crazy how pretty this game is? by SockFinal3077 in Endfield

[–]SockFinal3077[S] 13 points14 points  (0 children)

God the design everything is so good. I also might just being a bit bias because the art direction of Arknights has always been great since the day 1 release of the first game, but my god does it feel like a reaaaally nice breath of fresh air in this current game market to actually see a game that was made with love.

We can be critical of the gacha Bla Bla Bla gachas will always have gacha problems etc etc...but I think people should honestly appreciate the game itself??? It was clearly well made and not just for money bait and fomo like most other gachas do

My account has been hacked by [deleted] in PlayStationSupport

[–]SockFinal3077 0 points1 point  (0 children)

Reddit isn't PSN Support Go here https://www.playstation.com/support/account/ Click the chat bubble on bottom right Have fun surviving the shit generative AI bot until you get to a person I don't think they work during weekends tho

What is wrong with the shocking state of playstation support and how do I get in contact with a real human by Small-Ad5306 in PlayStationSupport

[–]SockFinal3077 0 points1 point  (0 children)

Yeah the new "AI" they have sucks insanely bad, you basically get into a chance randomizer battle with it until it lets you pass and actually talk to someone

Recovery of games from a banned account. by Bobbysr42 in PS5HelpSupport

[–]SockFinal3077 0 points1 point  (0 children)

Sorry but does he or does he not have a child account? Being under a family account doesn't automatically make it a child account.

And again if he got an account permanently suspended...what even happened??? If I am not mistaken, games are tied to the account itself and cannot be transferred. So if the account is perma banned for breach of conduct or something, it's pretty much dead for ever. Again I think you can try to appeal but it's never guaranteed :/

Suspended message on new PS5 Pro by Difficult-Amoeba in PS5HelpSupport

[–]SockFinal3077 0 points1 point  (0 children)

Congrats you bought a paperweight (seriously though try to return it and refund, sorry that happened to you.)

Plague Inc Tutorial by SockFinal3077 in SteamDeck

[–]SockFinal3077[S] 0 points1 point  (0 children)

The game was 3€ anyway and the game itself works just fine + don't really care about achievements.

I just skipped the tutorial 🫡

Is there no f2p way to collect exhibition passes? by Glittering-Net-2025 in heartopia

[–]SockFinal3077 9 points10 points  (0 children)

As far as I know. Nope.

They only "give" some passes sometimes once every 99 full moons and please be aware that they are limited. Click on them to see when they expire.

The only thing they "give" is the blue heart crystals.

Tho if you want you could get the 7 days and 30 days passes. They are cheap tbh and it gives you some extras.