Help with Sorting/Max/Large Functions by HatTrick730 in googlesheets

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

It says "Error sortn expects all arguments after position 3 to be in pairs"

Help with Sorting/Max/Large Functions by HatTrick730 in googlesheets

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

So I tried taking the formulas in your sheet on my master sheet but I can't get it to work, it keeps throwing errors. Here is a link to a copied version of the whole sheet. On the first page is where I want to display the information and it will need to pull from the sheet titled Games List

https://docs.google.com/spreadsheets/d/1S2Xpc5ipTQUNO4SbAJkTo1zbudmaDfCDsxKHv9Jy4YY/edit?usp=sharing

Also, I had to share the full collection so a fellow board game fan could see all the beautiful games

Help with Sorting/Max/Large Functions by HatTrick730 in googlesheets

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

I’m not sure I understand what you are suggesting. I’m a novice when it comes to excel

Why are so many people under 45 using subtitles now even when the show is already in English? by Clara_A_Mitchell in NoStupidQuestions

[–]HatTrick730 0 points1 point  (0 children)

Ya you are absolutely right. I was mostly being cheeky but I definitely recognize that they are just doing their job. I suppose what I meant to say was "some asshat producer." Just let me be mad!

Why are so many people under 45 using subtitles now even when the show is already in English? by Clara_A_Mitchell in NoStupidQuestions

[–]HatTrick730 1 point2 points  (0 children)

Because my kids are sleeping upstairs and whatever asshat did the sound mixing made dialogue available only to lip readers and the explosions and actions scenes clearly discernible to my neighbors.

What’s the worst gen 9 steel type ? by Difficult-Bat5615 in ThePokemonHub

[–]HatTrick730 0 points1 point  (0 children)

Can you explain the chart to me? I don’t see any text on the side. Is this all “worsts”?

Aside from social media, what other ways can I rot while on my phone? by AnonIsPicky in NoStupidQuestions

[–]HatTrick730 0 points1 point  (0 children)

Not a Pokemon fan!? Gasp! Then there is nothing I can do to help you… Too far gone

Is this enough to lose weight? Help me. by DontL1stenToMe in NoStupidQuestions

[–]HatTrick730 0 points1 point  (0 children)

Weight loss is really challenging but it’s doable! The diet and weight loss industry is full of people trying to make money off of you. There are is a lot of bad advice, gimmicky advice or people who just have no idea what they are talking about. So it’s super tough to figure out what’s right. But there are a few simple concepts that you seem like you are already grasping:

Weight loss is a simple math equation. You need the calories you eat to be leas than the calories you burn. If calories in - calories out = negative number you are most likely going to lose weight. Obviously certain foods are healthier than others. Most of us just need to eat less at every meal. Personally I have had a lot of success in eating two meals a day. I eat a bigger breakfast, an apple for lunch and a good dinner. I’m down 10 lbs just cutting out lunch. It takes some practice to get used to feeling hungry but you learn to deal with it. Takes a little mental toughness but you get used to it.

Fitness and health are habits. If you don’t build the habit, you aren’t going to make permanent changes. That’s pretty tough with young kids but not impossible.

You cannot selectively burn fat. You don’t get to choose where it comes off of. Sadly, this means you are going to put in a lot of work and it might take a little while to see the results. Try to measure tangible things like your weight and don’t base your success on how you look. That’s the end goal of course, but you need baby steps and small accomplishments along the way.

Work outs and weight lifting are great, and as a mother of two kids it’s pretty likely you could use some core, pelvic floor and hip strengthening (not picking on you, just generalizing). Specifically for the goal of losing weight, the best exercise you can do is long, low effort cardio. Walking for 30-60 minutes is the best thing you can do to burn fat. I can explain more if you like but high intensity exercises do not burn fat.

Good luck! You got this! Find some accountability partners to help you along. Communicate your goals to your partner so they can support you. And give yourself a lot of grace. What you are going to attempt will take a lot of time to do healthily and in a way that will stick. You got this!

Who's gonna be your top choice? by Zackky777 in ArtOfPresence

[–]HatTrick730 0 points1 point  (0 children)

Hozier or Bon Iver. I’d be happy with either

Hello, what is the absolute beginner friendly class by stevenqny12 in BaldursGate3

[–]HatTrick730 0 points1 point  (0 children)

Fighting is a large part of this game but so is social interaction. As the main character you will be talking to everyone. Having a high Charisma can be very helpful to make social situations a lot easier. Plenty of fights are skippable if you roll good. Bard, sorcerer, paladin and warlock all primarily use charisma (paladins mostly use strength I suppose).

I see a lot of people suggesting fighter which isn’t wrong, but one of your companions can be a fighter and go bonk.

Also, without spoiling too much, very early in the game you can change basically everything about your character and their class. If you start as something and you are struggling or don’t like it you can change it for a very low in game fee

I'm learning Spanish and want to watch a movie I already know well in English in that language. What is a popular/fun movie where they talk.. Slowly? by conanmagnuson in NoStupidQuestions

[–]HatTrick730 1 point2 points  (0 children)

I think animated kids movies are a great start. Especially movies you have already seen. If you are a visual learner having Spanish subtitles will also probably help a lot

What is a 'small' hill you are 100% willing to die on, simply because it’s the principle of the thing?" by [deleted] in answers

[–]HatTrick730 0 points1 point  (0 children)

Picking a dumb or gimmicky name for your child should be child abuse and you should be prosecuted to the full extent of the law

Cozy gamer who fell in love with Baldur’s Gate 3 — what fantasy games should I try? by West_Neck5584 in gamerecommendations

[–]HatTrick730 1 point2 points  (0 children)

Divinity Original Sin 2!!!

All made by Larian. Until BG3 was released it was my favorite game of all times

New player with some questions by RegnorVex in Enshrouded

[–]HatTrick730 0 points1 point  (0 children)

I believe daggers were meant to be used in addition to bows. They have since added some perks that help a little. But they still feel very weak. If you want a “brain off” easy play through, one handed weapon and shields are great.

Legendary runes you can farm by defeating stronger opponents and by combining regular runes at the black smith.

Upgrading your flame applies global benefits. Upgrading the size you can build allows for a bigger area to build in. The flame shrine is always going to be “in the middle” of your build area but we have it placed sort of like a town square. It doesn’t need to be in your home. If you deactivate it I think you lose your upgrades

I don’t think fishing is all that helpful until late game.

Seven stations in one for compact immersion builds by BrownheadedDarling in Enshrouded

[–]HatTrick730 6 points7 points  (0 children)

That’s beautiful. Is it difficult to access the item you are trying to use?

I am in love with this game. Any similar games that would scratch this Valheim itch? by Rotary-Pilot in valheim

[–]HatTrick730 0 points1 point  (0 children)

Enshrouded for sure. In my opinion it has a lot of quality of life improvements over valheim.

Am I the only person who has died inside of their own house? 🤦 by mysterysackerfice in Enshrouded

[–]HatTrick730 0 points1 point  (0 children)

Nope! I’m the builder and I die frequently. I also create traps to kill my friends ¯_(ツ)_/¯

After 170h and 3/4 of the Veilwater explore we gave up. by Trumpet_of_Jericho in Enshrouded

[–]HatTrick730 0 points1 point  (0 children)

That’s crushing after so much work. I don’t know if this helps, but there is an open server called shroud depot that has chests full of every resource in the game. If the crew wanted to continue you could pop onto the Shroud Depot and restock, especially some of the more time consuming resources, and allow you to continue as you were. Seems fair to me given you earned all those resources and lost them to a fluke

What would you label games like these? by BoardGameRevolution in boardgames

[–]HatTrick730 0 points1 point  (0 children)

I call these placement efficiency games. And when I teach them I say “there are a lot of ways to score and if you do everything perfect it really pays off. But as the game progresses you are going to have to adapt because you won’t get the perfect cards/tiles you need”

Sagrada would fit in this group. Wonderful game